Zen Cart 源代码 mysql_upgrade_zencart_126_to

Zen Cart 源代码 mysql_upgrade_zencart_126_to_127.sql

下载文件

文件名: mysql_upgrade_zencart_126_to_127.sql
文件类型: Unknown文件
文件大小: 2.24 KiB
MD5: ae0a8213e316120bdd4ca0fcca9dbaf8

mysql_upgrade_zencart_126_to_127.sql - 打开高亮: # This SQL script upgrades the core Zen Cart database structure from v1.2.6 to v1.2.7 # # $Id: mysql_upgrade_zencart_126_to_127.sql 4243 2006-08-24 10:55:28Z drbyte $ # ## CONFIGURATION TABLE UPDATE configuration SET configuration_description = 'Shopping Cart Shows<br />0= Always<br />1= Only when full<br />2= Only when full but not when viewing the Shopping Cart' where configuration_key = 'SHOW_SHOPPING_CART_BOX_STATUS'; UPDATE configuration SET configuration_description = 'Automatically check to see if a new version of Zen Cart is available. Enabling this can sometimes slow down the loading of Admin pages. (Displayed on main Index page after login, and Server Info page.)' where configuration_key = 'SHOW_VERSION_UPDATE_IN_HEADER'; ############# #### VERSION UPDATE COMMANDS ## 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's 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='2.7', project_version_patch1='', project_version_patch1_source='', project_version_patch2='', project_version_patch2_source='', project_version_comment='Version Update 1.2.6->1.2.7', project_version_date_applied=now() WHERE project_version_key = 'Zen-Cart Main'; UPDATE project_version SET project_version_major='1', project_version_minor='2.7', project_version_patch1='', project_version_patch1_source='', project_version_patch2='', project_version_patch2_source='', project_version_comment='Version Update 1.2.6->1.2.7', project_version_date_applied=now() WHERE project_version_key = 'Zen-Cart Database'; ##### END OF UPGRADE SCRIPT