aboutsummaryrefslogtreecommitdiff
path: root/sql/update/metadata_audit.sql
diff options
context:
space:
mode:
authorBonfaceKilz2021-07-23 13:00:37 +0300
committerBonfaceKilz2021-07-23 13:00:37 +0300
commit13c4e1bbe6f30454c06235698efad146d99116dd (patch)
tree077f6eb97d1840b35413fc261f4292d87fa7b54a /sql/update/metadata_audit.sql
parent278f1a18b59b1cadd04c50a9af35b5aece4d722d (diff)
downloadgenenetwork3-13c4e1bbe6f30454c06235698efad146d99116dd.tar.gz
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/
Diffstat (limited to 'sql/update/metadata_audit.sql')
-rw-r--r--sql/update/metadata_audit.sql2
1 files changed, 1 insertions, 1 deletions
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';