CREATE TABLE IF NOT EXISTS `jx_commissions` (
`cid` int(20) NOT NULL AUTO_INCREMENT,
`mid` int(20) unsigned NOT NULL DEFAULT '0',
`pid` int(20) unsigned NOT NULL DEFAULT '0',
`status` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`approved` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
`date` date NOT NULL DEFAULT '0000-00-00',
`commission_amount` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
`sale_amount` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`commission_level` mediumint(3) unsigned NOT NULL DEFAULT '1',
`referrer` text COLLATE utf8_unicode_ci NOT NULL,
`trans_id` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`ip_address` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`commission_timer` int(25) NOT NULL DEFAULT '0',
`commission_frequency` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`next_pay_date` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`date_paid` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`commission_notes` tinytext COLLATE utf8_unicode_ci,
`performance_paid` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
`sale_var_1_value` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`sale_var_2_value` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`sale_var_3_value` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`sale_var_4_value` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`sale_var_5_value` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`email_sent` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',
`tracker` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
`tool` varchar(25) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`tool_id` varchar(25) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (`cid`),
KEY `mid` (`mid`),
KEY `pid` (`pid`),
KEY `status` (`status`),
KEY `date` (`date`),
KEY `commission_amount` (`commission_amount`),
KEY `sale_amount` (`sale_amount`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=422 ;