diff options
| author | alec <alec@208e9e7b-5314-0410-a742-e7e81cd9613c> | 2010-11-02 09:27:03 +0000 |
|---|---|---|
| committer | alec <alec@208e9e7b-5314-0410-a742-e7e81cd9613c> | 2010-11-02 09:27:03 +0000 |
| commit | 847060fb5a85af8581910c694965c136c677a621 (patch) | |
| tree | a07da67665c26842029e1f9b59b7fbadc963fdf6 /roundcubemail/SQL/mssql.upgrade.sql | |
| parent | a9b4a030d159738f59e1d782dbf0d17b1a90115f (diff) | |
- 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
Diffstat (limited to 'roundcubemail/SQL/mssql.upgrade.sql')
| -rw-r--r-- | roundcubemail/SQL/mssql.upgrade.sql | 4 |
1 files changed, 3 insertions, 1 deletions
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
|