#

# * This SQL script upgrades the core Zen Cart database structure from v1.5.1 to v1.5.2

# *

# * @package Installer

# * @access private

# * @copyright Copyright 2003-2013 Zen Cart Development Team

# * @copyright Portions Copyright 2003 osCommerce

# * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0

# * @version GIT: $Id: Author: DrByte  Thu Oct 31 13:50:24 2013 -0400 New in v1.5.2 $

#

 

############ IMPORTANT INSTRUCTIONS ###############

#

# * Zen Cart uses the zc_install/index.php program to do database upgrades

# * This SQL script is intended to be used by running zc_install

# * It is *not* recommended to simply run these statements manually via any other means

# * ie: not via phpMyAdmin or via the Install SQL Patch tool in Zen Cart admin

# * The zc_install program catches possible problems and also handles table-prefixes automatically

# *

# * To use the zc_install program to do your database upgrade:

# * a. Upload the NEWEST zc_install folder to your server

# * b. Surf to zc_install/index.php via your browser

# * c. On the System Inspection page, scroll to the bottom and click on Database Upgrade

# *    NOTE: do NOT click on the "Install" button, because that will erase your database.

# * d. On the Database Upgrade screen, you will be presented with a list of checkboxes for

# *    various Zen Cart versions, with the recommended upgrades already pre-selected.

# * e. Verify the checkboxes, then scroll down and enter your Zen Cart Admin username

# *    and password, and then click on the Upgrade button.

# * f. If any errors occur, you will be notified.  Some warnings can be ignored.

# * g. When done, you will be taken to the Finished page.

#

#####################################################

 

# Set store to Down-For-Maintenance mode.  Must reset manually via admin after upgrade is done.

#UPDATE configuration set configuration_value = 'true' where configuration_key = 'DOWN_FOR_MAINTENANCE';

 

# Clear out active customer sessions

TRUNCATE TABLE whos_online;

TRUNCATE TABLE db_cache;

TRUNCATE TABLE sessions;

 

ALTER TABLE sessions MODIFY COLUMN sesskey varchar(255) NOT NULL default '';

ALTER TABLE whos_online MODIFY COLUMN session_id varchar(255) NOT NULL default '';

 

UPDATE configuration SET configuration_description = '指向 configure.php 文件中 DIR_FS_SQL_CACHE 设定的目录。' WHERE configuration_key = 'SESSION_WRITE_DIRECTORY';

 

UPDATE configuration set configuration_title = '记录页面解析时间', configuration_description = '保存(到文件)解析页面的时间' WHERE configuration_key = 'STORE_PAGE_PARSE_TIME';

UPDATE configuration set configuration_title = '日志路径', configuration_description = '页面解析时间的日志目录和文件名' WHERE configuration_key = 'STORE_PAGE_PARSE_TIME_LOG';

UPDATE configuration set configuration_title = '日志时间格式', configuration_description = '时间格式' WHERE configuration_key = 'STORE_PARSE_DATE_TIME_FORMAT';

UPDATE configuration set configuration_title = '显示页面解析时间', configuration_description = '在每个页面底部显示页面解析时间<br />(说明: 显示解析时间并不要求保存。)' WHERE configuration_key = 'DISPLAY_PAGE_PARSE_TIME';

UPDATE configuration set configuration_title = '保存数据库查询', configuration_description = '保存数据库查询到系统的 /logs/ 目录。注意，这有可能严重影响系统性能并用光硬盘空间。' WHERE configuration_key = 'STORE_DB_TRANSACTIONS';

 

UPDATE configuration set configuration_title = '使用 HTML 邮件?', configuration_description = '是否使用 HTML 格式发送电子邮件' WHERE configuration_key = 'EMAIL_USE_HTML';

UPDATE configuration set configuration_title = '管理员邮件格式', configuration_description = '请选择管理员电子邮件格式' WHERE configuration_key = 'ADMIN_EXTRA_EMAIL_FORMAT';

 

INSERT INTO address_format VALUES (7, '$firstname $lastname$cr$streets$cr$city $state $postcode$cr$country','$city $state / $country');

UPDATE countries set address_format_id = 7 where countries_iso_code_3 = 'AUS';

