diff options
| author | Nils Adermann <naderman@naderman.de> | 2007-03-04 16:05:17 +0000 |
|---|---|---|
| committer | Nils Adermann <naderman@naderman.de> | 2007-03-04 16:05:17 +0000 |
| commit | ac21b7d47b4c8783a41ba4dbf8d26971c252c6d1 (patch) | |
| tree | 8110ad6a167a84c7c6d0a849ec9fa645ed5b1178 /phpBB/develop | |
| parent | 567b01302b735c03e596be1b1b7d01261084c62b (diff) | |
| download | forums-ac21b7d47b4c8783a41ba4dbf8d26971c252c6d1.tar forums-ac21b7d47b4c8783a41ba4dbf8d26971c252c6d1.tar.gz forums-ac21b7d47b4c8783a41ba4dbf8d26971c252c6d1.tar.bz2 forums-ac21b7d47b4c8783a41ba4dbf8d26971c252c6d1.tar.xz forums-ac21b7d47b4c8783a41ba4dbf8d26971c252c6d1.zip | |
- 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
Diffstat (limited to 'phpBB/develop')
| -rw-r--r-- | phpBB/develop/create_schema_files.php | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/phpBB/develop/create_schema_files.php b/phpBB/develop/create_schema_files.php index eede9a2bd1..264b722d8a 100644 --- a/phpBB/develop/create_schema_files.php +++ b/phpBB/develop/create_schema_files.php @@ -1474,6 +1474,7 @@ function get_schema_struct() 'title_match' => array('BOOL', 0), ), 'KEYS' => array( + 'unique_match' => array('UNIQUE', array('word_id', 'post_id', 'title_match')), 'word_id' => array('INDEX', 'word_id'), 'post_id' => array('INDEX', 'post_id'), ), |