Page MenuHomePhorge
Files F2534512

No OneTemporary
Actions

Size
1 KB
Referenced Files
None
Subscribers
None

View Options

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
@@ -1,14 +1,21 @@
ALTER TABLE `session` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `users` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `cache` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `cache_shared` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `cache_index` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `cache_thread` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `cache_messages` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `contacts` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `contactgroups` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `identities` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `dictionary` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
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;

File Metadata

Mime Type
text/x-diff
Expires
Fri, Feb 6, 2:19 PM (1 h, 31 m)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
428298
Default Alt Text
(1 KB)

Event Timeline