From 874e1572298531dde9bc1d3ccdb704af0a045605 Mon Sep 17 00:00:00 2001 From: ivar Date: Fri, 19 Dec 2025 22:00:06 +0100 Subject: Migrate schema to pg --- app/src/lib/server/db/schema.ts | 12 ++++++------ 1 file changed, 6 insertions(+), 6 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 150d970..bb57703 100644 --- a/app/src/lib/server/db/schema.ts +++ b/app/src/lib/server/db/schema.ts @@ -1,17 +1,17 @@ -import { relations } from 'drizzle-orm'; -import { numeric, text, pgTable } from "drizzle-orm/pg-core"; - +import { relations, sql } from 'drizzle-orm'; +import { numeric, text, pgTable, uuid, json } from "drizzle-orm/pg-core"; +import type { Sb1Tokens } from '../sb1'; export const syncSession = pgTable("session", { - id: text('id').primaryKey().$defaultFn(() => crypto.randomUUID()), + id: uuid('id').primaryKey().default(sql`uuidv7()`), authzState: text("authzState"), accessTokenCreated: numeric("accessTokenCreated"), refreshTokenCreated: numeric("refreshTokenCreated"), - tokens: text("tokens") + tokens: json("tokens").$type() }) export const syncLog = pgTable("session_log", { - id: text("id").primaryKey(), + id: uuid('id').primaryKey().default(sql`uuidv7()`), sessionId: text("session_id"), dateTime: text("date_time"), msg: text("msg") -- cgit v1.3