Imported Upstream version 0.6+dfsg

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

diff --git a/SQL/mssql.upgrade.sql b/SQL/mssql.upgrade.sql
index 4072c25ff34321b79e625a7b400dd38d05f35546..606db60466f71e108e8e13c921b49511493a31c8 100644 (file)
--- a/SQL/mssql.upgrade.sql
+++ b/SQL/mssql.upgrade.sql
@@ -96,4 +96,17 @@ CREATE UNIQUE INDEX [IX_users_username] ON [dbo].[users]([username],[mail_host])
 GO\r
 ALTER TABLE [dbo].[contacts] ALTER COLUMN [email] [varchar] (255) COLLATE Latin1_General_CI_AI NOT NULL\r
 GO\r
-
+\r
+-- Updates from version 0.5.1\r
+-- Updates from version 0.5.2\r
+-- Updates from version 0.5.3\r
+-- Updates from version 0.5.4\r
+\r
+ALTER TABLE [dbo].[contacts] ADD [words] [text] COLLATE Latin1_General_CI_AI NULL \r
+GO\r
+CREATE INDEX [IX_contactgroupmembers_contact_id] ON [dbo].[contactgroupmembers]([contact_id]) ON [PRIMARY]\r
+GO\r
+DELETE FROM [dbo].[messages]\r
+GO\r
+DELETE FROM [dbo].[cache]\r
+GO\r