create table `{prefix}affiliates_commissions` (
  `id` int(7) not null auto_increment,
  `ts` int(20) not null default '0',
  `affid` int(7) not null default '0',
  `product` int(7) not null default '0',
  `saletotal` varchar(250) not null default '',
  `commtotal` varchar(250) not null default '',
  `notes` mediumtext default null,
  `approved` enum('yes','no') not null default 'yes',
  `en` enum('yes','no') not null default 'yes',
  primary key (`id`),
  key `affid` (`affid`),
  key `approved` (`approved`),
  key `en` (`en`),
  KEY `product` (`product`)
) {engine}
