summaryrefslogtreecommitdiff
path: root/SQL
diff options
context:
space:
mode:
authorthomascube <thomas@roundcube.net>2007-05-17 20:30:15 +0000
committerthomascube <thomas@roundcube.net>2007-05-17 20:30:15 +0000
commit3c3b3517c1d806c1602d09b216348954f17a8750 (patch)
treedec3782d1f9eb6cb22f9aa6daf4cefcfa598e6db /SQL
parent6ae6e41fb32ca544ed29681d18130ba2c9c344fd (diff)
Fix default value problem for MySQL (#1483940)
Diffstat (limited to 'SQL')
-rw-r--r--SQL/mysql5.initial.sql2
1 files changed, 1 insertions, 1 deletions
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`)