diff options
| author | Joas Schilling <nickvergessen@gmx.de> | 2009-08-05 15:28:46 +0000 |
|---|---|---|
| committer | Joas Schilling <nickvergessen@gmx.de> | 2009-08-05 15:28:46 +0000 |
| commit | ee65d2147b7e672c6dfdcd695f0b6314c40e42d2 (patch) | |
| tree | d089603d67b4225bafa5f11db59bdd9a99a850ca /phpBB/install/schemas/mssql_schema.sql | |
| parent | d0e9e4189ce83390beeb58acefee05bff2e6b167 (diff) | |
| download | forums-ee65d2147b7e672c6dfdcd695f0b6314c40e42d2.tar forums-ee65d2147b7e672c6dfdcd695f0b6314c40e42d2.tar.gz forums-ee65d2147b7e672c6dfdcd695f0b6314c40e42d2.tar.bz2 forums-ee65d2147b7e672c6dfdcd695f0b6314c40e42d2.tar.xz forums-ee65d2147b7e672c6dfdcd695f0b6314c40e42d2.zip | |
fix r9713 for #36565
Authorised by: AcydBurn
git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9931 89ea8834-ac86-4346-8a33-228a782c2dd0
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 b6f85c907e..3c96299571 100644 --- a/phpBB/install/schemas/mssql_schema.sql +++ b/phpBB/install/schemas/mssql_schema.sql @@ -803,6 +803,9 @@ GO CREATE INDEX [post_approved] ON [phpbb_posts]([post_approved]) ON [PRIMARY] GO +CREATE INDEX [post_username] ON [phpbb_posts]([post_username]) ON [PRIMARY] +GO + CREATE INDEX [tid_post_time] ON [phpbb_posts]([topic_id], [post_time]) ON [PRIMARY] GO |