From d5ae9772c1427dbbcf1cb7582106dd1d542bc26e Mon Sep 17 00:00:00 2001 From: alecpl Date: Tue, 6 Sep 2011 17:18:12 +0000 Subject: - Fix username case-insensitivity issue in MySQL (#1488021) --- SQL/mysql.initial.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'SQL/mysql.initial.sql') diff --git a/SQL/mysql.initial.sql b/SQL/mysql.initial.sql index 6c2669009..a50e28c35 100644 --- a/SQL/mysql.initial.sql +++ b/SQL/mysql.initial.sql @@ -20,9 +20,9 @@ CREATE TABLE `session` ( CREATE TABLE `users` ( `user_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, - `username` varchar(128) NOT NULL, + `username` varchar(128) BINARY NOT NULL, `mail_host` varchar(128) NOT NULL, - `alias` varchar(128) NOT NULL, + `alias` varchar(128) BINARY NOT NULL, `created` datetime NOT NULL DEFAULT '1000-01-01 00:00:00', `last_login` datetime DEFAULT NULL, `language` varchar(5), -- cgit v1.2.3