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`)