Hi,

I took a look at the zencart db, and it is pretty straightforward.

I just ran through a zencart database migration to oscmax, and it was pretty easy, and can be completed in about 20 to 30 minutes, faster if you know what you are doing



Here are some steps to follow:

  • Make a duplicate of your Zen db to work on.
  • Remove the zen_ prefix from all the tables in the zencart db.
  • Run mysqldiff, comparing the zencart db to the oscmax db to get the mysql batch script.
  • Run the sql commands generated by mysqldiff on the zencart database. This will effectively turn the zencart db into an oscmax db.
  • Then simply export the data from the customer, order, address, and products/categories tables to a batch file, and run that file on the oscmax database.

It is a pretty easy process, and I have also included the batch script that will update a zencart db structure to an oscmax db structure. This will allow you to skip the mysqldiff step above. Paste code below to a phpmyadmin query or save it to an sql file and run it from the command line :

Code:
#
# MySQLDiff 1.5.0
#
# http://www.mysqldiff.org
# (c) 2001-2004, Lippe-Net Online-Service
#
# Create time: 29.12.2004 20:51
#
# --------------------------------------------------------
# Source info
# Host: localhost
# Database: zencart
# --------------------------------------------------------
# Target info
# Host: localhost
# Database: default_oscmax17
# --------------------------------------------------------
#

SET FOREIGN_KEY_CHECKS = 0;

#
# DDL START
#
CREATE TABLE admin_files (
    admin_files_id int(11) NOT NULL DEFAULT 0 auto_increment,
    admin_files_name varchar(64) NOT NULL DEFAULT '',
    admin_files_is_boxes tinyint(5) NOT NULL DEFAULT '0',
    admin_files_to_boxes int(11) NOT NULL DEFAULT '0',
    admin_groups_id set('1','2') NOT NULL DEFAULT '1',
    PRIMARY KEY (admin_files_id)
) TYPE=MyISAM;

CREATE TABLE admin_groups (
    admin_groups_id int(11) NOT NULL DEFAULT 0 auto_increment,
    admin_groups_name varchar(64) NULL DEFAULT NULL,
    PRIMARY KEY (admin_groups_id),
    UNIQUE admin_groups_name (admin_groups_name)
) TYPE=MyISAM;

CREATE TABLE affiliate_affiliate (
    affiliate_id int(11) NOT NULL DEFAULT 0 auto_increment,
    affiliate_gender char(1) NOT NULL DEFAULT '',
    affiliate_firstname varchar(32) NOT NULL DEFAULT '',
    affiliate_lastname varchar(32) NOT NULL DEFAULT '',
    affiliate_dob datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    affiliate_email_address varchar(96) NOT NULL DEFAULT '',
    affiliate_telephone varchar(32) NOT NULL DEFAULT '',
    affiliate_fax varchar(32) NOT NULL DEFAULT '',
    affiliate_password varchar(40) NOT NULL DEFAULT '',
    affiliate_homepage varchar(96) NOT NULL DEFAULT '',
    affiliate_street_address varchar(64) NOT NULL DEFAULT '',
    affiliate_suburb varchar(64) NOT NULL DEFAULT '',
    affiliate_city varchar(32) NOT NULL DEFAULT '',
    affiliate_postcode varchar(10) NOT NULL DEFAULT '',
    affiliate_state varchar(32) NOT NULL DEFAULT '',
    affiliate_country_id int(11) NOT NULL DEFAULT '0',
    affiliate_zone_id int(11) NOT NULL DEFAULT '0',
    affiliate_agb tinyint(4) NOT NULL DEFAULT '0',
    affiliate_company varchar(60) NOT NULL DEFAULT '',
    affiliate_company_taxid varchar(64) NOT NULL DEFAULT '',
    affiliate_commission_percent decimal(4,2) NOT NULL DEFAULT '0.00',
    affiliate_payment_check varchar(100) NOT NULL DEFAULT '',
    affiliate_payment_paypal varchar(64) NOT NULL DEFAULT '',
    affiliate_payment_bank_name varchar(64) NOT NULL DEFAULT '',
    affiliate_payment_bank_branch_number varchar(64) NOT NULL DEFAULT '',
    affiliate_payment_bank_swift_code varchar(64) NOT NULL DEFAULT '',
    affiliate_payment_bank_account_name varchar(64) NOT NULL DEFAULT '',
    affiliate_payment_bank_account_number varchar(64) NOT NULL DEFAULT '',
    affiliate_date_of_last_logon datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    affiliate_number_of_logons int(11) NOT NULL DEFAULT '0',
    affiliate_date_account_created datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    affiliate_date_account_last_modified datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    affiliate_lft int(11) NOT NULL DEFAULT '0',
    affiliate_rgt int(11) NOT NULL DEFAULT '0',
    affiliate_root int(11) NOT NULL DEFAULT '0',
    PRIMARY KEY (affiliate_id)
) TYPE=MyISAM;

