# phpMyAdmin MySQL-Dump
# version 2.3.2
# http://www.phpmyadmin.net/ (download page)
#
# Host: localhost
# Generation Time: Jul 21, 2003 at 11:03 AM
# Server version: 3.23.52
# PHP Version: 4.1.2
# Database : `echocart`
# --------------------------------------------------------

#
# Table structure for table `address_book`
#

CREATE TABLE address_book (
  customers_id int(5) NOT NULL default '0',
address_book_id int(5) NOT NULL default '1',
entry_gender char(1) NOT NULL default '',
entry_company varchar(32) default NULL,
entry_firstname varchar(32) NOT NULL default '',
entry_lastname varchar(32) NOT NULL default '',
entry_street_address varchar(64) NOT NULL default '',
entry_suburb varchar(32) default NULL,
entry_postcode varchar(10) NOT NULL default '',
entry_city varchar(32) NOT NULL default '',
entry_state varchar(32) default NULL,
entry_country_id int(5) NOT NULL default '0',
entry_zone_id int(5) NOT NULL default '0',
PRIMARY KEY  (address_book_id,customers_id)
) TYPE=MyISAM

#
# Table structure for table `address_format`
#

CREATE TABLE address_format (
address_format_id int(5) NOT NULL auto_increment,
address_format varchar(128) NOT NULL default '',
address_summary varchar(48) NOT NULL default '',
PRIMARY KEY  (address_format_id)
) TYPE=MyISAM
# --------------------------------------------------------

#
# Table structure for table `banners`
#

CREATE TABLE banners (
banners_id int(5) NOT NULL auto_increment,
banners_title varchar(64) NOT NULL default '',
banners_url varchar(64) NOT NULL default '',
banners_image varchar(64) NOT NULL default '',
banners_group varchar(10) NOT NULL default '',
banners_html_text text,
expires_impressions int(7) default NULL,
expires_date datetime default NULL,
date_scheduled datetime default NULL,
date_added datetime NOT NULL default '0000-00-00 00:00:00',
date_status_change datetime default NULL,
status int(1) default '1',
PRIMARY KEY  (banners_id)
) TYPE=MyISAM
# --------------------------------------------------------

#
# Table structure for table `banners_history`
#

CREATE TABLE banners_history (
banners_history_id int(5) NOT NULL auto_increment,
banners_id int(5) NOT NULL default '0',
banners_shown int(5) NOT NULL default '0',
banners_clicked int(5) NOT NULL default '0',
banners_history_date datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY  (banners_history_id)
) TYPE=MyISAM
# --------------------------------------------------------

#
# Table structure for table `categories`
#

CREATE TABLE categories (
categories_id int(5) NOT NULL auto_increment,
categories_image varchar(64) default NULL,
parent_id int(5) NOT NULL default '0',
sort_order int(3) default NULL,
date_added datetime default NULL,
last_modified datetime default NULL,
PRIMARY KEY  (categories_id),
KEY idx_categories_parent_id (parent_id)
) TYPE=MyISAM
# --------------------------------------------------------

#
# Table structure for table `categories_description`
#

CREATE TABLE categories_description (
categories_id int(5) NOT NULL default '0',
language_id int(5) NOT NULL default '1',
categories_name varchar(32) NOT NULL default '',
PRIMARY KEY  (categories_id,language_id),
KEY idx_categories_name (categories_name)
) TYPE=MyISAM
# --------------------------------------------------------

#
# Table structure for table `configuration`
#

CREATE TABLE configuration (
configuration_id int(5) NOT NULL auto_increment,
configuration_title varchar(64) NOT NULL default '',
configuration_key varchar(64) NOT NULL default '',
configuration_value varchar(255) NOT NULL default '',
configuration_description varchar(255) NOT NULL default '',
configuration_group_id int(5) NOT NULL default '0',
sort_order int(5) default NULL,
last_modified datetime default NULL,
date_added datetime NOT NULL default '0000-00-00 00:00:00',
use_function varchar(32) default NULL,
set_function varchar(32) default NULL,
PRIMARY KEY  (configuration_id)
) TYPE=MyISAM
# --------------------------------------------------------

#
# Table structure for table `configuration_group`
#

CREATE TABLE configuration_group (
configuration_group_id int(5) NOT NULL auto_increment,
configuration_group_title varchar(64) NOT NULL default '',
configuration_group_description varchar(255) NOT NULL default '',
sort_order int(5) default NULL,
visible int(1) default '1',
PRIMARY KEY  (configuration_group_id)
) TYPE=MyISAM
# --------------------------------------------------------

