/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004071500.php |
---|
New file |
0,0 → 1,8 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
// altering the message-table with an index for unapproved messages |
$upgrade_queries[]="ALTER TABLE {$PHORUM['forums_table']} CHANGE list_length list_length_flat INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL"; |
$upgrade_queries[]="ALTER TABLE {$PHORUM['forums_table']} ADD list_length_threaded INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL AFTER `list_length_flat` "; |
$upgrade_queries[]="UPDATE {$PHORUM['forums_table']} SET list_length_threaded = list_length_flat/2 "; |
?> |