From 56dd6588503908d9a562445c1cb6a99c2a7aa415 Mon Sep 17 00:00:00 2001
From: xengineering <me@xengineering.eu>
Date: Mon, 22 Jun 2026 20:09:08 +0200
Subject: sql: migrations: Add 0003.sqlite3

This adds persistence for tokens.
---
 sql/migrations/0003.sqlite3 | 12 ++++++++++++
 1 file changed, 12 insertions(+)
 create mode 100644 sql/migrations/0003.sqlite3

(limited to 'sql/migrations')

diff --git a/sql/migrations/0003.sqlite3 b/sql/migrations/0003.sqlite3
new file mode 100644
index 0000000..79f7516
--- /dev/null
+++ b/sql/migrations/0003.sqlite3
@@ -0,0 +1,12 @@
+PRAGMA user_version = 3;
+
+CREATE TABLE tokens (
+	id         INTEGER PRIMARY KEY,
+	user_id    INTEGER NOT NULL,
+	token      TEXT NOT NULL,
+	created_at DATETIME NOT NULL DEFAULT (datetime('now')),
+
+	FOREIGN KEY (user_id) REFERENCES users(id)
+		ON DELETE CASCADE
+		ON UPDATE CASCADE
+);
-- 
cgit v1.3.1