create table `{prefix}affiliates_tracking` (
  `id` int(7) not null auto_increment,
  `affid` int(7) not null default '0',
  `product` int(7) not null default '0',
  `referrer` mediumtext default null,
  `count` int(11) unsigned not null default '1',
  primary key (`id`),
  key `affid` (`affid`),
  key `product` (`product`)
) {engine}
