summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAleksander Machniak <alec@alec.pl>2014-09-13 12:18:07 +0200
committerAleksander Machniak <alec@alec.pl>2014-09-13 12:18:07 +0200
commitd6867490abc543da0c8ec7895d3748d1e7e93e63 (patch)
treee3b8f7701ea373fd5ab8abd2c9198304f5c5daea
parent728e6ffb6928f3e69d38757e68bc5cb1a0aebc74 (diff)
Index IX_contactgroups_user_id was created on the wrong table
-rw-r--r--SQL/mssql.initial.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/SQL/mssql.initial.sql b/SQL/mssql.initial.sql
index a6132b15c..b45db10b4 100644
--- a/SQL/mssql.initial.sql
+++ b/SQL/mssql.initial.sql
@@ -280,7 +280,7 @@ ALTER TABLE [dbo].[contactgroups] ADD
CONSTRAINT [CK_contactgroups_del] CHECK ([del] = '1' or [del] = '0')
GO
-CREATE INDEX [IX_contactgroups_user_id] ON [dbo].[contacts]([user_id]) ON [PRIMARY]
+CREATE INDEX [IX_contactgroups_user_id] ON [dbo].[contactgroups]([user_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[contactgroupmembers] ADD