summaryrefslogtreecommitdiff
path: root/SQL/mysql.initial.sql
diff options
context:
space:
mode:
authoralecpl <alec@alec.pl>2011-09-06 17:18:12 +0000
committeralecpl <alec@alec.pl>2011-09-06 17:18:12 +0000
commitd5ae9772c1427dbbcf1cb7582106dd1d542bc26e (patch)
tree4c3f47d650e675777bbaa4265e59d52cc3058062 /SQL/mysql.initial.sql
parentf8e48df71540b268ceac058d32b8ee848fc2ab6b (diff)
- Fix username case-insensitivity issue in MySQL (#1488021)
Diffstat (limited to 'SQL/mysql.initial.sql')
-rw-r--r--SQL/mysql.initial.sql4
1 files changed, 2 insertions, 2 deletions
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),