diff options
author | Aleksander Machniak <alec@alec.pl> | 2020-03-14 13:27:55 +0300 |
---|---|---|
committer | Aleksander Machniak <alec@alec.pl> | 2020-03-14 13:27:55 +0300 |
commit | dc1ce546b9cbd897ecd7950d58f35df0afc89c23 (patch) | |
tree | 98b2060d44ab7d8d0c29f830fd3897736df77ddd /SQL | |
parent | 2c1a22d2837afe9a35eea64610e2279e4849a608 (diff) |
Fix sql syntax error introduced in last commit
Diffstat (limited to 'SQL')
-rw-r--r-- | SQL/mysql/2020020101.sql | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/SQL/mysql/2020020101.sql b/SQL/mysql/2020020101.sql index 4731d2546..371d6d596 100644 --- a/SQL/mysql/2020020101.sql +++ b/SQL/mysql/2020020101.sql @@ -13,9 +13,9 @@ ALTER TABLE `searches` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ 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; +ALTER TABLE `users` CHANGE `username` `username` varchar(128) BINARY NOT NULL; +ALTER TABLE `cache` CHANGE `cache_key` `cache_key` varchar(128) BINARY NOT NULL; +ALTER TABLE `cache_shared` CHANGE `cache_key` `cache_key` varchar(255) BINARY NOT NULL; +ALTER TABLE `cache_index` CHANGE `mailbox` `mailbox` varchar(255) BINARY NOT NULL; +ALTER TABLE `cache_thread` CHANGE `mailbox` `mailbox` varchar(255) BINARY NOT NULL; +ALTER TABLE `cache_messages` CHANGE `mailbox` `mailbox` varchar(255) BINARY NOT NULL; |