From 847060fb5a85af8581910c694965c136c677a621 Mon Sep 17 00:00:00 2001 From: alec Date: Tue, 2 Nov 2010 09:27:03 +0000 Subject: - Support contact's email addresses up to 255 characters long (#1487095) - Added email format checks when saving contacts data git-svn-id: https://svn.roundcube.net/trunk@4166 208e9e7b-5314-0410-a742-e7e81cd9613c --- roundcubemail/SQL/mssql.upgrade.sql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'roundcubemail/SQL/mssql.upgrade.sql') diff --git a/roundcubemail/SQL/mssql.upgrade.sql b/roundcubemail/SQL/mssql.upgrade.sql index 6b3cd6d03..cf0c17157 100644 --- a/roundcubemail/SQL/mssql.upgrade.sql +++ b/roundcubemail/SQL/mssql.upgrade.sql @@ -22,7 +22,7 @@ ALTER TABLE [dbo].[identities] ADD CONSTRAINT [FK_identities_user_id] 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] ( @@ -93,4 +93,6 @@ 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 -- cgit v1.2.3