Originally Posted by
christiansees
Isn't there anyone else out there working on this? I would post to the thread listed above but it seems I don't have permission. So here goes messing about with multiple threads.
When I try to run the script
Code:
Convert OSC to ZENCART CUSTOMER; CATEGORY; PRODUCTS and ORDERS
ALTER TABLE customers ADD customers_nick VARCHAR( 96 ) NOT NULL AFTER `customers_email_address`;
ALTER TABLE customers ADD customers_group_pricing INT( 11 ) DEFAULT '0' NOT NULL;
ALTER TABLE customers ADD customers_email_format VARCHAR( 4 ) DEFAULT 'TEXT' NOT NULL;
ALTER TABLE customers ADD customers_authorization int(1) NOT NULL default '0';
ALTER TABLE customers ADD customers_referral VARCHAR(32) NOT NULL default '';
ALTER TABLE orders ADD payment_module_code varchar(32) NOT NULL default ''AFTER payment_method;
ALTER TABLE orders ADD shipping_method varchar(128) NOT NULL default '' AFTER payment_module_code;
ALTER TABLE orders ADD shipping_module_code varchar(32) NOT NULL default '' AFTER shipping_method;
ALTER TABLE orders ADD coupon_code varchar(32) NOT NULL default '' AFTER shipping_module_code;
ALTER TABLE orders ADD cc_cvv blob AFTER cc_expires;
ALTER TABLE orders ADD order_total decimal(14,2) default NULL;
ALTER TABLE orders ADD order_tax decimal(14,2) default NULL;
ALTER TABLE orders ADD paypal_ipn_id INT( 11 ) DEFAULT '0' NOT NULL;
ALTER TABLE orders ADD ip_address varchar(15) NOT NULL default '';
ALTER TABLE orders_products CHANGE products_quantity products_quantity FLOAT DEFAULT '0' NOT NULL;
ALTER TABLE orders_products ADD onetime_charges decimal(15,4) NOT NULL default '0.0000';
ALTER TABLE orders_products ADD products_priced_by_attribute tinyint(1) NOT NULL default '0';
ALTER TABLE orders_products ADD product_is_free tinyint(1) NOT NULL default '0';
ALTER TABLE orders_products ADD products_discount_type tinyint(1) NOT NULL default '0';
ALTER TABLE orders_products ADD products_discount_type_from tinyint(1) NOT NULL default '0';
ALTER TABLE products ADD products_type INT( 11 ) DEFAULT '1' NOT NULL AFTER products_id;
ALTER TABLE products ADD products_virtual TINYINT( 1 ) DEFAULT '0' NOT NULL AFTER products_price;
ALTER TABLE products CHANGE products_weight products_weight FLOAT DEFAULT '0' NOT NULL;
ALTER TABLE products CHANGE products_ordered products_ordered FLOAT DEFAULT '0' NOT NULL;
ALTER TABLE products ADD products_quantity_order_min FLOAT DEFAULT '1' NOT NULL;
ALTER TABLE products ADD products_quantity_order_units FLOAT DEFAULT '1' NOT NULL;
ALTER TABLE products ADD products_priced_by_attribute tinyint(1) NOT NULL default '0';
ALTER TABLE products ADD product_is_free tinyint(1) NOT NULL default '0';
ALTER TABLE products ADD product_is_call tinyint(1) NOT NULL default '0';
ALTER TABLE products ADD products_quantity_mixed tinyint(1) NOT NULL default '0';
ALTER TABLE products ADD product_is_always_free_shipping tinyint(1) NOT NULL default '0';
ALTER TABLE products ADD products_qty_box_status tinyint(1) NOT NULL default '1';
ALTER TABLE products ADD products_quantity_order_max FLOAT DEFAULT '0' NOT NULL;
ALTER TABLE products ADD products_sort_order int(11) NOT NULL default '0';
ALTER TABLE products ADD products_discount_type tinyint(1) NOT NULL default '0';
ALTER TABLE products ADD products_discount_type_from tinyint(1) NOT NULL default '0';
ALTER TABLE products ADD products_price_sorter decimal(15,4) NOT NULL default '0.0000';
ALTER TABLE products ADD master_categories_id int(11) NOT NULL default '0';
ALTER TABLE products ADD products_mixed_discount_quantity tinyint(1) NOT NULL default '1';
ALTER TABLE products ADD metatags_title_status TINYINT( 1 ) DEFAULT '0' NOT NULL;
ALTER TABLE products ADD metatags_products_name_status TINYINT( 1 ) DEFAULT '0' NOT NULL;
ALTER TABLE products ADD metatags_model_status TINYINT( 1 ) DEFAULT '0' NOT NULL;
ALTER TABLE products ADD metatags_price_status TINYINT( 1 ) DEFAULT '0' NOT NULL;
ALTER TABLE products ADD metatags_title_tagline_status TINYINT( 1 ) DEFAULT '0' NOT NULL;
ALTER TABLE `categories` ADD `categories_status` TINYINT( 1 ) DEFAULT '1' NOT NULL;
ALTER TABLE `categories_description` ADD `categories_description` TEXT NOT NULL;
ALTER TABLE banners_history ADD INDEX idx_banners_id_zen ( banners_id );
ALTER TABLE banners ADD INDEX idx_status_group_zen ( status, banners_group );
ALTER TABLE specials ADD INDEX idx_status_zen ( status );
ALTER TABLE specials ADD INDEX idx_products_id_zen ( products_id );
ALTER TABLE specials ADD INDEX idx_date_avail_zen ( specials_date_available );
ALTER TABLE featured ADD INDEX idx_status_zen ( status );
ALTER TABLE featured ADD INDEX idx_products_id_zen ( products_id );
ALTER TABLE featured ADD INDEX idx_date_avail_zen ( featured_date_available );
ALTER TABLE salemaker_sales ADD INDEX idx_sale_status_zen ( sale_status );
ALTER TABLE categories ADD INDEX idx_categories_parent_id_TEST ( parent_id );
ALTER TABLE categories ADD INDEX idx_parent_id_cat_id_zen ( parent_id, categories_id );
ALTER TABLE categories ADD INDEX idx_status_zen ( categories_status );
ALTER TABLE product_types_to_category ADD INDEX idx_category_id_zen ( category_id );
ALTER TABLE product_types_to_category ADD INDEX idx_product_type_id_zen ( product_type_id );
ALTER TABLE product_types ADD INDEX idx_type_master_type_zen ( type_master_type );
ALTER TABLE products ADD INDEX idx_products_status_zen ( products_status );
ALTER TABLE products_to_categories ADD INDEX idx_cat_prod_id_zen (categories_id, products_id);
ALTER TABLE products_attributes ADD INDEX idx_id_options_id_values_zen ( products_id, options_id, options_values_id );
ALTER TABLE products_discount_quantity ADD INDEX idx_id_qty_zen ( products_id, discount_qty );
ALTER TABLE products_options_values_to_products_options ADD INDEX idx_prod_opt_val_id_zen ( products_options_values_id );
ALTER TABLE products_options ADD INDEX idx_lang_id_zen ( language_id );
ALTER TABLE tax_rates ADD INDEX idx_tax_zone_id_zen ( tax_zone_id );
ALTER TABLE tax_rates ADD INDEX idx_tax_class_id_zen ( tax_class_id );
ALTER TABLE configuration ADD INDEX idx_key_value_zen ( configuration_key, configuration_value(10) );
ALTER TABLE configuration_group ADD INDEX idx_visible_zen ( visible );
ALTER TABLE configuration ADD INDEX idx_cfg_grp_id_zen ( configuration_group_id );
ALTER TABLE product_type_layout ADD INDEX idx_key_value_zen ( configuration_key, configuration_value(10) );
ALTER TABLE customers ADD INDEX idx_email_address_zen ( customers_email_address );
ALTER TABLE customers ADD INDEX idx_referral_zen ( customers_referral(10) );
ALTER TABLE customers ADD INDEX idx_grp_pricing_zen ( customers_group_pricing );
ALTER TABLE customers ADD INDEX idx_nick_zen ( customers_nick );
ALTER TABLE customers ADD INDEX idx_newsletter_zen ( customers_newsletter );
ALTER TABLE customers_basket ADD INDEX idx_customers_id_zen ( customers_id );
ALTER TABLE customers_basket_attributes ADD INDEX idx_cust_id_prod_id_zen ( customers_id, products_id(36) );
ALTER TABLE orders ADD INDEX idx_status_orders_cust_zen ( orders_status, orders_id, customers_id );
#ALTER TABLE orders ADD INDEX idx_customers_id_zen ( customers_id );
ALTER TABLE orders_status_history ADD INDEX idx_orders_id_status_id_zen ( orders_id, orders_status_id );
ALTER TABLE orders_products ADD INDEX idx_orders_id_zen ( orders_id );
ALTER TABLE orders_products ADD INDEX orders_id_prod_id_zen ( orders_id , products_id );
ALTER TABLE orders_products_attributes ADD INDEX idx_orders_id_prod_id_zen ( orders_id , orders_products_id );
ALTER TABLE orders_products_download ADD INDEX idx_orders_id_zen ( orders_id );
ALTER TABLE orders_products_download ADD INDEX idx_orders_products_id_zen ( orders_products_id );
ALTER TABLE layout_boxes ADD INDEX idx_name_template_zen ( layout_template, layout_box_name );
ALTER TABLE coupon_gv_queue ADD INDEX idx_release_flag_zen ( release_flag );
ALTER TABLE coupons ADD INDEX idx_active_type_zen ( coupon_active, coupon_type );
ALTER TABLE coupons_description DROP INDEX coupon_id;
ALTER TABLE coupons_description ADD PRIMARY KEY (coupon_id, language_id);
ALTER TABLE coupon_restrict ADD INDEX idx_coup_id_prod_id_zen (coupon_id, product_id);
ALTER TABLE coupon_redeem_track ADD INDEX idx_coupon_id_zen ( coupon_id );
ALTER TABLE coupon_gv_queue DROP INDEX uid;
ALTER TABLE coupon_gv_queue ADD INDEX idx_cust_id_order_id_zen ( customer_id , order_id );
ALTER TABLE coupon_email_track ADD INDEX idx_coupon_id_zen ( coupon_id );
ALTER TABLE reviews ADD INDEX idx_products_id_zen ( products_id );
ALTER TABLE reviews ADD INDEX idx_customers_id_zen ( customers_id );
ALTER TABLE admin ADD INDEX idx_admin_name_zen ( admin_name );
ALTER TABLE files_uploaded ADD INDEX idx_customers_id_zen ( customers_id );
ALTER TABLE email_archive DROP INDEX email_to;
ALTER TABLE email_archive ADD INDEX idx_email_to_address_zen ( email_to_address );
ALTER TABLE email_archive DROP INDEX module;
ALTER TABLE email_archive ADD INDEX idx_module_zen ( module );
ALTER TABLE media_to_products ADD INDEX idx_media_product_zen ( media_id, product_id );
ALTER TABLE media_clips ADD INDEX idx_media_id_zen ( media_id );
ALTER TABLE product_music_extra ADD INDEX idx_music_genre_id_zen ( music_genre_id );
ALTER TABLE paypal ADD INDEX idx_zen_order_id_zen ( zen_order_id );
ALTER TABLE paypal_payment_status_history ADD INDEX idx_paypal_ipn_id_zen ( paypal_ipn_id );
ALTER TABLE paypal_session ADD INDEX idx_session_id_zen ( session_id(36) );
First I found several end of line errors. Then I got this error ALTER TABLE specials ADD INDEX idx_date_avail_zen( specials_date_available ) ; no such item.
Suggestions, constructive help?
thanks
Bookmarks