From 6f096812c9fd460fddd21ff1cef55542cb79a890 Mon Sep 17 00:00:00 2001 From: alecpl <alec@alec.pl> Date: Tue, 02 Nov 2010 05:27:03 -0400 Subject: [PATCH] - Support contact's email addresses up to 255 characters long (#1487095) - Added email format checks when saving contacts data --- SQL/mssql.initial.sql | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) diff --git a/SQL/mssql.initial.sql b/SQL/mssql.initial.sql index 553e68a..3678858 100644 --- a/SQL/mssql.initial.sql +++ b/SQL/mssql.initial.sql @@ -13,7 +13,7 @@ [changed] [datetime] NOT NULL , [del] [char] (1) COLLATE Latin1_General_CI_AI NOT NULL , [name] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL , - [email] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL , + [email] [varchar] (255) COLLATE Latin1_General_CI_AI NOT NULL , [firstname] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL , [surname] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL , [vcard] [text] COLLATE Latin1_General_CI_AI NULL @@ -255,7 +255,7 @@ CONSTRAINT [DF_users_created] DEFAULT (getdate()) FOR [created] GO -CREATE INDEX [IX_users_username] ON [dbo].[users]([username]) ON [PRIMARY] +CREATE UNIQUE INDEX [IX_users_username] ON [dbo].[users]([username],[mail_host]) ON [PRIMARY] GO CREATE INDEX [IX_users_alias] ON [dbo].[users]([alias]) ON [PRIMARY] -- Gitblit v1.9.1