diff options
| author | alecpl <alec@alec.pl> | 2010-11-02 09:27:03 +0000 |
|---|---|---|
| committer | alecpl <alec@alec.pl> | 2010-11-02 09:27:03 +0000 |
| commit | 6f096812c9fd460fddd21ff1cef55542cb79a890 (patch) | |
| tree | e69c88fc0b3da2cf8da7e19f3b1e24b230c1d59c /SQL/mssql.upgrade.sql | |
| parent | d3664623169c8db7a83b4049e4d3ef7b8714a923 (diff) | |
- Support contact's email addresses up to 255 characters long (#1487095)
- Added email format checks when saving contacts data
Diffstat (limited to 'SQL/mssql.upgrade.sql')
| -rw-r--r-- | SQL/mssql.upgrade.sql | 4 |
1 files changed, 3 insertions, 1 deletions
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
|