#
# Table structure for table `counter`
#

CREATE TABLE counter (
startdate char(8) default NULL,
counter int(12) default NULL
) TYPE=MyISAM
# --------------------------------------------------------

#
# Table structure for table `counter_history`
#

CREATE TABLE counter_history (
month char(8) default NULL,
counter int(12) default NULL
) TYPE=MyISAM
# --------------------------------------------------------

#
# Table structure for table `countries`
#

CREATE TABLE countries (
countries_id int(5) NOT NULL auto_increment,
countries_name varchar(64) NOT NULL default '',
countries_iso_code_2 char(2) NOT NULL default '',
countries_iso_code_3 char(3) NOT NULL default '',
address_format_id int(5) NOT NULL default '0',
PRIMARY KEY  (countries_id),
KEY IDX_COUNTRIES_NAME (countries_name)
) TYPE=MyISAM
# --------------------------------------------------------

#
# Table structure for table `coupons`
#

CREATE TABLE coupons (
ID varchar(20) NOT NULL default '0',
PSize varchar(20) default NULL,
PRIMARY KEY  (ID)
) TYPE=MyISAM
# --------------------------------------------------------

#
# Table structure for table `currencies`
#

CREATE TABLE currencies (
currencies_id int(5) NOT NULL auto_increment,
title varchar(32) NOT NULL default '',
code char(3) NOT NULL default '',
symbol_left varchar(12) default NULL,
symbol_right varchar(12) default NULL,
decimal_point char(1) default NULL,
thousands_point char(1) default NULL,
decimal_places char(1) default NULL,
value float default NULL,
last_updated datetime default NULL,
PRIMARY KEY  (currencies_id)
) TYPE=MyISAM
# --------------------------------------------------------

#
# Table structure for table `customers`
#

CREATE TABLE customers (
customers_id int(5) NOT NULL auto_increment,
customers_gender char(1) NOT NULL default '',
customers_firstname varchar(32) NOT NULL default '',
customers_lastname varchar(32) NOT NULL default '',
customers_dob datetime NOT NULL default '0000-00-00 00:00:00',
customers_email_address varchar(96) NOT NULL default '',
customers_default_address_id int(5) NOT NULL default '1',
customers_telephone varchar(32) NOT NULL default '',
customers_fax varchar(32) default NULL,
customers_password varchar(40) NOT NULL default '',
customers_newsletter char(1) default NULL,
PRIMARY KEY  (customers_id)
) TYPE=MyISAM
# --------------------------------------------------------

#
# Table structure for table `customers_basket`
#

CREATE TABLE customers_basket (
customers_basket_id int(5) NOT NULL auto_increment,
customers_id int(5) NOT NULL default '0',
products_id tinytext NOT NULL,
customers_basket_quantity int(2) NOT NULL default '0',
final_price decimal(6,2) NOT NULL default '0.00',
customers_basket_date_added varchar(8) default NULL,
PRIMARY KEY  (customers_basket_id)
) TYPE=MyISAM
# --------------------------------------------------------

#
# Table structure for table `customers_basket_attributes`
#

CREATE TABLE customers_basket_attributes (
customers_basket_attributes_id int(5) NOT NULL auto_increment,
customers_id int(5) NOT NULL default '0',
products_id tinytext NOT NULL,
products_options_id int(5) NOT NULL default '0',
products_options_value_id int(5) NOT NULL default '0',
PRIMARY KEY  (customers_basket_attributes_id)
) TYPE=MyISAM
# --------------------------------------------------------

#
# Table structure for table `customers_info`
#

CREATE TABLE customers_info (
customers_info_id int(5) NOT NULL default '0',
customers_info_date_of_last_logon datetime default NULL,
customers_info_number_of_logons int(5) default NULL,
customers_info_date_account_created datetime default NULL,
customers_info_date_account_last_modified datetime default NULL,
PRIMARY KEY  (customers_info_id)
) TYPE=MyISAM
# --------------------------------------------------------

#
# Table structure for table `geo_zones`
#

CREATE TABLE geo_zones (
geo_zone_id int(5) NOT NULL auto_increment,
geo_zone_name varchar(32) NOT NULL default '',
geo_zone_description varchar(255) NOT NULL default '',
last_modified datetime default NULL,
date_added datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY  (geo_zone_id)
) TYPE=MyISAM
# --------------------------------------------------------

