From d5ae9772c1427dbbcf1cb7582106dd1d542bc26e Mon Sep 17 00:00:00 2001 From: alecpl <alec@alec.pl> Date: Tue, 06 Sep 2011 13:18:12 -0400 Subject: [PATCH] - Fix username case-insensitivity issue in MySQL (#1488021) --- SQL/mysql.initial.sql | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) diff --git a/SQL/mysql.initial.sql b/SQL/mysql.initial.sql index 6c26690..a50e28c 100644 --- a/SQL/mysql.initial.sql +++ b/SQL/mysql.initial.sql @@ -20,9 +20,9 @@ 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), -- Gitblit v1.9.1