diff options
| author | Andreas Fischer <bantu@phpbb.com> | 2010-01-28 23:15:25 +0000 |
|---|---|---|
| committer | Andreas Fischer <bantu@phpbb.com> | 2010-01-28 23:15:25 +0000 |
| commit | 2906a24122535856f5a195264dc1d9a6836e0bcd (patch) | |
| tree | 708b62bbacdc62a53cfce34c6909be3e39ae77b3 /phpBB/develop | |
| parent | c0cd713f4ca58d064edb70e3c2cb6d1ab6a1b042 (diff) | |
| download | forums-2906a24122535856f5a195264dc1d9a6836e0bcd.tar forums-2906a24122535856f5a195264dc1d9a6836e0bcd.tar.gz forums-2906a24122535856f5a195264dc1d9a6836e0bcd.tar.bz2 forums-2906a24122535856f5a195264dc1d9a6836e0bcd.tar.xz forums-2906a24122535856f5a195264dc1d9a6836e0bcd.zip | |
Bug #56545 - Speed up topic move operation by adding an index for topic_id on the topics track table.
git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@10462 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/develop')
| -rw-r--r-- | phpBB/develop/create_schema_files.php | 1 | ||||
| -rw-r--r-- | phpBB/develop/mysql_upgrader.php | 1 |
2 files changed, 2 insertions, 0 deletions
diff --git a/phpBB/develop/create_schema_files.php b/phpBB/develop/create_schema_files.php index a612a318a7..03932bcc13 100644 --- a/phpBB/develop/create_schema_files.php +++ b/phpBB/develop/create_schema_files.php @@ -1746,6 +1746,7 @@ function get_schema_struct() ), 'PRIMARY_KEY' => array('user_id', 'topic_id'), 'KEYS' => array( + 'topic_id' => array('INDEX', 'topic_id'), 'forum_id' => array('INDEX', 'forum_id'), ), ); diff --git a/phpBB/develop/mysql_upgrader.php b/phpBB/develop/mysql_upgrader.php index ae29b536bc..57230339e8 100644 --- a/phpBB/develop/mysql_upgrader.php +++ b/phpBB/develop/mysql_upgrader.php @@ -1236,6 +1236,7 @@ function get_schema_struct() ), 'PRIMARY_KEY' => array('user_id', 'topic_id'), 'KEYS' => array( + 'topic_id' => array('INDEX', 'topic_id'), 'forum_id' => array('INDEX', 'forum_id'), ), ); |