From 6b79f7b57a51141dbef44011cdf0ebacf5f74c8c Mon Sep 17 00:00:00 2001 From: thomascube <thomas@roundcube.net> Date: Wed, 26 Sep 2007 11:13:22 -0400 Subject: [PATCH] Set default IMAP folder delimiter; make sure is not empty --- SQL/mysql5.initial.sql | 6 +++--- 1 files changed, 3 insertions(+), 3 deletions(-) diff --git a/SQL/mysql5.initial.sql b/SQL/mysql5.initial.sql index fbca3dc..7981769 100644 --- a/SQL/mysql5.initial.sql +++ b/SQL/mysql5.initial.sql @@ -12,10 +12,10 @@ `sess_id` varchar(40) NOT NULL, `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `changed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', - `ip` varchar(15) NOT NULL, + `ip` varchar(40) NOT NULL, `vars` text NOT NULL, PRIMARY KEY(`sess_id`) -) TYPE=MYISAM CHARACTER SET ascii COLLATE ascii_general_ci; +) TYPE=MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci; -- Table structure for table `users` @@ -91,7 +91,7 @@ `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`) -- Gitblit v1.9.1