diff options
| author | ivar <i@oiee.no> | 2025-12-19 12:05:27 +0100 |
|---|---|---|
| committer | ivar <i@oiee.no> | 2025-12-19 12:05:27 +0100 |
| commit | 6c65d3947e56530e7ec3976e2955b027b7abe679 (patch) | |
| tree | ba874e9316c42e009eb0f322e63c5ef044ae1b0b /app/src/lib/server/db/schema.ts | |
| parent | 7e0caba2a27160273fd1ddc2a0b56b0b0cb6eb01 (diff) | |
| download | sparebank1-actualbudget-6c65d3947e56530e7ec3976e2955b027b7abe679.tar.xz sparebank1-actualbudget-6c65d3947e56530e7ec3976e2955b027b7abe679.zip | |
Swap sqlite for postgres
Diffstat (limited to 'app/src/lib/server/db/schema.ts')
| -rw-r--r-- | app/src/lib/server/db/schema.ts | 11 |
1 files changed, 6 insertions, 5 deletions
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"), |