Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Tool to Convert DB?


FlyingMonkey

Recommended Posts

MS2 Database

 

Database db96051649 running on db11.perfora.net 
# phpMyAdmin SQL Dump
# version 2.6.0
# http://www.phpmyadmin.net
#
# Host: db11.perfora.net
# Generation Time: Jan 18, 2005 at 12:25 AM
# Server version: 4.0.23
# PHP Version: 4.3.10
# 
# Database : `db96051649`
# 

# --------------------------------------------------------

#
# Table structure for table `address_book`
#

CREATE TABLE `address_book` (
?`address_book_id` int(11) NOT NULL auto_increment,
?`customers_id` int(11) NOT NULL default '0',
?`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(11) NOT NULL default '0',
?`entry_zone_id` int(11) NOT NULL default '0',
?PRIMARY KEY ?(`address_book_id`),
?KEY `idx_address_book_customers_id` (`customers_id`)
) TYPE=MyISAM AUTO_INCREMENT=153;

# --------------------------------------------------------

#
# Table structure for table `address_format`
#

CREATE TABLE `address_format` (
?`address_format_id` int(11) 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 AUTO_INCREMENT=6;

# --------------------------------------------------------

#
# Table structure for table `banners`
#

CREATE TABLE `banners` (
?`banners_id` int(11) NOT NULL auto_increment,
?`banners_title` varchar(64) NOT NULL default '',
?`banners_url` varchar(255) 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 '0',
?`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) NOT NULL default '1',
?PRIMARY KEY ?(`banners_id`)
) TYPE=MyISAM AUTO_INCREMENT=2;

# --------------------------------------------------------

#
# Table structure for table `banners_history`
#

