From 3c3b3517c1d806c1602d09b216348954f17a8750 Mon Sep 17 00:00:00 2001
From: thomascube <thomas@roundcube.net>
Date: Thu, 17 May 2007 20:30:15 +0000
Subject: Fix default value problem for MySQL (#1483940)

---
 SQL/mysql5.initial.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'SQL/mysql5.initial.sql')

diff --git a/SQL/mysql5.initial.sql b/SQL/mysql5.initial.sql
index fbca3dcac..0c0dcb199 100644
--- a/SQL/mysql5.initial.sql
+++ b/SQL/mysql5.initial.sql
@@ -91,7 +91,7 @@ CREATE TABLE `contacts` (
  `email` varchar(128) NOT NULL,
  `firstname` varchar(128) NOT NULL,
  `surname` varchar(128) NOT NULL,
- `vcard` text NOT NULL,
+ `vcard` text NULL,
  `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`contact_id`),
  CONSTRAINT `user_id_fk_contacts` FOREIGN KEY (`user_id`)
-- 
cgit v1.2.3

