From 00290a603237e719cc4ec3db65e6661ba7d46a51 Mon Sep 17 00:00:00 2001
From: alecpl <alec@alec.pl>
Date: Tue, 09 Nov 2010 02:54:34 -0500
Subject: [PATCH] - Add support for shared folders (#1403507)
---
SQL/mssql.upgrade.sql | 13 +++++++++++--
1 files changed, 11 insertions(+), 2 deletions(-)
diff --git a/SQL/mssql.upgrade.sql b/SQL/mssql.upgrade.sql
index ef29a39..cf0c171 100644
--- a/SQL/mssql.upgrade.sql
+++ b/SQL/mssql.upgrade.sql
@@ -1,4 +1,4 @@
--- RoundCube Webmail update script for MSSQL databases
+-- Roundcube Webmail update script for MSSQL databases
-- Updates from version 0.3.1
@@ -22,7 +22,7 @@
ON DELETE CASCADE ON UPDATE CASCADE
GO
-ALTER TABLE [dbo].[identities] add [changed] [datetime] NULL
+ALTER TABLE [dbo].[identities] ADD [changed] [datetime] NULL
GO
CREATE TABLE [dbo].[contactgroups] (
@@ -87,3 +87,12 @@
ON DELETE CASCADE ON UPDATE CASCADE
GO
+-- Updates from version 0.4.2
+
+DROP INDEX [IX_users_username]
+GO
+CREATE UNIQUE INDEX [IX_users_username] ON [dbo].[users]([username],[mail_host]) ON [PRIMARY]
+GO
+ALTER TABLE [dbo].[contacts] ALTER COLUMN [email] [varchar] (255) COLLATE Latin1_General_CI_AI NOT NULL
+GO
+
--
Gitblit v1.9.1