Fix operator incompat. in some queries on contacts table using MS SQL Server (#1488505)
| | |
| | | [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] [text] COLLATE Latin1_General_CI_AI NOT NULL ,
|
| | | [email] [varchar] (8000) 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 ,
|
| | |
| | | ALTER TABLE [dbo].[contacts] ALTER COLUMN [email] [text] COLLATE Latin1_General_CI_AI NOT NULL
|
| | | GO
|
| | |
|
| | | -- Updates from version 0.8-rc
|
| | |
|
| | | ALTER TABLE [dbo].[contacts] DROP CONSTRAINT [DF_contacts_email]
|
| | | GO
|
| | | ALTER TABLE [dbo].[contacts] ALTER COLUMN [email] [varchar] (8000) COLLATE Latin1_General_CI_AI NOT NULL
|
| | | GO
|
| | | ALTER TABLE [dbo].[contacts] ADD CONSTRAINT [DF_contacts_email] DEFAULT ('') FOR [email]
|
| | | GO
|
| | |
|