create table `{prefix}affiliates_payments` (
  `id` int(7) not null auto_increment,
  `ts` int(20) not null default '0',
  `affid` int(7) not null default '0',
  `payamount` varchar(250) not null default '',
  `paymethod` varchar(250) not null default '',
  `notes` mediumtext default null,
  primary key (`id`),
  key `affid` (`affid`)
) {engine}
