From 5effbf0ab6b3f8522dbdd1d909b3da148480053b Mon Sep 17 00:00:00 2001 From: Tor Andersson Date: Tue, 7 Dec 2021 13:04:41 +0100 Subject: Put login session table in main database. --- tools/sql/schema.txt | 9 +++++++++ 1 file changed, 9 insertions(+) (limited to 'tools/sql/schema.txt') 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, -- cgit v1.2.3