[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: 0_19_inc.php,v 1.14.16.1 2007-10-13 22:35:09 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              'bugnote-type',
  33              'Add note type column to bugnote',
  34              "ALTER TABLE $t_bugnote_table ADD note_type INT(7) default '0'" );
  35  
  36      $upgrades[] = new SQLUpgrade(
  37              'bugnote-attr',
  38              'Add note_attr column to bugnote',
  39              "ALTER TABLE $t_bugnote_table ADD note_attr VARCHAR(250) default ''" );
  40  
  41      $upgrades[] = new SQLUpgrade(
  42              'tokensdb-1',
  43              'Add mantis_tokens_table',
  44              "CREATE TABLE $t_tokens_table (
  45                id int NOT NULL auto_increment,
  46                owner int NOT NULL,
  47                type int NOT NULL,
  48                timestamp datetime NOT NULL,
  49                expiry datetime NOT NULL,
  50                value text NOT NULL,
  51                PRIMARY KEY (id))"
  52          );
  53  
  54      $upgrades[] = new SQLUpgrade(
  55              'sticky-issues',
  56              'Add sticky column to bug table',
  57              "ALTER TABLE $t_bug_table ADD sticky TINYINT(1) default '0' NOT NULL" );
  58  
  59      $upgrades[] = new SQLUpgrade(
  60              'project-hierarchy',
  61              'Add project hierarchy table',
  62              "CREATE TABLE $t_project_hierarchy_table (
  63                child_id  INT UNSIGNED NOT NULL,
  64                parent_id INT UNSIGNED NOT NULL)"
  65              );
  66  
  67      $upgrades[] = new SQLUpgrade(
  68              'configdb-1',
  69              'Add mantis_config_table',
  70              "CREATE TABLE $t_config_table (
  71                config_id VARCHAR(64) NOT NULL,
  72                project_id INT DEFAULT 0,
  73                user_id INT DEFAULT 0,
  74                access INT DEFAULT 0,
  75                type INT DEFAULT 90,
  76                value text NOT NULL,
  77                INDEX (config_id),
  78                UNIQUE config ( config_id, project_id, user_id ) )"
  79          );
  80  
  81      $upgrades[] = new SQLUpgrade(
  82              'field_shorten-1',
  83              'shorten field names: lost_password_in_progress_count',
  84              "ALTER TABLE $t_user_table CHANGE lost_password_in_progress_count lost_password_request_count INT(2) DEFAULT '0' NOT NULL"
  85          );
  86  
  87      $upgrades[] = new SQLUpgrade(
  88              'field_naming-1',
  89              'DBMS compatibility: access is a reserved word',
  90              "ALTER TABLE $t_config_table CHANGE access access_reqd INT DEFAULT '0'"
  91          );
  92  
  93      $upgrades[] = new SQLUpgrade(
  94              'configdb-un',
  95              'Drop mantis_config_table unique key',
  96              "ALTER TABLE $t_config_table 
  97                  DROP INDEX config"
  98          );
  99  
 100      return $upgrades;
 101  ?>