Updates for CW 2 to CW 3
This update makes the following changes to a Cartweaver 2 MySQL database: [click to expand]
- tbl_companyinfo
delete table -- put data into tbl_config (data will be moved in this update. Delete table manually when you no longer need it.)
- tbl_images
delete table manually -- not used in CW2 or CW3
- add imgType_Folder varchar(50) to table tbl_list_imagetypes
- tbl_orders:
add order_Comments varchar(255)
add order_DiscountID int
add order_DiscountAmount money
add order_ShippingTax money
- tbl_orderskus
add orderSKU_TaxRate money
add orderSKU_TaxRateID int
add orderSKU_DiscountID int
add orderSKU_DiscountAmount money
- tbl_products
add product_taxgroupid int
- tbl_shipweights
change table name to tbl_shipranges (new table added. Delete old table manually if no longer needed.)
change field ship_weightrange_ID to ship_range_ID
change field ship_weightrange_Method_ID to ship_range_Method_ID
change field ship_weightrange_From to ship_range_From
change field ship_weightrange_To to ship_range_To
change field ship_weightrange_Amount to ship_range_Amount
- Added New Tables
tbl_config
tbl_configgroup
tbl_discount_amounts
tbl_discount_apply_types
tbl_discount_usage
tbl_discounts
tbl_discounts_products_rel
tbl_discounts_skus_rel
tbl_taxgroups
tbl_taxrates
tbl_taxregions
Update the Cartweaver Database
Follow the steps below to update the Cartweaver 2 database on your server.
Use at your own risk and make sure you have backed up your data. Every effort has been made to make this script work well on a CW2 site, but if your site depends on old data CW2 tables, make sure you are also updating your PHP scripts. This updater only updates the database. All existing data will remain.