Initial commit

1 files changed, 28 insertions, 0 deletions

diff --git a/app/src/lib/server/db/schema.ts b/app/src/lib/server/db/schema.ts
new file mode 100644
index 0000000..c1bea43
--- /dev/null
+++ b/app/src/lib/server/db/schema.ts
@@ -0,0 +1,28 @@
+import { relations } from 'drizzle-orm';
+import { int, sqliteTable, text } from 'drizzle-orm/sqlite-core';
+
+export const syncSession = sqliteTable("session", {
+	id: text('id').primaryKey().$defaultFn(() => crypto.randomUUID()),
+	authzState: text("authzState"),
+	accessTokenCreated: int("accessTokenCreated"),
+	refreshTokenCreated: int("refreshTokenCreated"),
+	tokens: text("tokens")
+})
+
+export const syncLog = sqliteTable("session_log", {
+	id: text("id").primaryKey(),
+	sessionId: text("session_id"),
+	dateTime: text("date_time"),
+	msg: text("msg")
+})
+
+export const syncLogRelation = relations(syncLog, ({ one }) => ({
+	author: one(syncSession, {
+		fields: [syncLog.sessionId],
+		references: [syncSession.id],
+	})
+}))
+
+export const syncSessionLogRelation = relations(syncSession, ({ many }) => ({
+	logs: many(syncLog)
+}))