[Sommaire] [Imprimer]

   1  # $Id: upgrade_101_to_102.sql,v 1.5.12.1 2007/02/17 04:48:22 ajdonnison Exp $
   2  #
   3  # Upgrade dotProject DB Schema
   4  # Version 1.0.1 to release 1.0.2
   5  #
   6  # NOTE: This will NOT upgrade older releases to release 1.0.1
   7  #       You must apply older upgrade script first
   8  #
   9  # !                  W A R N I N G                !
  10  # !BACKUP YOU DATABASE BEFORE APPLYING THIS SCRIPT!
  11  # !                  W A R N I N G                !
  12  #
  13  # 00000000
  14  # add task_departments and contacts to task table
  15  ALTER TABLE `tasks` ADD `task_departments` CHAR( 100 ) ;
  16  ALTER TABLE `tasks` ADD `task_contacts` CHAR( 100 ) ;
  17  
  18  # add contact_department to contacts table
  19  ALTER TABLE `contacts` ADD `contact_department` TINYTEXT AFTER `contact_company` ;
  20  
  21  # add custom info to tasks
  22  ALTER TABLE `tasks` ADD `task_custom` LONGTEXT;
  23  
  24  # custom info on companies
  25  ALTER TABLE `companies` ADD `company_custom` LONGTEXT;
  26  
  27  #
  28  ALTER TABLE `tasks` DROP INDEX `idx_task_owner`;
  29  ALTER TABLE `tasks` ADD INDEX `idx_task_owner` (`task_owner`);
  30  
  31  # IMPORTANT NOTICE #
  32  # This line will reset all dynamic tasks, and is required due to the
  33  # changed nature of dynamic tasks.  Please check the release notices
  34  # for details of the new functionality
  35  
  36  UPDATE `tasks` SET `task_dynamic` = 0 WHERE `task_dynamic` = 1;