From 6c65d3947e56530e7ec3976e2955b027b7abe679 Mon Sep 17 00:00:00 2001 From: ivar Date: Fri, 19 Dec 2025 12:05:27 +0100 Subject: Swap sqlite for postgres --- app/src/lib/server/db/schema.ts | 11 ++++++----- 1 file changed, 6 insertions(+), 5 deletions(-) (limited to 'app/src/lib/server/db/schema.ts') diff --git a/app/src/lib/server/db/schema.ts b/app/src/lib/server/db/schema.ts index c1bea43..150d970 100644 --- a/app/src/lib/server/db/schema.ts +++ b/app/src/lib/server/db/schema.ts @@ -1,15 +1,16 @@ import { relations } from 'drizzle-orm'; -import { int, sqliteTable, text } from 'drizzle-orm/sqlite-core'; +import { numeric, text, pgTable } from "drizzle-orm/pg-core"; -export const syncSession = sqliteTable("session", { + +export const syncSession = pgTable("session", { id: text('id').primaryKey().$defaultFn(() => crypto.randomUUID()), authzState: text("authzState"), - accessTokenCreated: int("accessTokenCreated"), - refreshTokenCreated: int("refreshTokenCreated"), + accessTokenCreated: numeric("accessTokenCreated"), + refreshTokenCreated: numeric("refreshTokenCreated"), tokens: text("tokens") }) -export const syncLog = sqliteTable("session_log", { +export const syncLog = pgTable("session_log", { id: text("id").primaryKey(), sessionId: text("session_id"), dateTime: text("date_time"), -- cgit v1.3