diff options
| author | Andreas Fischer <bantu@phpbb.com> | 2009-06-08 12:36:26 +0000 |
|---|---|---|
| committer | Andreas Fischer <bantu@phpbb.com> | 2009-06-08 12:36:26 +0000 |
| commit | 9f21f1ab5e2b70da18459ef26c14a2372bc0eb76 (patch) | |
| tree | 601ec121ad656ce614751d41beaadda19773b3d2 /phpBB/develop/mysql_upgrader.php | |
| parent | 27d4c7229d97ba25e5bd303b21f376e14550eba6 (diff) | |
| download | forums-9f21f1ab5e2b70da18459ef26c14a2372bc0eb76.tar forums-9f21f1ab5e2b70da18459ef26c14a2372bc0eb76.tar.gz forums-9f21f1ab5e2b70da18459ef26c14a2372bc0eb76.tar.bz2 forums-9f21f1ab5e2b70da18459ef26c14a2372bc0eb76.tar.xz forums-9f21f1ab5e2b70da18459ef26c14a2372bc0eb76.zip | |
Fix bug #44665 - Add index on log_time to the log table to prevent slowdown on boards with many log entries.
Authorised by: acydburn
git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9564 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/develop/mysql_upgrader.php')
| -rw-r--r-- | phpBB/develop/mysql_upgrader.php | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/phpBB/develop/mysql_upgrader.php b/phpBB/develop/mysql_upgrader.php index 77341500e1..22406d1286 100644 --- a/phpBB/develop/mysql_upgrader.php +++ b/phpBB/develop/mysql_upgrader.php @@ -667,6 +667,7 @@ function get_schema_struct() 'PRIMARY_KEY' => 'log_id', 'KEYS' => array( 'log_type' => array('INDEX', 'log_type'), + 'log_time' => array('INDEX', 'log_time'), 'forum_id' => array('INDEX', 'forum_id'), 'topic_id' => array('INDEX', 'topic_id'), 'reportee_id' => array('INDEX', 'reportee_id'), |