diff options
author | Aleksander Machniak <alec@alec.pl> | 2020-03-14 10:31:28 +0300 |
---|---|---|
committer | Aleksander Machniak <alec@alec.pl> | 2020-03-14 10:31:28 +0300 |
commit | 2c1a22d2837afe9a35eea64610e2279e4849a608 (patch) | |
tree | ce412d354f93db67e5697f72895ae6b2a27bf23a /SQL | |
parent | 0fbd18429476c591416df9064aa19e11003c5594 (diff) |
Bring back BINARY for some columns after switch to utf8mb4 charset (#7277)
Diffstat (limited to 'SQL')
-rw-r--r-- | SQL/mysql/2020020101.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/SQL/mysql/2020020101.sql b/SQL/mysql/2020020101.sql index ddab0878d..4731d2546 100644 --- a/SQL/mysql/2020020101.sql +++ b/SQL/mysql/2020020101.sql @@ -12,3 +12,10 @@ ALTER TABLE `dictionary` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicod ALTER TABLE `searches` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; ALTER TABLE `filestore` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; ALTER TABLE `system` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; + +ALTER TABLE `users` ALTER `username` varchar(128) BINARY NOT NULL; +ALTER TABLE `cache` ALTER `cache_key` varchar(128) BINARY NOT NULL; +ALTER TABLE `cache_shared` ALTER `cache_key` varchar(255) BINARY NOT NULL; +ALTER TABLE `cache_index` ALTER `mailbox` varchar(255) BINARY NOT NULL; +ALTER TABLE `cache_thread` ALTER `mailbox` varchar(255) BINARY NOT NULL; +ALTER TABLE `cache_messages` ALTER `mailbox` varchar(255) BINARY NOT NULL; |