From 13c4e1bbe6f30454c06235698efad146d99116dd Mon Sep 17 00:00:00 2001 From: BonfaceKilz Date: Fri, 23 Jul 2021 13:00:37 +0300 Subject: sql: metadata_audit: Make char-set encoding explicit(utf8mb4) See: https://www.eversql.com/mysql-utf8-vs-utf8mb4-whats-the-difference-between-utf8-and-utf8mb4/ --- sql/update/metadata_audit.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/sql/update/metadata_audit.sql b/sql/update/metadata_audit.sql index 514a2fc..5055666 100644 --- a/sql/update/metadata_audit.sql +++ b/sql/update/metadata_audit.sql @@ -26,4 +26,4 @@ CREATE TABLE metadata_audit ( json_diff_data VARCHAR(2048) NOT NULL, time_stamp timestamp DEFAULT CURRENT_TIMESTAMP NOT NULL, CHECK (JSON_VALID(json_diff_data)) -); +) CHARACTER SET 'utf8mb4'; -- cgit v1.2.3