diff options
| author | Chris Lu <chris.lu@gmail.com> | 2021-03-23 00:46:50 -0700 |
|---|---|---|
| committer | Chris Lu <chris.lu@gmail.com> | 2021-03-23 00:46:50 -0700 |
| commit | 85cff10787271fd94fec868e692cac7315d9d8fb (patch) | |
| tree | 42b619759b5531988f58a65f1c48cf18cddc7d5a | |
| parent | 5f0e68c21e9e7b87d9f4165714bedbb2d1827fae (diff) | |
| download | seaweedfs-85cff10787271fd94fec868e692cac7315d9d8fb.tar.xz seaweedfs-85cff10787271fd94fec868e692cac7315d9d8fb.zip | |
mysql: ensure name column is case sensitive
fix https://github.com/chrislusf/seaweedfs/issues/1931
| -rw-r--r-- | weed/command/scaffold.go | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/weed/command/scaffold.go b/weed/command/scaffold.go index 07d448042..e990bb3ea 100644 --- a/weed/command/scaffold.go +++ b/weed/command/scaffold.go @@ -103,9 +103,9 @@ dir = "./filerrdb" # directory to store rocksdb files [mysql] # or memsql, tidb # 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', +# dirhash BIGINT COMMENT 'first 64 bits of MD5 hash value of directory field', +# name VARCHAR(1000) BINARY COMMENT 'directory or file name', +# directory TEXT COMMENT 'full path to parent directory', # meta LONGBLOB, # PRIMARY KEY (dirhash, name) # ) DEFAULT CHARSET=utf8; @@ -126,7 +126,7 @@ enabled = false createTable = """ CREATE TABLE IF NOT EXISTS ` + "`%s`" + ` ( dirhash BIGINT, - name VARCHAR(1000), + name VARCHAR(1000) BINARY, directory TEXT, meta LONGBLOB, PRIMARY KEY (dirhash, name) |