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/develop/create_schema_files.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/develop/create_schema_files.php')
| -rw-r--r-- | phpBB/develop/create_schema_files.php | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/phpBB/develop/create_schema_files.php b/phpBB/develop/create_schema_files.php index 375ea8588d..cefdf404dd 100644 --- a/phpBB/develop/create_schema_files.php +++ b/phpBB/develop/create_schema_files.php @@ -1144,7 +1144,7 @@ function get_schema_struct() ), 'PRIMARY_KEY' => 'group_id', 'KEYS' => array( - 'group_legend' => array('INDEX', 'group_legend'), + 'group_legend_name' => array('INDEX', array('group_legend', 'group_name')), ), ); @@ -1520,6 +1520,7 @@ function get_schema_struct() 'COLUMNS' => array( 'session_id' => array('CHAR:32', ''), 'session_user_id' => array('UINT', 0), + 'session_forum_id' => array('UINT', 0), 'session_last_visit' => array('TIMESTAMP', 0), 'session_start' => array('TIMESTAMP', 0), 'session_time' => array('TIMESTAMP', 0), @@ -1535,6 +1536,7 @@ function get_schema_struct() 'KEYS' => array( 'session_time' => array('INDEX', 'session_time'), 'session_user_id' => array('INDEX', 'session_user_id'), + 'session_forum_id' => array('INDEX', 'session_forum_id'), ), ); |