CREATE TABLE affiliate_banners (
    affiliate_banners_id int(11) NOT NULL DEFAULT 0 auto_increment,
    affiliate_banners_title varchar(64) NOT NULL DEFAULT '',
    affiliate_products_id int(11) NOT NULL DEFAULT '0',
    affiliate_banners_image varchar(64) NOT NULL DEFAULT '',
    affiliate_banners_group varchar(10) NOT NULL DEFAULT '',
    affiliate_banners_html_text text NULL DEFAULT NULL,
    affiliate_expires_impressions int(7) NULL DEFAULT '0',
    affiliate_expires_date datetime NULL DEFAULT NULL,
    affiliate_date_scheduled datetime NULL DEFAULT NULL,
    affiliate_date_added datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    affiliate_date_status_change datetime NULL DEFAULT NULL,
    affiliate_status int(1) NOT NULL DEFAULT '1',
    PRIMARY KEY (affiliate_banners_id)
) TYPE=MyISAM;

CREATE TABLE affiliate_banners_history (
    affiliate_banners_history_id int(11) NOT NULL DEFAULT 0 auto_increment,
    affiliate_banners_products_id int(11) NOT NULL DEFAULT '0',
    affiliate_banners_id int(11) NOT NULL DEFAULT '0',
    affiliate_banners_affiliate_id int(11) NOT NULL DEFAULT '0',
    affiliate_banners_shown int(11) NOT NULL DEFAULT '0',
    affiliate_banners_clicks tinyint(4) NOT NULL DEFAULT '0',
    affiliate_banners_history_date date NOT NULL DEFAULT '0000-00-00',
    PRIMARY KEY (affiliate_banners_history_id, affiliate_banners_products_id)
) TYPE=MyISAM;

CREATE TABLE affiliate_clickthroughs (
    affiliate_clickthrough_id int(11) NOT NULL DEFAULT 0 auto_increment,
    affiliate_id int(11) NOT NULL DEFAULT '0',
    affiliate_clientdate datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    affiliate_clientbrowser varchar(200) NULL DEFAULT 'Could Not Find This Data',
    affiliate_clientip varchar(50) NULL DEFAULT 'Could Not Find This Data',
    affiliate_clientreferer varchar(200) NULL DEFAULT 'none detected (maybe a direct link)',
    affiliate_products_id int(11) NULL DEFAULT '0',
    affiliate_banner_id int(11) NOT NULL DEFAULT '0',
    PRIMARY KEY (affiliate_clickthrough_id),
    INDEX refid (affiliate_id)
) TYPE=MyISAM;

