diff options
Diffstat (limited to 'phpBB/install/schemas/mssql_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/mssql_schema.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/phpBB/install/schemas/mssql_schema.sql b/phpBB/install/schemas/mssql_schema.sql index e6da562358..8ef4c97c0d 100644 --- a/phpBB/install/schemas/mssql_schema.sql +++ b/phpBB/install/schemas/mssql_schema.sql @@ -1123,6 +1123,9 @@ CREATE TABLE [phpbb_search_wordmatch] ( ) ON [PRIMARY] GO +CREATE UNIQUE INDEX [unique_match] ON [phpbb_search_wordmatch]([word_id], [post_id], [title_match]) ON [PRIMARY] +GO + CREATE INDEX [word_id] ON [phpbb_search_wordmatch]([word_id]) ON [PRIMARY] GO |