aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/develop/create_schema_files.php
diff options
context:
space:
mode:
authorAndreas Fischer <bantu@phpbb.com>2010-01-28 23:15:25 +0000
committerAndreas Fischer <bantu@phpbb.com>2010-01-28 23:15:25 +0000
commit2906a24122535856f5a195264dc1d9a6836e0bcd (patch)
tree708b62bbacdc62a53cfce34c6909be3e39ae77b3 /phpBB/develop/create_schema_files.php
parentc0cd713f4ca58d064edb70e3c2cb6d1ab6a1b042 (diff)
downloadforums-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/create_schema_files.php')
-rw-r--r--phpBB/develop/create_schema_files.php1
1 files changed, 1 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'),
),
);