FlyingMonkey Posted January 18, 2005 Share Posted January 18, 2005 I have already heavily modded a ms2 site... but i need to port a ms1 database for the customer info, order info, and the product info over. is there a tool to do this? thanks in advance. Most likely your question has been answered, please do a search first. Link to comment Share on other sites More sharing options...
Guest Posted January 18, 2005 Share Posted January 18, 2005 Post the database structure dump (not the data) for both databases...we'll get it worked out. Bobby Link to comment Share on other sites More sharing options...
FlyingMonkey Posted January 18, 2005 Author Share Posted January 18, 2005 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 More sharing options...
FlyingMonkey Posted January 18, 2005 Author Share Posted January 18, 2005 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 More sharing options...
Guest Posted January 18, 2005 Share Posted January 18, 2005 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 More sharing options...
FlyingMonkey Posted January 18, 2005 Author Share Posted January 18, 2005 true, thanks johnson Most likely your question has been answered, please do a search first. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.