diff options
| author | BonfaceKilz | 2021-07-23 13:00:37 +0300 |
|---|---|---|
| committer | BonfaceKilz | 2021-07-23 13:00:37 +0300 |
| commit | 13c4e1bbe6f30454c06235698efad146d99116dd (patch) | |
| tree | 077f6eb97d1840b35413fc261f4292d87fa7b54a | |
| parent | 278f1a18b59b1cadd04c50a9af35b5aece4d722d (diff) | |
| download | genenetwork3-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/
| -rw-r--r-- | sql/update/metadata_audit.sql | 2 |
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'; |