Migrate schema to pg

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")