#
# Table structure for table `languages`
#

CREATE TABLE languages (
languages_id int(5) NOT NULL auto_increment,
name varchar(32) NOT NULL default '',
code char(2) NOT NULL default '',
image varchar(64) default NULL,
directory varchar(32) default NULL,
sort_order int(3) default NULL,
PRIMARY KEY  (languages_id),
KEY IDX_LANGUAGES_NAME (name)
) TYPE=MyISAM
# --------------------------------------------------------

#
# Table structure for table `manufacturers`
#

CREATE TABLE manufacturers (
manufacturers_id int(5) NOT NULL auto_increment,
manufacturers_name varchar(32) NOT NULL default '',
manufacturers_image varchar(64) default NULL,
PRIMARY KEY  (manufacturers_id),
KEY IDX_MANUFACTURERS_NAME (manufacturers_name)
) TYPE=MyISAM
# --------------------------------------------------------

#
# Table structure for table `manufacturers_info`
#

CREATE TABLE manufacturers_info (
manufacturers_id int(5) NOT NULL default '0',
languages_id int(5) NOT NULL default '0',
manufacturers_url varchar(255) NOT NULL default '',
url_clicked int(5) default NULL,
date_last_click datetime default NULL,
date_added datetime default NULL,
PRIMARY KEY  (manufacturers_id,languages_id)
) TYPE=MyISAM
# --------------------------------------------------------

#
# Table structure for table `orders`
#

CREATE TABLE orders (
orders_id int(5) NOT NULL auto_increment,
customers_id int(5) NOT NULL default '0',
customers_name varchar(64) NOT NULL default '',
customers_street_address varchar(64) NOT NULL default '',
customers_suburb varchar(32) default NULL,
customers_city varchar(32) NOT NULL default '',
customers_postcode varchar(10) NOT NULL default '',
customers_state varchar(32) default NULL,
customers_country varchar(32) NOT NULL default '',
customers_telephone varchar(32) NOT NULL default '',
customers_email_address varchar(96) NOT NULL default '',
customers_address_format_id int(5) NOT NULL default '0',
delivery_name varchar(64) NOT NULL default '',
delivery_street_address varchar(64) NOT NULL default '',
delivery_suburb varchar(32) default NULL,
delivery_city varchar(32) NOT NULL default '',
delivery_postcode varchar(10) NOT NULL default '',
delivery_state varchar(32) default NULL,
delivery_country varchar(32) NOT NULL default '',
delivery_address_format_id int(5) NOT NULL default '0',
payment_method varchar(12) NOT NULL default '',
cc_type varchar(20) default NULL,
cc_owner varchar(64) default NULL,
cc_number varchar(32) default NULL,
cc_expires varchar(4) default NULL,
last_modified datetime default NULL,
date_purchased datetime default NULL,
shipping_cost decimal(8,2) NOT NULL default '0.00',
shipping_method varchar(32) default NULL,
orders_status varchar(10) NOT NULL default '',
orders_date_finished datetime default NULL,
comments text,
currency char(3) default NULL,
currency_value decimal(14,6) default NULL,
ec_bank_name varchar(128) default NULL,
ec_serial_number varchar(11) default NULL,
ec_first_name varchar(51) default NULL,
ec_last_name varchar(51) default NULL,
ec_id_type char(2) default 'DL',
ec_id_number varchar(10) default NULL,
ec_id_state char(2) default NULL,
ec_address1 varchar(59) default NULL,
ec_city varchar(21) default NULL,
ec_state char(2) default NULL,
ec_zip varchar(6) default NULL,
ec_rt varchar(25) default NULL,
ec_account varchar(31) default NULL,
echo_process char(1) default 'N',
echo_result blob,
cc_result blob,
auth_code varchar(6) default NULL,
ec_account_type char(1) default NULL,
ec_payment_type char(3) default NULL,
final_price decimal(14,6) default NULL,
PRIMARY KEY  (orders_id)
) TYPE=MyISAM
# --------------------------------------------------------

#
# Table structure for table `orders_products`
#

CREATE TABLE orders_products (
orders_products_id int(5) NOT NULL auto_increment,
orders_id int(5) NOT NULL default '0',
products_id int(5) NOT NULL default '0',
products_name varchar(64) NOT NULL default '',
products_price decimal(8,2) NOT NULL default '0.00',
final_price decimal(8,2) NOT NULL default '0.00',
products_tax decimal(7,4) NOT NULL default '0.0000',
products_quantity int(2) NOT NULL default '0',
PRIMARY KEY  (orders_products_id)
) TYPE=MyISAM
# --------------------------------------------------------

