From f09bca308e00502cbf62e4345efbfb6ec771420e Mon Sep 17 00:00:00 2001 From: till <till@php.net> Date: Tue, 28 Aug 2007 22:22:43 -0400 Subject: [PATCH] # fixed: #1484456 --- SQL/mysql5.initial.sql | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) diff --git a/SQL/mysql5.initial.sql b/SQL/mysql5.initial.sql index fbca3dc..aeec961 100644 --- a/SQL/mysql5.initial.sql +++ b/SQL/mysql5.initial.sql @@ -15,7 +15,7 @@ `ip` varchar(15) 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