diff options
| author | CommanderRoot <CommanderRoot@users.noreply.github.com> | 2023-01-01 14:07:53 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2023-01-01 05:07:53 -0800 |
| commit | c7c9d22f37de989b20fd06aaf9c6ea1411028834 (patch) | |
| tree | 0ec53a09407a6ba10ec3d7495f527385fd5d1cff /docker | |
| parent | c2280e94cf21dc5736b9f0c6c07ef611c8ed67c4 (diff) | |
| download | seaweedfs-c7c9d22f37de989b20fd06aaf9c6ea1411028834.tar.xz seaweedfs-c7c9d22f37de989b20fd06aaf9c6ea1411028834.zip | |
filer.store.mysql: Use utf8mb4 instead of 3 byte UTF8 (#4094)
Diffstat (limited to 'docker')
| -rw-r--r-- | docker/seaweedfs.sql | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/docker/seaweedfs.sql b/docker/seaweedfs.sql index a27eb7081..c9974e0e6 100644 --- a/docker/seaweedfs.sql +++ b/docker/seaweedfs.sql @@ -3,10 +3,10 @@ CREATE USER IF NOT EXISTS 'seaweedfs'@'%' IDENTIFIED BY 'secret'; GRANT ALL PRIVILEGES ON seaweedfs.* TO 'seaweedfs'@'%'; FLUSH PRIVILEGES; USE seaweedfs; -CREATE TABLE IF NOT EXISTS filemeta ( - dirhash BIGINT COMMENT 'first 64 bits of MD5 hash value of directory field', - name VARCHAR(1000) COMMENT 'directory or file name', - directory TEXT COMMENT 'full path to parent directory', - meta LONGBLOB, - PRIMARY KEY (dirhash, name) -) DEFAULT CHARSET=utf8;
\ No newline at end of file +CREATE TABLE IF NOT EXISTS `filemeta` ( + `dirhash` BIGINT NOT NULL COMMENT 'first 64 bits of MD5 hash value of directory field', + `name` VARCHAR(766) NOT NULL COMMENT 'directory or file name', + `directory` TEXT NOT NULL COMMENT 'full path to parent directory', + `meta` LONGBLOB, + PRIMARY KEY (`dirhash`, `name`) +) DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
\ No newline at end of file |