diff options
Diffstat (limited to 'app/src/lib/server/db/schema.ts')
| -rw-r--r-- | app/src/lib/server/db/schema.ts | 12 |
1 files changed, 6 insertions, 6 deletions
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<Sb1Tokens>() }) 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") |