[Sommaire] [Imprimer]

   1  #
   2  # $Id: upgrade_204_to_21rc1.sql,v 1.1.2.1 2007/02/17 04:48:22 ajdonnison Exp $
   3  # 
   4  # DO NOT USE THIS SCRIPT DIRECTLY - USE THE INSTALLER INSTEAD.
   5  #
   6  # All entries must be date stamped in the correct format.
   7  #
   8  
   9  # 20060809
  10  ALTER TABLE `sessions` ADD `session_user` INT DEFAULT '0' NOT NULL AFTER `session_id`;
  11  
  12  # 20061119 
  13  # archived status replaces project (in)active flag:
  14  UPDATE `sysvals` SET `sysval_value` = '0|Not Defined\r\n1|Proposed\r\n2|In Planning\r\n3|In Progress\r\n4|On Hold\r\n5|Complete\r\n6|Template\r\n7|Archived' WHERE `sysval_title` = 'ProjectStatus' LIMIT 1;
  15  UPDATE `projects` SET `project_status` = 7 WHERE `project_active` = 0;
  16  ALTER TABLE `projects` DROP `project_active`;
  17  
  18  # 20061129
  19  INSERT INTO `sysvals` ( `sysval_id` , `sysval_key_id` , `sysval_title` , `sysval_value` ) VALUES (null, '1', 'ProjectRequiredFields', 'f.project_name.value.length|<3\r\nf.project_color_identifier.value.length|<3\r\nf.project_company.options[f.project_company.selectedIndex].value|<1' );
  20  
  21  # 20070106
  22  # Adding Index to the custom fields value
  23  ALTER TABLE `custom_fields_values` ADD INDEX `idx_cfv_id` ( `value_id` );
  24  
  25  # 20070126
  26  ALTER TABLE `files` ADD `file_folder` INT(11) DEFAULT '0' NOT NULL;
  27  
  28  # 20070126
  29  #
  30  # Table structure for table `file_folders`
  31  #
  32  
  33  DROP TABLE IF EXISTS `file_folders`;
  34  CREATE TABLE `file_folders` (
  35      `file_folder_id` int(11) NOT NULL auto_increment,
  36      `file_folder_parent` int(11) NOT NULL default '0',
  37      `file_folder_name` varchar(255) NOT NULL default '',
  38      `file_folder_description` text,
  39      PRIMARY KEY  (`file_folder_id`)
  40  ) TYPE=MyISAM;
  41  
  42  # 20070210
  43  # Adding the UserType sysval to close issue #1882
  44  INSERT INTO `sysvals` (`sysval_id`, `sysval_key_id`, `sysval_title`, `sysval_value`) VALUES (null, 1, 'UserType', '0|Default User\r\n1|Administrator\r\n2|CEO\r\n3|Director\r\n4|Branch Manager\r\n5|Manager\r\n6|Supervisor\r\n7|Employee');