From 2906a24122535856f5a195264dc1d9a6836e0bcd Mon Sep 17 00:00:00 2001 From: Andreas Fischer Date: Thu, 28 Jan 2010 23:15:25 +0000 Subject: 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 --- phpBB/develop/create_schema_files.php | 1 + 1 file changed, 1 insertion(+) (limited to 'phpBB/develop/create_schema_files.php') 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'), ), ); -- cgit v1.2.1