Changeset 64584be in github

Timestamp:

Jun 10, 2012 4:15:07 AM (12 months ago)

Author:

Aleksander Machniak <alec@…>

Branches:

release-0.8

Children:

d1f7432

Parents:

2c48c19

git-author:

Aleksander Machniak <alec@…> (06/10/12 04:13:47)

git-committer:

Aleksander Machniak <alec@…> (06/10/12 04:15:07)

Message:

Fix DDL update from 0.7 for MS SQL Server

File:

• SQL/mssql.upgrade.sql (modified) (1 diff)

SQL/mssql.upgrade.sql

@@ -247 +247 @@
 -- Updates from version 0.7
 
+ALTER TABLE [dbo].[contacts] DROP CONSTRAINT [DF_contacts_email]
+GO
 ALTER TABLE [dbo].[contacts] ALTER COLUMN [email] [text] COLLATE Latin1_General_CI_AI NOT NULL
 GO
+ALTER TABLE [dbo].[contacts] ADD CONSTRAINT [DF_contacts_email] DEFAULT ('') FOR [email]
+GO
 
 -- Updates from version 0.8-rc