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 ;