kevsgsm78 Posted October 29, 2003 Share Posted October 29, 2003 hi guys i have this and wish to remove it from database but dont know where to start, this is the install sql # $Id: oscommerce.sql,v 1.84 2003/05/27 17:32:16 hpdl Exp $## osCommerce, Open Source E-Commerce Solutions# http://www.oscommerce.com## Copyright (c) 2003 osCommerce## Released under the GNU General Public License## NOTE: * Please make any modifications to this file by hand!# * DO NOT use a mysqldump created file for new changes!# * Please take note of the table structure, and use this# structure as a standard for future modifications!# * Any tables you add here should be added in admin/backup.php# and in catalog/install/includes/functions/database.php# * To see the \'diff\'erence between MySQL databases, use# the mysqldiff perl script located in the extras# directory of the \'catalog\' module.# * Comments should be like these, full line comments.# (don\'t use inline comments) DROP TABLE IF EXISTS address_book;CREATE TABLE address_book ( address_book_id int NOT NULL auto_increment, customers_id int NOT NULL, entry_gender char(1) NOT NULL, entry_company varchar(32), entry_firstname varchar(32) NOT NULL, entry_lastname varchar(32) NOT NULL, entry_street_address varchar(64) NOT NULL, entry_suburb varchar(32), entry_postcode varchar(10) NOT NULL, entry_city varchar(32) NOT NULL, entry_state varchar(32), entry_country_id int DEFAULT \'0\' NOT NULL, entry_zone_id int DEFAULT \'0\' NOT NULL, PRIMARY KEY (address_book_id), KEY idx_address_book_customers_id (customers_id)); DROP TABLE IF EXISTS address_format;CREATE TABLE address_format ( address_format_id int NOT NULL auto_increment, address_format varchar(128) NOT NULL, address_summary varchar(48) NOT NULL, PRIMARY KEY (address_format_id)); DROP TABLE IF EXISTS banners;CREATE TABLE banners ( banners_id int NOT NULL auto_increment, banners_title varchar(64) NOT NULL, banners_url varchar(255) NOT NULL, banners_image varchar(64) NOT NULL, banners_group varchar(10) NOT NULL, banners_html_text text, expires_impressions int(7) DEFAULT \'0\', expires_date datetime DEFAULT NULL, date_scheduled datetime DEFAULT NULL, date_added datetime NOT NULL, date_status_change datetime DEFAULT NULL, status int(1) DEFAULT \'1\' NOT NULL, PRIMARY KEY (banners_id)); DROP TABLE IF EXISTS banners_history;CREATE TABLE banners_history ( banners_history_id int NOT NULL auto_increment, banners_id int NOT NULL, banners_shown int(5) NOT NULL DEFAULT \'0\', banners_clicked int(5) NOT NULL DEFAULT \'0\', banners_history_date datetime NOT NULL, PRIMARY KEY (banners_history_id)); DROP TABLE IF EXISTS categories;CREATE TABLE categories ( categories_id int NOT NULL auto_increment, categories_image varchar(64), parent_id int DEFAULT \'0\' NOT NULL, sort_order int(3), date_added datetime, last_modified datetime, PRIMARY KEY (categories_id), KEY idx_categories_parent_id (parent_id)); DROP TABLE IF EXISTS categories_description;CREATE TABLE categories_description ( categories_id int DEFAULT \'0\' NOT NULL, language_id int DEFAULT \'1\' NOT NULL, categories_name varchar(32) NOT NULL, PRIMARY KEY (categories_id, language_id), KEY idx_categories_name (categories_name)); DROP TABLE IF EXISTS configuration;CREATE TABLE configuration ( configuration_id int NOT NULL auto_increment, configuration_title varchar(64) NOT NULL, configuration_key varchar(64) NOT NULL, configuration_value varchar(255) NOT NULL, configuration_description varchar(255) NOT NULL, configuration_group_id int NOT NULL, sort_order int(5) NULL, last_modified datetime NULL, date_added datetime NOT NULL, use_function varchar(255) NULL, set_function varchar(255) NULL, PRIMARY KEY (configuration_id)); DROP TABLE IF EXISTS configuration_group;CREATE TABLE configuration_group ( configuration_group_id int NOT NULL auto_increment, configuration_group_title varchar(64) NOT NULL, configuration_group_description varchar(255) NOT NULL, sort_order int(5) NULL, visible int(1) DEFAULT \'1\' NULL, PRIMARY KEY (configuration_group_id)); DROP TABLE IF EXISTS counter;CREATE TABLE counter ( startdate char(8), counter int(12)); DROP TABLE IF EXISTS counter_history;CREATE TABLE counter_history ( month char(8), counter int(12)); DROP TABLE IF EXISTS countries;CREATE TABLE countries ( countries_id int NOT NULL auto_increment, countries_name varchar(64) NOT NULL, countries_iso_code_2 char(2) NOT NULL, countries_iso_code_3 char(3) NOT NULL, address_format_id int NOT NULL, PRIMARY KEY (countries_id), KEY IDX_COUNTRIES_NAME (countries_name)); DROP TABLE IF EXISTS currencies;CREATE TABLE currencies ( currencies_id int NOT NULL auto_increment, title varchar(32) NOT NULL, code char(3) NOT NULL, symbol_left varchar(12), symbol_right varchar(12), decimal_point char(1), thousands_point char(1), decimal_places char(1), value float(13,8), last_updated datetime NULL, PRIMARY KEY (currencies_id)); DROP TABLE IF EXISTS customers;CREATE TABLE customers ( customers_id int NOT NULL auto_increment, customers_gender char(1) NOT NULL, customers_firstname varchar(32) NOT NULL, customers_lastname varchar(32) NOT NULL, customers_dob datetime DEFAULT \'0000-00-00 00:00:00\' NOT NULL, customers_email_address varchar(96) NOT NULL, customers_default_address_id int NOT NULL, customers_telephone varchar(32) NOT NULL, customers_fax varchar(32), customers_password varchar(40) NOT NULL, customers_newsletter char(1), PRIMARY KEY (customers_id)); DROP TABLE IF EXISTS customers_basket;CREATE TABLE customers_basket ( customers_basket_id int NOT NULL auto_increment, customers_id int NOT NULL, products_id tinytext NOT NULL, customers_basket_quantity int(2) NOT NULL, final_price decimal(15,4) NOT NULL, customers_basket_date_added char(8), PRIMARY KEY (customers_basket_id)); DROP TABLE IF EXISTS customers_basket_attributes;CREATE TABLE customers_basket_attributes ( customers_basket_attributes_id int NOT NULL auto_increment, customers_id int NOT NULL, products_id tinytext NOT NULL, products_options_id int NOT NULL, products_options_value_id int NOT NULL, PRIMARY KEY (customers_basket_attributes_id)); DROP TABLE IF EXISTS customers_info;CREATE TABLE customers_info ( customers_info_id int NOT NULL, customers_info_date_of_last_logon datetime, customers_info_number_of_logons int(5), customers_info_date_account_created datetime, customers_info_date_account_last_modified datetime, global_product_notifications int(1) DEFAULT \'0\', PRIMARY KEY (customers_info_id)); DROP TABLE IF EXISTS languages;CREATE TABLE languages ( languages_id int NOT NULL auto_increment, name varchar(32) NOT NULL, code char(2) NOT NULL, image varchar(64), directory varchar(32), sort_order int(3), PRIMARY KEY (languages_id), KEY IDX_LANGUAGES_NAME (name)); DROP TABLE IF EXISTS manufacturers;CREATE TABLE manufacturers ( manufacturers_id int NOT NULL auto_increment, manufacturers_name varchar(32) NOT NULL, manufacturers_image varchar(64), date_added datetime NULL, last_modified datetime NULL, PRIMARY KEY (manufacturers_id), KEY IDX_MANUFACTURERS_NAME (manufacturers_name)); DROP TABLE IF EXISTS manufacturers_info;CREATE TABLE manufacturers_info ( manufacturers_id int NOT NULL, languages_id int NOT NULL, manufacturers_url varchar(255) NOT NULL, url_clicked int(5) NOT NULL default \'0\', date_last_click datetime NULL, PRIMARY KEY (manufacturers_id, languages_id)); DROP TABLE IF EXISTS newsletters;CREATE TABLE newsletters ( newsletters_id int NOT NULL auto_increment, title varchar(255) NOT NULL, content text NOT NULL, module varchar(255) NOT NULL, date_added datetime NOT NULL, date_sent datetime, status int(1), locked int(1) DEFAULT \'0\', PRIMARY KEY (newsletters_id)); DROP TABLE IF EXISTS orders;CREATE TABLE orders ( orders_id int NOT NULL auto_increment, customers_id int NOT NULL, customers_name varchar(64) NOT NULL, customers_company varchar(32), customers_street_address varchar(64) NOT NULL, customers_suburb varchar(32), customers_city varchar(32) NOT NULL, customers_postcode varchar(10) NOT NULL, customers_state varchar(32), customers_country varchar(32) NOT NULL, customers_telephone varchar(32) NOT NULL, customers_email_address varchar(96) NOT NULL, customers_address_format_id int(5) NOT NULL, delivery_name varchar(64) NOT NULL, delivery_company varchar(32), delivery_street_address varchar(64) NOT NULL, delivery_suburb varchar(32), delivery_city varchar(32) NOT NULL, delivery_postcode varchar(10) NOT NULL, delivery_state varchar(32), delivery_country varchar(32) NOT NULL, delivery_address_format_id int(5) NOT NULL, billing_name varchar(64) NOT NULL, billing_company varchar(32), billing_street_address varchar(64) NOT NULL, billing_suburb varchar(32), billing_city varchar(32) NOT NULL, billing_postcode varchar(10) NOT NULL, billing_state varchar(32), billing_country varchar(32) NOT NULL, billing_address_format_id int(5) NOT NULL, payment_method varchar(32) NOT NULL, cc_type varchar(20), cc_owner varchar(64), cc_number varchar(32), cc_expires varchar(4), last_modified datetime, date_purchased datetime, orders_status int(5) NOT NULL, orders_date_finished datetime, currency char(3), currency_value decimal(14,6), PRIMARY KEY (orders_id)); DROP TABLE IF EXISTS orders_products;CREATE TABLE orders_products ( orders_products_id int NOT NULL auto_increment, orders_id int NOT NULL, products_id int NOT NULL, products_model varchar(12), products_name varchar(64) NOT NULL, products_price decimal(15,4) NOT NULL, final_price decimal(15,4) NOT NULL, products_tax decimal(7,4) NOT NULL, products_quantity int(2) NOT NULL, PRIMARY KEY (orders_products_id)); DROP TABLE IF EXISTS orders_status;CREATE TABLE orders_status ( orders_status_id int DEFAULT \'0\' NOT NULL, language_id int DEFAULT \'1\' NOT NULL, orders_status_name varchar(32) NOT NULL, PRIMARY KEY (orders_status_id, language_id), KEY idx_orders_status_name (orders_status_name)); DROP TABLE IF EXISTS orders_status_history;CREATE TABLE orders_status_history ( orders_status_history_id int NOT NULL auto_increment, orders_id int NOT NULL, orders_status_id int(5) NOT NULL, date_added datetime NOT NULL, customer_notified int(1) DEFAULT \'0\', comments text, PRIMARY KEY (orders_status_history_id)); DROP TABLE IF EXISTS orders_products_attributes;CREATE TABLE orders_products_attributes ( orders_products_attributes_id int NOT NULL auto_increment, orders_id int NOT NULL, orders_products_id int NOT NULL, products_options varchar(32) NOT NULL, products_options_values varchar(32) NOT NULL, options_values_price decimal(15,4) NOT NULL, price_prefix char(1) NOT NULL, PRIMARY KEY (orders_products_attributes_id)); DROP TABLE IF EXISTS orders_products_download;CREATE TABLE orders_products_download ( orders_products_download_id int NOT NULL auto_increment, orders_id int NOT NULL default \'0\', orders_products_id int NOT NULL default \'0\', orders_products_filename varchar(255) NOT NULL default \'\', download_maxdays int(2) NOT NULL default \'0\', download_count int(2) NOT NULL default \'0\', PRIMARY KEY (orders_products_download_id)); DROP TABLE IF EXISTS orders_total;CREATE TABLE orders_total ( orders_total_id int unsigned NOT NULL auto_increment, orders_id int NOT NULL, title varchar(255) NOT NULL, text varchar(255) NOT NULL, value decimal(15,4) NOT NULL, class varchar(32) NOT NULL, sort_order int NOT NULL, PRIMARY KEY (orders_total_id), KEY idx_orders_total_orders_id (orders_id)); DROP TABLE IF EXISTS products;CREATE TABLE products ( products_id int NOT NULL auto_increment, products_quantity int(4) NOT NULL, products_model varchar(12), products_image varchar(64), products_price decimal(15,4) NOT NULL, products_date_added datetime NOT NULL, products_last_modified datetime, products_date_available datetime, products_weight decimal(5,2) NOT NULL, products_status tinyint(1) NOT NULL, products_tax_class_id int NOT NULL, manufacturers_id int NULL, products_ordered int NOT NULL default \'0\', PRIMARY KEY (products_id), KEY idx_products_date_added (products_date_added)); DROP TABLE IF EXISTS products_attributes;CREATE TABLE products_attributes ( products_attributes_id int NOT NULL auto_increment, products_id int NOT NULL, options_id int NOT NULL, options_values_id int NOT NULL, options_values_price decimal(15,4) NOT NULL, price_prefix char(1) NOT NULL, PRIMARY KEY (products_attributes_id)); DROP TABLE IF EXISTS products_attributes_download;CREATE TABLE products_attributes_download ( products_attributes_id int NOT NULL, products_attributes_filename varchar(255) NOT NULL default \'\', products_attributes_maxdays int(2) default \'0\', products_attributes_maxcount int(2) default \'0\', PRIMARY KEY (products_attributes_id)); DROP TABLE IF EXISTS products_description;CREATE TABLE products_description ( products_id int NOT NULL auto_increment, language_id int NOT NULL default \'1\', products_name varchar(64) NOT NULL default \'\', products_description text, products_url varchar(255) default NULL, products_viewed int(5) default \'0\', PRIMARY KEY (products_id,language_id), KEY products_name (products_name)); DROP TABLE IF EXISTS products_notifications;CREATE TABLE products_notifications ( products_id int NOT NULL, customers_id int NOT NULL, date_added datetime NOT NULL, PRIMARY KEY (products_id, customers_id)); DROP TABLE IF EXISTS products_options;CREATE TABLE products_options ( products_options_id int NOT NULL default \'0\', language_id int NOT NULL default \'1\', products_options_name varchar(32) NOT NULL default \'\', PRIMARY KEY (products_options_id,language_id)); DROP TABLE IF EXISTS products_options_values;CREATE TABLE products_options_values ( products_options_values_id int NOT NULL default \'0\', language_id int NOT NULL default \'1\', products_options_values_name varchar(64) NOT NULL default \'\', PRIMARY KEY (products_options_values_id,language_id)); DROP TABLE IF EXISTS products_options_values_to_products_options;CREATE TABLE products_options_values_to_products_options ( products_options_values_to_products_options_id int NOT NULL auto_increment, products_options_id int NOT NULL, products_options_values_id int NOT NULL, PRIMARY KEY (products_options_values_to_products_options_id)); DROP TABLE IF EXISTS products_to_categories;CREATE TABLE products_to_categories ( products_id int NOT NULL, categories_id int NOT NULL, PRIMARY KEY (products_id,categories_id)); DROP TABLE IF EXISTS reviews;CREATE TABLE reviews ( reviews_id int NOT NULL auto_increment, products_id int NOT NULL, customers_id int, customers_name varchar(64) NOT NULL, reviews_rating int(1), date_added datetime, last_modified datetime, reviews_read int(5) NOT NULL default \'0\', PRIMARY KEY (reviews_id)); DROP TABLE IF EXISTS reviews_description;CREATE TABLE reviews_description ( reviews_id int NOT NULL, languages_id int NOT NULL, reviews_text text NOT NULL, PRIMARY KEY (reviews_id, languages_id)); DROP TABLE IF EXISTS sessions;CREATE TABLE sessions ( sesskey varchar(32) NOT NULL, expiry int(11) unsigned NOT NULL, value text NOT NULL, PRIMARY KEY (sesskey)); DROP TABLE IF EXISTS specials;CREATE TABLE specials ( specials_id int NOT NULL auto_increment, products_id int NOT NULL, specials_new_products_price decimal(15,4) NOT NULL, specials_date_added datetime, specials_last_modified datetime, expires_date datetime, date_status_change datetime, status int(1) NOT NULL DEFAULT \'1\', PRIMARY KEY (specials_id)); DROP TABLE IF EXISTS tax_class;CREATE TABLE tax_class ( tax_class_id int NOT NULL auto_increment, tax_class_title varchar(32) NOT NULL, tax_class_description varchar(255) NOT NULL, last_modified datetime NULL, date_added datetime NOT NULL, PRIMARY KEY (tax_class_id)); DROP TABLE IF EXISTS tax_rates;CREATE TABLE tax_rates ( tax_rates_id int NOT NULL auto_increment, tax_zone_id int NOT NULL, tax_class_id int NOT NULL, tax_priority int(5) DEFAULT 1, tax_rate decimal(7,4) NOT NULL, tax_description varchar(255) NOT NULL, last_modified datetime NULL, date_added datetime NOT NULL, PRIMARY KEY (tax_rates_id)); DROP TABLE IF EXISTS geo_zones;CREATE TABLE geo_zones ( geo_zone_id int NOT NULL auto_increment, geo_zone_name varchar(32) NOT NULL, geo_zone_description varchar(255) NOT NULL, last_modified datetime NULL, date_added datetime NOT NULL, PRIMARY KEY (geo_zone_id)); DROP TABLE IF EXISTS whos_online;CREATE TABLE whos_online ( customer_id int, full_name varchar(64) NOT NULL, session_id varchar(128) NOT NULL, ip_address varchar(15) NOT NULL, time_entry varchar(14) NOT NULL, time_last_click varchar(14) NOT NULL, last_page_url varchar(64) NOT NULL); DROP TABLE IF EXISTS zones;CREATE TABLE zones ( zone_id int NOT NULL auto_increment, zone_country_id int NOT NULL, zone_code varchar(32) NOT NULL, zone_name varchar(32) NOT NULL, PRIMARY KEY (zone_id)); DROP TABLE IF EXISTS zones_to_geo_zones;CREATE TABLE zones_to_geo_zones ( association_id int NOT NULL auto_increment, zone_country_id int NOT NULL, zone_id int NULL, geo_zone_id int NULL, last_modified datetime NULL, date_added datetime NOT NULL, PRIMARY KEY (association_id)); # data INSERT INTO address_book VALUES ( \'1\', \'1\', \'m\', \'ACME Inc.\', \'John\', \'Doe\', \'1 Way Street\', \'\', \'12345\', \'NeverNever\', \'\', \'223\', \'12\'); # 1 - Default, 2 - USA, 3 - Spain, 4 - Singapore, 5 - GermanyINSERT INTO address_format VALUES (1, \'$firstname $lastname$cr$streets$cr$city, $postcode$cr$statecomma$country\',\'$city / $country\');INSERT INTO address_format VALUES (2, \'$firstname $lastname$cr$streets$cr$city, $state $postcode$cr$country\',\'$city, $state / $country\');INSERT INTO address_format VALUES (3, \'$firstname $lastname$cr$streets$cr$city$cr$postcode - $statecomma$country\',\'$state / $country\');INSERT INTO address_format VALUES (4, \'$firstname $lastname$cr$streets$cr$city ($postcode)$cr$country\', \'$postcode / $country\');INSERT INTO address_format VALUES (5, \'$firstname $lastname$cr$streets$cr$postcode $city$cr$country\',\'$city / $country\'); INSERT INTO banners VALUES (1, \'osCommerce\', \'http://www.oscommerce.com\', \'banners/oscommerce.gif\', \'468x50\', \'\', 0, null, null, now(), null, 1); INSERT INTO categories VALUES (\'1\', \'category_hardware.gif\', \'0\', \'1\', now(), null);INSERT INTO categories VALUES (\'2\', \'category_software.gif\', \'0\', \'2\', now(), null);INSERT INTO categories VALUES (\'3\', \'category_dvd_movies.gif\', \'0\', \'3\', now(), null);INSERT INTO categories VALUES (\'4\', \'subcategory_graphic_cards.gif\', \'1\', \'0\', now(), null);INSERT INTO categories VALUES (\'5\', \'subcategory_printers.gif\', \'1\', \'0\', now(), null);INSERT INTO categories VALUES (\'6\', \'subcategory_monitors.gif\', \'1\', \'0\', now(), null);INSERT INTO categories VALUES (\'7\', \'subcategory_speakers.gif\', \'1\', \'0\', now(), null);INSERT INTO categories VALUES (\'8\', \'subcategory_keyboards.gif\', \'1\', \'0\', now(), null);INSERT INTO categories VALUES (\'9\', \'subcategory_mice.gif\', \'1\', \'0\', now(), null);INSERT INTO categories VALUES (\'10\', \'subcategory_action.gif\', \'3\', \'0\', now(), null);INSERT INTO categories VALUES (\'11\', \'subcategory_science_fiction.gif\', \'3\', \'0\', now(), null);INSERT INTO categories VALUES (\'12\', \'subcategory_comedy.gif\', \'3\', \'0\', now(), null);INSERT INTO categories VALUES (\'13\', \'subcategory_cartoons.gif\', \'3\', \'0\', now(), null);INSERT INTO categories VALUES (\'14\', \'subcategory_thriller.gif\', \'3\', \'0\', now(), null);INSERT INTO categories VALUES (\'15\', \'subcategory_drama.gif\', \'3\', \'0\', now(), null);INSERT INTO categories VALUES (\'16\', \'subcategory_memory.gif\', \'1\', \'0\', now(), null);INSERT INTO categories VALUES (\'17\', \'subcategory_cdrom_drives.gif\', \'1\', \'0\', now(), null);INSERT INTO categories VALUES (\'18\', \'subcategory_simulation.gif\', \'2\', \'0\', now(), null);INSERT INTO categories VALUES (\'19\', \'subcategory_action_games.gif\', \'2\', \'0\', now(), null);INSERT INTO categories VALUES (\'20\', \'subcategory_strategy.gif\', \'2\', \'0\', now(), null); INSERT INTO categories_description VALUES ( \'1\', \'1\', \'Hardware\');INSERT INTO categories_description VALUES ( \'2\', \'1\', \'Software\');INSERT INTO categories_description VALUES ( \'3\', \'1\', \'DVD Movies\');INSERT INTO categories_description VALUES ( \'4\', \'1\', \'Graphics Cards\');INSERT INTO categories_description VALUES ( \'5\', \'1\', \'Printers\');INSERT INTO categories_description VALUES ( \'6\', \'1\', \'Monitors\');INSERT INTO categories_description VALUES ( \'7\', \'1\', \'Speakers\');INSERT INTO categories_description VALUES ( \'8\', \'1\', \'Keyboards\');INSERT INTO categories_description VALUES ( \'9\', \'1\', \'Mice\');INSERT INTO categories_description VALUES ( \'10\', \'1\', \'Action\');INSERT INTO categories_description VALUES ( \'11\', \'1\', \'Science Fiction\');INSERT INTO categories_description VALUES ( \'12\', \'1\', \'Comedy\');INSERT INTO categories_description VALUES ( \'13\', \'1\', \'Cartoons\');INSERT INTO categories_description VALUES ( \'14\', \'1\', \'Thriller\');INSERT INTO categories_description VALUES ( \'15\', \'1\', \'Drama\');INSERT INTO categories_description VALUES ( \'16\', \'1\', \'Memory\');INSERT INTO categories_description VALUES ( \'17\', \'1\', \'CDROM Drives\');INSERT INTO categories_description VALUES ( \'18\', \'1\', \'Simulation\');INSERT INTO categories_description VALUES ( \'19\', \'1\', \'Action\');INSERT INTO categories_description VALUES ( \'20\', \'1\', \'Strategy\');INSERT INTO categories_description VALUES ( \'1\', \'2\', \'Hardware\');INSERT INTO categories_description VALUES ( \'2\', \'2\', \'Software\');INSERT INTO categories_description VALUES ( \'3\', \'2\', \'DVD Filme\');INSERT INTO categories_description VALUES ( \'4\', \'2\', \'Grafikkarten\');INSERT INTO categories_description VALUES ( \'5\', \'2\', \'Drucker\');INSERT INTO categories_description VALUES ( \'6\', \'2\', \'Bildschirme\');INSERT INTO categories_description VALUES ( \'7\', \'2\', \'Lautsprecher\');INSERT INTO categories_description VALUES ( \'8\', \'2\', \'Tastaturen\');INSERT INTO categories_description VALUES ( \'9\', \'2\', \'Mäuse\');INSERT INTO categories_description VALUES ( \'10\', \'2\', \'Action\');INSERT INTO categories_description VALUES ( \'11\', \'2\', \'Science Fiction\');INSERT INTO categories_description VALUES ( \'12\', \'2\', \'Komödie\');INSERT INTO categories_description VALUES ( \'13\', \'2\', \'Zeichentrick\');INSERT INTO categories_description VALUES ( \'14\', \'2\', \'Thriller\');INSERT INTO categories_description VALUES ( \'15\', \'2\', \'Drama\');INSERT INTO categories_description VALUES ( \'16\', \'2\', \'Speicher\');INSERT INTO categories_description VALUES ( \'17\', \'2\', \'CDROM Laufwerke\');INSERT INTO categories_description VALUES ( \'18\', \'2\', \'Simulation\');INSERT INTO categories_description VALUES ( \'19\', \'2\', \'Action\');INSERT INTO categories_description VALUES ( \'20\', \'2\', \'Strategie\');INSERT INTO categories_description VALUES ( \'1\', \'3\', \'Hardware\');INSERT INTO categories_description VALUES ( \'2\', \'3\', \'Software\');INSERT INTO categories_description VALUES ( \'3\', \'3\', \'Peliculas DVD\');INSERT INTO categories_description VALUES ( \'4\', \'3\', \'Tarjetas Graficas\');INSERT INTO categories_description VALUES ( \'5\', \'3\', \'Impresoras\');INSERT INTO categories_description VALUES ( \'6\', \'3\', \'Monitores\');INSERT INTO categories_description VALUES ( \'7\', \'3\', \'Altavoces\');INSERT INTO categories_description VALUES ( \'8\', \'3\', \'Teclados\');INSERT INTO categories_description VALUES ( \'9\', \'3\', \'Ratones\');INSERT INTO categories_description VALUES ( \'10\', \'3\', \'Accion\');INSERT INTO categories_description VALUES ( \'11\', \'3\', \'Ciencia Ficcion\');INSERT INTO categories_description VALUES ( \'12\', \'3\', \'Comedia\');INSERT INTO categories_description VALUES ( \'13\', \'3\', \'Dibujos Animados\');INSERT INTO categories_description VALUES ( \'14\', \'3\', \'Suspense\');INSERT INTO categories_description VALUES ( \'15\', \'3\', \'Drama\');INSERT INTO categories_description VALUES ( \'16\', \'3\', \'Memoria\');INSERT INTO categories_description VALUES ( \'17\', \'3\', \'Unidades CDROM\');INSERT INTO categories_description VALUES ( \'18\', \'3\', \'Simulacion\');INSERT INTO categories_description VALUES ( \'19\', \'3\', \'Accion\');INSERT INTO categories_description VALUES ( \'20\', \'3\', \'Estrategia\'); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'Store Name\', \'STORE_NAME\', \'osCommerce\', \'The name of my store\', \'1\', \'1\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'Store Owner\', \'STORE_OWNER\', \'Harald Ponce de Leon\', \'The name of my store owner\', \'1\', \'2\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'E-Mail Address\', \'STORE_OWNER_EMAIL_ADDRESS\', \'root@localhost\', \'The e-mail address of my store owner\', \'1\', \'3\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'E-Mail From\', \'EMAIL_FROM\', \'osCommerce <root@localhost>\', \'The e-mail address used in (sent) e-mails\', \'1\', \'4\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) VALUES (\'Country\', \'STORE_COUNTRY\', \'223\', \'The country my store is located in <br><br><b>Note: Please remember to update the store zone.</b>\', \'1\', \'6\', \'tep_get_country_name\', \'tep_cfg_pull_down_country_list(\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) VALUES (\'Zone\', \'STORE_ZONE\', \'18\', \'The zone my store is located in\', \'1\', \'7\', \'tep_cfg_get_zone_name\', \'tep_cfg_pull_down_zone_list(\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (\'Expected Sort Order\', \'EXPECTED_PRODUCTS_SORT\', \'desc\', \'This is the sort order used in the expected products box.\', \'1\', \'8\', \'tep_cfg_select_option(array(\'asc\', \'desc\'), \', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (\'Expected Sort Field\', \'EXPECTED_PRODUCTS_FIELD\', \'date_expected\', \'The column to sort by in the expected products box.\', \'1\', \'9\', \'tep_cfg_select_option(array(\'products_name\', \'date_expected\'), \', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (\'Switch To Default Language Currency\', \'USE_DEFAULT_LANGUAGE_CURRENCY\', \'false\', \'Automatically switch to the language\'s currency when it is changed\', \'1\', \'10\', \'tep_cfg_select_option(array(\'true\', \'false\'), \', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'Send Extra Order Emails To\', \'SEND_EXTRA_ORDER_EMAILS_TO\', \'\', \'Send extra order emails to the following email addresses, in this format: Name 1 <email@address1>, Name 2 <email@address2>\', \'1\', \'11\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (\'Use Search-Engine Safe URLs (still in development)\', \'SEARCH_ENGINE_FRIENDLY_URLS\', \'false\', \'Use search-engine safe urls for all site links\', \'1\', \'12\', \'tep_cfg_select_option(array(\'true\', \'false\'), \', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (\'Display Cart After Adding Product\', \'DISPLAY_CART\', \'true\', \'Display the shopping cart after adding a product (or return back to their origin)\', \'1\', \'14\', \'tep_cfg_select_option(array(\'true\', \'false\'), \', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (\'Allow Guest To Tell A Friend\', \'ALLOW_GUEST_TO_TELL_A_FRIEND\', \'false\', \'Allow guests to tell a friend about a product\', \'1\', \'15\', \'tep_cfg_select_option(array(\'true\', \'false\'), \', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (\'Default Search Operator\', \'ADVANCED_SEARCH_DEFAULT_OPERATOR\', \'and\', \'Default search operators\', \'1\', \'17\', \'tep_cfg_select_option(array(\'and\', \'or\'), \', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (\'Store Address and Phone\', \'STORE_NAME_ADDRESS\', \'Store NamenAddressnCountrynPhone\', \'This is the Store Name, Address and Phone used on printable documents and displayed online\', \'1\', \'18\', \'tep_cfg_textarea(\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (\'Show Category Counts\', \'SHOW_COUNTS\', \'true\', \'Count recursively how many products are in each category\', \'1\', \'19\', \'tep_cfg_select_option(array(\'true\', \'false\'), \', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'Tax Decimal Places\', \'TAX_DECIMAL_PLACES\', \'0\', \'Pad the tax value this amount of decimal places\', \'1\', \'20\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (\'Display Prices with Tax\', \'DISPLAY_PRICE_WITH_TAX\', \'false\', \'Display prices with tax included (true) or add the tax at the end (false)\', \'1\', \'21\', \'tep_cfg_select_option(array(\'true\', \'false\'), \', now()); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'First Name\', \'ENTRY_FIRST_NAME_MIN_LENGTH\', \'2\', \'Minimum length of first name\', \'2\', \'1\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'Last Name\', \'ENTRY_LAST_NAME_MIN_LENGTH\', \'2\', \'Minimum length of last name\', \'2\', \'2\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'Date of Birth\', \'ENTRY_DOB_MIN_LENGTH\', \'10\', \'Minimum length of date of birth\', \'2\', \'3\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'E-Mail Address\', \'ENTRY_EMAIL_ADDRESS_MIN_LENGTH\', \'6\', \'Minimum length of e-mail address\', \'2\', \'4\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'Street Address\', \'ENTRY_STREET_ADDRESS_MIN_LENGTH\', \'5\', \'Minimum length of street address\', \'2\', \'5\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'Company\', \'ENTRY_COMPANY_MIN_LENGTH\', \'2\', \'Minimum length of company name\', \'2\', \'6\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'Post Code\', \'ENTRY_POSTCODE_MIN_LENGTH\', \'4\', \'Minimum length of post code\', \'2\', \'7\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'City\', \'ENTRY_CITY_MIN_LENGTH\', \'3\', \'Minimum length of city\', \'2\', \'8\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'State\', \'ENTRY_STATE_MIN_LENGTH\', \'2\', \'Minimum length of state\', \'2\', \'9\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'Telephone Number\', \'ENTRY_TELEPHONE_MIN_LENGTH\', \'3\', \'Minimum length of telephone number\', \'2\', \'10\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'Password\', \'ENTRY_PASSWORD_MIN_LENGTH\', \'5\', \'Minimum length of password\', \'2\', \'11\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'Credit Card Owner Name\', \'CC_OWNER_MIN_LENGTH\', \'3\', \'Minimum length of credit card owner name\', \'2\', \'12\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'Credit Card Number\', \'CC_NUMBER_MIN_LENGTH\', \'10\', \'Minimum length of credit card number\', \'2\', \'13\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'Review Text\', \'REVIEW_TEXT_MIN_LENGTH\', \'50\', \'Minimum length of review text\', \'2\', \'14\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'Best Sellers\', \'MIN_DISPLAY_BESTSELLERS\', \'1\', \'Minimum number of best sellers to display\', \'2\', \'15\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'Also Purchased\', \'MIN_DISPLAY_ALSO_PURCHASED\', \'1\', \'Minimum number of products to display in the \'This Customer Also Purchased\' box\', \'2\', \'16\', now()); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'Address Book Entries\', \'MAX_ADDRESS_BOOK_ENTRIES\', \'5\', \'Maximum address book entries a customer is allowed to have\', \'3\', \'1\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'Search Results\', \'MAX_DISPLAY_SEARCH_RESULTS\', \'20\', \'Amount of products to list\', \'3\', \'2\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'Page Links\', \'MAX_DISPLAY_PAGE_LINKS\', \'5\', \'Number of \'number\' links use for page-sets\', \'3\', \'3\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'Special Products\', \'MAX_DISPLAY_SPECIAL_PRODUCTS\', \'9\', \'Maximum number of products on special to display\', \'3\', \'4\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'New Products Module\', \'MAX_DISPLAY_NEW_PRODUCTS\', \'9\', \'Maximum number of new products to display in a category\', \'3\', \'5\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'Products Expected\', \'MAX_DISPLAY_UPCOMING_PRODUCTS\', \'10\', \'Maximum number of products expected to display\', \'3\', \'6\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'Manufacturers List\', \'MAX_DISPLAY_MANUFACTURERS_IN_A_LIST\', \'0\', \'Used in manufacturers box; when the number of manufacturers exceeds this number, a drop-down list will be displayed instead of the default list\', \'3\', \'7\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'Manufacturers Select Size\', \'MAX_MANUFACTURERS_LIST\', \'1\', \'Used in manufacturers box; when this value is \'1\' the classic drop-down list will be used for the manufacturers box. Otherwise, a list-box with the specified number of rows will be displayed.\', \'3\', \'7\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'Length of Manufacturers Name\', \'MAX_DISPLAY_MANUFACTURER_NAME_LEN\', \'15\', \'Used in manufacturers box; maximum length of manufacturers name to display\', \'3\', \'8\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'New Reviews\', \'MAX_DISPLAY_NEW_REVIEWS\', \'6\', \'Maximum number of new reviews to display\', \'3\', \'9\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'Selection of Random Reviews\', \'MAX_RANDOM_SELECT_REVIEWS\', \'10\', \'How many records to select from to choose one random product review\', \'3\', \'10\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'Selection of Random New Products\', \'MAX_RANDOM_SELECT_NEW\', \'10\', \'How many records to select from to choose one random new product to display\', \'3\', \'11\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'Selection of Products on Special\', \'MAX_RANDOM_SELECT_SPECIALS\', \'10\', \'How many records to select from to choose one random product special to display\', \'3\', \'12\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'Categories To List Per Row\', \'MAX_DISPLAY_CATEGORIES_PER_ROW\', \'3\', \'How many categories to list per row\', \'3\', \'13\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'New Products Listing\', \'MAX_DISPLAY_PRODUCTS_NEW\', \'10\', \'Maximum number of new products to display in new products page\', \'3\', \'14\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'Best Sellers\', \'MAX_DISPLAY_BESTSELLERS\', \'10\', \'Maximum number of best sellers to display\', \'3\', \'15\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'Also Purchased\', \'MAX_DISPLAY_ALSO_PURCHASED\', \'6\', \'Maximum number of products to display in the \'This Customer Also Purchased\' box\', \'3\', \'16\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'Customer Order History Box\', \'MAX_DISPLAY_PRODUCTS_IN_ORDER_HISTORY_BOX\', \'6\', \'Maximum number of products to display in the customer order history box\', \'3\', \'17\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'Order History\', \'MAX_DISPLAY_ORDER_HISTORY\', \'10\', \'Maximum number of orders to display in the order history page\', \'3\', \'18\', now()); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'Small Image Width\', \'SMALL_IMAGE_WIDTH\', \'100\', \'The pixel width of small images\', \'4\', \'1\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'Small Image Height\', \'SMALL_IMAGE_HEIGHT\', \'80\', \'The pixel height of small images\', \'4\', \'2\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'Heading Image Width\', \'HEADING_IMAGE_WIDTH\', \'57\', \'The pixel width of heading images\', \'4\', \'3\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'Heading Image Height\', \'HEADING_IMAGE_HEIGHT\', \'40\', \'The pixel height of heading images\', \'4\', \'4\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'Subcategory Image Width\', \'SUBCATEGORY_IMAGE_WIDTH\', \'100\', \'The pixel width of subcategory images\', \'4\', \'5\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'Subcategory Image Height\', \'SUBCATEGORY_IMAGE_HEIGHT\', \'57\', \'The pixel height of subcategory images\', \'4\', \'6\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (\'Calculate Image Size\', \'CONFIG_CALCULATE_IMAGE_SIZE\', \'true\', \'Calculate the size of images?\', \'4\', \'7\', \'tep_cfg_select_option(array(\'true\', \'false\'), \', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (\'Image Required\', \'IMAGE_REQUIRED\', \'true\', \'Enable to display broken images. Good for development.\', \'4\', \'8\', \'tep_cfg_select_option(array(\'true\', \'false\'), \', now()); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (\'Gender\', \'ACCOUNT_GENDER\', \'true\', \'Display gender in the customers account\', \'5\', \'1\', \'tep_cfg_select_option(array(\'true\', \'false\'), \', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (\'Date of Birth\', \'ACCOUNT_DOB\', \'true\', \'Display date of birth in the customers account\', \'5\', \'2\', \'tep_cfg_select_option(array(\'true\', \'false\'), \', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (\'Company\', \'ACCOUNT_COMPANY\', \'true\', \'Display company in the customers account\', \'5\', \'3\', \'tep_cfg_select_option(array(\'true\', \'false\'), \', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (\'Suburb\', \'ACCOUNT_SUBURB\', \'true\', \'Display suburb in the customers account\', \'5\', \'4\', \'tep_cfg_select_option(array(\'true\', \'false\'), \', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (\'State\', \'ACCOUNT_STATE\', \'true\', \'Display state in the customers account\', \'5\', \'5\', \'tep_cfg_select_option(array(\'true\', \'false\'), \', now()); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'Installed Modules\', \'MODULE_PAYMENT_INSTALLED\', \'cc.php;cod.php\', \'List of payment module filenames separated by a semi-colon. This is automatically updated. No need to edit. (Example: cc.php;cod.php;paypal.php)\', \'6\', \'0\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'Installed Modules\', \'MODULE_ORDER_TOTAL_INSTALLED\', \'ot_subtotal.php;ot_tax.php;ot_shipping.php;ot_total.php\', \'List of order_total module filenames separated by a semi-colon. This is automatically updated. No need to edit. (Example: ot_subtotal.php;ot_tax.php;ot_shipping.php;ot_total.php)\', \'6\', \'0\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'Installed Modules\', \'MODULE_SHIPPING_INSTALLED\', \'flat.php\', \'List of shipping module filenames separated by a semi-colon. This is automatically updated. No need to edit. (Example: ups.php;flat.php;item.php)\', \'6\', \'0\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (\'Enable Cash On Delivery Module\', \'MODULE_PAYMENT_COD_STATUS\', \'True\', \'Do you want to accept Cash On Delevery payments?\', \'6\', \'1\', \'tep_cfg_select_option(array(\'True\', \'False\'), \', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) VALUES (\'Payment Zone\', \'MODULE_PAYMENT_COD_ZONE\', \'0\', \'If a zone is selected, only enable this payment method for that zone.\', \'6\', \'2\', \'tep_get_zone_class_title\', \'tep_cfg_pull_down_zone_classes(\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'Sort order of display.\', \'MODULE_PAYMENT_COD_SORT_ORDER\', \'0\', \'Sort order of display. Lowest is displayed first.\', \'6\', \'0\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, use_function, date_added) VALUES (\'Set Order Status\', \'MODULE_PAYMENT_COD_ORDER_STATUS_ID\', \'0\', \'Set the status of orders made with this payment module to this value\', \'6\', \'0\', \'tep_cfg_pull_down_order_statuses(\', \'tep_get_order_status_name\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (\'Enable Credit Card Module\', \'MODULE_PAYMENT_CC_STATUS\', \'True\', \'Do you want to accept credit card payments?\', \'6\', \'0\', \'tep_cfg_select_option(array(\'True\', \'False\'), \', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'Split Credit Card E-Mail Address\', \'MODULE_PAYMENT_CC_EMAIL\', \'\', \'If an e-mail address is entered, the middle digits of the credit card number will be sent to the e-mail address (the outside digits are stored in the database with the middle digits censored)\', \'6\', \'0\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'Sort order of display.\', \'MODULE_PAYMENT_CC_SORT_ORDER\', \'0\', \'Sort order of display. Lowest is displayed first.\', \'6\', \'0\' , now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) VALUES (\'Payment Zone\', \'MODULE_PAYMENT_CC_ZONE\', \'0\', \'If a zone is selected, only enable this payment method for that zone.\', \'6\', \'2\', \'tep_get_zone_class_title\', \'tep_cfg_pull_down_zone_classes(\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, use_function, date_added) VALUES (\'Set Order Status\', \'MODULE_PAYMENT_CC_ORDER_STATUS_ID\', \'0\', \'Set the status of orders made with this payment module to this value\', \'6\', \'0\', \'tep_cfg_pull_down_order_statuses(\', \'tep_get_order_status_name\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (\'Enable Flat Shipping\', \'MODULE_SHIPPING_FLAT_STATUS\', \'True\', \'Do you want to offer flat rate shipping?\', \'6\', \'0\', \'tep_cfg_select_option(array(\'True\', \'False\'), \', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'Shipping Cost\', \'MODULE_SHIPPING_FLAT_COST\', \'5.00\', \'The shipping cost for all orders using this shipping method.\', \'6\', \'0\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) VALUES (\'Tax Class\', \'MODULE_SHIPPING_FLAT_TAX_CLASS\', \'0\', \'Use the following tax class on the shipping fee.\', \'6\', \'0\', \'tep_get_tax_class_title\', \'tep_cfg_pull_down_tax_classes(\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) VALUES (\'Shipping Zone\', \'MODULE_SHIPPING_FLAT_ZONE\', \'0\', \'If a zone is selected, only enable this shipping method for that zone.\', \'6\', \'0\', \'tep_get_zone_class_title\', \'tep_cfg_pull_down_zone_classes(\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'Sort Order\', \'MODULE_SHIPPING_FLAT_SORT_ORDER\', \'0\', \'Sort order of display.\', \'6\', \'0\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'Default Currency\', \'DEFAULT_CURRENCY\', \'USD\', \'Default Currency\', \'6\', \'0\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'Default Language\', \'DEFAULT_LANGUAGE\', \'en\', \'Default Language\', \'6\', \'0\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (\'Default Order Status For New Orders\', \'DEFAULT_ORDERS_STATUS_ID\', \'1\', \'When a new order is created, this order status will be assigned to it.\', \'6\', \'0\', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (\'Display Shipping\', \'MODULE_ORDER_TOTAL_SHIPPING_STATUS\', \'true\', \'Do you want to display the order shipping cost?\', \'6\', \'1\',\'tep_cfg_select_option(array(\'true\', \'false\'), \', now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort Quote Link to comment https://forums.phpfreaks.com/topic/1253-anyone-know-how-to-drop-this-from-database/ Share on other sites More sharing options...
pauper_i Posted October 30, 2003 Share Posted October 30, 2003 DROP TABLE address_book; DROP TABLE address_format; DROP TABLE banners; DROP TABLE banners_history; DROP TABLE categories; DROP TABLE categories_description; DROP TABLE configuration; DROP TABLE configuration_group; DROP TABLE counter; DROP TABLE counter_history; DROP TABLE countries; DROP TABLE currencies; DROP TABLE customers; DROP TABLE customers_basket; DROP TABLE customers_basket_attributes; DROP TABLE customers_info; DROP TABLE geo_zones; DROP TABLE languages; DROP TABLE manufacturers; DROP TABLE manufacturers_info; DROP TABLE newsletters; DROP TABLE orders; DROP TABLE orders_products; DROP TABLE orders_products_attributes; DROP TABLE orders_products_download; DROP TABLE orders_status; DROP TABLE orders_status_history; DROP TABLE orders_total; DROP TABLE products; DROP TABLE products_attributes; DROP TABLE products_attributes_download; DROP TABLE products_description; DROP TABLE products_notifications; DROP TABLE products_options; DROP TABLE products_options_values; DROP TABLE products_options_values_to_products_options; DROP TABLE products_to_categories; DROP TABLE reviews; DROP TABLE reviews_description; DROP TABLE sessions; DROP TABLE specials; DROP TABLE tax_class; DROP TABLE tax_rates; DROP TABLE whos_online; DROP TABLE zones; DROP TABLE zones_to_geo_zones; Just a simple parse from the information you provided. Quote Link to comment https://forums.phpfreaks.com/topic/1253-anyone-know-how-to-drop-this-from-database/#findComment-4172 Share on other sites More sharing options...
kevsgsm78 Posted October 30, 2003 Author Share Posted October 30, 2003 thanks very much mate Quote Link to comment https://forums.phpfreaks.com/topic/1253-anyone-know-how-to-drop-this-from-database/#findComment-4179 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.