From 14326ba9be276d2649b4681d3ebed1c32f65013f Mon Sep 17 00:00:00 2001 From: Runxi Yu Date: Thu, 13 Feb 2025 01:28:35 +0800 Subject: _header.html: Add header --- schema.sql | 6 ++++++ 1 file changed, 6 insertions(+) (limited to 'schema.sql') diff --git a/schema.sql b/schema.sql index fbd9ac8..6317819 100644 --- a/schema.sql +++ b/schema.sql @@ -51,6 +51,12 @@ CREATE TABLE users ( password TEXT NOT NULL ); +CREATE TABLE sessions ( + user_id INTEGER NOT NULL REFERENCES users(id) ON DELETE CASCADE, + session_id TEXT NOT NULL, + PRIMARY KEY (user_id, session_id) +); + CREATE TABLE merge_requests ( id INTEGER GENERATED ALWAYS AS IDENTITY PRIMARY KEY, repo_id INTEGER NOT NULL REFERENCES repos(id) ON DELETE CASCADE, -- cgit v1.2.3