CREATE TABLE affiliate_payment (
    affiliate_payment_id int(11) NOT NULL DEFAULT 0 auto_increment,
    affiliate_id int(11) NOT NULL DEFAULT '0',
    affiliate_payment decimal(15,2) NOT NULL DEFAULT '0.00',
    affiliate_payment_tax decimal(15,2) NOT NULL DEFAULT '0.00',
    affiliate_payment_total decimal(15,2) NOT NULL DEFAULT '0.00',
    affiliate_payment_date datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    affiliate_payment_last_modified datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    affiliate_payment_status int(5) NOT NULL DEFAULT '0',
    affiliate_firstname varchar(32) NOT NULL DEFAULT '',
    affiliate_lastname varchar(32) NOT NULL DEFAULT '',
    affiliate_street_address varchar(64) NOT NULL DEFAULT '',
    affiliate_suburb varchar(64) NOT NULL DEFAULT '',
    affiliate_city varchar(32) NOT NULL DEFAULT '',
    affiliate_postcode varchar(10) NOT NULL DEFAULT '',
    affiliate_country varchar(32) NOT NULL DEFAULT '0',
    affiliate_company varchar(60) NOT NULL DEFAULT '',
    affiliate_state varchar(32) NOT NULL DEFAULT '0',
    affiliate_address_format_id int(5) NOT NULL DEFAULT '0',
    affiliate_last_modified datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    PRIMARY KEY (affiliate_payment_id)
) TYPE=MyISAM;

CREATE TABLE affiliate_payment_status (
    affiliate_payment_status_id int(11) NOT NULL DEFAULT '0',
    affiliate_language_id int(11) NOT NULL DEFAULT '1',
    affiliate_payment_status_name varchar(32) NOT NULL DEFAULT '',
    PRIMARY KEY (affiliate_payment_status_id, affiliate_language_id),
    INDEX idx_affiliate_payment_status_name (affiliate_payment_status_name)
) TYPE=MyISAM;

CREATE TABLE affiliate_payment_status_history (
    affiliate_status_history_id int(11) NOT NULL DEFAULT 0 auto_increment,
    affiliate_payment_id int(11) NOT NULL DEFAULT '0',
    affiliate_new_value int(5) NOT NULL DEFAULT '0',
    affiliate_old_value int(5) NULL DEFAULT NULL,
    affiliate_date_added datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    affiliate_notified int(1) NULL DEFAULT '0',
    PRIMARY KEY (affiliate_status_history_id)
) TYPE=MyISAM;

CREATE TABLE affiliate_sales (
    affiliate_id int(11) NOT NULL DEFAULT '0',
    affiliate_date datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    affiliate_browser varchar(100) NOT NULL DEFAULT '',
    affiliate_ipaddress varchar(20) NOT NULL DEFAULT '',
    affiliate_orders_id int(11) NOT NULL DEFAULT '0',
    affiliate_value decimal(15,2) NOT NULL DEFAULT '0.00',
    affiliate_payment decimal(15,2) NOT NULL DEFAULT '0.00',
    affiliate_clickthroughs_id int(11) NOT NULL DEFAULT '0',
    affiliate_billing_status int(5) NOT NULL DEFAULT '0',
    affiliate_payment_date datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    affiliate_payment_id int(11) NOT NULL DEFAULT '0',
    affiliate_percent decimal(4,2) NOT NULL DEFAULT '0.00',
    affiliate_salesman int(11) NOT NULL DEFAULT '0',
    PRIMARY KEY (affiliate_orders_id, affiliate_id)
) TYPE=MyISAM;

