From d6867490abc543da0c8ec7895d3748d1e7e93e63 Mon Sep 17 00:00:00 2001 From: Aleksander Machniak Date: Sat, 13 Sep 2014 12:18:07 +0200 Subject: Index IX_contactgroups_user_id was created on the wrong table --- SQL/mssql.initial.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'SQL') 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 -- cgit v1.2.3