Public Pastes
SHARE
TWEET

caleb2003

a guest Feb 20th, 2010 71 Never
  1. CREATE TABLE IF NOT EXISTS {prefix}banners (
  2.   id int(10) unsigned NOT NULL auto_increment,
  3.   listing_id int(10) unsigned NULL default NULL,
  4.   type_id tinyint(3) unsigned NOT NULL default '0',
  5.   status varchar(15) NOT NULL default '',
  6.   url text NOT NULL,
  7.   target varchar(15) NOT NULL default '',
  8.   alt_text varchar(255) NOT NULL default '',
  9.   code text NOT NULL,
  10.   extension varchar(55) NOT NULL default '',
  11.   clicks int(10) NOT NULL default '0',
  12.   impressions int(10) NOT NULL default '0',
  13.   date_last_displayed datetime NOT NULL default '0000-00-00 00:00:00',
  14.   PRIMARY KEY  (id),
  15.   KEY type_id (type_id,date_last_displayed)
  16. ) ENGINE=MyISAM;
  17.  
  18. CREATE TABLE IF NOT EXISTS {prefix}banners_categories (
  19.   banner_id int(10) unsigned NOT NULL default '0',
  20.   category_id int(10) unsigned NOT NULL default '0',
  21.   PRIMARY KEY  (banner_id,category_id),
  22.   KEY category_id (category_id)
  23. ) ENGINE=MyISAM;
  24.  
  25. CREATE TABLE IF NOT EXISTS {prefix}banner_types (
  26.   id tinyint(3) unsigned NOT NULL auto_increment,
  27.   category_id int(10) NULL default NULL,
  28.   type varchar(15) NOT NULL default '',
  29.   name varchar(255) NOT NULL default '',
  30.   description text NOT NULL,
  31.   width smallint(6) unsigned NOT NULL default '0',
  32.   height smallint(6) unsigned NOT NULL default '0',
  33.   filesize mediumint(8) unsigned NOT NULL default '0',
  34.   PRIMARY KEY  (id)
  35. ) ENGINE=MyISAM;
  36.  
  37. CREATE TABLE IF NOT EXISTS {prefix}categories (
  38.   id int(10) unsigned NOT NULL auto_increment,
  39.   title varchar(255) NOT NULL default '',
  40.   description_short text NOT NULL,
  41.   description text NOT NULL,
  42.   keywords text NOT NULL,
  43.   friendly_url varchar(255) NOT NULL default '',
  44.   friendly_url_path text NOT NULL,
  45.   title_override varchar(255) NOT NULL default '',
  46.   meta_description text NOT NULL,
  47.   meta_keywords text NOT NULL,
  48.   link varchar(255) NOT NULL default '',
  49.   hidden tinyint(1) NOT NULL default '0',
  50.   count int(10) unsigned NOT NULL default '0',
  51.   `level` tinyint(3) unsigned NOT NULL default '0',
  52.   left_ mediumint(8) unsigned NOT NULL default '0',
  53.   right_ mediumint(8) unsigned NOT NULL default '0',
  54.   hits int(10) unsigned NOT NULL default '0',
  55.   ip varchar(15) NOT NULL default '',
  56.   import_id smallint(6) unsigned NOT NULL default '0',
  57.   PRIMARY KEY  (id),
  58.   KEY left_ (left_,right_,`level`),
  59.   KEY `level` (`level`),
  60.   KEY friendly_url (friendly_url),
  61.   KEY import_id (import_id),
  62.   FULLTEXT KEY title (title,keywords)
  63. ) ENGINE=MyISAM;
  64.  
  65. CREATE TABLE IF NOT EXISTS {prefix}categories_fields (
  66.   category_id int(10) unsigned NOT NULL default '0',
  67.   field_id smallint(6) unsigned NOT NULL default '0',
  68.   KEY category_id (category_id,field_id),
  69.   KEY field_id (field_id)
  70. ) ENGINE=MyISAM;
  71.  
  72. CREATE TABLE IF NOT EXISTS {prefix}cron (
  73.   id varchar(55) NOT NULL,
  74.   run_date datetime NOT NULL default '0000-00-00 00:00:00',
  75.   last_run_date datetime NOT NULL default '0000-00-00 00:00:00',
  76.   run_order tinyint(3) unsigned NOT NULL default '0',
  77.   `day` smallint(6) NOT NULL default '0',
  78.   `hour` smallint(6) NOT NULL default '0',
  79.   `minute` smallint(6) NOT NULL default '0',
  80.   PRIMARY KEY  (id)
  81. ) ENGINE=MyISAM;
  82.  
  83. CREATE TABLE IF NOT EXISTS {prefix}cron_log (
  84.   id varchar(55) NOT NULL,
  85.   `date` datetime NOT NULL default '0000-00-00 00:00:00',
  86.   `status` tinyint(1) NOT NULL default '0',
  87.   `data` text NOT NULL,
  88.   KEY  id (id),
  89.   KEY `date` (`date`)
  90. ) ENGINE=MyISAM;
  91.  
  92. CREATE TABLE IF NOT EXISTS {prefix}discount_codes (
  93.   id smallint(6) unsigned NOT NULL auto_increment,
  94.   title varchar(255) NOT NULL default '',
  95.   code varchar(55) NOT NULL default '',
  96.   `value` decimal(10,2) NOT NULL default '0.00',
  97.   `type` enum('onetime','recurring') NOT NULL default 'onetime',
  98.   discount_type enum('fixed','percentage') NOT NULL default 'fixed',
  99.   date_start datetime NOT NULL default '0000-00-00 00:00:00',
  100.   date_expire datetime NOT NULL default '0000-00-00 00:00:00',
  101.   used_limit smallint(6) NOT NULL default '0',
  102.   user_used_limit smallint(6) NOT NULL default '0',
  103.   used smallint(6) NOT NULL default '0',
  104.   pricing_ids text NOT NULL,
  105.   gateway_ids text NOT NULL,
  106.   PRIMARY KEY  (id),
  107.   UNIQUE KEY code (code)
  108. ) ENGINE=MyISAM;
  109.  
  110. CREATE TABLE IF NOT EXISTS {prefix}documents (
  111.   id int(10) unsigned NOT NULL auto_increment,
  112.   listing_id int(10) unsigned NOT NULL default '0',
  113.   title varchar(255) NOT NULL default '',
  114.   `date` datetime NOT NULL default '0000-00-00 00:00:00',
  115.   description text NOT NULL,
  116.   extension varchar(4) NOT NULL default '',
  117.   PRIMARY KEY  (id),
  118.   KEY listing_id (listing_id),
  119.   FULLTEXT KEY item (title,description)
  120. ) ENGINE=MyISAM;
  121.  
  122. CREATE TABLE IF NOT EXISTS {prefix}email_queue (
  123.   id int(10) unsigned NOT NULL auto_increment,
  124.   batch_id int(10) NOT NULL default '0',
  125.   user_id int(10) unsigned NOT NULL default '0',
  126.   listing_id int(10) unsigned default NULL,
  127.   `status` enum('sent','queued','failed') NOT NULL default 'queued',
  128.   date_queued datetime NOT NULL default '0000-00-00 00:00:00',
  129.   date_sent datetime default NULL,
  130.   `subject` varchar(255) NOT NULL default '',
  131.   body_plain text NOT NULL,
  132.   body_html text NOT NULL,
  133.   cc_recipients text NOT NULL,
  134.   PRIMARY KEY  (id),
  135.   KEY message_id (user_id,`status`),
  136.   KEY batch_id (batch_id),
  137.   KEY listing_id (listing_id)
  138. ) ENGINE=MyISAM;
  139.  
  140. CREATE TABLE IF NOT EXISTS {prefix}email_queue_batches (
  141.   id int(10) unsigned NOT NULL auto_increment,
  142.   name varchar(255) NOT NULL default '',
  143.   description text NOT NULL,
  144.   from_name varchar(255) NOT NULL default '',
  145.   from_email varchar(255) NOT NULL default '',
  146.   attachment varchar(255) default NULL,
  147.   attachment_mimetype varchar(50) default NULL,
  148.   date_queued datetime NOT NULL default '0000-00-00 00:00:00',
  149.   PRIMARY KEY  (id)
  150. ) ENGINE=MyISAM;
  151.  
  152. CREATE TABLE IF NOT EXISTS {prefix}email_templates (
  153.   id varchar(255) NOT NULL default '',
  154.   `type` varchar(55) NOT NULL default '',
  155.   recipients varchar(255) NOT NULL default '',
  156.   fromaddress varchar(50) default NULL,
  157.   fromname varchar(50) default NULL,
  158.   `disable` tinyint(1) NOT NULL default '0',
  159.   custom tinyint(1) NOT NULL default '0',
  160.   PRIMARY KEY  (id),
  161.   KEY `type` (`type`)
  162. ) ENGINE=MyISAM;
  163.  
  164. CREATE TABLE IF NOT EXISTS {prefix}faq_categories (
  165.   id smallint(6) unsigned NOT NULL auto_increment,
  166.   title varchar(55) NOT NULL default '',
  167.   ordering smallint(6) NOT NULL default '0',
  168.   active tinyint(1) NOT NULL default '0',
  169.   PRIMARY KEY  (id)
  170. ) ENGINE=MyISAM;
  171.  
  172. CREATE TABLE IF NOT EXISTS {prefix}faq_questions (
  173.   id smallint(6) unsigned NOT NULL auto_increment,
  174.   category_id smallint(6) NOT NULL default '0',
  175.   question text NOT NULL,
  176.   answer text NOT NULL,
  177.   ordering smallint(6) NOT NULL default '0',
  178.   active tinyint(1) NOT NULL default '0',
  179.   PRIMARY KEY  (id),
  180.   KEY category_id (category_id)
  181. ) ENGINE=MyISAM;
  182.  
  183. CREATE TABLE IF NOT EXISTS {prefix}favorites (
  184.   id int(10) unsigned NOT NULL auto_increment,
  185.   user_id int(10) unsigned NOT NULL default '0',
  186.   listing_id int(10) unsigned NOT NULL default '0',
  187.   PRIMARY KEY  (id),
  188.   UNIQUE KEY user_id (user_id,listing_id),
  189.   KEY listing_id (listing_id)
  190. ) ENGINE=MyISAM;
  191.  
  192. CREATE TABLE IF NOT EXISTS {prefix}feeds_external (
  193.   id smallint(6) unsigned NOT NULL auto_increment,
  194.   title varchar(255) NOT NULL default '',
  195.   description text NOT NULL,
  196.   url varchar(255) NOT NULL default '',
  197.   active tinyint(1) NOT NULL default '0',
  198.   PRIMARY KEY  (id)
  199. ) ENGINE=MyISAM;
  200.  
  201. CREATE TABLE IF NOT EXISTS {prefix}fields (
  202.   id smallint(6) unsigned NOT NULL auto_increment,
  203.   group_id smallint(6) NOT NULL default '0',
  204.   name varchar(255) NOT NULL default '',
  205.   description text NOT NULL,
  206.   `type` varchar(15) NOT NULL default '',
  207.   required tinyint(1) NOT NULL default '0',
  208.   options text NOT NULL,
  209.   selected text NOT NULL,
  210.   ordering int(10) NOT NULL default '0',
  211.   search tinyint(1) unsigned NOT NULL default '0',
  212.   admin_only tinyint(1) unsigned NOT NULL default '0',
  213.   PRIMARY KEY  (id),
  214.   KEY group_id (group_id),
  215.   KEY search (search)
  216. ) ENGINE=MyISAM;
  217.  
  218. CREATE TABLE IF NOT EXISTS {prefix}fields_groups (
  219.   id smallint(6) unsigned NOT NULL auto_increment,
  220.   title varchar(255) NOT NULL default '',
  221.   `type` varchar(25) NOT NULL default '',
  222.   ordering smallint(6) unsigned NOT NULL default '0',
  223.   PRIMARY KEY  (id),
  224.   KEY `type` (`type`)
  225. ) ENGINE=MyISAM;
  226.  
  227. CREATE TABLE IF NOT EXISTS {prefix}gateways (
  228.   id varchar(55) NOT NULL default '',
  229.   display_name varchar(255) NOT NULL default '',
  230.   enabled tinyint(1) NOT NULL default '0',
  231.   settings mediumtext NOT NULL,
  232.   ordering smallint(6) unsigned NOT NULL default '0',
  233.   KEY enabled (enabled),
  234.   KEY ordering (ordering)
  235. ) ENGINE=MyISAM;
  236.  
  237. CREATE TABLE IF NOT EXISTS {prefix}gateways_log (
  238.   id int(10) unsigned NOT NULL auto_increment,
  239.   `date` datetime NOT NULL default '0000-00-00 00:00:00',
  240.   gateway varchar(255) NOT NULL default '',
  241.   `data` text NOT NULL,
  242.   result varchar(255) default NULL,
  243.   `errors` text NOT NULL,
  244.   PRIMARY KEY  (id)
  245. ) ENGINE=MyISAM;
  246.  
  247. CREATE TABLE IF NOT EXISTS {prefix}images (
  248.   id int(10) unsigned NOT NULL auto_increment,
  249.   listing_id int(10) unsigned NOT NULL default '0',
  250.   title varchar(255) NOT NULL default '',
  251.   `date` datetime NOT NULL default '0000-00-00 00:00:00',
  252.   description text NOT NULL,
  253.   extension varchar(4) NOT NULL default '',
  254.   PRIMARY KEY  (id),
  255.   KEY listing_id (listing_id),
  256.   FULLTEXT KEY item (title,description)
  257. ) ENGINE=MyISAM;
  258.  
  259. CREATE TABLE IF NOT EXISTS {prefix}imports (
  260.   id smallint(6) unsigned NOT NULL auto_increment,
  261.   name varchar(255) NOT NULL default '',
  262.   delimiter char(1) NOT NULL default '',
  263.   encapsulator char(1) NOT NULL default '',
  264.   map text NOT NULL,
  265.   `data` text NOT NULL,
  266.   import_count int(10) NOT NULL default '0',
  267.   `date` datetime NOT NULL default '0000-00-00 00:00:00',
  268.   `status` varchar(50) NOT NULL default 'incomplete',
  269.   PRIMARY KEY  (id)
  270. ) ENGINE=MyISAM;
  271.  
  272. CREATE TABLE IF NOT EXISTS {prefix}invoices (
  273.   id int(10) unsigned NOT NULL auto_increment,
  274.   order_id int(10) unsigned default NULL,
  275.   user_id int(10) unsigned NOT NULL default '0',
  276.   `type` varchar(255) NOT NULL default '',
  277.   type_id smallint(6) unsigned NOT NULL default '0',
  278.   description varchar(255) NOT NULL default '',
  279.   `date` date NOT NULL default '0000-00-00',
  280.   date_due date NOT NULL default '0000-00-00',
  281.   date_paid date NOT NULL default '0000-00-00',
  282.   subtotal decimal(10,2) NOT NULL default '0.00',
  283.   tax decimal(10,2) NOT NULL default '0.00',
  284.   tax_rate decimal(10,2) NOT NULL default '0.00',
  285.   total decimal(10,2) unsigned NOT NULL default '0.00',
  286.   `status` enum('paid','cancelled','unpaid') NOT NULL default 'unpaid',
  287.   gateway_id varchar(55) NOT NULL default '',
  288.   discount_code varchar(55) NOT NULL default '',
  289.   discount_code_value decimal(10,2) NOT NULL default '0.00',
  290.   discount_code_type enum('onetime','recurring') NOT NULL default 'onetime',
  291.   discount_code_discount_type enum('fixed','percentage') NOT NULL default 'fixed',
  292.   created_sent tinyint(1) NOT NULL default '0',
  293.   reminder_sent tinyint(1) NOT NULL default '0',
  294.   overdue_1_sent tinyint(1) NOT NULL default '0',
  295.   overdue_2_sent tinyint(1) NOT NULL default '0',
  296.   overdue_3_sent tinyint(1) NOT NULL default '0',
  297.   notes text NOT NULL,
  298.   PRIMARY KEY  (id),
  299.   KEY userid (user_id)
  300. ) ENGINE=MyISAM;
  301.  
  302. CREATE TABLE IF NOT EXISTS {prefix}ip_limits (
  303.   ip_address varchar(15) NOT NULL,
  304.   `type` varchar(55) NOT NULL default '',
  305.   `date` datetime NOT NULL default '0000-00-00 00:00:00',
  306.   KEY ip_address (ip_address, `type`)
  307. ) ENGINE=MyISAM;
  308.  
  309. CREATE TABLE IF NOT EXISTS {prefix}languages (
  310.   languageid smallint(6) unsigned NOT NULL auto_increment,
  311.   title varchar(50) NOT NULL default '',
  312.   languagecode varchar(12) NOT NULL default '',
  313.   `charset` varchar(15) NOT NULL default '',
  314.   textdirection char(3) NOT NULL default '',
  315.   ismaster tinyint(1) NOT NULL default '0',
  316.   isdefault tinyint(1) NOT NULL default '0',
  317.   decimalseperator char(1) NOT NULL default '',
  318.   thousandseperator char(1) NOT NULL default '',
  319.   currencysymbol char(3) NOT NULL default '',
  320.   date_override varchar(50) NOT NULL default '',
  321.   time_override varchar(50) NOT NULL default '',
  322.   locale varchar(20) NOT NULL default '',
  323.   PRIMARY KEY  (languageid)
  324. ) ENGINE=MyISAM;
  325.  
  326. CREATE TABLE IF NOT EXISTS {prefix}language_phrases (
  327.   phraseid mediumint(8) unsigned NOT NULL auto_increment,
  328.   languageid smallint(6) NOT NULL default '0',
  329.   section varchar(50) NOT NULL default '',
  330.   variablename varchar(250) NOT NULL default '',
  331.   content text,
  332.   date_update datetime NOT NULL default '0000-00-00 00:00:00',
  333.   PRIMARY KEY  (phraseid),
  334.   KEY languageid (languageid),
  335.   KEY section (section),
  336.   KEY variablename (variablename)
  337. ) ENGINE=MyISAM;
  338.  
  339. CREATE TABLE IF NOT EXISTS {prefix}listings (
  340.   id int(10) unsigned NOT NULL auto_increment,
  341.   user_id int(10) unsigned NOT NULL default '0',
  342.   primary_category_id int(10) unsigned NOT NULL,
  343.   `status` enum('active','pending','suspended') NOT NULL default 'pending',
  344.   priority int(10) NOT NULL default '0',
  345.   title varchar(100) NOT NULL default '',
  346.   friendly_url varchar(255) NOT NULL default '',
  347.   description_short text NOT NULL,
  348.   description text NOT NULL,
  349.   meta_description text NOT NULL,
  350.   meta_keywords text NOT NULL,
  351.   keywords text NOT NULL,
  352.   logo_extension varchar(4) NOT NULL default '',
  353.   phone varchar(55) NOT NULL default '',
  354.   fax varchar(55) NOT NULL default '',
  355.   location_id int(10) unsigned NOT NULL default '0',
  356.   listing_address1 varchar(255) NOT NULL default '',
  357.   listing_address2 varchar(255) NOT NULL default '',
  358.   listing_zip varchar(15) NOT NULL default '',
  359.   location_text_1 varchar(255) NOT NULL default '',
  360.   location_text_2 varchar(255) NOT NULL default '',
  361.   location_text_3 varchar(255) NOT NULL default '',
  362.   location_search_text varchar(255) NOT NULL default '',
  363.   latitude decimal(15,10) NOT NULL default '0.0000000000',
  364.   longitude decimal(15,10) NOT NULL default '0.0000000000',
  365.   coordinates_date_checked datetime NOT NULL default '0000-00-00 00:00:00',
  366.   www varchar(255) NOT NULL default '',
  367.   www_status varchar(15) NOT NULL default 'valid',
  368.   www_date_checked datetime NOT NULL default '0000-00-00 00:00:00',
  369.   www_hits int(10) unsigned NOT NULL default '0',
  370.   www_screenshot_last_updated datetime NOT NULL default '0000-00-00 00:00:00',
  371.   pagerank tinyint( 2 ) NOT NULL default '0',
  372.   pagerank_expiration datetime NOT NULL default '0000-00-00 00:00:00',
  373.   ip varchar(15) NOT NULL default '',
  374.   `date` datetime NOT NULL default '0000-00-00 00:00:00',
  375.   date_update datetime NOT NULL default '0000-00-00 00:00:00',
  376.   ip_update varchar(15) NOT NULL default '',
  377.   hits int(10) unsigned NOT NULL default '0',
  378.   email_counter int(10) unsigned NOT NULL default '0',
  379.   rating float NOT NULL default '0',
  380.   banner_show int(10) unsigned NOT NULL default '0',
  381.   banner_click int(10) unsigned NOT NULL default '0',
  382.   counterip varchar(15) NOT NULL default '',
  383.   mail varchar(255) NOT NULL default '',
  384.   claimed tinyint(1) NOT NULL default '0',
  385.   `comment` varchar(255) NOT NULL default '',
  386.   votes int(10) NOT NULL default '0',
  387.   header_template_file varchar(255) NOT NULL default '',
  388.   footer_template_file varchar(255) NOT NULL default '',
  389.   wrapper_template_file varchar(255) NOT NULL default '',
  390.   template_file varchar(255) NOT NULL default '',
  391.   template_file_results varchar(255) NOT NULL default '',
  392.   category_limit smallint(6) unsigned NOT NULL default '0',
  393.   featured tinyint(1) NOT NULL default '0',
  394.   friendly_url_allow tinyint(1) NOT NULL default '0',
  395.   html_editor_allow tinyint(1) NOT NULL default '0',
  396.   phone_allow tinyint(1) NOT NULL default '0',
  397.   fax_allow tinyint(1) NOT NULL default '0',
  398.   address_allow tinyint(1) NOT NULL default '0',
  399.   zip_allow tinyint(1) NOT NULL default '0',
  400.   email_allow tinyint(1) NOT NULL default '0',
  401.   email_friend_allow tinyint(1) NOT NULL default '0',
  402.   www_allow tinyint(1) NOT NULL default '0',
  403.   www_screenshot_allow tinyint(1) NOT NULL default '0',
  404.   require_reciprocal tinyint(1) NOT NULL default '0',
  405.   map_allow tinyint(1) NOT NULL default '0',
  406.   logo_allow tinyint(1) NOT NULL default '0',
  407.   reviews_allow tinyint(1) NOT NULL default '0',
  408.   ratings_allow tinyint(1) NOT NULL default '0',
  409.   suggestion_allow tinyint(1) NOT NULL default '0',
  410.   claim_allow tinyint(1) NOT NULL default '0',
  411.   pdf_allow tinyint(1) NOT NULL default '0',
  412.   vcard_allow tinyint(1) NOT NULL default '0',
  413.   addtofavorites_allow tinyint(1) NOT NULL default '0',
  414.   print_allow tinyint(1) NOT NULL default '0',
  415.   coordinates_allow tinyint(1) NOT NULL default '0',
  416.   offers_images_allow tinyint(1) NOT NULL default '0',
  417.   offers_limit smallint(5) unsigned NOT NULL default '0',
  418.   images_limit smallint(5) unsigned NOT NULL default '0',
  419.   documents_limit smallint(5) unsigned NOT NULL default '0',
  420.   short_description_size smallint(5) unsigned NOT NULL default '0',
  421.   description_size mediumint(8) unsigned NOT NULL default '0',
  422.   meta_description_size smallint(5) NOT NULL default '0',
  423.   meta_keywords_limit smallint(5) NOT NULL default '0',
  424.   keywords_limit smallint(5) NOT NULL default '0',
  425.   PRIMARY KEY  (id),
  426.   KEY userid (user_id),
  427.   KEY loc_id (location_id),
  428.   KEY friendly_url (friendly_url),
  429.   FULLTEXT KEY search_txt (title,description_short,keywords,location_search_text)
  430. ) ENGINE=MyISAM;
  431.  
  432. CREATE TABLE IF NOT EXISTS {prefix}listings_categories (
  433.   list_id int(10) unsigned NOT NULL default '0',
  434.   cat_id int(10) unsigned NOT NULL default '0',
  435.   PRIMARY KEY  (list_id,cat_id),
  436.   KEY cat_id_2 (cat_id,list_id)
  437. ) ENGINE=MyISAM;
  438.  
  439. CREATE TABLE IF NOT EXISTS {prefix}listings_claims (
  440.   id int(10) unsigned NOT NULL auto_increment,
  441.   listing_id int(10) unsigned NOT NULL default '0',
  442.   user_id int(10) unsigned NOT NULL default '0',
  443.   `date` datetime NOT NULL default '0000-00-00 00:00:00',
  444.   comments text NOT NULL,
  445.   PRIMARY KEY  (id),
  446.   KEY listing_id (listing_id)
  447. ) ENGINE=MyISAM;
  448.  
  449. CREATE TABLE IF NOT EXISTS {prefix}listings_suggestions (
  450.   id int(10) unsigned NOT NULL auto_increment,
  451.   listing_id int(10) unsigned NOT NULL default '0',
  452.   user_id int(10) unsigned NOT NULL default '0',
  453.   `date` datetime NOT NULL default '0000-00-00 00:00:00',
  454.   comments text NOT NULL,
  455.   PRIMARY KEY  (id),
  456.   KEY listing_id (listing_id)
  457. ) ENGINE=MyISAM;
  458.  
  459. CREATE TABLE IF NOT EXISTS {prefix}listings_website_clicks (
  460.   id int(10) NOT NULL auto_increment,
  461.   listing_id int(10) NOT NULL default '0',
  462.   ip_address varchar(15) NOT NULL default '',
  463.   PRIMARY KEY  (id),
  464.   KEY listing_id (listing_id,ip_address)
  465. ) ENGINE=MyISAM;
  466.  
  467. CREATE TABLE IF NOT EXISTS {prefix}locations (
  468.   id int(10) unsigned NOT NULL auto_increment,
  469.   title varchar(255) NOT NULL default '',
  470.   description_short text NOT NULL,
  471.   description text NOT NULL,
  472.   keywords text NOT NULL,
  473.   friendly_url varchar(255) NOT NULL default '',
  474.   friendly_url_path text NOT NULL,
  475.   title_override varchar(255) NOT NULL default '',
  476.   meta_description text NOT NULL,
  477.   meta_keywords text NOT NULL,
  478.   link varchar(255) NOT NULL default '',
  479.   hidden tinyint(1) NOT NULL default '0',
  480.   count int(10) unsigned NOT NULL default '0',
  481.   `level` tinyint(3) unsigned NOT NULL default '0',
  482.   left_ mediumint(8) unsigned NOT NULL default '0',
  483.   right_ mediumint(8) unsigned NOT NULL default '0',
  484.   hits int(10) unsigned NOT NULL default '0',
  485.   ip varchar(15) NOT NULL default '',
  486.   import_id smallint(6) unsigned NOT NULL default '0',
  487.   PRIMARY KEY  (id),
  488.   KEY left_ (left_,right_,`level`),
  489.   KEY `level` (`level`),
  490.   KEY friendly_url (friendly_url),
  491.   KEY import_id (import_id),
  492.   FULLTEXT KEY title (title,description_short,description,keywords)
  493. ) ENGINE=MyISAM;
  494.  
  495. CREATE TABLE IF NOT EXISTS {prefix}log (
  496.   id int(10) NOT NULL auto_increment,
  497.   user_id int(10) default NULL,
  498.   ip_address varchar(15) NOT NULL default '',
  499.   hostname varchar(255) NOT NULL default '',
  500.   action_date datetime NOT NULL default '0000-00-00 00:00:00',
  501.   action_type varchar(50) NOT NULL default '',
  502.   `action` text NOT NULL,
  503.   PRIMARY KEY  (id),
  504.   KEY userid (user_id),
  505.   KEY ip_address (ip_address),
  506.   KEY action_date (action_date),
  507.   KEY action_type (action_type)
  508. ) ENGINE=MyISAM;
  509.  
  510. CREATE TABLE IF NOT EXISTS {prefix}log_sql (
  511.   created datetime NOT NULL default '0000-00-00 00:00:00',
  512.   sql_query text NOT NULL,
  513.   url text NOT NULL,
  514.   timer decimal(16,6) NOT NULL default '0.000000'
  515. ) ENGINE=MyISAM;
  516.  
  517. CREATE TABLE IF NOT EXISTS {prefix}memberships (
  518.   id int(3) unsigned NOT NULL auto_increment,
  519.   priority smallint(6) NOT NULL default '0',
  520.   header_template_file varchar(255) NOT NULL default '',
  521.   footer_template_file varchar(255) NOT NULL default '',
  522.   wrapper_template_file varchar(255) NOT NULL default '',
  523.   template_file varchar(255) NOT NULL default '',
  524.   template_file_results varchar(255) NOT NULL default '',
  525.   category_limit smallint(6) unsigned NOT NULL default '1',
  526.   featured tinyint(1) NOT NULL default '0',
  527.   friendly_url_allow tinyint(1) NOT NULL default '0',
  528.   html_editor_allow tinyint(1) NOT NULL default '0',
  529.   phone_allow tinyint(1) NOT NULL default '0',
  530.   fax_allow tinyint(1) NOT NULL default '0',
  531.   address_allow tinyint(1) NOT NULL default '0',
  532.   zip_allow tinyint(1) NOT NULL default '0',
  533.   email_allow tinyint(1) NOT NULL default '0',
  534.   email_friend_allow tinyint(1) NOT NULL default '0',
  535.   www_allow tinyint(1) NOT NULL default '0',
  536.   www_screenshot_allow tinyint(1) NOT NULL default '0',
  537.   require_reciprocal tinyint(1) NOT NULL default '0',
  538.   map_allow tinyint(1) NOT NULL default '0',
  539.   logo_allow tinyint(1) NOT NULL default '0',
  540.   reviews_allow tinyint(1) NOT NULL default '0',
  541.   ratings_allow tinyint(1) NOT NULL default '0',
  542.   suggestion_allow tinyint(1) NOT NULL default '0',
  543.   claim_allow tinyint(1) NOT NULL default '0',
  544.   pdf_allow tinyint(1) NOT NULL default '0',
  545.   vcard_allow tinyint(1) NOT NULL default '0',
  546.   addtofavorites_allow tinyint(1) NOT NULL default '0',
  547.   print_allow tinyint(1) NOT NULL default '0',
  548.   coordinates_allow tinyint(1) NOT NULL default '0',
  549.   offers_images_allow tinyint(1) NOT NULL default '0',
  550.   offers_limit smallint(6) unsigned NOT NULL default '0',
  551.   images_limit smallint(6) unsigned NOT NULL default '0',
  552.   documents_limit smallint(6) unsigned NOT NULL default '0',
  553.   short_description_size smallint(6) unsigned NOT NULL default '25',
  554.   description_size mediumint(8) NOT NULL default '50',
  555.   meta_description_size smallint(6) unsigned NOT NULL default '0',
  556.   meta_keywords_limit smallint(6) unsigned NOT NULL default '0',
  557.   keywords_limit smallint(6) unsigned NOT NULL default '0',
  558.   PRIMARY KEY  (id)
  559. ) ENGINE=MyISAM;
  560.  
  561. CREATE TABLE IF NOT EXISTS {prefix}menu_links (
  562.   id smallint(6) unsigned NOT NULL auto_increment,
  563.   page_id smallint(6) unsigned default NULL,
  564.   parent_id smallint(6) unsigned default NULL,
  565.   title varchar(255) NOT NULL default '',
  566.   link varchar(255) default NULL,
  567.   target varchar(15) NOT NULL default '',
  568.   nofollow tinyint(1) NOT NULL default '0',
  569.   ordering smallint(6) NOT NULL default '0',
  570.   logged_in tinyint(1) NOT NULL default '1',
  571.   logged_out tinyint(1) NOT NULL default '1',
  572.   sitemap tinyint(1) NOT NULL default '0',
  573.   active tinyint(1) NOT NULL default '1',
  574.   PRIMARY KEY  (id),
  575.   KEY page_id (page_id,parent_id)
  576. ) ENGINE=MyISAM;
  577.  
  578. CREATE TABLE IF NOT EXISTS {prefix}offers (
  579.   id int(10) unsigned NOT NULL auto_increment,
  580.   listing_id int(10) unsigned NOT NULL default '0',
  581.   title varchar(255) NOT NULL default '',
  582.   `date` date NOT NULL default '0000-00-00',
  583.   description text NOT NULL,
  584.   price varchar(255) NOT NULL default '',
  585.   expire_date date NOT NULL default '0000-00-00',
  586.   www varchar(255) NOT NULL default '',
  587.   buttoncode text NOT NULL,
  588.   PRIMARY KEY  (id),
  589.   KEY listing_id (listing_id),
  590.   FULLTEXT KEY item (title,description)
  591. ) ENGINE=MyISAM;
  592.  
  593. CREATE TABLE IF NOT EXISTS {prefix}offers_images (
  594.   id int(10) unsigned NOT NULL auto_increment,
  595.   offer_id int(10) unsigned NOT NULL default '0',
  596.   extension varchar(4) NOT NULL default '',
  597.   PRIMARY KEY  (id,offer_id),
  598.   KEY offer_id (offer_id)
  599. ) ENGINE=MyISAM;
  600.  
  601. CREATE TABLE IF NOT EXISTS {prefix}orders (
  602.   id int(10) unsigned NOT NULL auto_increment,
  603.   order_id int(10) unsigned NOT NULL default '0',
  604.   `type` varchar(255) NOT NULL default '',
  605.   type_id int(10) unsigned NOT NULL default '0',
  606.   invoice_id int(10) unsigned NOT NULL default '0',
  607.   user_id int(10) unsigned NOT NULL default '0',
  608.   pricing_id smallint(6) unsigned NOT NULL default '0',
  609.   gateway_id varchar(55) NOT NULL default '',
  610.   `date` datetime NOT NULL default '0000-00-00 00:00:00',
  611.   `status` varchar(255) NOT NULL default '',
  612.   amount_recurring decimal(10,2) NOT NULL default '0.00',
  613.   period varchar(255) NOT NULL default '',
  614.   period_count smallint(6) NOT NULL default '0',
  615.   next_due_date date NOT NULL default '0000-00-00',
  616.   future_due_date date NOT NULL default '0000-00-00',
  617.   next_invoice_date date NOT NULL default '0000-00-00',
  618.   taxed tinyint(1) NOT NULL default '0',
  619.   upgrades varchar(255) NOT NULL default '',
  620.   renewable tinyint(1) NOT NULL default '0',
  621.   subscription_id varchar(255) NOT NULL default '',
  622.   suspend_overdue_days smallint(6) NOT NULL default '1',
  623.   discount_code varchar(55) NOT NULL default '',
  624.   discount_code_value decimal(10,2) NOT NULL default '0.00',
  625.   discount_code_type enum('onetime','recurring') default NULL,
  626.   discount_code_discount_type enum('fixed','percentage') NOT NULL default 'fixed',
  627.   ip_address varchar(15) NOT NULL default '',
  628.   import_id smallint(6) unsigned NOT NULL default '0',
  629.   PRIMARY KEY  (id),
  630.   UNIQUE KEY order_id (order_id),
  631.   KEY user_id (user_id,invoice_id),
  632.   KEY type_id (type_id,type),
  633.   KEY type (type)
  634. ) ENGINE=MyISAM;
  635.  
  636. CREATE TABLE IF NOT EXISTS {prefix}pages (
  637.   id smallint(6) unsigned NOT NULL auto_increment,
  638.   title varchar(255) NOT NULL default '',
  639.   content text NOT NULL,
  640.   friendly_url varchar(255) NOT NULL default '',
  641.   meta_description text NOT NULL,
  642.   meta_keywords text NOT NULL,
  643.   PRIMARY KEY  (id)
  644. ) ENGINE=MyISAM;
  645.  
  646. CREATE TABLE IF NOT EXISTS {prefix}plugins (
  647.   id varchar(55) NOT NULL default '',
  648.   installed tinyint(1) NOT NULL default '0',
  649.   active tinyint(1) NOT NULL default '0',
  650.   version varchar(15) NOT NULL default '',
  651.   PRIMARY KEY  (id)
  652. ) ENGINE=MyISAM;
  653.  
  654. CREATE TABLE IF NOT EXISTS {prefix}products (
  655.   id smallint(6) unsigned NOT NULL auto_increment,
  656.   group_id tinyint(3) unsigned NOT NULL default '0',
  657.   `type` varchar(255) NOT NULL default '',
  658.   type_id mediumint(8) NOT NULL default '0',
  659.   upgrades varchar(255) NOT NULL default '',
  660.   name varchar(255) NOT NULL default '',
  661.   description text NOT NULL,
  662.   hidden tinyint(1) NOT NULL default '0',
  663.   ordering smallint(6) NOT NULL default '0',
  664.   taxed tinyint(1) NOT NULL default '0',
  665.   suspend_overdue_days smallint(6) NOT NULL default '1',
  666.   PRIMARY KEY  (id),
  667.   KEY group_id (group_id)
  668. ) ENGINE=MyISAM;
  669.  
  670. CREATE TABLE IF NOT EXISTS {prefix}products_groups (
  671.   id tinyint(3) unsigned NOT NULL auto_increment,
  672.   name varchar(255) NOT NULL default '',
  673.   hidden tinyint(1) NOT NULL default '0',
  674.   ordering tinyint(3) unsigned NOT NULL default '0',
  675.   PRIMARY KEY  (id)
  676. ) ENGINE=MyISAM;
  677.  
  678. CREATE TABLE IF NOT EXISTS {prefix}products_pricing (
  679.   id smallint(6) unsigned NOT NULL auto_increment,
  680.   product_id smallint(6) NOT NULL default '0',
  681.   label varchar(255) NOT NULL default '',
  682.   period varchar(15) NOT NULL default '',
  683.   period_count smallint(6) NOT NULL default '0',
  684.   setup_price decimal(10,2) NOT NULL default '0.00',
  685.   price decimal(10,2) NOT NULL default '0.00',
  686.   prorate tinyint(1) NOT NULL default '0',
  687.   prorate_day tinyint(2) NOT NULL default '0',
  688.   prorate_day_next_month tinyint(2) NOT NULL default '0',
  689.   ordering smallint(6) NOT NULL default '0',
  690.   user_limit smallint(6) NOT NULL default '0',
  691.   activate varchar(15) NOT NULL default '',
  692.   renewable tinyint(1) NOT NULL default '0',
  693.   PRIMARY KEY  (id),
  694.   KEY product_id (product_id)
  695. ) ENGINE=MyISAM;
  696.  
  697. CREATE TABLE IF NOT EXISTS {prefix}ratings (
  698.   id int(10) unsigned NOT NULL auto_increment,
  699.   user_id int(10) unsigned default NULL,
  700.   listing_id int(10) unsigned NOT NULL default '0',
  701.   review_id int(10) unsigned default NULL,
  702.   rating tinyint(1) unsigned NOT NULL default '0',
  703.   ip_address varchar(15) NOT NULL default '',
  704.   PRIMARY KEY  (id),
  705.   KEY review_id (review_id),
  706.   KEY listing_id (listing_id),
  707.   KEY user_id (user_id)
  708. ) ENGINE=MyISAM;
  709.  
  710. CREATE TABLE IF NOT EXISTS {prefix}reviews (
  711.   id int(10) unsigned NOT NULL auto_increment,
  712.   listing_id int(10) unsigned NOT NULL default '0',
  713.   user_id int(10) unsigned default NULL,
  714.   comment_count int(10) unsigned NOT NULL default '0',
  715.   helpful_count int(10) unsigned NOT NULL default '0',
  716.   helpful_total int(10) unsigned NOT NULL default '0',
  717.   `date` datetime NOT NULL default '0000-00-00 00:00:00',
  718.   `status` varchar(25) NOT NULL default '',
  719.   title varchar(255) NOT NULL default '',
  720.   review text NOT NULL,
  721.   PRIMARY KEY  (id),
  722.   KEY listing_d (listing_id),
  723.   KEY user_id (user_id)
  724. ) ENGINE=MyISAM;
  725.  
  726. CREATE TABLE IF NOT EXISTS {prefix}reviews_comments (
  727.   id int(10) unsigned NOT NULL auto_increment,
  728.   review_id int(10) unsigned NOT NULL default '0',
  729.   user_id int(10) unsigned NOT NULL default '0',
  730.   `date` datetime NOT NULL default '0000-00-00 00:00:00',
  731.   `comment` text NOT NULL,
  732.   PRIMARY KEY  (id),
  733.   KEY review_id (review_id)
  734. ) ENGINE=MyISAM;
  735.  
  736. CREATE TABLE IF NOT EXISTS {prefix}reviews_quality (
  737.   id int(10) unsigned NOT NULL auto_increment,
  738.   review_id int(10) unsigned NOT NULL default '0',
  739.   user_id int(10) unsigned NOT NULL default '0',
  740.   helpful tinyint(1) NOT NULL default '0',
  741.   PRIMARY KEY  (id),
  742.   UNIQUE KEY review_id (review_id,user_id)
  743. ) ENGINE=MyISAM;
  744.  
  745. CREATE TABLE IF NOT EXISTS {prefix}search_log (
  746.   id int(10) unsigned NOT NULL auto_increment,
  747.   user_id int(10) unsigned NULL,
  748.   `date` datetime NOT NULL default '0000-00-00 00:00:00',
  749.   ip varchar(15) NOT NULL default '',
  750.   results text NOT NULL,
  751.   category_results text NOT NULL,
  752.   count int(10) unsigned NOT NULL default '0',
  753.   keywords varchar(255) NOT NULL default '',
  754.   sort_by varchar(255) NOT NULL default '',
  755.   sort_order varchar(255) NOT NULL default '',
  756.   execution_time float NOT NULL default '0',
  757.   terms text NOT NULL,
  758.   `hash` varchar(32) NOT NULL default '',
  759.   PRIMARY KEY  (id)
  760. ) ENGINE=MyISAM;
  761.  
  762. CREATE TABLE IF NOT EXISTS {prefix}sessions (
  763.   id varchar(64) NOT NULL default '',
  764.   session_data text,
  765.   last_access int(10) unsigned NOT NULL default '0',
  766.   http_user_agent varchar(255) NOT NULL default '',
  767.   PRIMARY KEY  (id),
  768.   KEY expiry (last_access)
  769. ) ENGINE=MyISAM;
  770.  
  771. CREATE TABLE IF NOT EXISTS {prefix}settings (
  772.   varname varchar(100) NOT NULL default '',
  773.   grouptitle varchar(50) NOT NULL default '',
  774.   `value` mediumtext,
  775.   optioncode mediumtext,
  776.   optioncode_type enum('input','textarea','select','radio','checkbox','eval') NOT NULL default 'input',
  777.   optioncode_parse_type enum('static','eval_options','eval') NOT NULL default 'static',
  778.   display_order smallint(5) unsigned NOT NULL default '0',
  779.   validationcode text,
  780.   PRIMARY KEY  (varname)
  781. ) ENGINE=MyISAM;
  782.  
  783. CREATE TABLE IF NOT EXISTS {prefix}site_links (
  784.   id smallint(6) unsigned NOT NULL auto_increment,
  785.   listing_id int(11) unsigned default NULL,
  786.   title varchar(255) NOT NULL default '',
  787.   description text NOT NULL,
  788.   link_text varchar(255) NOT NULL default '',
  789.   show_date tinyint(1) NOT NULL default '0',
  790.   requires_active_product tinyint(1) NOT NULL default '0',
  791.   pricing_ids text NOT NULL,
  792.   extension char(3) NOT NULL default '',
  793.   PRIMARY KEY (id),
  794.   KEY listing_id (listing_id)
  795. ) ENGINE=MyISAM;
  796.  
  797. CREATE TABLE IF NOT EXISTS {prefix}tax (
  798.   id mediumint(8) unsigned NOT NULL auto_increment,
  799.   name varchar(255) NOT NULL default '',
  800.   country varchar(255) NOT NULL default '0',
  801.   state varchar(255) NOT NULL default '',
  802.   tax_rate decimal(10,2) NOT NULL default '0.00',
  803.   PRIMARY KEY  (id)
  804. ) ENGINE=MyISAM;
  805.  
  806. CREATE TABLE IF NOT EXISTS {prefix}templates (
  807.   id smallint(6) unsigned NOT NULL auto_increment,
  808.   folder varchar(50) NOT NULL default '',
  809.   title varchar(255) NOT NULL default '',
  810.   description text NOT NULL,
  811.   author varchar(255) NOT NULL default '',
  812.   PRIMARY KEY  (id)
  813. ) ENGINE=MyISAM;
  814.  
  815. CREATE TABLE IF NOT EXISTS {prefix}templates_data (
  816.   id int(10) unsigned NOT NULL auto_increment,
  817.   template_id smallint(6) unsigned NOT NULL default '0',
  818.   subfolder varchar(55) NOT NULL default '',
  819.   name varchar(255) NOT NULL default '',
  820.   `date` datetime NOT NULL default '0000-00-00 00:00:00',
  821.   contents text NOT NULL,
  822.   contents_default text NOT NULL,
  823.   PRIMARY KEY  (id),
  824.   KEY template_id (template_id)
  825. ) ENGINE=MyISAM;
  826.  
  827. CREATE TABLE IF NOT EXISTS {prefix}todo (
  828.   id int(10) unsigned NOT NULL auto_increment,
  829.   `status` varchar(55) NOT NULL default 'new',
  830.   title text NOT NULL,
  831.   description text NOT NULL,
  832.   color varchar(6) NOT NULL default '',
  833.   date_created datetime NOT NULL default '0000-00-00 00:00:00',
  834.   date_due datetime NOT NULL default '0000-00-00 00:00:00',
  835.   PRIMARY KEY  (id)
  836. ) ENGINE=MyISAM;
  837.  
  838. CREATE TABLE IF NOT EXISTS {prefix}transactions (
  839.   id int(10) unsigned NOT NULL auto_increment,
  840.   user_id int(10) unsigned NOT NULL default '0',
  841.   gateway_id varchar(55) NOT NULL default '',
  842.   transaction_id varchar(255) NOT NULL default '',
  843.   invoice_id int(10) unsigned NOT NULL default '0',
  844.   `date` datetime NOT NULL default '0000-00-00 00:00:00',
  845.   description text NOT NULL,
  846.   amount decimal(10,2) NOT NULL default '0.00',
  847.   PRIMARY KEY  (id),
  848.   KEY user_id (user_id,gateway_id),
  849.   KEY invoice_id (invoice_id)
  850. ) ENGINE=MyISAM;
  851.  
  852. CREATE TABLE IF NOT EXISTS {prefix}updates (
  853.   id int(10) unsigned NOT NULL auto_increment,
  854.   user_id int(10) unsigned NOT NULL default '0',
  855.   `type` varchar(255) NOT NULL default '',
  856.   type_id smallint(6) unsigned NOT NULL default '0',
  857.   `date` datetime NOT NULL default '0000-00-00 00:00:00',
  858.   PRIMARY KEY  (id),
  859.   UNIQUE KEY type_id (type_id,`type`),
  860.   KEY user_id (user_id)
  861. ) ENGINE=MyISAM;
  862.  
  863. CREATE TABLE IF NOT EXISTS {prefix}upgrades (
  864.   id int(10) unsigned NOT NULL auto_increment,
  865.   order_id int(10) unsigned NOT NULL default '0',
  866.   invoice_id int(10) unsigned default NULL,
  867.   `date` datetime NOT NULL default '0000-00-00 00:00:00',
  868.   pricing_id int(3) unsigned NOT NULL default '0',
  869.   pricing_id_new int(3) unsigned NOT NULL default '0',
  870.   `status` varchar(55) NOT NULL default '',
  871.   PRIMARY KEY  (id)
  872. ) ENGINE=MyISAM;
  873.  
  874. CREATE TABLE IF NOT EXISTS {prefix}users (
  875.   id int(10) unsigned NOT NULL auto_increment,
  876.   login varchar(50) NOT NULL default '',
  877.   pass varchar(50) NOT NULL default '',
  878.   salt varchar(4) NOT NULL default '',
  879.   user_email varchar(255) NOT NULL default '',
  880.   logged_last datetime NOT NULL default '0000-00-00 00:00:00',
  881.   logged_ip varchar(15) NOT NULL default '',
  882.   logged_host varchar(255) NOT NULL default '',
  883.   created datetime NOT NULL default '0000-00-00 00:00:00',
  884.   timezone_offset varchar(4) NOT NULL default '0',
  885.   password_verify varchar(255) NOT NULL default '',
  886.   credit decimal(10,2) NOT NULL default '0.00',
  887.   user_first_name varchar(255) NOT NULL default '',
  888.   user_last_name varchar(255) NOT NULL default '',
  889.   user_organization varchar(255) NOT NULL default '',
  890.   user_address1 varchar(255) NOT NULL default '',
  891.   user_address2 varchar(255) NOT NULL default '',
  892.   user_city varchar(255) NOT NULL default '',
  893.   user_state varchar(255) NOT NULL default '',
  894.   user_country varchar(255) NOT NULL default '',
  895.   user_zip varchar(15) NOT NULL default '',
  896.   user_phone varchar(15) NOT NULL default '',
  897.   user_fax varchar(15) NOT NULL default '',
  898.   user_comment text NOT NULL,
  899.   facebook_id int(10) unsigned NOT NULL default '0',
  900.   import_id smallint(6) unsigned NOT NULL default '0',
  901.   PRIMARY KEY  (id),
  902.   KEY import_id (import_id)
  903. ) ENGINE=MyISAM;
  904.  
  905. CREATE TABLE IF NOT EXISTS {prefix}users_groups (
  906.   id int(10) NOT NULL auto_increment,
  907.   name varchar(50) NOT NULL default '',
  908.   description text NOT NULL,
  909.   PRIMARY KEY  (id)
  910. ) ENGINE=MyISAM;
  911.  
  912. CREATE TABLE IF NOT EXISTS {prefix}users_groups_lookup (
  913.   user_id int(10) NOT NULL default '0',
  914.   group_id int(10) NOT NULL default '0',
  915.   PRIMARY KEY  (user_id,group_id)
  916. ) ENGINE=MyISAM;
  917.  
  918. CREATE TABLE IF NOT EXISTS {prefix}users_groups_permissions_lookup (
  919.   group_id int(10) NOT NULL default '0',
  920.   permission_id int(10) NOT NULL default '0',
  921.   PRIMARY KEY  (group_id,permission_id)
  922. ) ENGINE=MyISAM;
  923.  
  924. CREATE TABLE IF NOT EXISTS {prefix}users_login_fails (
  925.   `date` datetime NOT NULL default '0000-00-00 00:00:00',
  926.   ip_address varchar(15) NOT NULL default '',
  927.   KEY ip_address (ip_address)
  928. ) ENGINE=MyISAM;
  929.  
  930. CREATE TABLE IF NOT EXISTS {prefix}users_permissions (
  931.   id int(10) NOT NULL auto_increment,
  932.   permission_key varchar(50) NOT NULL default '',
  933.   PRIMARY KEY  (id)
  934. ) ENGINE=MyISAM;
  935.  
  936. CREATE TABLE IF NOT EXISTS {prefix}zip_data (
  937.   id int(10) unsigned NOT NULL auto_increment,
  938.   zipcode varchar(8) NOT NULL default '',
  939.   lon varchar(8) NOT NULL default '',
  940.   lat varchar(8) NOT NULL default '',
  941.   PRIMARY KEY  (id),
  942.   UNIQUE KEY zipcode (zipcode),
  943.   KEY `point` (lat,lon)
  944. ) ENGINE=MyISAM;
RAW Paste Data
Top