CREATE TABLE paypal_ipn (
    paypal_ipn_id int(10) unsigned NOT NULL DEFAULT 0 auto_increment,
    txn_type int(10) unsigned NOT NULL DEFAULT '0',
    reason_code int(11) NULL DEFAULT NULL,
    payment_type int(11) NOT NULL DEFAULT '0',
    payment_status int(11) NOT NULL DEFAULT '0',
    pending_reason int(11) NULL DEFAULT NULL,
    invoice varchar(64) NULL DEFAULT NULL,
    mc_currency int(11) NOT NULL DEFAULT '1',
    first_name varchar(32) NOT NULL DEFAULT '',
    last_name varchar(32) NOT NULL DEFAULT '',
    payer_business_name varchar(32) NULL DEFAULT NULL,
    address_name varchar(32) NOT NULL DEFAULT '',
    address_street varchar(64) NOT NULL DEFAULT '',
    address_city varchar(32) NOT NULL DEFAULT '',
    address_state varchar(32) NOT NULL DEFAULT '',
    address_zip varchar(64) NOT NULL DEFAULT '',
    address_country varchar(32) NOT NULL DEFAULT '',
    address_status varchar(64) NOT NULL DEFAULT '',
    address_owner varchar(64) NOT NULL DEFAULT '0',
    payer_email varchar(96) NOT NULL DEFAULT '',
    ebay_address_id varchar(96) NULL DEFAULT NULL,
    payer_id varchar(32) NOT NULL DEFAULT '',
    payer_status varchar(32) NOT NULL DEFAULT '',
    payment_date varchar(32) NOT NULL DEFAULT '',
    business varchar(32) NOT NULL DEFAULT '',
    receiver_email varchar(96) NOT NULL DEFAULT '',
    receiver_id varchar(32) NOT NULL DEFAULT '',
    paypal_address_id varchar(64) NOT NULL DEFAULT '',
    txn_id varchar(17) NOT NULL DEFAULT '',
    notify_version varchar(17) NOT NULL DEFAULT '',
    verify_sign varchar(64) NOT NULL DEFAULT '',
    date_added datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    PRIMARY KEY (paypal_ipn_id, txn_id),
    INDEX idx_paypal_ipn_paypal_ipn_id (paypal_ipn_id)
) TYPE=MyISAM;

CREATE TABLE paypal_ipn_address_status (
    address_status_id int(11) NOT NULL DEFAULT 0 auto_increment,
    language_id int(11) NOT NULL DEFAULT '1',
    address_status_name varchar(64) NOT NULL DEFAULT '',
    PRIMARY KEY (address_status_id, language_id)
) TYPE=MyISAM;

CREATE TABLE paypal_ipn_mc_currency (
    mc_currency_id int(11) NOT NULL DEFAULT 0 auto_increment,
    language_id int(11) NOT NULL DEFAULT '1',
    mc_currency_name varchar(64) NOT NULL DEFAULT '',
    PRIMARY KEY (mc_currency_id, language_id)
) TYPE=MyISAM;

CREATE TABLE paypal_ipn_orders (
    paypal_ipn_orders_id int(11) NOT NULL DEFAULT 0 auto_increment,
    paypal_ipn_id int(11) NOT NULL DEFAULT '0',
    num_cart_items tinyint(4) NOT NULL DEFAULT '0',
    mc_gross decimal(7,2) NOT NULL DEFAULT '0.00',
    mc_fee decimal(7,2) NOT NULL DEFAULT '0.00',
    payment_gross decimal(7,2) NOT NULL DEFAULT '0.00',
    payment_fee decimal(7,2) NOT NULL DEFAULT '0.00',
    settle_amount decimal(7,2) NOT NULL DEFAULT '0.00',
    settle_currency decimal(7,2) NOT NULL DEFAULT '0.00',
    exchange_rate decimal(7,2) NULL DEFAULT '0.00',
    PRIMARY KEY (paypal_ipn_orders_id, paypal_ipn_id)
) TYPE=MyISAM;

CREATE TABLE paypal_ipn_orders_memo (
    orders_memo_id int(11) NOT NULL DEFAULT 0 auto_increment,
    paypal_ipn_id int(11) NOT NULL DEFAULT '1',
    memo text NULL DEFAULT NULL,
    PRIMARY KEY (orders_memo_id, paypal_ipn_id)
) TYPE=MyISAM;

CREATE TABLE paypal_ipn_payment_status (
    payment_status_id int(11) NOT NULL DEFAULT 0 auto_increment,
    language_id int(11) NOT NULL DEFAULT '1',
    payment_status_name varchar(64) NOT NULL DEFAULT '',
    PRIMARY KEY (payment_status_id, language_id)
) TYPE=MyISAM;

CREATE TABLE paypal_ipn_payment_type (
    payment_type_id int(11) NOT NULL DEFAULT 0 auto_increment,
    language_id int(11) NOT NULL DEFAULT '1',
    payment_type_name varchar(64) NOT NULL DEFAULT '',
    PRIMARY KEY (payment_type_id, language_id)
) TYPE=MyISAM;

