diff options
| author | Marco Miltenburg <marco@virtualpages.nl> | 2014-09-05 12:17:27 +0200 |
|---|---|---|
| committer | Marco Miltenburg <marco@virtualpages.nl> | 2014-09-05 12:17:27 +0200 |
| commit | f63ff72a458957595df2625596875c60924d681f (patch) | |
| tree | 8710630fea472fa97dc57222706a9a43a812cf1c /SQL/mssql.initial.sql | |
| parent | 030ebec02fb97dedb78cb6ddb10f0edcc77b208a (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.sql | 2 |
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
|