[Sommaire] [Imprimer]

   1  <?php
   2  if(!defined("PHORUM_ADMIN")) return;
   3  
   4  $upgrade_queries[]="alter table {$PHORUM['message_table']} drop KEY parent_thread";
   5  $upgrade_queries[]="alter table {$PHORUM['message_table']} drop KEY modifystamp_thread";
   6  $upgrade_queries[]="alter table {$PHORUM['message_table']} drop KEY parent_status_mod";
   7  $upgrade_queries[]="alter table {$PHORUM['message_table']} drop KEY parent_status_thread";
   8  $upgrade_queries[]="alter table {$PHORUM['message_table']} drop KEY message_status_thread";
   9  $upgrade_queries[]="alter table {$PHORUM['message_table']} drop KEY message_status_mod";
  10  $upgrade_queries[]="alter table {$PHORUM['message_table']} drop KEY parent_id";
  11  $upgrade_queries[]="alter table {$PHORUM['message_table']} drop KEY parent_status_forum";
  12    
  13  $upgrade_queries[]="alter table {$PHORUM['message_table']} add KEY list_page_flat (thread,forum_id,status,parent_id,sort)";
  14  $upgrade_queries[]="alter table {$PHORUM['message_table']} add KEY special_threads (sort,forum_id)";
  15  $upgrade_queries[]="alter table {$PHORUM['message_table']} add KEY list_page_float (modifystamp,forum_id,status,parent_id,sort)";
  16  
  17  ?>