Jump to content

Archived

This topic is now archived and is closed to further replies.

kevsgsm78

Anyone know how to drop this from database

Recommended Posts

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 - 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 <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

Share this post


Link to post
Share on other sites

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. ;)

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.