diff options
| author | ivar <i@oiee.no> | 2025-12-19 22:00:06 +0100 |
|---|---|---|
| committer | ivar <i@oiee.no> | 2025-12-19 22:00:06 +0100 |
| commit | 874e1572298531dde9bc1d3ccdb704af0a045605 (patch) | |
| tree | 2dd684797894eed12fa2cdcc2216f102e1515813 /app/src/lib/server/db/schema.ts | |
| parent | 6c65d3947e56530e7ec3976e2955b027b7abe679 (diff) | |
| download | sparebank1-actualbudget-874e1572298531dde9bc1d3ccdb704af0a045605.tar.xz sparebank1-actualbudget-874e1572298531dde9bc1d3ccdb704af0a045605.zip | |
Migrate schema to pg
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") |