aboutsummaryrefslogtreecommitdiff
path: root/docker/seaweedfs.sql
diff options
context:
space:
mode:
authorKonstantin Lebedev <lebedev_k@tochka.com>2020-12-21 20:58:41 +0500
committerKonstantin Lebedev <lebedev_k@tochka.com>2020-12-21 20:58:41 +0500
commit6b4e9eef57bfb613f2c2a1dc4ca3edf4f333d4ec (patch)
treea0ac9fd5fba6ebf1fd742186d5bb091847526ecc /docker/seaweedfs.sql
parent75629954d1d215b3e6f7fe43024af2db137ad5ba (diff)
downloadseaweedfs-6b4e9eef57bfb613f2c2a1dc4ca3edf4f333d4ec.tar.xz
seaweedfs-6b4e9eef57bfb613f2c2a1dc4ca3edf4f333d4ec.zip
k8s build
Diffstat (limited to 'docker/seaweedfs.sql')
-rw-r--r--docker/seaweedfs.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/docker/seaweedfs.sql b/docker/seaweedfs.sql
new file mode 100644
index 000000000..38ebc575c
--- /dev/null
+++ b/docker/seaweedfs.sql
@@ -0,0 +1,12 @@
+CREATE DATABASE IF NOT EXISTS seaweedfs;
+CREATE USER IF NOT EXISTS 'seaweedfs'@'%' IDENTIFIED BY 'secret';
+GRANT ALL PRIVILEGES ON seaweedfs_fast.* 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