Imported Upstream version 0.6+dfsg

[roundcube.git] / SQL / mssql.initial.sql

diff --git a/SQL/mssql.initial.sql b/SQL/mssql.initial.sql
index 823d1b3aeead181cfa63ac92e4f72bae09e903ce..4aa6fc9f7516112bc5fb5e08184ff786321276cf 100644 (file)
--- a/SQL/mssql.initial.sql
+++ b/SQL/mssql.initial.sql
@@ -16,7 +16,8 @@ CREATE TABLE [dbo].[contacts] (
        [email] [varchar] (255) COLLATE Latin1_General_CI_AI NOT NULL ,\r
        [firstname] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL ,\r
        [surname] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL ,\r
-       [vcard] [text] COLLATE Latin1_General_CI_AI NULL \r
+       [vcard] [text] COLLATE Latin1_General_CI_AI NULL ,\r
+       [words] [text] COLLATE Latin1_General_CI_AI NULL \r
 ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]\r
 GO\r
 \r
@@ -194,6 +195,8 @@ ALTER TABLE [dbo].[contactgroupmembers] ADD
        CONSTRAINT [DF_contactgroupmembers_created] DEFAULT (getdate()) FOR [created]\r
 GO\r
 \r
+CREATE  INDEX [IX_contactgroupmembers_contact_id] ON [dbo].[contactgroupmembers]([contact_id]) ON [PRIMARY]\r
+GO\r
 \r
 ALTER TABLE [dbo].[identities] ADD \r
        CONSTRAINT [DF_identities_user] DEFAULT ('0') FOR [user_id],\r