diff options
| author | Julien Dessaux | 2025-01-06 00:41:32 +0100 |
|---|---|---|
| committer | Julien Dessaux | 2025-01-06 00:41:32 +0100 |
| commit | 6e069484cb0a911ba541e07bf04331fadbb76612 (patch) | |
| tree | 3457c759d54ae91e5ac1e64fe0bbf9c4b8ac18f0 /pkg/database/sql | |
| parent | feat(tfstated): add syscall.SIGTERM handling (diff) | |
| download | tfstated-6e069484cb0a911ba541e07bf04331fadbb76612.tar.gz tfstated-6e069484cb0a911ba541e07bf04331fadbb76612.tar.bz2 tfstated-6e069484cb0a911ba541e07bf04331fadbb76612.zip | |
feat(webui): bootstrap session handling and login process
Diffstat (limited to '')
| -rw-r--r-- | pkg/database/sql/000_init.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/pkg/database/sql/000_init.sql b/pkg/database/sql/000_init.sql index b635442..e14142b 100644 --- a/pkg/database/sql/000_init.sql +++ b/pkg/database/sql/000_init.sql @@ -14,6 +14,15 @@ CREATE TABLE accounts ( ) STRICT; CREATE UNIQUE INDEX accounts_username on accounts(username); +CREATE TABLE sessions ( + id TEXT PRIMARY KEY, + account_id INTEGER NOT NULL, + created INTEGER NOT NULL DEFAULT (unixepoch()), + updated INTEGER NOT NULL DEFAULT (unixepoch()), + data TEXT NOT NULL, + FOREIGN KEY(account_id) REFERENCES accounts(id) ON DELETE CASCADE +) STRICT; + CREATE TABLE states ( id INTEGER PRIMARY KEY, path TEXT NOT NULL, |