summaryrefslogtreecommitdiff
path: root/SQL/mssql.initial.sql
diff options
context:
space:
mode:
authorMarco Miltenburg <marco@virtualpages.nl>2014-09-05 12:17:27 +0200
committerMarco Miltenburg <marco@virtualpages.nl>2014-09-05 12:17:27 +0200
commitf63ff72a458957595df2625596875c60924d681f (patch)
tree8710630fea472fa97dc57222706a9a43a812cf1c /SQL/mssql.initial.sql
parent030ebec02fb97dedb78cb6ddb10f0edcc77b208a (diff)
Index IX_contactgroups_user_id was created on the wrong table.
Diffstat (limited to 'SQL/mssql.initial.sql')
-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