CREATE TABLE paypal_ipn_pending_reason (
    pending_reason_id int(11) NOT NULL DEFAULT 0 auto_increment,
    language_id int(11) NOT NULL DEFAULT '1',
    pending_reason_name varchar(64) NOT NULL DEFAULT '',
    PRIMARY KEY (pending_reason_id, language_id)
) TYPE=MyISAM;

CREATE TABLE paypal_ipn_reason_code (
    reason_code_id int(11) NOT NULL DEFAULT 0 auto_increment,
    language_id int(11) NOT NULL DEFAULT '1',
    reason_code_name varchar(64) NOT NULL DEFAULT '',
    PRIMARY KEY (reason_code_id, language_id)
) TYPE=MyISAM;

CREATE TABLE paypal_ipn_txn_type (
    txn_type_id int(11) NOT NULL DEFAULT 0 auto_increment,
    language_id int(11) NOT NULL DEFAULT '1',
    txn_type_name varchar(64) NOT NULL DEFAULT '',
    PRIMARY KEY (txn_type_id, language_id)
) TYPE=MyISAM;

CREATE TABLE products_groups (
    customers_group_id int(11) NOT NULL DEFAULT '0',
    customers_group_price decimal(15,4) NOT NULL DEFAULT '0.0000',
    products_id int(11) NOT NULL DEFAULT '0',
    products_price decimal(15,4) NOT NULL DEFAULT '0.0000'
) TYPE=MyISAM;

CREATE TABLE products_xsell (
    ID int(10) NOT NULL DEFAULT 0 auto_increment,
    products_id int(10) unsigned NOT NULL DEFAULT '1',
    xsell_id int(10) unsigned NOT NULL DEFAULT '1',
    sort_order int(10) unsigned NOT NULL DEFAULT '1',
    PRIMARY KEY (ID)
) TYPE=MyISAM;

ALTER TABLE admin
    ADD admin_groups_id int(11) NULL DEFAULT NULL AFTER admin_id,
    ADD admin_firstname varchar(32) NOT NULL DEFAULT '' AFTER admin_groups_id,
    ADD admin_lastname varchar(32) NULL DEFAULT NULL AFTER admin_firstname,
    ADD admin_email_address varchar(96) NOT NULL DEFAULT '' AFTER admin_lastname,
    ADD admin_password varchar(40) NOT NULL DEFAULT '' AFTER admin_email_address,
    ADD admin_created datetime NULL DEFAULT NULL AFTER admin_password,
    ADD admin_modified datetime NOT NULL DEFAULT '0000-00-00 00:00:00' AFTER admin_created,
    ADD admin_logdate datetime NULL DEFAULT NULL AFTER admin_modified,
    ADD admin_lognum int(11) NOT NULL DEFAULT '0' AFTER admin_logdate,
    DROP admin_name,
    DROP admin_email,
    DROP admin_pass,
    DROP admin_level,
    ADD UNIQUE admin_email_address (admin_email_address);


DROP TABLE authorizenet;

ALTER TABLE banners
    MODIFY banners_group varchar(10) NOT NULL DEFAULT '',
    ALTER date_added SET DEFAULT '0000-00-00 00:00:00',
    DROP banners_open_new_windows,
    DROP banners_on_ssl;
#
#  Fieldformat of
#    banners.banners_group changed from varchar(15) NOT NULL DEFAULT '' to varchar(10) NOT NULL DEFAULT ''.
#  Possibly data modifications needed!
#

ALTER TABLE banners_history
    ALTER banners_history_date SET DEFAULT '0000-00-00 00:00:00';


ALTER TABLE categories
    DROP categories_status,
    DROP INDEX idx_sort_order;


ALTER TABLE categories_description
    ADD categories_heading_title varchar(64) NULL DEFAULT NULL AFTER categories_name,
    MODIFY categories_description text NULL DEFAULT NULL;
