From 9720fb85a152dc60efd14b1894ac57a45d9f1ce1 Mon Sep 17 00:00:00 2001
From: Jan Schneider <jan@horde.org>
Date: Sat, 7 Nov 2009 14:13:06 +0100
Subject: [PATCH] MFB: Fix syntax (Bug #8664).

---
 turba/docs/CHANGES                | 1 +
 turba/scripts/sql/turba.mssql.sql | 6 +++---
 2 files changed, 4 insertions(+), 3 deletions(-)

diff --git a/turba/docs/CHANGES b/turba/docs/CHANGES
index 5a2ee06b3..962a589a6 100644
--- a/turba/docs/CHANGES
+++ b/turba/docs/CHANGES
@@ -10,6 +10,7 @@ v3.0-git
 v2.3.3-cvs
 ----------
 
+[jan] Fix syntax of MSSQL scripts (Bug #8664).
 [jan] Add preference for the name format to use for sorting (Request #6721).
 [jan] Condense whitespace in composite fields (Request #8654).
 [jan] Add and fix Oracle-specific SQL scripts.
diff --git a/turba/scripts/sql/turba.mssql.sql b/turba/scripts/sql/turba.mssql.sql
index 604216471..357197b5d 100644
--- a/turba/scripts/sql/turba.mssql.sql
+++ b/turba/scripts/sql/turba.mssql.sql
@@ -3,14 +3,14 @@ CREATE TABLE turba_objects (
     owner_id VARCHAR(255) NOT NULL,
     object_type VARCHAR(255) DEFAULT 'Object' NOT NULL,
     object_uid VARCHAR(255),
-    object_members BLOB,
+    object_members IMAGE,
     object_firstname VARCHAR(255),
     object_lastname VARCHAR(255),
     object_middlenames VARCHAR(255),
     object_nameprefix VARCHAR(32),
     object_namesuffix VARCHAR(32),
     object_alias VARCHAR(32),
-    object_photo BLOB,
+    object_photo IMAGE,
     object_phototype VARCHAR(10),
     object_bday VARCHAR(10),
     object_homestreet VARCHAR(255),
@@ -35,7 +35,7 @@ CREATE TABLE turba_objects (
     object_pager VARCHAR(25),
     object_title VARCHAR(255),
     object_role VARCHAR(255),
-    object_logo BLOB,
+    object_logo IMAGE,
     object_logotype VARCHAR(10),
     object_company VARCHAR(255),
     object_category VARCHAR(80),
-- 
2.11.0