diff options
Diffstat (limited to 'app/src/lib/server/db')
| -rw-r--r-- | app/src/lib/server/db/index.ts | 3 | ||||
| -rw-r--r-- | app/src/lib/server/db/schema.ts | 12 |
2 files changed, 6 insertions, 9 deletions
diff --git a/app/src/lib/server/db/index.ts b/app/src/lib/server/db/index.ts index 3168d01..e477388 100644 --- a/app/src/lib/server/db/index.ts +++ b/app/src/lib/server/db/index.ts @@ -1,9 +1,6 @@ import { drizzle } from 'drizzle-orm/node-postgres'; -import Database from 'better-sqlite3'; import { env } from '$env/dynamic/private'; if (!env.DATABASE_URL) throw new Error('DATABASE_URL is not set'); -const client = new Database(env.DATABASE_URL); - export const db = drizzle(env.DATABASE_URL);
\ No newline at end of file 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") |