diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2002-02-11 17:21:30 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2002-02-11 17:21:30 +0000 |
| commit | 647ecbe37780edf6910fddb6fa8479cbbda798d6 (patch) | |
| tree | 39333dbae4b75fb58bc7413aa5e7b6a8b695a5b5 | |
| parent | 4c21aea0f31bc847a054fce62d3eb71619b38630 (diff) | |
| download | forums-647ecbe37780edf6910fddb6fa8479cbbda798d6.tar forums-647ecbe37780edf6910fddb6fa8479cbbda798d6.tar.gz forums-647ecbe37780edf6910fddb6fa8479cbbda798d6.tar.bz2 forums-647ecbe37780edf6910fddb6fa8479cbbda798d6.tar.xz forums-647ecbe37780edf6910fddb6fa8479cbbda798d6.zip | |
Altered wordlist table to ignore duplicates on the word_text index
git-svn-id: file:///svn/phpbb/trunk@2090 89ea8834-ac86-4346-8a33-228a782c2dd0
| -rw-r--r-- | phpBB/db/schemas/mssql_schema.sql | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/phpBB/db/schemas/mssql_schema.sql b/phpBB/db/schemas/mssql_schema.sql index 1e76eb855c..cf6df98908 100644 --- a/phpBB/db/schemas/mssql_schema.sql +++ b/phpBB/db/schemas/mssql_schema.sql @@ -622,7 +622,10 @@ GO CREATE INDEX [IX_phpbb_search_results] ON [phpbb_search_results]([session_id]) ON [PRIMARY] GO - CREATE UNIQUE INDEX [IX_phpbb_search_wordlist] ON [phpbb_search_wordlist]([word_text]) ON [PRIMARY] + CREATE UNIQUE INDEX [IX_phpbb_search_wordlist] ON [phpbb_search_wordlist]([word_text]) WITH IGNORE_DUP_KEY ON [PRIMARY] +GO + + CREATE INDEX [IX_phpbb_search_wordlist_1] ON [phpbb_search_wordlist]([word_common]) ON [PRIMARY] GO CREATE INDEX [IX_phpbb_search_wordmatch] ON [phpbb_search_wordmatch]([post_id]) ON [PRIMARY] |