From 48be8f6428ba3be7375b84aea2b73d1c67de6da1 Mon Sep 17 00:00:00 2001
From: alecpl <alec@alec.pl>
Date: Thu, 05 Jan 2012 03:45:22 -0500
Subject: [PATCH] - Fix SQL Error when saving a contact with many email addresses (#1488286)
---
SQL/mssql.upgrade.sql | 7 +++++++
1 files changed, 7 insertions(+), 0 deletions(-)
diff --git a/SQL/mssql.upgrade.sql b/SQL/mssql.upgrade.sql
index b479b16..336d53c 100644
--- a/SQL/mssql.upgrade.sql
+++ b/SQL/mssql.upgrade.sql
@@ -239,6 +239,13 @@
ON DELETE CASCADE ON UPDATE CASCADE
GO
+-- Updates from version 0.7-beta
+
ALTER TABLE [dbo].[session] ALTER COLUMN [sess_id] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL
GO
+-- Updates from version 0.7
+
+ALTER TABLE [dbo].[contacts] ALTER COLUMN [email] [text] COLLATE Latin1_General_CI_AI NOT NULL
+GO
+
--
Gitblit v1.9.1