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 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. 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 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
Archived
This topic is now archived and is closed to further replies.