From 14326ba9be276d2649b4681d3ebed1c32f65013f Mon Sep 17 00:00:00 2001
From: Runxi Yu <me@runxiyu.org>
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

