diff options
Diffstat (limited to 'backend/cargohold.sql')
-rw-r--r-- | backend/cargohold.sql | 2 |
1 files changed, 2 insertions, 0 deletions
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); |