[Sommaire] [Imprimer]

   1  #
   2  # $Id: upgrade_20beta_to_20.sql,v 1.1 2005/04/01 00:28:38 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  # 20050316
   9  # Remove config elements that are no longer used.
  10  DELETE FROM `config` where `config_name` = 'cal_day_view_show_minical';
  11  DELETE FROM `config` where `config_name` = 'show_all_tasks';
  12  
  13  #
  14  # 20050318
  15  # Change indexes on files module to fix bug 616
  16  ALTER TABLE `files_index` DROP INDEX `idx_wcnt`;
  17  ALTER TABLE `files_index` CHANGE `word_placement` `word_placement` INT( 11 ) DEFAULT '0' NOT NULL;
  18  ALTER TABLE `files_index` DROP PRIMARY KEY;
  19  ALTER TABLE `files_index` ADD PRIMARY KEY( `file_id`, `word`, `word_placement`);
  20  #
  21  
  22  # 20050319
  23  # Remove more configs that are no longer in use
  24  DELETE FROM `config` where `config_name` = 'forum_descendent_order';
  25  #