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.
---
 main.go                     |  5 +++++
 sql/migrations/0003.sqlite3 | 12 ++++++++++++
 2 files changed, 17 insertions(+)
 create mode 100644 sql/migrations/0003.sqlite3

diff --git a/main.go b/main.go
index 4cd1150..6f628a5 100644
--- a/main.go
+++ b/main.go
@@ -58,6 +58,11 @@ func run(
 	}
 	defer db.Close()
 
+	_, err = db.Exec(`PRAGMA foreign_keys = ON;`)
+	if err != nil {
+		log.Fatalf("Failed to enable foreign key support in database: %v", err)
+	}
+
 	err = MigrateToLatest(db)
 	if err != nil {
 		log.Fatalf("Failed to migrate SQLite3 database '%s': %v", dbPath, err)
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