diff options
| author | cbdev <cb@cbcdn.com> | 2022-07-04 19:21:34 +0200 |
|---|---|---|
| committer | cbdev <cb@cbcdn.com> | 2022-07-04 19:21:34 +0200 |
| commit | 507f0d060da30a8f65bec8b2ac1f08837d536b4c (patch) | |
| tree | b2c5a1f9cc5080fb7f2586e2371fce443e43fbaa /backend/cargohold.sql | |
| parent | 4369d6a7f024f9ebf3c5f41a8fe17bfc65d0a820 (diff) | |
| download | cargohold-507f0d060da30a8f65bec8b2ac1f08837d536b4c.tar.gz cargohold-507f0d060da30a8f65bec8b2ac1f08837d536b4c.tar.bz2 cargohold-507f0d060da30a8f65bec8b2ac1f08837d536b4c.zip | |
Implement authentication modules for admin panel
Diffstat (limited to 'backend/cargohold.sql')
| -rw-r--r-- | backend/cargohold.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/backend/cargohold.sql b/backend/cargohold.sql index 5447325..2f0a1db 100644 --- a/backend/cargohold.sql +++ b/backend/cargohold.sql @@ -1,2 +1,3 @@ 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); +CREATE TABLE sessions (id TEXT PRIMARY KEY UNIQUE NOT NULL, user TEXT REFERENCES users (name) ON DELETE CASCADE ON UPDATE CASCADE NOT NULL, expire INTEGER); |