aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorfunjoker <funjoker109@gmail.com>2020-07-04 19:09:36 +0200
committerGitHub <noreply@github.com>2020-07-04 19:09:36 +0200
commit590f541019f7630f614110c60ce3653b17ca77e2 (patch)
treec9d12656dececeed73e3ab30b8fd8526da20079e /sql/updates
parentaa44a9f08b376cd76a18ab8e999b600f388a8190 (diff)
Core/Hotfixes: Add locales to hotfix_blob (#24913)
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/hotfixes/master/2020_07_04_00_hotfixes.sql6
1 files changed, 6 insertions, 0 deletions
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";