#
#  Fieldformat of
#    categories_description.categories_description changed from text NOT NULL DEFAULT '' to text NULL DEFAULT NULL.
#  Possibly data modifications needed!
#

ALTER TABLE configuration
    MODIFY configuration_title varchar(64) NOT NULL DEFAULT '',
    MODIFY configuration_key varchar(64) NOT NULL DEFAULT '',
    MODIFY configuration_value varchar(255) NOT NULL DEFAULT '',
    MODIFY configuration_description varchar(255) NOT NULL DEFAULT '',
    ALTER date_added SET DEFAULT '0000-00-00 00:00:00',
    MODIFY use_function varchar(255) NULL DEFAULT NULL,
    MODIFY set_function varchar(255) NULL DEFAULT NULL;
#
#  Fieldformats of
#    configuration.configuration_title changed from text NOT NULL DEFAULT '' to varchar(64) NOT NULL DEFAULT ''.
#    configuration.configuration_key changed from varchar(255) NOT NULL DEFAULT '' to varchar(64) NOT NULL DEFAULT ''.
#    configuration.configuration_value changed from text NOT NULL DEFAULT '' to varchar(255) NOT NULL DEFAULT ''.
#    configuration.configuration_description changed from text NOT NULL DEFAULT '' to varchar(255) NOT NULL DEFAULT ''.
#    configuration.use_function changed from text NULL DEFAULT NULL to varchar(255) NULL DEFAULT NULL.
#    configuration.set_function changed from text NULL DEFAULT NULL to varchar(255) NULL DEFAULT NULL.
#  Possibly data modifications needed!
#

ALTER TABLE coupon_email_track
    ALTER date_sent SET DEFAULT '0000-00-00 00:00:00';


ALTER TABLE coupon_gv_queue
    ALTER date_created SET DEFAULT '0000-00-00 00:00:00';


ALTER TABLE coupon_redeem_track
    ALTER redeem_date SET DEFAULT '0000-00-00 00:00:00';


DROP TABLE coupon_restrict;

ALTER TABLE coupons
    ALTER coupon_start_date SET DEFAULT '0000-00-00 00:00:00',
    ALTER coupon_expire_date SET DEFAULT '0000-00-00 00:00:00',
    ALTER date_created SET DEFAULT '0000-00-00 00:00:00',
    ALTER date_modified SET DEFAULT '0000-00-00 00:00:00';


ALTER TABLE currencies
    MODIFY symbol_left varchar(12) NULL DEFAULT NULL,
    MODIFY symbol_right varchar(12) NULL DEFAULT NULL;
#
#  Fieldformats of
#    currencies.symbol_left changed from varchar(24) NULL DEFAULT NULL to varchar(12) NULL DEFAULT NULL.
#    currencies.symbol_right changed from varchar(24) NULL DEFAULT NULL to varchar(12) NULL DEFAULT NULL.
#  Possibly data modifications needed!
#

ALTER TABLE customers
    ADD purchased_without_account tinyint(1) unsigned NOT NULL DEFAULT '0' AFTER customers_id,
    ADD customers_group_name varchar(27) NOT NULL DEFAULT 'Retail' AFTER customers_newsletter,
    ADD customers_group_id int(11) NOT NULL DEFAULT '0' AFTER customers_group_name,
    ALTER customers_dob SET DEFAULT '0000-00-00 00:00:00',
    DROP customers_nick,
    DROP customers_group_pricing,
    DROP customers_email_format,
    DROP customers_authorization,
    DROP customers_referral,
    ADD INDEX purchased_without_account (purchased_without_account);


ALTER TABLE customers_basket
    MODIFY customers_basket_quantity int(2) NOT NULL DEFAULT '0';
#
#  Fieldformat of
#    customers_basket.customers_basket_quantity changed from float NOT NULL DEFAULT '0' to int(2) NOT NULL DEFAULT '0'.
#  Possibly data modifications needed!
#

ALTER TABLE customers_basket_attributes
    MODIFY products_options_id int(11) NOT NULL DEFAULT '0',
    MODIFY products_options_value_text varchar(32) NULL DEFAULT NULL,
    DROP products_options_sort_order;
