From 6f096812c9fd460fddd21ff1cef55542cb79a890 Mon Sep 17 00:00:00 2001 From: alecpl 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 --- SQL/mssql.upgrade.sql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'SQL/mssql.upgrade.sql') diff --git a/SQL/mssql.upgrade.sql b/SQL/mssql.upgrade.sql index 6b3cd6d03..cf0c17157 100644 --- a/SQL/mssql.upgrade.sql +++ b/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