diff options
| author | Tor Andersson <tor@ccxvii.net> | 2021-12-07 13:04:41 +0100 |
|---|---|---|
| committer | Tor Andersson <tor@ccxvii.net> | 2021-12-07 13:04:41 +0100 |
| commit | 5effbf0ab6b3f8522dbdd1d909b3da148480053b (patch) | |
| tree | 19e761a39eb11c8d25f3a3465d232d2fa8f6422b /tools/sql/schema.txt | |
| parent | de3183e620f9a60d82456303880173a27ca2ef21 (diff) | |
| download | server-5effbf0ab6b3f8522dbdd1d909b3da148480053b.tar.gz | |
Put login session table in main database.
Diffstat (limited to 'tools/sql/schema.txt')
| -rw-r--r-- | tools/sql/schema.txt | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/tools/sql/schema.txt b/tools/sql/schema.txt index cd04c25..62bde47 100644 --- a/tools/sql/schema.txt +++ b/tools/sql/schema.txt @@ -22,6 +22,15 @@ create table if not exists roles ( -- Users -- +create table if not exists logins ( + sid integer + primary key, + user_id integer + references users + on delete cascade, + expires real +); + create table if not exists users ( user_id integer primary key, |