| 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 |
?>
|