From f63ff72a458957595df2625596875c60924d681f Mon Sep 17 00:00:00 2001
From: Marco Miltenburg <marco@virtualpages.nl>
Date: Fri, 05 Sep 2014 06:17:27 -0400
Subject: [PATCH] Index IX_contactgroups_user_id was created on the wrong table.
---
SQL/mssql.initial.sql | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/SQL/mssql.initial.sql b/SQL/mssql.initial.sql
index 9d0521c..b45db10 100644
--- a/SQL/mssql.initial.sql
+++ b/SQL/mssql.initial.sql
@@ -280,7 +280,7 @@
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
@@ -393,6 +393,6 @@
WHERE [contact_id] IN (SELECT [contact_id] FROM deleted)
GO
-INSERT INTO [dbo].[system] ([name], [value]) VALUES ('roundcube-version', '2013061000')
+INSERT INTO [dbo].[system] ([name], [value]) VALUES ('roundcube-version', '2014042900')
GO
\ No newline at end of file
--
Gitblit v1.9.1