From 689cdb8168b509887a459ea92d74280bc2fe8bbe Mon Sep 17 00:00:00 2001 From: cbdev Date: Sat, 30 Oct 2021 00:29:27 +0200 Subject: Document config.py, add example nginx config and DB schema --- backend/cargohold.sql | 2 ++ 1 file changed, 2 insertions(+) create mode 100644 backend/cargohold.sql (limited to 'backend/cargohold.sql') diff --git a/backend/cargohold.sql b/backend/cargohold.sql new file mode 100644 index 0000000..5447325 --- /dev/null +++ b/backend/cargohold.sql @@ -0,0 +1,2 @@ +CREATE TABLE users (name TEXT NOT NULL UNIQUE PRIMARY KEY, storage INTEGER DEFAULT (0)); +CREATE TABLE aliases (alias TEXT PRIMARY KEY UNIQUE NOT NULL, user TEXT REFERENCES users (name) ON DELETE CASCADE ON UPDATE CASCADE NOT NULL, real TEXT NOT NULL, access TEXT DEFAULT r, storage INTEGER, display TEXT); -- cgit v1.2.3