From 815de9906a014c2eb1a4fe2bd8cf1b3077f03c9c Mon Sep 17 00:00:00 2001
From: Mathias Magnusson <mathias@magnusson.space>
Date: Thu, 14 Aug 2025 18:42:27 +0200
Subject: Add passkey authentication

---
 src/db/schema.ts | 34 +++++++++++++++++++++++++++++++---
 1 file changed, 31 insertions(+), 3 deletions(-)

(limited to 'src/db/schema.ts')

diff --git a/src/db/schema.ts b/src/db/schema.ts
index 15da652..01b7228 100644
--- a/src/db/schema.ts
+++ b/src/db/schema.ts
@@ -1,5 +1,33 @@
-import { text, sqliteTable } from "drizzle-orm/sqlite-core";
+import { relations } from "drizzle-orm";
+import { text, sqliteTable, integer } from "drizzle-orm/sqlite-core";
 
-export const groupsTable = sqliteTable("groups", {
-    name: text("name").notNull(),
+export const groupTable = sqliteTable("groups", {
+    id: integer().primaryKey(),
+    name: text().notNull(),
+});
+
+export const userTable = sqliteTable("users", {
+    id: integer().primaryKey(),
+    name: text().unique().notNull(),
+    passkey: text(),
+    passkeyId: text("passkey_id").notNull(),
+});
+
+export const sessionTable = sqliteTable("sessions", {
+    id: integer().primaryKey(),
+    uuid: text().unique().notNull(),
+    userId: integer("user_id").notNull(),
+});
+
+export const sessionRelations = relations(sessionTable, ({ one }) => ({
+    user: one(userTable, {
+        fields: [sessionTable.userId],
+        references: [userTable.id],
+    }),
+}));
+
+export const webauthnChallenges = sqliteTable("webauthn_challenges", {
+    id: integer().primaryKey(),
+    challenge: text().notNull(),
+    key: text().notNull(),
 });
-- 
cgit v1.2.3