[Sommaire] [Imprimer]

   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