mysql_upgrade_zencart_104_to_111.sql

Zen Cart是真正的电子商务艺术

#
# The following commands are used to upgrade the Zen Cart v1.0.4 database structure to v1.1.1 format.
# $Id: mysql_upgrade_zencart_104_to_111.sql 4243 2006-08-24 10:55:28Z drbyte $
#

CREATE TABLE files_uploaded (files_uploaded_id int(11) NOT NULL auto_increment, sesskey varchar(32) NULL DEFAULT NULL, customers_id int(11) NULL DEFAULT NULL,files_uploaded_name varchar(64) NOT NULL DEFAULT '', PRIMARY KEY (files_uploaded_id)) TYPE=MyISAM;

CREATE TABLE products_options_types (products_options_types_id int(11) NOT NULL DEFAULT '0', products_options_types_name varchar(32) NULL DEFAULT NULL, language_id int(11) NOT NULL DEFAULT '0', PRIMARY KEY (products_options_types_id, language_id)) TYPE=MyISAM COMMENT='Track products_options_types';

CREATE TABLE salemaker_sales (sale_id int(11) NOT NULL auto_increment, sale_status tinyint(4) NOT NULL DEFAULT '0', sale_name varchar(30) NOT NULL DEFAULT '', sale_deduction_value decimal(15,4) NOT NULL DEFAULT '0.0000', sale_deduction_type tinyint(4) NOT NULL DEFAULT '0', sale_pricerange_from decimal(15,4) NOT NULL DEFAULT '0.0000', sale_pricerange_to decimal(15,4) NOT NULL DEFAULT '0.0000', sale_specials_condition tinyint(4) NOT NULL DEFAULT '0', sale_categories_selected varchar(255) NULL DEFAULT NULL, sale_categories_all varchar(255) NULL DEFAULT NULL, sale_date_start date NOT NULL DEFAULT '0000-00-00', sale_date_end date NOT NULL DEFAULT '0000-00-00', sale_date_added date NOT NULL DEFAULT '0000-00-00', sale_date_last_modified date NOT NULL DEFAULT '0000-00-00', sale_date_status_change date NOT NULL DEFAULT '0000-00-00', PRIMARY KEY (sale_id)) TYPE=MyISAM;

ALTER TABLE admin ADD admin_level tinyint(1) NOT NULL DEFAULT '1' AFTER admin_pass;

ALTER TABLE configuration CHANGE configuration_title configuration_title TEXT NOT NULL;
ALTER TABLE configuration CHANGE configuration_value configuration_value TEXT DEFAULT NULL;
ALTER TABLE configuration CHANGE configuration_description configuration_description TEXT DEFAULT NULL;

ALTER TABLE customers_basket MODIFY customers_basket_quantity decimal(11,3) NOT NULL DEFAULT '0.000';

ALTER TABLE customers_basket_attributes ADD products_options_value_text varchar(64) NULL DEFAULT NULL AFTER products_options_value_id, MODIFY products_options_id varchar(64) NOT NULL DEFAULT '0';

ALTER TABLE orders ADD cc_cvv blob NULL DEFAULT NULL AFTER cc_expires, ADD order_total decimal(14,2) NULL DEFAULT NULL AFTER currency_value, ADD order_tax decimal(14,2) NULL DEFAULT NULL AFTER order_total;

ALTER TABLE orders_products MODIFY products_quantity decimal(11,3) NOT NULL DEFAULT '0.000';

ALTER TABLE products ADD products_quantity_order_min int(8) NOT NULL DEFAULT '1' AFTER products_ordered, ADD products_quantity_order_units int(8) NOT NULL DEFAULT '1' AFTER products_quantity_order_min, ADD products_priced_by_attribute tinyint(1) NOT NULL DEFAULT '0' AFTER products_quantity_order_units, ADD product_is_free tinyint(1) NOT NULL DEFAULT '0' AFTER products_priced_by_attribute, ADD product_is_call tinyint(1) NOT NULL DEFAULT '0' AFTER product_is_free, ADD products_quantity_mixed tinyint(1) NOT NULL DEFAULT '0' AFTER product_is_call, ADD product_is_always_free_shipping tinyint(1) NOT NULL DEFAULT '0' AFTER products_quantity_mixed, ADD products_qty_box_status tinyint(1) NOT NULL DEFAULT '1' AFTER product_is_always_free_shipping, ADD products_quantity_order_max int(8) NOT NULL DEFAULT '0' AFTER products_qty_box_status;


