Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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 ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement