mirror of
https://github.com/chrislusf/seaweedfs
synced 2024-05-09 13:00:45 +02:00
12 lines
545 B
SQL
12 lines
545 B
SQL
CREATE DATABASE IF NOT EXISTS seaweedfs;
|
|
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; |