[Sommaire] [Imprimer]

   1  <?php
   2  # Mantis - a php based bugtracking system
   3  
   4  # Copyright (C) 2000 - 2002  Kenzaburo Ito - kenito@300baud.org
   5  # Copyright (C) 2002 - 2007  Mantis Team   - mantisbt-dev@lists.sourceforge.net
   6  
   7  # Mantis is free software: you can redistribute it and/or modify
   8  # it under the terms of the GNU General Public License as published by
   9  # the Free Software Foundation, either version 2 of the License, or
  10  # (at your option) any later version.
  11  #
  12  # Mantis is distributed in the hope that it will be useful,
  13  # but WITHOUT ANY WARRANTY; without even the implied warranty of
  14  # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  15  # GNU General Public License for more details.
  16  #
  17  # You should have received a copy of the GNU General Public License
  18  # along with Mantis.  If not, see <http://www.gnu.org/licenses/>.
  19  
  20      # Changes applied to 0.18 database
  21  
  22      # --------------------------------------------------------
  23      # $Id: 1_00_inc.php,v 1.12.2.1 2007-10-13 22:35:10 giallu Exp $
  24      # --------------------------------------------------------
  25  ?>
  26  <?php
  27      require( dirname( dirname( __FILE__ ) ) . DIRECTORY_SEPARATOR . 'db_table_names_inc.php' );
  28  
  29      $upgrades = array();
  30  
  31      $upgrades[] = new SQLUpgrade(
  32              'config-key1',
  33              'make mantis_config_table keys not null',
  34              "ALTER TABLE $t_config_table CHANGE project_id project_id INT NOT NULL DEFAULT '0'"
  35          );
  36  
  37      $upgrades[] = new SQLUpgrade(
  38              'config-key2',
  39              'make mantis_config_table keys not null',
  40              "ALTER TABLE $t_config_table CHANGE user_id user_id INT NOT NULL DEFAULT '0'"
  41          );
  42  
  43      $upgrades[] = new SQLUpgrade(
  44              'configdb-pk',
  45              'Add mantis_config_table primary key',
  46              "ALTER TABLE $t_config_table
  47                  ADD PRIMARY KEY (config_id, project_id, user_id)"
  48          );
  49  
  50      $upgrades[] = new SQLUpgrade(
  51              'note_bug_id_index',
  52              'Add index on bug_id in bugnotes table',
  53              "ALTER TABLE $t_bugnote_table ADD INDEX ( bug_id )"
  54          );
  55  
  56      $upgrades[] = new SQLUpgrade(
  57              'project_child_index',
  58              'Add index on child_id in project hierarchy table',
  59              "ALTER TABLE $t_project_hierarchy_table ADD INDEX ( child_id )"
  60          );
  61  
  62      $upgrades[] = new SQLUpgrade(
  63              'bug_status_index',
  64              'Add index on status in bug table',
  65              "ALTER TABLE $t_bug_table ADD INDEX ( status )"
  66          );
  67  
  68      $upgrades[] = new SQLUpgrade(
  69              'bug_project_index',
  70              'Add index on project_id in bug table',
  71              "ALTER TABLE $t_bug_table ADD INDEX ( project_id )"
  72          );
  73  
  74      $upgrades[] = new SQLUpgrade(
  75              'note_updated_index',
  76              'Add index on last_modified in bugnotes table',
  77              "ALTER TABLE $t_bugnote_table ADD INDEX ( last_modified )"
  78          );
  79  
  80      $upgrades[] = new SQLUpgrade(
  81              'project_vs_index',
  82              'Add index on view_state in project table',
  83              "ALTER TABLE $t_project_table ADD INDEX ( view_state )"
  84          );
  85  
  86      $upgrades[] = new SQLUpgrade(
  87              'project_uid_index',
  88              'Add index on user_id in project_user table',
  89              "ALTER TABLE $t_project_user_list_table ADD INDEX ( user_id )"
  90          );
  91  
  92      $upgrades[] = new SQLUpgrade(
  93              'user_enabled_index',
  94              'Add index on enabled in user table',
  95              "ALTER TABLE $t_user_table ADD INDEX ( enabled )"
  96          );
  97  
  98      $upgrades[] = new SQLUpgrade(
  99              'user_access_index',
 100              'Add index on access_level in user table',
 101              "ALTER TABLE $t_user_table ADD INDEX ( access_level )"
 102          );
 103          
 104      $upgrades[] = new SQLUpgrade(
 105              'cf_string_bug_index',
 106              'Add index on bug_id in custom_field_string table',
 107              "ALTER TABLE $t_custom_field_string_table ADD INDEX ( bug_id )"
 108          );
 109      
 110      $upgrades[] = new SQLUpgrade(
 111              'pref_new_min',
 112              'change pref email_on_new_minimum_severity for database compabilility',
 113              "ALTER TABLE $t_user_pref_table CHANGE email_on_new_minimum_severity email_on_new_min_severity INT(2) DEFAULT '10' NOT NULL"
 114          );
 115      
 116      $upgrades[] = new SQLUpgrade(
 117              'pref_assigned_min',
 118              'change pref email_on_assigned_minimum_severity for database compabilility',
 119              "ALTER TABLE $t_user_pref_table CHANGE email_on_assigned_minimum_severity email_on_assigned_min_severity INT(2) DEFAULT '10' NOT NULL"
 120          );
 121      
 122      $upgrades[] = new SQLUpgrade(
 123              'pref_feedback_min',
 124              'change pref email_on_feedback_minimum_severity for database compabilility',
 125              "ALTER TABLE $t_user_pref_table CHANGE email_on_status_minimum_severity email_on_status_min_severity INT(2) DEFAULT '10' NOT NULL"
 126          );
 127      
 128      $upgrades[] = new SQLUpgrade(
 129              'pref_status_min',
 130              'change pref email_on_minimum_severity for database compabilility',
 131              "ALTER TABLE $t_user_pref_table CHANGE email_on_feedback_minimum_severity email_on_feedback_min_severity INT(2) DEFAULT '10' NOT NULL"
 132          );
 133      
 134      $upgrades[] = new SQLUpgrade(
 135              'pref_resolved_min',
 136              'change pref email_on_resolved_minimum_severity for database compabilility',
 137              "ALTER TABLE $t_user_pref_table CHANGE email_on_resolved_minimum_severity email_on_resolved_min_severity INT(2) DEFAULT '10' NOT NULL"
 138          );
 139      
 140      $upgrades[] = new SQLUpgrade(
 141              'pref_closed_min',
 142              'change pref email_on_closed_minimum_severity for database compabilility',
 143              "ALTER TABLE $t_user_pref_table CHANGE email_on_closed_minimum_severity email_on_closed_min_severity INT(2) DEFAULT '10' NOT NULL"
 144          );
 145      
 146      $upgrades[] = new SQLUpgrade(
 147              'pref_reopened_min',
 148              'change pref email_on_reopened_minimum_severity for database compabilility',
 149              "ALTER TABLE $t_user_pref_table CHANGE email_on_reopened_minimum_severity email_on_reopened_min_severity INT(2) DEFAULT '10' NOT NULL"
 150          );
 151      
 152      $upgrades[] = new SQLUpgrade(
 153              'pref_bugnote_min',
 154              'change pref email_on_bugnote_minimum_severity for database compabilility',
 155              "ALTER TABLE $t_user_pref_table CHANGE email_on_bugnote_minimum_severity email_on_bugnote_min_severity INT(2) DEFAULT '10' NOT NULL"
 156          );
 157      
 158      $upgrades[] = new SQLUpgrade(
 159              'pref_status_min',
 160              'change pref email_on_status_minimum_severity for database compabilility',
 161              "ALTER TABLE $t_user_pref_table CHANGE email_on_status_minimum_severity email_on_status_min_severity INT(2) DEFAULT '10' NOT NULL"
 162          );
 163      
 164      $upgrades[] = new SQLUpgrade(
 165              'pref_priority_min',
 166              'change pref email_on_priority_minimum_severity for database compabilility',
 167              "ALTER TABLE $t_user_pref_table CHANGE email_on_priority_minimum_severity email_on_priority_min_severity INT(2) DEFAULT '10' NOT NULL"
 168          );
 169      
 170      # this line should be the last upgrade in a version. When it is set, the upgrader
 171      # assumed that all updates in this file have been applied
 172      
 173      # uncomment the following line before the final release when the installer ( schema.php )is 
 174      # sync'd with these incremantal updates
 175      $upgrades[] = new ReleaseUpgrade( '51' );
 176  
 177      $upgrades[] = new SQLUpgrade(
 178              'def_fixed_in_v',
 179              'add default for fixed in version',
 180              "ALTER TABLE $t_bug_table CHANGE fixed_in_version fixed_in_version VARCHAR(64) DEFAULT '' NOT NULL"
 181          );
 182      
 183      return $upgrades;
 184  ?>