CREATE TABLE `banners_history` (
?`banners_history_id` int(11) NOT NULL auto_increment,
?`banners_id` int(11) 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 AUTO_INCREMENT=1;

# --------------------------------------------------------

#
# Table structure for table `categories`
#

CREATE TABLE `categories` (
?`categories_id` int(11) NOT NULL auto_increment,
?`categories_image` varchar(64) default NULL,
?`parent_id` int(11) 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 AUTO_INCREMENT=27;

# --------------------------------------------------------

#
# Table structure for table `categories_description`
#

CREATE TABLE `categories_description` (
?`categories_id` int(11) NOT NULL default '0',
?`language_id` int(11) NOT NULL default '1',
?`categories_name` varchar(32) NOT NULL default '',
?`categories_description` varchar(255) 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(11) 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(11) 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(255) default NULL,
?`set_function` varchar(255) default NULL,
?PRIMARY KEY ?(`configuration_id`)
) TYPE=MyISAM AUTO_INCREMENT=515;

# --------------------------------------------------------

#
# Table structure for table `configuration_group`
#

CREATE TABLE `configuration_group` (
?`configuration_group_id` int(11) 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 AUTO_INCREMENT=40;

# --------------------------------------------------------

#
# 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(11) 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(11) NOT NULL default '0',
?PRIMARY KEY ?(`countries_id`),
?KEY `IDX_COUNTRIES_NAME` (`countries_name`)
) TYPE=MyISAM AUTO_INCREMENT=240;

# --------------------------------------------------------

#
# Table structure for table `coupon_email_track`
#

CREATE TABLE `coupon_email_track` (
?`unique_id` int(11) NOT NULL auto_increment,
?`coupon_id` int(11) NOT NULL default '0',
?`customer_id_sent` int(11) NOT NULL default '0',
?`sent_firstname` varchar(32) default NULL,
?`sent_lastname` varchar(32) default NULL,
?`emailed_to` varchar(32) default NULL,
?`date_sent` datetime NOT NULL default '0000-00-00 00:00:00',
?PRIMARY KEY ?(`unique_id`)
) TYPE=MyISAM AUTO_INCREMENT=7;

# --------------------------------------------------------

#
# Table structure for table `coupon_gv_customer`
#

CREATE TABLE `coupon_gv_customer` (
?`customer_id` int(5) NOT NULL default '0',
?`amount` decimal(8,4) NOT NULL default '0.0000',
?PRIMARY KEY ?(`customer_id`),
?KEY `customer_id` (`customer_id`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `coupon_gv_queue`
#

CREATE TABLE `coupon_gv_queue` (
?`unique_id` int(5) NOT NULL auto_increment,
?`customer_id` int(5) NOT NULL default '0',
?`order_id` int(5) NOT NULL default '0',
?`amount` decimal(8,4) NOT NULL default '0.0000',
?`date_created` datetime NOT NULL default '0000-00-00 00:00:00',
?`ipaddr` varchar(32) NOT NULL default '',
?`release_flag` char(1) NOT NULL default 'N',
?PRIMARY KEY ?(`unique_id`),
?KEY `uid` (`unique_id`,`customer_id`,`order_id`)
) TYPE=MyISAM AUTO_INCREMENT=1;

# --------------------------------------------------------

#
# Table structure for table `coupon_redeem_track`
#

CREATE TABLE `coupon_redeem_track` (
?`unique_id` int(11) NOT NULL auto_increment,
?`coupon_id` int(11) NOT NULL default '0',
?`customer_id` int(11) NOT NULL default '0',
?`redeem_date` datetime NOT NULL default '0000-00-00 00:00:00',
?`redeem_ip` varchar(32) NOT NULL default '',
?`order_id` int(11) NOT NULL default '0',
?PRIMARY KEY ?(`unique_id`)
) TYPE=MyISAM AUTO_INCREMENT=29;

# --------------------------------------------------------

#
# Table structure for table `coupons`
#

CREATE TABLE `coupons` (
?`coupon_id` int(11) NOT NULL auto_increment,
?`coupon_type` char(1) NOT NULL default 'F',
?`coupon_code` varchar(32) NOT NULL default '',
?`coupon_amount` decimal(8,4) NOT NULL default '0.0000',
?`coupon_minimum_order` decimal(8,4) NOT NULL default '0.0000',
?`coupon_start_date` datetime NOT NULL default '0000-00-00 00:00:00',
?`coupon_expire_date` datetime NOT NULL default '0000-00-00 00:00:00',
?`uses_per_coupon` int(5) NOT NULL default '1',
?`uses_per_user` int(5) NOT NULL default '0',
?`restrict_to_products` varchar(255) default NULL,
?`restrict_to_categories` varchar(255) default NULL,
?`restrict_to_customers` text,
?`coupon_active` char(1) NOT NULL default 'Y',
?`date_created` datetime NOT NULL default '0000-00-00 00:00:00',
?`date_modified` datetime NOT NULL default '0000-00-00 00:00:00',
?PRIMARY KEY ?(`coupon_id`)
) TYPE=MyISAM AUTO_INCREMENT=23;

# --------------------------------------------------------

#
# Table structure for table `coupons_description`
#

CREATE TABLE `coupons_description` (
?`coupon_id` int(11) NOT NULL default '0',
?`language_id` int(11) NOT NULL default '0',
?`coupon_name` varchar(32) NOT NULL default '',
?`coupon_description` text,
?KEY `coupon_id` (`coupon_id`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `currencies`
#

CREATE TABLE `currencies` (
?`currencies_id` int(11) 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(13,8) default NULL,
?`last_updated` datetime default NULL,
?PRIMARY KEY ?(`currencies_id`)
) TYPE=MyISAM AUTO_INCREMENT=3;

# --------------------------------------------------------

#
# Table structure for table `customers`
#

CREATE TABLE `customers` (
?`customers_id` int(11) 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(11) NOT NULL default '0',
?`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 AUTO_INCREMENT=132;

# --------------------------------------------------------

#
# Table structure for table `customers_basket`
#

CREATE TABLE `customers_basket` (
?`customers_basket_id` int(11) NOT NULL auto_increment,
?`customers_id` int(11) NOT NULL default '0',
?`products_id` tinytext NOT NULL,
?`customers_basket_quantity` int(2) NOT NULL default '0',
?`final_price` decimal(15,4) NOT NULL default '0.0000',
?`customers_basket_date_added` varchar(8) default NULL,
?PRIMARY KEY ?(`customers_basket_id`)
) TYPE=MyISAM AUTO_INCREMENT=408;

# --------------------------------------------------------

#
# Table structure for table `customers_basket_attributes`
#

CREATE TABLE `customers_basket_attributes` (
?`customers_basket_attributes_id` int(11) NOT NULL auto_increment,
?`customers_id` int(11) NOT NULL default '0',
?`products_id` tinytext NOT NULL,
?`products_options_id` int(11) NOT NULL default '0',
?`products_options_value_id` int(11) NOT NULL default '0',
?PRIMARY KEY ?(`customers_basket_attributes_id`)
) TYPE=MyISAM AUTO_INCREMENT=1;

# --------------------------------------------------------

#
# Table structure for table `customers_info`
#

CREATE TABLE `customers_info` (
?`customers_info_id` int(11) 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,
?`global_product_notifications` int(1) default '0',
?PRIMARY KEY ?(`customers_info_id`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `db_queries`
#

CREATE TABLE `db_queries` (
?`q_id` tinyint(4) NOT NULL auto_increment,
?`q_desc` text NOT NULL,
?`q_var` char(2) NOT NULL default '',
?`sorq` varchar(12) NOT NULL default '',
?PRIMARY KEY ?(`q_id`)
) TYPE=MyISAM AUTO_INCREMENT=31;

# --------------------------------------------------------

#
# Table structure for table `db_queries_desc`
#

CREATE TABLE `db_queries_desc` (
?`prim_id` tinyint(4) NOT NULL auto_increment,
?`q_id` tinyint(4) NOT NULL default '0',
?`q_query` text NOT NULL,
?PRIMARY KEY ?(`prim_id`)
) TYPE=MyISAM AUTO_INCREMENT=92;

# --------------------------------------------------------

#
# Table structure for table `featured`
#

CREATE TABLE `featured` (
?`featured_id` int(11) NOT NULL auto_increment,
?`products_id` int(11) NOT NULL default '0',
?`featured_date_added` datetime default NULL,
?`featured_last_modified` datetime default NULL,
?`expires_date` datetime default NULL,
?`date_status_change` datetime default NULL,
?`status` int(1) default '1',
?PRIMARY KEY ?(`featured_id`)
) TYPE=MyISAM AUTO_INCREMENT=32;

# --------------------------------------------------------

#
# Table structure for table `geo_zones`
#

CREATE TABLE `geo_zones` (
?`geo_zone_id` int(11) 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 AUTO_INCREMENT=4;

# --------------------------------------------------------

#
# Table structure for table `languages`
#

CREATE TABLE `languages` (
?`languages_id` int(11) 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 AUTO_INCREMENT=2;

# --------------------------------------------------------

#
# Table structure for table `manufacturers`
#

CREATE TABLE `manufacturers` (
?`manufacturers_id` int(11) NOT NULL auto_increment,
?`manufacturers_name` varchar(32) NOT NULL default '',
?`manufacturers_image` varchar(64) default NULL,
?`date_added` datetime default NULL,
?`last_modified` datetime default NULL,
?PRIMARY KEY ?(`manufacturers_id`),
?KEY `IDX_MANUFACTURERS_NAME` (`manufacturers_name`)
) TYPE=MyISAM AUTO_INCREMENT=21;

# --------------------------------------------------------

#
# Table structure for table `manufacturers_info`
#

CREATE TABLE `manufacturers_info` (
?`manufacturers_id` int(11) NOT NULL default '0',
?`languages_id` int(11) NOT NULL default '0',
?`manufacturers_url` varchar(255) NOT NULL default '',
?`url_clicked` int(5) NOT NULL default '0',
?`date_last_click` datetime default NULL,
?PRIMARY KEY ?(`manufacturers_id`,`languages_id`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `newsletters`
#

CREATE TABLE `newsletters` (
?`newsletters_id` int(11) NOT NULL auto_increment,
?`title` varchar(255) NOT NULL default '',
?`content` text NOT NULL,
?`module` varchar(255) NOT NULL default '',
?`date_added` datetime NOT NULL default '0000-00-00 00:00:00',
?`date_sent` datetime default NULL,
?`status` int(1) default NULL,
?`locked` int(1) default '0',
?PRIMARY KEY ?(`newsletters_id`)
) TYPE=MyISAM AUTO_INCREMENT=1;

# --------------------------------------------------------

#
# Table structure for table `orders`
#

CREATE TABLE `orders` (
?`orders_id` int(11) NOT NULL auto_increment,
?`customers_id` int(11) NOT NULL default '0',
?`customers_name` varchar(64) NOT NULL default '',
?`customers_company` varchar(32) default NULL,
?`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_company` varchar(32) default NULL,
?`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',
?`billing_name` varchar(64) NOT NULL default '',
?`billing_company` varchar(32) default NULL,
?`billing_street_address` varchar(64) NOT NULL default '',
?`billing_suburb` varchar(32) default NULL,
?`billing_city` varchar(32) NOT NULL default '',
?`billing_postcode` varchar(10) NOT NULL default '',
?`billing_state` varchar(32) default NULL,
?`billing_country` varchar(32) NOT NULL default '',
?`billing_address_format_id` int(5) NOT NULL default '0',
?`payment_method` varchar(32) 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,
?`orders_status` int(5) NOT NULL default '0',
?`orders_date_finished` datetime default NULL,
?`currency` char(3) default NULL,
?`currency_value` decimal(14,6) default NULL,
?PRIMARY KEY ?(`orders_id`)
) TYPE=MyISAM AUTO_INCREMENT=114;

# --------------------------------------------------------

#
# Table structure for table `orders_products`
#

CREATE TABLE `orders_products` (
?`orders_products_id` int(11) NOT NULL auto_increment,
?`orders_id` int(11) NOT NULL default '0',
?`products_id` int(11) NOT NULL default '0',
?`products_model` varchar(12) default NULL,
?`products_name` varchar(64) NOT NULL default '',
?`products_price` decimal(15,4) NOT NULL default '0.0000',
?`final_price` decimal(15,4) NOT NULL default '0.0000',
?`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 AUTO_INCREMENT=231;

# --------------------------------------------------------

#
# Table structure for table `orders_products_attributes`
#

CREATE TABLE `orders_products_attributes` (
?`orders_products_attributes_id` int(11) NOT NULL auto_increment,
?`orders_id` int(11) NOT NULL default '0',
?`orders_products_id` int(11) NOT NULL default '0',
?`products_options` varchar(32) NOT NULL default '',
?`products_options_values` varchar(32) NOT NULL default '',
?`options_values_price` decimal(15,4) NOT NULL default '0.0000',
?`price_prefix` char(1) NOT NULL default '',
?PRIMARY KEY ?(`orders_products_attributes_id`)
) TYPE=MyISAM AUTO_INCREMENT=1;

# --------------------------------------------------------

#
# Table structure for table `orders_products_download`
#

CREATE TABLE `orders_products_download` (
?`orders_products_download_id` int(11) NOT NULL auto_increment,
?`orders_id` int(11) NOT NULL default '0',
?`orders_products_id` int(11) 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`)
) TYPE=MyISAM AUTO_INCREMENT=1;

# --------------------------------------------------------

#
# Table structure for table `orders_status`
#

CREATE TABLE `orders_status` (
?`orders_status_id` int(11) NOT NULL default '0',
?`language_id` int(11) 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 `orders_status_history`
#

CREATE TABLE `orders_status_history` (
?`orders_status_history_id` int(11) NOT NULL auto_increment,
?`orders_id` int(11) NOT NULL default '0',
?`orders_status_id` int(5) NOT NULL default '0',
?`date_added` datetime NOT NULL default '0000-00-00 00:00:00',
?`customer_notified` int(1) default '0',
?`comments` text,
?PRIMARY KEY ?(`orders_status_history_id`)
) TYPE=MyISAM AUTO_INCREMENT=159;

# --------------------------------------------------------

#
# Table structure for table `orders_total`
#

CREATE TABLE `orders_total` (
?`orders_total_id` int(10) unsigned NOT NULL auto_increment,
?`orders_id` int(11) NOT NULL default '0',
?`title` varchar(255) NOT NULL default '',
?`text` varchar(255) NOT NULL default '',
?`value` decimal(15,4) NOT NULL default '0.0000',
?`class` varchar(32) NOT NULL default '',
?`sort_order` int(11) NOT NULL default '0',
?PRIMARY KEY ?(`orders_total_id`),
?KEY `idx_orders_total_orders_id` (`orders_id`)
) TYPE=MyISAM AUTO_INCREMENT=312;

# --------------------------------------------------------

#
# Table structure for table `products`
#

CREATE TABLE `products` (
?`products_id` int(11) 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(15,4) NOT NULL default '0.0000',
?`products_date_added` datetime NOT NULL default '0000-00-00 00:00:00',
?`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(11) NOT NULL default '0',
?`manufacturers_id` int(11) default NULL,
?`products_ordered` int(11) NOT NULL default '0',
?PRIMARY KEY ?(`products_id`),
?KEY `idx_products_date_added` (`products_date_added`)
) TYPE=MyISAM AUTO_INCREMENT=81;

# --------------------------------------------------------

#
# Table structure for table `products_attributes`
#

CREATE TABLE `products_attributes` (
?`products_attributes_id` int(11) NOT NULL auto_increment,
?`products_id` int(11) NOT NULL default '0',
?`options_id` int(11) NOT NULL default '0',
?`options_values_id` int(11) NOT NULL default '0',
?`options_values_price` decimal(15,4) NOT NULL default '0.0000',
?`price_prefix` char(1) NOT NULL default '',
?`attribute_sort` int(10) unsigned NOT NULL default '0',
?PRIMARY KEY ?(`products_attributes_id`)
) TYPE=MyISAM AUTO_INCREMENT=1;

# --------------------------------------------------------

#
# Table structure for table `products_attributes_download`
#

CREATE TABLE `products_attributes_download` (
?`products_attributes_id` int(11) NOT NULL default '0',
?`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`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `products_description`
#

CREATE TABLE `products_description` (
?`products_id` int(11) NOT NULL auto_increment,
?`language_id` int(11) 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 AUTO_INCREMENT=81;

# --------------------------------------------------------

#
# Table structure for table `products_notifications`
#

CREATE TABLE `products_notifications` (
?`products_id` int(11) NOT NULL default '0',
?`customers_id` int(11) NOT NULL default '0',
?`date_added` datetime NOT NULL default '0000-00-00 00:00:00',
?PRIMARY KEY ?(`products_id`,`customers_id`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `products_options`
#

CREATE TABLE `products_options` (
?`products_options_id` int(11) NOT NULL default '0',
?`language_id` int(11) 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(11) NOT NULL default '0',
?`language_id` int(11) 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(11) NOT NULL auto_increment,
?`products_options_id` int(11) NOT NULL default '0',
?`products_options_values_id` int(11) NOT NULL default '0',
?PRIMARY KEY ?(`products_options_values_to_products_options_id`)
) TYPE=MyISAM AUTO_INCREMENT=26;

# --------------------------------------------------------

#
# Table structure for table `products_to_categories`
#

CREATE TABLE `products_to_categories` (
?`products_id` int(11) NOT NULL default '0',
?`categories_id` int(11) NOT NULL default '0',
?PRIMARY KEY ?(`products_id`,`categories_id`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `reviews`
#

CREATE TABLE `reviews` (
?`reviews_id` int(11) NOT NULL auto_increment,
?`products_id` int(11) NOT NULL default '0',
?`customers_id` int(11) 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) NOT NULL default '0',
?`approved` tinyint(3) unsigned default '0',
?PRIMARY KEY ?(`reviews_id`)
) TYPE=MyISAM AUTO_INCREMENT=11;

# --------------------------------------------------------

#
# Table structure for table `reviews_description`
#

CREATE TABLE `reviews_description` (
?`reviews_id` int(11) NOT NULL default '0',
?`languages_id` int(11) 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(11) NOT NULL auto_increment,
?`products_id` int(11) NOT NULL default '0',
?`specials_new_products_price` decimal(15,4) NOT NULL default '0.0000',
?`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) NOT NULL default '1',
?PRIMARY KEY ?(`specials_id`)
) TYPE=MyISAM AUTO_INCREMENT=46;

# --------------------------------------------------------

#
# Table structure for table `tax_class`
#

CREATE TABLE `tax_class` (
?`tax_class_id` int(11) 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 AUTO_INCREMENT=2;

# --------------------------------------------------------

#
# Table structure for table `tax_rates`
#

CREATE TABLE `tax_rates` (
?`tax_rates_id` int(11) NOT NULL auto_increment,
?`tax_zone_id` int(11) NOT NULL default '0',
?`tax_class_id` int(11) 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 AUTO_INCREMENT=2;

# --------------------------------------------------------

#
# Table structure for table `whos_online`
#

CREATE TABLE `whos_online` (
?`customer_id` int(11) 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 '',
?`http_referer` varchar(255) NOT NULL default ''
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `zones`
#

CREATE TABLE `zones` (
?`zone_id` int(11) NOT NULL auto_increment,
?`zone_country_id` int(11) NOT NULL default '0',
?`zone_code` varchar(32) NOT NULL default '',
?`zone_name` varchar(32) NOT NULL default '',
?PRIMARY KEY ?(`zone_id`)
) TYPE=MyISAM AUTO_INCREMENT=182;

# --------------------------------------------------------

#
# Table structure for table `zones_to_geo_zones`
#

CREATE TABLE `zones_to_geo_zones` (
?`association_id` int(11) NOT NULL auto_increment,
?`zone_country_id` int(11) NOT NULL default '0',
?`zone_id` int(11) default NULL,
?`geo_zone_id` int(11) 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 AUTO_INCREMENT=4;
? ?

Most likely your question has been answered, please do a search first.

Link to comment
Share on other sites

MS1:

 

-- phpMyAdmin SQL Dump
-- version 2.6.0-pl3
-- http://www.phpmyadmin.net
-- 
-- Host: db125.perfora.net
-- Generation Time: Jan 18, 2005 at 12:31 AM
-- Server version: 4.0.23
-- PHP Version: 4.3.10
-- 
-- Database: `db110174644`
-- 
CREATE DATABASE `db110174644`;
USE db110174644;

-- --------------------------------------------------------

-- 
-- Table structure for table `address_book`
-- 

CREATE TABLE `address_book` (
 `address_book_id` int(11) NOT NULL auto_increment,
 `customers_id` int(11) NOT NULL default '0',
 `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(11) NOT NULL default '0',
 `entry_zone_id` int(11) NOT NULL default '0',
 PRIMARY KEY  (`address_book_id`),
 KEY `idx_address_book_customers_id` (`customers_id`)
) TYPE=MyISAM AUTO_INCREMENT=1;

-- --------------------------------------------------------

-- 
-- Table structure for table `address_format`
-- 

CREATE TABLE `address_format` (
 `address_format_id` int(11) 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 AUTO_INCREMENT=6;

-- --------------------------------------------------------

-- 
-- Table structure for table `banners`
-- 

CREATE TABLE `banners` (
 `banners_id` int(11) NOT NULL auto_increment,
 `banners_title` varchar(64) NOT NULL default '',
 `banners_url` varchar(255) 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 '0',
 `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) NOT NULL default '1',
 PRIMARY KEY  (`banners_id`)
) TYPE=MyISAM AUTO_INCREMENT=2;

-- --------------------------------------------------------

-- 
-- Table structure for table `banners_history`
-- 

CREATE TABLE `banners_history` (
 `banners_history_id` int(11) NOT NULL auto_increment,
 `banners_id` int(11) 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 AUTO_INCREMENT=1;

-- --------------------------------------------------------

-- 
-- Table structure for table `categories`
-- 

CREATE TABLE `categories` (
 `categories_id` int(11) NOT NULL auto_increment,
 `categories_image` varchar(64) default NULL,
 `parent_id` int(11) 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 AUTO_INCREMENT=1;

-- --------------------------------------------------------

-- 
-- Table structure for table `categories_description`
-- 

CREATE TABLE `categories_description` (
 `categories_id` int(11) NOT NULL default '0',
 `language_id` int(11) NOT NULL default '1',
 `categories_name` varchar(32) NOT NULL default '',
 `categories_description` varchar(255) 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(11) 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(11) 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(255) default NULL,
 `set_function` varchar(255) default NULL,
 PRIMARY KEY  (`configuration_id`)
) TYPE=MyISAM AUTO_INCREMENT=516;

-- --------------------------------------------------------

-- 
-- Table structure for table `configuration_group`
-- 

CREATE TABLE `configuration_group` (
 `configuration_group_id` int(11) 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 AUTO_INCREMENT=40;

-- --------------------------------------------------------

-- 
-- 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(11) 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(11) NOT NULL default '0',
 PRIMARY KEY  (`countries_id`),
 KEY `IDX_COUNTRIES_NAME` (`countries_name`)
) TYPE=MyISAM AUTO_INCREMENT=240;

-- --------------------------------------------------------

-- 
-- Table structure for table `coupon_email_track`
-- 

CREATE TABLE `coupon_email_track` (
 `unique_id` int(11) NOT NULL auto_increment,
 `coupon_id` int(11) NOT NULL default '0',
 `customer_id_sent` int(11) NOT NULL default '0',
 `sent_firstname` varchar(32) default NULL,
 `sent_lastname` varchar(32) default NULL,
 `emailed_to` varchar(32) default NULL,
 `date_sent` datetime NOT NULL default '0000-00-00 00:00:00',
 PRIMARY KEY  (`unique_id`)
) TYPE=MyISAM AUTO_INCREMENT=7;

-- --------------------------------------------------------

-- 
-- Table structure for table `coupon_gv_customer`
-- 

CREATE TABLE `coupon_gv_customer` (
 `customer_id` int(5) NOT NULL default '0',
 `amount` decimal(8,4) NOT NULL default '0.0000',
 PRIMARY KEY  (`customer_id`),
 KEY `customer_id` (`customer_id`)
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Table structure for table `coupon_gv_queue`
-- 

CREATE TABLE `coupon_gv_queue` (
 `unique_id` int(5) NOT NULL auto_increment,
 `customer_id` int(5) NOT NULL default '0',
 `order_id` int(5) NOT NULL default '0',
 `amount` decimal(8,4) NOT NULL default '0.0000',
 `date_created` datetime NOT NULL default '0000-00-00 00:00:00',
 `ipaddr` varchar(32) NOT NULL default '',
 `release_flag` char(1) NOT NULL default 'N',
 PRIMARY KEY  (`unique_id`),
 KEY `uid` (`unique_id`,`customer_id`,`order_id`)
) TYPE=MyISAM AUTO_INCREMENT=1;

-- --------------------------------------------------------

-- 
-- Table structure for table `coupon_redeem_track`
-- 

CREATE TABLE `coupon_redeem_track` (
 `unique_id` int(11) NOT NULL auto_increment,
 `coupon_id` int(11) NOT NULL default '0',
 `customer_id` int(11) NOT NULL default '0',
 `redeem_date` datetime NOT NULL default '0000-00-00 00:00:00',
 `redeem_ip` varchar(32) NOT NULL default '',
 `order_id` int(11) NOT NULL default '0',
 PRIMARY KEY  (`unique_id`)
) TYPE=MyISAM AUTO_INCREMENT=29;

-- --------------------------------------------------------

-- 
-- Table structure for table `coupons`
-- 

CREATE TABLE `coupons` (
 `coupon_id` int(11) NOT NULL auto_increment,
 `coupon_type` char(1) NOT NULL default 'F',
 `coupon_code` varchar(32) NOT NULL default '',
 `coupon_amount` decimal(8,4) NOT NULL default '0.0000',
 `coupon_minimum_order` decimal(8,4) NOT NULL default '0.0000',
 `coupon_start_date` datetime NOT NULL default '0000-00-00 00:00:00',
 `coupon_expire_date` datetime NOT NULL default '0000-00-00 00:00:00',
 `uses_per_coupon` int(5) NOT NULL default '1',
 `uses_per_user` int(5) NOT NULL default '0',
 `restrict_to_products` varchar(255) default NULL,
 `restrict_to_categories` varchar(255) default NULL,
 `restrict_to_customers` text,
 `coupon_active` char(1) NOT NULL default 'Y',
 `date_created` datetime NOT NULL default '0000-00-00 00:00:00',
 `date_modified` datetime NOT NULL default '0000-00-00 00:00:00',
 PRIMARY KEY  (`coupon_id`)
) TYPE=MyISAM AUTO_INCREMENT=23;

-- --------------------------------------------------------

-- 
-- Table structure for table `coupons_description`
-- 

CREATE TABLE `coupons_description` (
 `coupon_id` int(11) NOT NULL default '0',
 `language_id` int(11) NOT NULL default '0',
 `coupon_name` varchar(32) NOT NULL default '',
 `coupon_description` text,
 KEY `coupon_id` (`coupon_id`)
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Table structure for table `currencies`
-- 

CREATE TABLE `currencies` (
 `currencies_id` int(11) 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(13,8) default NULL,
 `last_updated` datetime default NULL,
 PRIMARY KEY  (`currencies_id`)
) TYPE=MyISAM AUTO_INCREMENT=3;

-- --------------------------------------------------------

-- 
-- Table structure for table `customers`
-- 

CREATE TABLE `customers` (
 `customers_id` int(11) 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(11) NOT NULL default '0',
 `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 AUTO_INCREMENT=1;

-- --------------------------------------------------------

-- 
-- Table structure for table `customers_basket`
-- 

CREATE TABLE `customers_basket` (
 `customers_basket_id` int(11) NOT NULL auto_increment,
 `customers_id` int(11) NOT NULL default '0',
 `products_id` tinytext NOT NULL,
 `customers_basket_quantity` int(2) NOT NULL default '0',
 `final_price` decimal(15,4) NOT NULL default '0.0000',
 `customers_basket_date_added` varchar(8) default NULL,
 PRIMARY KEY  (`customers_basket_id`)
) TYPE=MyISAM AUTO_INCREMENT=1;

-- --------------------------------------------------------

-- 
-- Table structure for table `customers_basket_attributes`
-- 

CREATE TABLE `customers_basket_attributes` (
 `customers_basket_attributes_id` int(11) NOT NULL auto_increment,
 `customers_id` int(11) NOT NULL default '0',
 `products_id` tinytext NOT NULL,
 `products_options_id` int(11) NOT NULL default '0',
 `products_options_value_id` int(11) NOT NULL default '0',
 PRIMARY KEY  (`customers_basket_attributes_id`)
) TYPE=MyISAM AUTO_INCREMENT=1;

-- --------------------------------------------------------

-- 
-- Table structure for table `customers_info`
-- 

CREATE TABLE `customers_info` (
 `customers_info_id` int(11) 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,
 `global_product_notifications` int(1) default '0',
 PRIMARY KEY  (`customers_info_id`)
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Table structure for table `db_queries`
-- 

CREATE TABLE `db_queries` (
 `q_id` tinyint(4) NOT NULL auto_increment,
 `q_desc` text NOT NULL,
 `q_var` char(2) NOT NULL default '',
 `sorq` varchar(12) NOT NULL default '',
 PRIMARY KEY  (`q_id`)
) TYPE=MyISAM AUTO_INCREMENT=31;

-- --------------------------------------------------------

-- 
-- Table structure for table `db_queries_desc`
-- 

CREATE TABLE `db_queries_desc` (
 `prim_id` tinyint(4) NOT NULL auto_increment,
 `q_id` tinyint(4) NOT NULL default '0',
 `q_query` text NOT NULL,
 PRIMARY KEY  (`prim_id`)
) TYPE=MyISAM AUTO_INCREMENT=92;

-- --------------------------------------------------------

-- 
-- Table structure for table `featured`
-- 

CREATE TABLE `featured` (
 `featured_id` int(11) NOT NULL auto_increment,
 `products_id` int(11) NOT NULL default '0',
 `featured_date_added` datetime default NULL,
 `featured_last_modified` datetime default NULL,
 `expires_date` datetime default NULL,
 `date_status_change` datetime default NULL,
 `status` int(1) default '1',
 PRIMARY KEY  (`featured_id`)
) TYPE=MyISAM AUTO_INCREMENT=1;

-- --------------------------------------------------------

-- 
-- Table structure for table `geo_zones`
-- 

CREATE TABLE `geo_zones` (
 `geo_zone_id` int(11) 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 AUTO_INCREMENT=4;

-- --------------------------------------------------------

-- 
-- Table structure for table `languages`
-- 

CREATE TABLE `languages` (
 `languages_id` int(11) 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 AUTO_INCREMENT=2;

-- --------------------------------------------------------

-- 
-- Table structure for table `manufacturers`
-- 

CREATE TABLE `manufacturers` (
 `manufacturers_id` int(11) NOT NULL auto_increment,
 `manufacturers_name` varchar(32) NOT NULL default '',
 `manufacturers_image` varchar(64) default NULL,
 `date_added` datetime default NULL,
 `last_modified` datetime default NULL,
 PRIMARY KEY  (`manufacturers_id`),
 KEY `IDX_MANUFACTURERS_NAME` (`manufacturers_name`)
) TYPE=MyISAM AUTO_INCREMENT=1;

-- --------------------------------------------------------

-- 
-- Table structure for table `manufacturers_info`
-- 

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

-- --------------------------------------------------------

-- 
-- Table structure for table `newsletters`
-- 

CREATE TABLE `newsletters` (
 `newsletters_id` int(11) NOT NULL auto_increment,
 `title` varchar(255) NOT NULL default '',
 `content` text NOT NULL,
 `module` varchar(255) NOT NULL default '',
 `date_added` datetime NOT NULL default '0000-00-00 00:00:00',
 `date_sent` datetime default NULL,
 `status` int(1) default NULL,
 `locked` int(1) default '0',
 PRIMARY KEY  (`newsletters_id`)
) TYPE=MyISAM AUTO_INCREMENT=1;

-- --------------------------------------------------------

-- 
-- Table structure for table `orders`
-- 

CREATE TABLE `orders` (
 `orders_id` int(11) NOT NULL auto_increment,
 `customers_id` int(11) NOT NULL default '0',
 `customers_name` varchar(64) NOT NULL default '',
 `customers_company` varchar(32) default NULL,
 `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_company` varchar(32) default NULL,
 `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',
 `billing_name` varchar(64) NOT NULL default '',
 `billing_company` varchar(32) default NULL,
 `billing_street_address` varchar(64) NOT NULL default '',
 `billing_suburb` varchar(32) default NULL,
 `billing_city` varchar(32) NOT NULL default '',
 `billing_postcode` varchar(10) NOT NULL default '',
 `billing_state` varchar(32) default NULL,
 `billing_country` varchar(32) NOT NULL default '',
 `billing_address_format_id` int(5) NOT NULL default '0',
 `payment_method` varchar(32) 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,
 `orders_status` int(5) NOT NULL default '0',
 `orders_date_finished` datetime default NULL,
 `currency` char(3) default NULL,
 `currency_value` decimal(14,6) default NULL,
 PRIMARY KEY  (`orders_id`)
) TYPE=MyISAM AUTO_INCREMENT=1;

-- --------------------------------------------------------

-- 
-- Table structure for table `orders_products`
-- 

CREATE TABLE `orders_products` (
 `orders_products_id` int(11) NOT NULL auto_increment,
 `orders_id` int(11) NOT NULL default '0',
 `products_id` int(11) NOT NULL default '0',
 `products_model` varchar(12) default NULL,
 `products_name` varchar(64) NOT NULL default '',
 `products_price` decimal(15,4) NOT NULL default '0.0000',
 `final_price` decimal(15,4) NOT NULL default '0.0000',
 `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 AUTO_INCREMENT=1;

-- --------------------------------------------------------

-- 
-- Table structure for table `orders_products_attributes`
-- 

CREATE TABLE `orders_products_attributes` (
 `orders_products_attributes_id` int(11) NOT NULL auto_increment,
 `orders_id` int(11) NOT NULL default '0',
 `orders_products_id` int(11) NOT NULL default '0',
 `products_options` varchar(32) NOT NULL default '',
 `products_options_values` varchar(32) NOT NULL default '',
 `options_values_price` decimal(15,4) NOT NULL default '0.0000',
 `price_prefix` char(1) NOT NULL default '',
 PRIMARY KEY  (`orders_products_attributes_id`)
) TYPE=MyISAM AUTO_INCREMENT=1;

-- --------------------------------------------------------

-- 
-- Table structure for table `orders_products_download`
-- 

CREATE TABLE `orders_products_download` (
 `orders_products_download_id` int(11) NOT NULL auto_increment,
 `orders_id` int(11) NOT NULL default '0',
 `orders_products_id` int(11) 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`)
) TYPE=MyISAM AUTO_INCREMENT=1;

-- --------------------------------------------------------

-- 
-- Table structure for table `orders_status`
-- 

CREATE TABLE `orders_status` (
 `orders_status_id` int(11) NOT NULL default '0',
 `language_id` int(11) 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 `orders_status_history`
-- 

CREATE TABLE `orders_status_history` (
 `orders_status_history_id` int(11) NOT NULL auto_increment,
 `orders_id` int(11) NOT NULL default '0',
 `orders_status_id` int(5) NOT NULL default '0',
 `date_added` datetime NOT NULL default '0000-00-00 00:00:00',
 `customer_notified` int(1) default '0',
 `comments` text,
 PRIMARY KEY  (`orders_status_history_id`)
) TYPE=MyISAM AUTO_INCREMENT=1;

-- --------------------------------------------------------

-- 
-- Table structure for table `orders_total`
-- 

CREATE TABLE `orders_total` (
 `orders_total_id` int(10) unsigned NOT NULL auto_increment,
 `orders_id` int(11) NOT NULL default '0',
 `title` varchar(255) NOT NULL default '',
 `text` varchar(255) NOT NULL default '',
 `value` decimal(15,4) NOT NULL default '0.0000',
 `class` varchar(32) NOT NULL default '',
 `sort_order` int(11) NOT NULL default '0',
 PRIMARY KEY  (`orders_total_id`),
 KEY `idx_orders_total_orders_id` (`orders_id`)
) TYPE=MyISAM AUTO_INCREMENT=1;

-- --------------------------------------------------------

-- 
-- Table structure for table `paypalipn_temp_data`
-- 

CREATE TABLE `paypalipn_temp_data` (
 `orders_id` int(11) NOT NULL default '0',
 `email_to` varchar(255) NOT NULL default '',
 `email_address` varchar(96) NOT NULL default '',
 `email_subject` varchar(255) NOT NULL default '',
 `email_text` text NOT NULL,
 KEY `orders_id` (`orders_id`)
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Table structure for table `paypalipn_txn`
-- 

CREATE TABLE `paypalipn_txn` (
 `paypalipn_txn_id` int(11) NOT NULL auto_increment,
 `txn_id` varchar(17) NOT NULL default '',
 `ipn_result` varchar(10) NOT NULL default '',
 `receiver_email` varchar(255) NOT NULL default '',
 `item_name` varchar(96) NOT NULL default '',
 `item_number` int(11) NOT NULL default '0',
 `quantity` int(11) NOT NULL default '0',
 `invoice` varchar(255) NOT NULL default '',
 `custom` varchar(255) NOT NULL default '',
 `option_name1` varchar(255) NOT NULL default '',
 `option_selection1` varchar(255) NOT NULL default '',
 `option_name2` varchar(255) NOT NULL default '',
 `option_selection2` varchar(255) NOT NULL default '',
 `num_cart_items` int(11) NOT NULL default '0',
 `payment_status` varchar(10) NOT NULL default '',
 `pending_reason` varchar(10) NOT NULL default '',
 `payment_date` varchar(100) NOT NULL default '',
 `payment_gross` decimal(15,4) NOT NULL default '0.0000',
 `payment_fee` decimal(15,4) NOT NULL default '0.0000',
 `mc_gross` decimal(15,4) NOT NULL default '0.0000',
 `mc_fee` decimal(15,4) NOT NULL default '0.0000',
 `mc_currency` varchar(10) NOT NULL default '',
 `txn_type` varchar(10) NOT NULL default '',
 `first_name` varchar(32) NOT NULL default '',
 `last_name` varchar(32) NOT NULL default '',
 `address_street` varchar(64) NOT NULL default '',
 `address_city` varchar(64) NOT NULL default '',
 `address_state` varchar(64) NOT NULL default '',
 `address_zip` varchar(10) NOT NULL default '',
 `address_country` varchar(32) NOT NULL default '',
 `address_status` varchar(11) NOT NULL default '',
 `payer_email` varchar(96) NOT NULL default '',
 `payer_id` varchar(128) NOT NULL default '',
 `payer_status` varchar(15) NOT NULL default '',
 `payment_type` varchar(7) NOT NULL default '',
 `notify_version` varchar(5) NOT NULL default '',
 `verify_sign` varchar(128) NOT NULL default '',
 PRIMARY KEY  (`paypalipn_txn_id`),
 KEY `txn_id` (`txn_id`)
) TYPE=MyISAM AUTO_INCREMENT=1;

-- --------------------------------------------------------

-- 
-- Table structure for table `products`
-- 

CREATE TABLE `products` (
 `products_id` int(11) 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(15,4) NOT NULL default '0.0000',
 `products_date_added` datetime NOT NULL default '0000-00-00 00:00:00',
 `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(11) NOT NULL default '0',
 `manufacturers_id` int(11) default NULL,
 `products_ordered` int(11) NOT NULL default '0',
 PRIMARY KEY  (`products_id`),
 KEY `idx_products_date_added` (`products_date_added`)
) TYPE=MyISAM AUTO_INCREMENT=1;

-- --------------------------------------------------------

-- 
-- Table structure for table `products_attributes`
-- 

CREATE TABLE `products_attributes` (
 `products_attributes_id` int(11) NOT NULL auto_increment,
 `products_id` int(11) NOT NULL default '0',
 `options_id` int(11) NOT NULL default '0',
 `options_values_id` int(11) NOT NULL default '0',
 `options_values_price` decimal(15,4) NOT NULL default '0.0000',
 `price_prefix` char(1) NOT NULL default '',
 `attribute_sort` int(10) unsigned NOT NULL default '0',
 PRIMARY KEY  (`products_attributes_id`)
) TYPE=MyISAM AUTO_INCREMENT=1;

-- --------------------------------------------------------

-- 
-- Table structure for table `products_attributes_download`
-- 

CREATE TABLE `products_attributes_download` (
 `products_attributes_id` int(11) NOT NULL default '0',
 `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`)
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Table structure for table `products_description`
-- 

CREATE TABLE `products_description` (
 `products_id` int(11) NOT NULL auto_increment,
 `language_id` int(11) 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 AUTO_INCREMENT=1;

-- --------------------------------------------------------

-- 
-- Table structure for table `products_notifications`
-- 

CREATE TABLE `products_notifications` (
 `products_id` int(11) NOT NULL default '0',
 `customers_id` int(11) NOT NULL default '0',
 `date_added` datetime NOT NULL default '0000-00-00 00:00:00',
 PRIMARY KEY  (`products_id`,`customers_id`)
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Table structure for table `products_options`
-- 

CREATE TABLE `products_options` (
 `products_options_id` int(11) NOT NULL default '0',
 `language_id` int(11) 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(11) NOT NULL default '0',
 `language_id` int(11) 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(11) NOT NULL auto_increment,
 `products_options_id` int(11) NOT NULL default '0',
 `products_options_values_id` int(11) NOT NULL default '0',
 PRIMARY KEY  (`products_options_values_to_products_options_id`)
) TYPE=MyISAM AUTO_INCREMENT=1;

-- --------------------------------------------------------

-- 
-- Table structure for table `products_to_categories`
-- 

CREATE TABLE `products_to_categories` (
 `products_id` int(11) NOT NULL default '0',
 `categories_id` int(11) NOT NULL default '0',
 PRIMARY KEY  (`products_id`,`categories_id`)
) TYPE=MyISAM;

-- --------------------------------------------------------

Most likely your question has been answered, please do a search first.

Link to comment
Share on other sites

In the osCommerce MS2 download package there is a script in the extras/pr21_to_pr22/ directory - ms1_to_ms2.php

 

This does the conversion to MS2 from MS1 - perhaps you can convert to standard MS2 then to your modded?

 

Matti

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...