From 3262d631fd1be55a5c85ede08d92a35c5fb7d2c4 Mon Sep 17 00:00:00 2001
From: Mathias Magnusson <mathias@magnusson.space>
Date: Mon, 18 Aug 2025 21:43:11 +0200
Subject: Get current user session

---
 migrations/0000_real_hitman.sql | 26 ++++++++++++++++++++++++++
 1 file changed, 26 insertions(+)
 create mode 100644 migrations/0000_real_hitman.sql

(limited to 'migrations/0000_real_hitman.sql')

diff --git a/migrations/0000_real_hitman.sql b/migrations/0000_real_hitman.sql
new file mode 100644
index 0000000..fc43e8e
--- /dev/null
+++ b/migrations/0000_real_hitman.sql
@@ -0,0 +1,26 @@
+CREATE TABLE `groups` (
+	`id` integer PRIMARY KEY NOT NULL,
+	`name` text NOT NULL
+);
+--> statement-breakpoint
+CREATE TABLE `sessions` (
+	`id` integer PRIMARY KEY NOT NULL,
+	`uuid` text NOT NULL,
+	`user_id` integer NOT NULL,
+	`last_use` integer NOT NULL
+);
+--> statement-breakpoint
+CREATE UNIQUE INDEX `sessions_uuid_unique` ON `sessions` (`uuid`);--> statement-breakpoint
+CREATE TABLE `users` (
+	`id` integer PRIMARY KEY NOT NULL,
+	`name` text NOT NULL,
+	`passkey` text,
+	`passkey_id` text NOT NULL
+);
+--> statement-breakpoint
+CREATE UNIQUE INDEX `users_name_unique` ON `users` (`name`);--> statement-breakpoint
+CREATE TABLE `webauthn_challenges` (
+	`id` integer PRIMARY KEY NOT NULL,
+	`challenge` text NOT NULL,
+	`key` text NOT NULL
+);
-- 
cgit v1.2.3