From 590f541019f7630f614110c60ce3653b17ca77e2 Mon Sep 17 00:00:00 2001
From: funjoker <funjoker109@gmail.com>
Date: Sat, 4 Jul 2020 19:09:36 +0200
Subject: Core/Hotfixes: Add locales to hotfix_blob (#24913)

---
 sql/updates/hotfixes/master/2020_07_04_00_hotfixes.sql | 6 ++++++
 1 file changed, 6 insertions(+)
 create mode 100644 sql/updates/hotfixes/master/2020_07_04_00_hotfixes.sql

(limited to 'sql')

diff --git a/sql/updates/hotfixes/master/2020_07_04_00_hotfixes.sql b/sql/updates/hotfixes/master/2020_07_04_00_hotfixes.sql
new file mode 100644
index 00000000000..064e65f8fe0
--- /dev/null
+++ b/sql/updates/hotfixes/master/2020_07_04_00_hotfixes.sql
@@ -0,0 +1,6 @@
+ALTER TABLE `hotfix_blob`
+ADD COLUMN `locale` VARCHAR(4) NOT NULL COLLATE 'utf8mb4_unicode_ci' AFTER `RecordId`,
+DROP PRIMARY KEY,
+ADD PRIMARY KEY (`TableHash`, `RecordId`, `locale`);
+
+UPDATE `hotfix_blob` SET `locale` = "enUS";
-- 
cgit v1.2.3