diff options
| author | Henry Sudhof <kellanved@phpbb.com> | 2008-03-17 16:25:07 +0000 |
|---|---|---|
| committer | Henry Sudhof <kellanved@phpbb.com> | 2008-03-17 16:25:07 +0000 |
| commit | b7ef95ed091580df66da23fc1bca403758645fc3 (patch) | |
| tree | 131cd972531444dbaac86c334e290d08a36c4b8d /phpBB/install/database_update.php | |
| parent | 217dc8e6d53beb62e6aa5ccaed68b86a9282d88e (diff) | |
| download | forums-b7ef95ed091580df66da23fc1bca403758645fc3.tar forums-b7ef95ed091580df66da23fc1bca403758645fc3.tar.gz forums-b7ef95ed091580df66da23fc1bca403758645fc3.tar.bz2 forums-b7ef95ed091580df66da23fc1bca403758645fc3.tar.xz forums-b7ef95ed091580df66da23fc1bca403758645fc3.zip | |
This should get rid of the filesorts and temp tables on index (with topic read tracking as exception).
Updater still needs testing. Not yet merged to 3.1
#22715 - thanks HoL
git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@8436 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install/database_update.php')
| -rw-r--r-- | phpBB/install/database_update.php | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/phpBB/install/database_update.php b/phpBB/install/database_update.php index 85627b9327..39e0d8131e 100644 --- a/phpBB/install/database_update.php +++ b/phpBB/install/database_update.php @@ -480,6 +480,20 @@ $database_update_info = array( FORUMS_TABLE => array( 'display_subforum_list' => array('BOOL', 1), ), + SESSIONS_TABLE => array( + 'session_forum_id' => array('UINT', 0), + ), + ), + 'add_index' => array( + SESSIONS_TABLE => array( + 'session_forum_id' => 'session_forum_id', + ), + GROUP_TABLE => array( + 'group_legend_name' => array('group_legend', 'group_name'), + ), + ), + 'drop_keys' => array( + GROUP_TABLE => array('group_legend'), ), ), ); |