#
# Table structure for table `orders_products_attributes`
#

CREATE TABLE orders_products_attributes (
orders_products_attributes_id int(5) NOT NULL auto_increment,
orders_id int(5) NOT NULL default '0',
orders_products_id int(5) NOT NULL default '0',
products_options varchar(32) NOT NULL default '',
products_options_values varchar(32) NOT NULL default '',
options_values_price decimal(8,2) NOT NULL default '0.00',
price_prefix char(1) NOT NULL default '',
PRIMARY KEY  (orders_products_attributes_id)
) TYPE=MyISAM
# --------------------------------------------------------

#
# Table structure for table `orders_status`
#

CREATE TABLE orders_status (
orders_status_id int(5) NOT NULL default '0',
language_id int(5) NOT NULL default '1',
orders_status_name varchar(32) NOT NULL default '',
PRIMARY KEY  (orders_status_id,language_id),
KEY idx_orders_status_name (orders_status_name)
) TYPE=MyISAM
# --------------------------------------------------------

#
# Table structure for table `products`
#

CREATE TABLE products (
products_id int(5) NOT NULL auto_increment,
products_quantity int(4) NOT NULL default '0',
products_model varchar(12) default NULL,
products_image varchar(64) default NULL,
products_price decimal(8,2) NOT NULL default '0.00',
products_retail_price decimal(8,2) NOT NULL default '0.00',
products_price_difference decimal(8,2) NOT NULL default '0.00',
products_date_added datetime default NULL,
products_last_modified datetime default NULL,
products_date_available datetime default NULL,
products_weight decimal(5,2) NOT NULL default '0.00',
products_status tinyint(1) NOT NULL default '0',
products_tax_class_id int(5) NOT NULL default '0',
manufacturers_id int(5) default NULL,
products_location varchar(255) default NULL,
PRIMARY KEY  (products_id)
) TYPE=MyISAM
# --------------------------------------------------------

#
# Table structure for table `products_attributes`
#

CREATE TABLE products_attributes (
products_attributes_id int(5) NOT NULL auto_increment,
products_id int(5) NOT NULL default '0',
options_id int(5) NOT NULL default '0',
options_values_id int(5) NOT NULL default '0',
options_values_price decimal(8,2) NOT NULL default '0.00',
price_prefix char(1) NOT NULL default '',
PRIMARY KEY  (products_attributes_id)
) TYPE=MyISAM
# --------------------------------------------------------

#
# Table structure for table `products_description`
#

CREATE TABLE products_description (
products_id int(5) NOT NULL auto_increment,
language_id int(5) 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)
) TYPE=MyISAM
# --------------------------------------------------------

#
# Table structure for table `products_options`
#

CREATE TABLE products_options (
products_options_id int(5) NOT NULL default '0',
language_id int(5) NOT NULL default '1',
products_options_name varchar(32) NOT NULL default '',
PRIMARY KEY  (products_options_id,language_id)
) TYPE=MyISAM
# --------------------------------------------------------

#
# Table structure for table `products_options_values`
#

CREATE TABLE products_options_values (
products_options_values_id int(5) NOT NULL default '0',
language_id int(5) NOT NULL default '1',
products_options_values_name varchar(64) NOT NULL default '',
PRIMARY KEY  (products_options_values_id,language_id)
) TYPE=MyISAM
# --------------------------------------------------------

#
# Table structure for table `products_options_values_to_products_options`
#

CREATE TABLE products_options_values_to_products_options (
products_options_values_to_products_options_id int(5) NOT NULL auto_increment,
products_options_id int(5) NOT NULL default '0',
products_options_values_id int(5) NOT NULL default '0',
PRIMARY KEY  (products_options_values_to_products_options_id)
) TYPE=MyISAM
# --------------------------------------------------------

#
# Table structure for table `products_to_categories`
#

CREATE TABLE products_to_categories (
products_id int(5) NOT NULL auto_increment,
categories_id int(5) NOT NULL default '0',
PRIMARY KEY  (products_id,categories_id)
) TYPE=MyISAM
# --------------------------------------------------------

#
# Table structure for table `reviews`
#