ALTER TABLE products_attributes ADD product_attribute_is_free tinyint(1) NOT NULL DEFAULT '0' AFTER products_options_sort_order, ADD attributes_display_only tinyint(1) NOT NULL DEFAULT '0' AFTER products_attributes_weight_prefix, ADD attributes_discounted tinyint(1) NOT NULL DEFAULT '1' AFTER attributes_default, ADD attributes_image varchar(64) NULL DEFAULT NULL AFTER attributes_discounted, ADD attributes_price_base_included tinyint(1) NOT NULL DEFAULT '1' AFTER attributes_image;

ALTER TABLE products_options ADD products_options_type int(5) NOT NULL DEFAULT '0' AFTER products_options_sort_order, ADD products_options_length smallint(2) NOT NULL DEFAULT '32' AFTER products_options_type, ADD products_options_comment varchar(64) NULL DEFAULT NULL AFTER products_options_length, ADD products_options_size smallint(2) NOT NULL DEFAULT '32' AFTER products_options_comment;

UPDATE template_select set template_dir='classic' where template_dir='template_default';

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Credit Card CVV Number', 'CC_CVV_MIN_LENGTH', '3', 'Minimum length of credit card CVV number', '2', '13', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Products Attributes - Attributes Controller Display', 'MAX_ROW_LISTS_ATTRIBUTES_CONTROLLER', '30', 'Maximum number of attributes to display in the Attributes Controller page', '3', '25', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Product Info - Image Width', 'MEDIUM_IMAGE_WIDTH', '150', 'The pixel width of Product Info images', '4', '20', now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Product Info - Image Height', 'MEDIUM_IMAGE_HEIGHT', '120', 'The pixel height of Product Info images', '4', '21', now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Product Info - Image Medium Suffix', 'IMAGE_SUFFIX_MEDIUM', '_MED', 'Product Info Medium Image Suffix<br />Default = _MED', '4', '22', now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Product Info - Image Large Suffix', 'IMAGE_SUFFIX_LARGE', '_LRG', 'Product Info Large Image Suffix<br />Default = _LRG', '4', '23', now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Product Info - Number of Additional Images per Row', 'IMAGES_AUTO_ADDED', '3', 'Product Info - Enter the number of additional images to display per row<br />Default = 3', '4', '30', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Image - Product Listing Width', 'IMAGE_PRODUCT_LISTING_WIDTH', '100', 'Default = 100', 4, 40, now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Image - Product Listing Height', 'IMAGE_PRODUCT_LISTING_HEIGHT', '80', 'Default = 80', 4, 41, now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Image - Product New Listing Width', 'IMAGE_PRODUCT_NEW_LISTING_WIDTH', '100', 'Default = 100', 4, 42, now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Image - Product New Listing Height', 'IMAGE_PRODUCT_NEW_LISTING_HEIGHT', '80', 'Default = 80', 4, 43, now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Image - New Products Width', 'IMAGE_PRODUCT_NEW_WIDTH', '100', 'Default = 100', 4, 44, now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Image - New Products Height', 'IMAGE_PRODUCT_NEW_HEIGHT', '80', 'Default = 80', 4, 45, now());

DELETE FROM configuration where configuration_key = 'SHOW_CREATE_ACCOUNT_DEFAULT_COUNTRY';
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) VALUES ('Create Account Default Country ID', 'SHOW_CREATE_ACCOUNT_DEFAULT_COUNTRY', '223', 'Set Create Account Default Country ID to:<br />Default is 223', '5', '6', 'zen_get_country_name', 'zen_cfg_pull_down_country_list(', now());