From ac21b7d47b4c8783a41ba4dbf8d26971c252c6d1 Mon Sep 17 00:00:00 2001 From: Nils Adermann Date: Sun, 4 Mar 2007 16:05:17 +0000 Subject: - added a UNIQUE index on the wordmatch table - some modifications of search indexing which might improve the speed and hopefully fixes [Bug #8352] - added logging to search indexing [Bug #8384] git-svn-id: file:///svn/phpbb/trunk@7119 89ea8834-ac86-4346-8a33-228a782c2dd0 --- phpBB/install/database_update.php | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) (limited to 'phpBB/install/database_update.php') diff --git a/phpBB/install/database_update.php b/phpBB/install/database_update.php index 1427ab69fe..b6b8e1f352 100644 --- a/phpBB/install/database_update.php +++ b/phpBB/install/database_update.php @@ -369,7 +369,10 @@ $database_update_info = array( ), // Add the following unique indexes 'add_unique_index' => array( - USERS_TABLE => array( + SEARCH_WORDMATCH_TABLE => array( + 'unique_match' => array('word_id', 'post_id', 'title_match'), + ), + USERS_TABLE => array( 'username_clean' => array('username_clean'), ), ), -- cgit v1.2.1