From 5effbf0ab6b3f8522dbdd1d909b3da148480053b Mon Sep 17 00:00:00 2001
From: Tor Andersson <tor@ccxvii.net>
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')

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