From 3934137fa15737145094ec4607de82e5b3dbf063 Mon Sep 17 00:00:00 2001
From: xengineering <me@xengineering.eu>
Date: Fri, 5 Jun 2026 22:39:17 +0200
Subject: sql: migrations: Add 0002.sqlite3

This migrations adds a `users` table with id, username and
password_bcrypt.

This allows basic user management and authentication.
---
 sql/migrations/0002.sqlite3 | 7 +++++++
 1 file changed, 7 insertions(+)
 create mode 100644 sql/migrations/0002.sqlite3

diff --git a/sql/migrations/0002.sqlite3 b/sql/migrations/0002.sqlite3
new file mode 100644
index 0000000..ea8aa3a
--- /dev/null
+++ b/sql/migrations/0002.sqlite3
@@ -0,0 +1,7 @@
+PRAGMA user_version = 2;
+
+CREATE TABLE users (
+	id              INTEGER PRIMARY KEY,
+	username        TEXT NOT NULL UNIQUE,
+	password_bcrypt BLOB NOT NULL UNIQUE
+);
-- 
cgit v1.3.1