[phpBB Debug] PHP Warning: in file [ROOT]/includes/crs/crs_misc_functions.php on line 37: mime_content_type(): Empty filename or path
[phpBB Debug] PHP Warning: in file [ROOT]/includes/crs/crs_misc_functions.php on line 37: mime_content_type(): Empty filename or path
Zen Cart 源代码 mysql_upgrade_zencart_126_to_127.sql

Zen Cart 源代码 mysql_upgrade_zencart_126_to_127.sql




下载文件

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

mysql_upgrade_zencart_126_to_127.sql - 关闭高亮
  1. # This SQL script upgrades the core Zen Cart database structure from v1.2.6 to v1.2.7
  2. #
  3. # $Id: mysql_upgrade_zencart_126_to_127.sql 4243 2006-08-24 10:55:28Z drbyte $
  4. #
  5.  
  6.  
  7. ## CONFIGURATION TABLE
  8. 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';
  9. 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';
  10.  
  11.  
  12.  
  13. #############
  14.  
  15. #### VERSION UPDATE COMMANDS
  16. ## 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.
  17. ##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
  18. #NEXT_X_ROWS_AS_ONE_COMMAND:3
  19. INSERT INTO project_version_history (project_version_key, project_version_major, project_version_minor, project_version_patch, project_version_date_applied, project_version_comment)
  20. SELECT project_version_key, project_version_major, project_version_minor, project_version_patch1 as project_version_patch, project_version_date_applied, project_version_comment
  21. FROM project_version;
  22.  
  23. ## Now set to new version
  24. 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';
  25. 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';
  26.  
  27.  
  28. #####  END OF UPGRADE SCRIPT


cron