[Sommaire] [Imprimer]

   1  #

   2  # * This SQL script upgrades the core Zen Cart database structure from v1.3.0.1 to v1.3.0.2

   3  # *

   4  # * @package Installer

   5  # * @access private

   6  # * @copyright Copyright 2003-2006 Zen Cart Development Team

   7  # * @copyright Portions Copyright 2003 osCommerce

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

   9  # * @version $Id: mysql_upgrade_zencart_1301_to_1302.sql 6536 2007-06-26 01:10:18Z drbyte $

  10  #

  11  
  12  ## CONFIGURATION TABLE

  13  #inserts for those who did an upgrade from 1.2.x to 1.3.0 and thus didn't get the insert:

  14  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 ('Upload prefix', 'UPLOAD_PREFIX', 'upload_', 'Prefix used to differentiate between upload options and other options', 0, NULL, now(), now(), NULL, NULL);
  15  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 ('Text prefix', 'TEXT_PREFIX', 'txt_', 'Prefix used to differentiate between text option values and other option values', 0, NULL, now(), now(), NULL, NULL);
  16  INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) VALUES ('Meta Tags Generated Description Maximum Length?', 'MAX_META_TAG_DESCRIPTION_LENGTH', '50', 'Set Generated Meta Tag Description Maximum Length to (words) Default 50:', '18', '71', '', '', now());
  17  #tidy sort order for consistency between upgrades and fresh installs

  18  UPDATE configuration SET sort_order=115 WHERE configuration_key = 'SHOW_ACCOUNT_LINKS_ON_SITE_MAP';
  19  
  20  #table alterations fixed in 1.3.5 but best completed here also for upgraders:

  21  ALTER TABLE query_builder CHANGE COLUMN query_category query_category varchar(40) NOT NULL default '';
  22  ALTER TABLE query_builder CHANGE COLUMN query_name query_name varchar(80) NOT NULL default '';
  23  ALTER TABLE query_builder CHANGE COLUMN query_description query_description TEXT NOT NULL;
  24  ALTER TABLE query_builder CHANGE COLUMN query_string query_string TEXT NOT NULL;
  25  ALTER TABLE query_builder CHANGE COLUMN query_keys_list query_keys_list TEXT NOT NULL;
  26  
  27  
  28  # add ability to send newsletters to self

  29  REPLACE INTO query_builder ( query_category , query_name , query_description , query_string, query_keys_list) VALUES ('email,newsletters', 'Administrator', 'Just the email account of the current administrator', 'select \'ADMIN\' as customers_firstname, admin_name as customers_lastname, admin_email as customers_email_address from TABLE_ADMIN where admin_id = $SESSION:admin_id', '');
  30  
  31  INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('State - Always display as pulldown?', 'ACCOUNT_STATE_DRAW_INITIAL_DROPDOWN', 'false', 'When state field is displayed, should it always be a pulldown menu?', 5, '5', 'zen_cfg_select_option(array(\'true\', \'false\'), ', now());
  32  
  33  
  34  
  35  #############

  36  
  37  #### VERSION UPDATE COMMANDS

  38  ## 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.

  39  ##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

  40  #NEXT_X_ROWS_AS_ONE_COMMAND:3

  41  INSERT INTO project_version_history (project_version_key, project_version_major, project_version_minor, project_version_patch, project_version_date_applied, project_version_comment)
  42  SELECT project_version_key, project_version_major, project_version_minor, project_version_patch1 as project_version_patch, project_version_date_applied, project_version_comment
  43  FROM project_version;
  44  
  45  ## Now set to new version

  46  UPDATE project_version SET project_version_major='1', project_version_minor='3.0.2', project_version_patch1='', project_version_patch1_source='', project_version_patch2='', project_version_patch2_source='', project_version_comment='Version Update 1.3.0.1->1.3.0.2', project_version_date_applied=now() WHERE project_version_key = 'Zen-Cart Main';
  47  UPDATE project_version SET project_version_major='1', project_version_minor='3.0.2', project_version_patch1='', project_version_patch1_source='', project_version_patch2='', project_version_patch2_source='', project_version_comment='Version Update 1.3.0.1->1.3.0.2', project_version_date_applied=now() WHERE project_version_key = 'Zen-Cart Database';
  48  
  49  
  50  #####  END OF UPGRADE SCRIPT

  51