diff options
Diffstat (limited to 'app/src/lib')
| -rw-r--r-- | app/src/lib/server/db/index.ts | 5 | ||||
| -rw-r--r-- | app/src/lib/server/db/schema.ts | 11 |
2 files changed, 8 insertions, 8 deletions
diff --git a/app/src/lib/server/db/index.ts b/app/src/lib/server/db/index.ts index b3c877b..3168d01 100644 --- a/app/src/lib/server/db/index.ts +++ b/app/src/lib/server/db/index.ts @@ -1,10 +1,9 @@ -import { drizzle } from 'drizzle-orm/better-sqlite3'; +import { drizzle } from 'drizzle-orm/node-postgres'; import Database from 'better-sqlite3'; -import * as schema from './schema'; 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(client, { schema }); +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 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"), |