Subversion Repositories Applications.papyrus

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
831 florian 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
?>