From 3c3b3517c1d806c1602d09b216348954f17a8750 Mon Sep 17 00:00:00 2001 From: thomascube 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') 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