#
#  Fieldformats of
#    customers_basket_attributes.products_options_id changed from varchar(64) NOT NULL DEFAULT '0' to int(11) NOT NULL DEFAULT '0'.
#    customers_basket_attributes.products_options_value_text changed from varchar(64) NULL DEFAULT NULL to varchar(32) NULL DEFAULT NULL.
#  Possibly data modifications needed!
#

DROP TABLE customers_wishlist;

DROP TABLE db_cache;

DROP TABLE email_archive;

DROP TABLE featured;

DROP TABLE files_uploaded;

ALTER TABLE geo_zones
    ALTER date_added SET DEFAULT '0000-00-00 00:00:00';


DROP TABLE get_terms_to_filter;

DROP TABLE group_pricing;

DROP TABLE layout_boxes;

DROP TABLE media_clips;

DROP TABLE media_manager;

DROP TABLE media_to_products;

DROP TABLE media_types;

DROP TABLE music_genre;

ALTER TABLE newsletters
    DROP content_html,
    ALTER date_added SET DEFAULT '0000-00-00 00:00:00';


ALTER TABLE orders
    ADD paypal_ipn_id int(11) NOT NULL DEFAULT '0' AFTER currency_value,
    DROP payment_module_code,
    DROP shipping_method,
    DROP shipping_module_code,
    DROP coupon_code,
    DROP cc_cvv,
    DROP order_total,
    DROP order_tax;


ALTER TABLE orders_products
    MODIFY products_model varchar(12) NULL DEFAULT NULL,
    MODIFY products_quantity int(2) NOT NULL DEFAULT '0',
    DROP onetime_charges,
    DROP products_priced_by_attribute,
    DROP product_is_free,
    DROP products_discount_type,
    DROP products_discount_type_from;
#
#  Fieldformats of
#    orders_products.products_model changed from varchar(32) NULL DEFAULT NULL to varchar(12) NULL DEFAULT NULL.
#    orders_products.products_quantity changed from float NOT NULL DEFAULT '0' to int(2) NOT NULL DEFAULT '0'.
#  Possibly data modifications needed!
#

ALTER TABLE orders_products_attributes
    DROP product_attribute_is_free,
    DROP products_attributes_weight,
    DROP products_attributes_weight_prefix,
    DROP attributes_discounted,
    DROP attributes_price_base_included,
    DROP attributes_price_onetime,
    DROP attributes_price_factor,
    DROP attributes_price_factor_offset,
    DROP attributes_price_factor_onetime,
    DROP attributes_price_factor_onetime_offset,
    DROP attributes_qty_prices,
    DROP attributes_qty_prices_onetime,
    DROP attributes_price_words,
    DROP attributes_price_words_free,
    DROP attributes_price_letters,
    DROP attributes_price_letters_free,
    DROP products_options_id,
    DROP products_options_values_id;


ALTER TABLE orders_status_history
    ALTER date_added SET DEFAULT '0000-00-00 00:00:00';


DROP TABLE paypal;

DROP TABLE paypal_session;

DROP TABLE product_music_extra;

DROP TABLE product_type_layout;

DROP TABLE product_types;

DROP TABLE product_types_to_category;

ALTER TABLE products
    ADD products_ship_price decimal(15,4) NOT NULL DEFAULT '0.0000' AFTER products_ordered,
    DROP products_type,
    MODIFY products_quantity int(4) NOT NULL DEFAULT '0',
    MODIFY products_model varchar(25) NULL DEFAULT NULL,
    DROP products_virtual,
    ALTER products_date_added SET DEFAULT '0000-00-00 00:00:00',
    MODIFY products_ordered int(11) NOT NULL DEFAULT '0',
    DROP products_quantity_order_min,
    DROP products_quantity_order_units,
    DROP products_priced_by_attribute,
    DROP product_is_free,
    DROP product_is_call,
    DROP products_quantity_mixed,
    DROP product_is_always_free_shipping,
    DROP products_qty_box_status,
    DROP products_quantity_order_max,
    DROP products_sort_order,
    DROP products_discount_type,
    DROP products_discount_type_from,
    DROP products_price_sorter,
    DROP master_categories_id,
    DROP products_mixed_discount_quantity;
