Jump to content


Photo

Anyone know how to drop this from database


  • Please log in to reply
2 replies to this topic

#1 kevsgsm78

kevsgsm78
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 29 October 2003 - 11:18 PM

hi guys

i have this and wish to remove it from database but dont know where to start, this is the install sql

[code=auto:0]# $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 - Germany
INSERT 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 &lt;email@address1&gt;, Name 2 &lt;email@address2&gt;\', \'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

#2 pauper_i

pauper_i
  • Members
  • PipPipPip
  • Advanced Member
  • 59 posts
  • LocationPhoenix, AZ, USA

Posted 30 October 2003 - 07:52 AM

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. ;)
Genius is one percent inspiration, and ninety-nine percent perspiration. [br]Thomas Alva Edison

#3 kevsgsm78

kevsgsm78
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 30 October 2003 - 01:23 PM

thanks very much mate




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users