Pastebin launched a little side project called VERYVIRAL.com, check it out ;-) Want more features on Pastebin? Sign Up, it's FREE!
Guest

Untitled

By: a guest on Jan 26th, 2011  |  syntax: None  |  size: 2.11 KB  |  views: 28  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. CREATE TABLE IF NOT EXISTS `jx_commissions` (
  2.   `cid` int(20) NOT NULL AUTO_INCREMENT,
  3.   `mid` int(20) unsigned NOT NULL DEFAULT '0',
  4.   `pid` int(20) unsigned NOT NULL DEFAULT '0',
  5.   `status` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  6.   `approved` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  7.   `date` date NOT NULL DEFAULT '0000-00-00',
  8.   `commission_amount` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  9.   `sale_amount` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  10.   `commission_level` mediumint(3) unsigned NOT NULL DEFAULT '1',
  11.   `referrer` text COLLATE utf8_unicode_ci NOT NULL,
  12.   `trans_id` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  13.   `ip_address` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  14.   `commission_timer` int(25) NOT NULL DEFAULT '0',
  15.   `commission_frequency` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  16.   `next_pay_date` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  17.   `date_paid` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  18.   `commission_notes` tinytext COLLATE utf8_unicode_ci,
  19.   `performance_paid` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  20.   `sale_var_1_value` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  21.   `sale_var_2_value` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  22.   `sale_var_3_value` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  23.   `sale_var_4_value` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  24.   `sale_var_5_value` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  25.   `email_sent` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',
  26.   `tracker` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
  27.   `tool` varchar(25) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  28.   `tool_id` varchar(25) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  29.   PRIMARY KEY (`cid`),
  30.   KEY `mid` (`mid`),
  31.   KEY `pid` (`pid`),
  32.   KEY `status` (`status`),
  33.   KEY `date` (`date`),
  34.   KEY `commission_amount` (`commission_amount`),
  35.   KEY `sale_amount` (`sale_amount`)
  36. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=422 ;
clone this paste RAW Paste Data