UPDATE countries set address_format_id = 5 where countries_iso_code_3 in ('BEL', 'NLD', 'SWE');

ALTER TABLE countries ADD status tinyint(1) DEFAULT '1';

 

ALTER TABLE paypal_payment_status_history MODIFY pending_reason varchar(32) default NULL;

 

ALTER TABLE sessions MODIFY sesskey varchar(255) NOT NULL default '';

ALTER TABLE whos_online MODIFY session_id varchar(255) NOT NULL default '';

ALTER TABLE admin_menus MODIFY menu_key VARCHAR(255) NOT NULL DEFAULT '';

ALTER TABLE admin_pages MODIFY page_key VARCHAR(255) NOT NULL DEFAULT '';

ALTER TABLE admin_pages MODIFY main_page VARCHAR(255) NOT NULL DEFAULT '';

ALTER TABLE admin_pages MODIFY page_params VARCHAR(255) NOT NULL DEFAULT '';

ALTER TABLE admin_pages MODIFY menu_key VARCHAR(255) NOT NULL DEFAULT '';

ALTER TABLE admin_profiles MODIFY profile_name VARCHAR(255) NOT NULL DEFAULT '';

ALTER TABLE admin_pages_to_profiles MODIFY page_key varchar(255) NOT NULL default '';

 

UPDATE configuration set configuration_description = '输入以秒为单位的时间。<br />PCI 兼容要求最大不超过 900 。<br /> 默认=900<br />例如: 900= 15 分钟<br /><br />备注: 时间太短会导致添加/编辑商品时超时', use_function = '', set_function = '' where configuration_key = 'SESSION_TIMEOUT_ADMIN';

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('PA-DSS 管理页面 Session 超时设置?', 'PADSS_ADMIN_SESSION_TIMEOUT_ENFORCED', '1', 'PA-DSS 规范要求管理页面在15分钟没有操作时关闭。<strong>禁用后网站不符合 PA-DSS 规范。</strong>', 1, 30, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(\'id\'=>\'0\', \'text\'=>\'Non-Compliant\'), array(\'id\'=>\'1\', \'text\'=>\'On\')),');

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('PA-DSS 高强度密码设置?', 'PADSS_PWD_EXPIRY_ENFORCED', '1', 'PA-DSS 规范要求管理员密码90天必须修改，且不能使用最近4次密码。<strong>禁用后网站不符合 PA-DSS 规范。</strong>', 1, 30, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(\'id\'=>\'0\', \'text\'=>\'Non-Compliant\'), array(\'id\'=>\'1\', \'text\'=>\'On\')),');

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('显示分类的链接状态', 'SHOW_CATEGORY_PRODUCTS_LINKED_STATUS', 'true', '显示分类产品链接状态?', '1', '19', 'zen_cfg_select_option(array(\'true\', \'false\'), ', now());

 

#############

 

#### VERSION UPDATE STATEMENTS

## THE FOLLOWING 2 SECTIONS SHOULD BE THE "LAST" ITEMS IN THE FILE, so that if the upgrade fails prematurely, the version info is not updated.

##The following updates the version HISTORY to store the prior version info (Essentially "moves" the prior version info from the "project_version" to "project_version_history" table

#NEXT_X_ROWS_AS_ONE_COMMAND:3

INSERT INTO project_version_history (project_version_key, project_version_major, project_version_minor, project_version_patch, project_version_date_applied, project_version_comment)

SELECT project_version_key, project_version_major, project_version_minor, project_version_patch1 as project_version_patch, project_version_date_applied, project_version_comment

FROM project_version;

 

## Now set to new version

UPDATE project_version SET project_version_major='1', project_version_minor='5.2', project_version_patch1='', project_version_patch1_source='', project_version_patch2='', project_version_patch2_source='', project_version_comment='Version Update 1.5.1->1.5.2', project_version_date_applied=now() WHERE project_version_key = 'Zen-Cart Main';

UPDATE project_version SET project_version_major='1', project_version_minor='5.2', project_version_patch1='', project_version_patch1_source='', project_version_patch2='', project_version_patch2_source='', project_version_comment='Version Update 1.5.1->1.5.2', project_version_date_applied=now() WHERE project_version_key = 'Zen-Cart Database';

 

#####  END OF UPGRADE SCRIPT