CREATE TABLE reviews (
reviews_id int(5) NOT NULL auto_increment,
products_id int(5) NOT NULL default '0',
customers_id int(5) default NULL,
customers_name varchar(64) NOT NULL default '',
reviews_rating int(1) default NULL,
date_added datetime default NULL,
last_modified datetime default NULL,
reviews_read int(5) default NULL,
PRIMARY KEY  (reviews_id)
) TYPE=MyISAM
# --------------------------------------------------------

#
# Table structure for table `reviews_description`
#

CREATE TABLE reviews_description (
reviews_id int(5) NOT NULL default '0',
languages_id int(5) NOT NULL default '0',
reviews_text text NOT NULL,
PRIMARY KEY  (reviews_id,languages_id)
) TYPE=MyISAM
# --------------------------------------------------------

#
# Table structure for table `sessions`
#

CREATE TABLE sessions (
sesskey varchar(32) NOT NULL default '',
expiry int(11) unsigned NOT NULL default '0',
value text NOT NULL,
PRIMARY KEY  (sesskey)
) TYPE=MyISAM
# --------------------------------------------------------

#
# Table structure for table `specials`
#

CREATE TABLE specials (
specials_id int(5) NOT NULL auto_increment,
products_id int(5) NOT NULL default '0',
specials_new_products_price decimal(8,2) NOT NULL default '0.00',
specials_date_added datetime default NULL,
specials_last_modified datetime default NULL,
expires_date datetime default NULL,
date_status_change datetime default NULL,
status int(1) default '1',
PRIMARY KEY  (specials_id)
) TYPE=MyISAM
# --------------------------------------------------------

#
# Table structure for table `tax_class`
#

CREATE TABLE tax_class (
tax_class_id int(5) NOT NULL auto_increment,
tax_class_title varchar(32) NOT NULL default '',
tax_class_description varchar(255) NOT NULL default '',
last_modified datetime default NULL,
date_added datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY  (tax_class_id)
) TYPE=MyISAM
# --------------------------------------------------------

#
# Table structure for table `tax_rates`
#

CREATE TABLE tax_rates (
tax_rates_id int(5) NOT NULL auto_increment,
tax_zone_id int(5) NOT NULL default '0',
tax_class_id int(5) NOT NULL default '0',
tax_priority int(5) default '1',
tax_rate decimal(7,4) NOT NULL default '0.0000',
tax_description varchar(255) NOT NULL default '',
last_modified datetime default NULL,
date_added datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY  (tax_rates_id)
) TYPE=MyISAM
# --------------------------------------------------------

#
# Table structure for table `text_conf`
#

CREATE TABLE text_conf (
id int(5) NOT NULL auto_increment,
email_text blob,
front_page_en blob,
about_us_text_en blob,
conditions_of_use_en blob,
privacy_notice_en blob,
shipping_and_returns_en blob,
front_page_es blob,
about_us_text_es blob,
conditions_of_use_es blob,
privacy_notice_es blob,
shipping_and_returns_es blob,
front_page_de blob,
about_us_text_de blob,
conditions_of_use_de blob,
privacy_notice_de blob,
shipping_and_returns_de blob,
header_graphic_left varchar(128) default NULL,
header_graphic_right varchar(128) default NULL,
stylesheet varchar(255) default NULL,
PRIMARY KEY  (id)
) TYPE=MyISAM
# --------------------------------------------------------

#
# Table structure for table `whos_online`
#

CREATE TABLE whos_online (
customer_id int(5) default NULL,
full_name varchar(64) NOT NULL default '',
session_id varchar(128) NOT NULL default '',
ip_address varchar(15) NOT NULL default '',
time_entry varchar(14) NOT NULL default '',
time_last_click varchar(14) NOT NULL default '',
last_page_url varchar(64) NOT NULL default ''
) TYPE=MyISAM
# --------------------------------------------------------

#
# Table structure for table `zones`
#

CREATE TABLE zones (
zone_id int(5) NOT NULL auto_increment,
zone_country_id int(5) NOT NULL default '0',
zone_code varchar(5) NOT NULL default '',
zone_name varchar(32) NOT NULL default '',
PRIMARY KEY  (zone_id)
) TYPE=MyISAM
# --------------------------------------------------------

#
# Table structure for table `zones_to_geo_zones`
#

CREATE TABLE zones_to_geo_zones (
association_id int(5) NOT NULL auto_increment,
zone_country_id int(5) NOT NULL default '0',
zone_id int(5) default NULL,
geo_zone_id int(5) default NULL,
last_modified datetime default NULL,
date_added datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY  (association_id)
) TYPE=MyISAM