From d9339daa138f0bb552208a8dba3ab7f245b3424f Mon Sep 17 00:00:00 2001
From: thomasb <thomasb@208e9e7b-5314-0410-a742-e7e81cd9613c>
Date: Thu, 17 May 2007 20:30:15 +0000
Subject: Fix default value problem for MySQL (#1483940)

git-svn-id: https://svn.roundcube.net/trunk@572 208e9e7b-5314-0410-a742-e7e81cd9613c
---
 roundcubemail/SQL/mysql5.initial.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

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

diff --git a/roundcubemail/SQL/mysql5.initial.sql b/roundcubemail/SQL/mysql5.initial.sql
index fbca3dcac..0c0dcb199 100644
--- a/roundcubemail/SQL/mysql5.initial.sql
+++ b/roundcubemail/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

