Misc stuffHEADmaster

1 files changed, 16 insertions, 11 deletions

diff --git a/app/src/lib/server/db/schema.ts b/app/src/lib/server/db/schema.ts
index 4d13ed6..dbff3a2 100644
--- a/app/src/lib/server/db/schema.ts
+++ b/app/src/lib/server/db/schema.ts
@@ -1,17 +1,17 @@
 import { relations, sql } from 'drizzle-orm';
-import { numeric, text, pgTable, uuid, json } from "drizzle-orm/pg-core";
-import type { Sb1Tokens } from '../sb1';
+import { numeric, text, pgTable, uuid, jsonb } from "drizzle-orm/pg-core";
 import type { SessionLogType } from '../session-log';
+import type { Sb1Tokens, Sb1Transaction, Sb1TransactionDetails } from '$lib/shared';
 
-export const syncSession = pgTable("session", {
+export const SyncSessionTable = pgTable("session", {
 	id: uuid('id').primaryKey().default(sql`uuidv7()`),
 	authzState: text("authzState"),
 	accessTokenCreated: numeric("accessTokenCreated"),
 	refreshTokenCreated: numeric("refreshTokenCreated"),
-	tokens: json("tokens").$type<Sb1Tokens>()
+	tokens: jsonb("tokens").$type<Sb1Tokens>()
 })
 
-export const syncLog = pgTable("session_log", {
+export const SyncLogTable = pgTable("session_log", {
 	id: uuid('id').primaryKey().default(sql`uuidv7()`),
 	sessionId: text("session_id"),
 	dateTime: text("date_time"),
@@ -19,13 +19,18 @@ export const syncLog = pgTable("session_log", {
 	msg: text("msg")
 })
 
-export const syncLogRelation = relations(syncLog, ({ one }) => ({
-	author: one(syncSession, {
-		fields: [syncLog.sessionId],
-		references: [syncSession.id],
+export const TransactionsTable = pgTable("transactions", {
+	transaction: jsonb("transaction").$type<Sb1Transaction>(),
+	details: jsonb("details").$type<Sb1TransactionDetails>()
+})
+
+export const SyncLogRelation = relations(SyncLogTable, ({ one }) => ({
+	author: one(SyncSessionTable, {
+		fields: [SyncLogTable.sessionId],
+		references: [SyncSessionTable.id],
 	})
 }))
 
-export const syncSessionLogRelation = relations(syncSession, ({ many }) => ({
-	logs: many(syncLog)
+export const SyncSessionLogRelation = relations(SyncSessionTable, ({ many }) => ({
+	logs: many(SyncLogTable)
 }))