diff options
| author | Aleksander Machniak <alec@alec.pl> | 2014-09-13 12:15:01 +0200 |
|---|---|---|
| committer | Aleksander Machniak <alec@alec.pl> | 2014-09-13 12:15:01 +0200 |
| commit | 050b482b38ce3c2147af976ba6d5b229539c6558 (patch) | |
| tree | b111f0c937a7e85dcab517ce44ecfaacaca981de | |
| parent | 0fb7a485a36fb7ee1865abb13818bfab4bb3f0f8 (diff) | |
| parent | f63ff72a458957595df2625596875c60924d681f (diff) | |
Merge pull request #216 from MarcoMiltenburg/20140905-index-on-contactgroups
Index IX_contactgroups_user_id was created on the wrong table.
| -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
|