#
#  Fieldformats of
#    products.products_quantity changed from float NOT NULL DEFAULT '0' to int(4) NOT NULL DEFAULT '0'.
#    products.products_model changed from varchar(32) NULL DEFAULT NULL to varchar(25) NULL DEFAULT NULL.
#    products.products_ordered changed from float NOT NULL DEFAULT '0' to int(11) NOT NULL DEFAULT '0'.
#  Possibly data modifications needed!
#

ALTER TABLE products_attributes
    DROP products_options_sort_order,
    DROP product_attribute_is_free,
    DROP products_attributes_weight,
    DROP products_attributes_weight_prefix,
    DROP attributes_display_only,
    DROP attributes_default,
    DROP attributes_discounted,
    DROP attributes_image,
    DROP attributes_price_base_included,
    DROP attributes_price_onetime,
    DROP attributes_price_factor,
    DROP attributes_price_factor_offset,
    DROP attributes_price_factor_onetime,
    DROP attributes_price_factor_onetime_offset,
    DROP attributes_qty_prices,
    DROP attributes_qty_prices_onetime,
    DROP attributes_price_words,
    DROP attributes_price_words_free,
    DROP attributes_price_letters,
    DROP attributes_price_letters_free,
    DROP attributes_required;


DROP TABLE products_discount_quantity;

ALTER TABLE products_notifications
    ALTER date_added SET DEFAULT '0000-00-00 00:00:00';


ALTER TABLE products_options
    DROP products_options_sort_order,
    MODIFY products_options_comment varchar(32) NULL DEFAULT NULL,
    DROP products_options_size,
    DROP products_options_images_per_row,
    DROP products_options_images_style;
#
#  Fieldformat of
#    products_options.products_options_comment changed from varchar(64) NULL DEFAULT NULL to varchar(32) NULL DEFAULT NULL.
#  Possibly data modifications needed!
#

DROP TABLE products_options_types;

ALTER TABLE products_options_values
    DROP products_options_values_sort_order;


DROP TABLE project_version;

DROP TABLE project_version_history;

DROP TABLE query_builder;

DROP TABLE record_artists;

DROP TABLE record_artists_info;

DROP TABLE record_company;

DROP TABLE record_company_info;

ALTER TABLE reviews
    DROP status;


DROP TABLE salemaker_sales;

ALTER TABLE specials
    ADD customers_group_id int(11) NOT NULL DEFAULT '0' AFTER status,
    MODIFY expires_date datetime NULL DEFAULT NULL,
    DROP specials_date_available;
#
#  Fieldformat of
#    specials.expires_date changed from date NOT NULL DEFAULT '0001-01-01' to datetime NULL DEFAULT NULL.
#  Possibly data modifications needed!
#

ALTER TABLE tax_class
    ALTER date_added SET DEFAULT '0000-00-00 00:00:00';


ALTER TABLE tax_rates
    ALTER date_added SET DEFAULT '0000-00-00 00:00:00';


DROP TABLE template_select;

ALTER TABLE whos_online
    MODIFY last_page_url varchar(64) NOT NULL DEFAULT '',
    DROP host_address,
    DROP INDEX ip_address,
    DROP INDEX session_id,
    DROP INDEX customer_id,
    DROP INDEX time_entry,
    DROP INDEX time_last_click,
    DROP INDEX last_page_url;
#
#  Fieldformat of
#    whos_online.last_page_url changed from varchar(255) NOT NULL DEFAULT '' to varchar(64) NOT NULL DEFAULT ''.
#  Possibly data modifications needed!
#

ALTER TABLE zones_to_geo_zones
    ALTER date_added SET DEFAULT '0000-00-00 00:00:00';


#
# DDL END
#

SET FOREIGN_KEY_CHECKS = 1;