From 3e89d2998588f8e35c524e523ba2ee853f0f6475 Mon Sep 17 00:00:00 2001
From: Maze Winther <mazewinther@gmail.com>
Date: Mon, 20 Apr 2026 11:31:17 +0200
Subject: refactor: restructure files to their domains,  new preview overlay
 system, and dep graph

---
 apps/web/src/db/index.ts  | 19 +++++++++++++
 apps/web/src/db/schema.ts | 70 +++++++++++++++++++++++++++++++++++++++++++++++
 2 files changed, 89 insertions(+)
 create mode 100644 apps/web/src/db/index.ts
 create mode 100644 apps/web/src/db/schema.ts

(limited to 'apps/web/src/db')

diff --git a/apps/web/src/db/index.ts b/apps/web/src/db/index.ts
new file mode 100644
index 00000000..29e3ffda
--- /dev/null
+++ b/apps/web/src/db/index.ts
@@ -0,0 +1,19 @@
+import { drizzle } from "drizzle-orm/postgres-js";
+import postgres from "postgres";
+import * as schema from "./schema";
+import { webEnv } from "@/env/web";
+
+let _db: ReturnType<typeof drizzle> | null = null;
+
+function getDb() {
+	if (!_db) {
+		const client = postgres(webEnv.DATABASE_URL);
+		_db = drizzle(client, { schema });
+	}
+
+	return _db;
+}
+
+export const db = getDb();
+
+export * from "./schema";
diff --git a/apps/web/src/db/schema.ts b/apps/web/src/db/schema.ts
new file mode 100644
index 00000000..8f8be248
--- /dev/null
+++ b/apps/web/src/db/schema.ts
@@ -0,0 +1,70 @@
+import { pgTable, text, timestamp, boolean } from "drizzle-orm/pg-core";
+
+export const users = pgTable("users", {
+	id: text("id").primaryKey(),
+
+	// todo: implement fully anonymous sign-in for privacy
+	// we don't have any auth flows currently so this is fine for now
+	name: text("name").notNull(),
+	email: text("email").notNull().unique(),
+	emailVerified: boolean("email_verified").default(false).notNull(),
+	image: text("image"),
+	createdAt: timestamp("created_at")
+		.$defaultFn(() => /* @__PURE__ */ new Date())
+		.notNull(),
+	updatedAt: timestamp("updated_at")
+		.$defaultFn(() => /* @__PURE__ */ new Date())
+		.notNull(),
+}).enableRLS();
+
+export const sessions = pgTable("sessions", {
+	id: text("id").primaryKey(),
+	expiresAt: timestamp("expires_at").notNull(),
+	token: text("token").notNull().unique(),
+	createdAt: timestamp("created_at").notNull(),
+	updatedAt: timestamp("updated_at").notNull(),
+	ipAddress: text("ip_address"),
+	userAgent: text("user_agent"),
+	userId: text("user_id")
+		.notNull()
+		.references(() => users.id, { onDelete: "cascade" }),
+}).enableRLS();
+
+export const accounts = pgTable("accounts", {
+	id: text("id").primaryKey(),
+	accountId: text("account_id").notNull(),
+	providerId: text("provider_id").notNull(),
+	userId: text("user_id")
+		.notNull()
+		.references(() => users.id, { onDelete: "cascade" }),
+	accessToken: text("access_token"),
+	refreshToken: text("refresh_token"),
+	idToken: text("id_token"),
+	accessTokenExpiresAt: timestamp("access_token_expires_at"),
+	refreshTokenExpiresAt: timestamp("refresh_token_expires_at"),
+	scope: text("scope"),
+	password: text("password"),
+	createdAt: timestamp("created_at").notNull(),
+	updatedAt: timestamp("updated_at").notNull(),
+}).enableRLS();
+
+export const feedback = pgTable("feedback", {
+	id: text("id").primaryKey(),
+	message: text("message").notNull(),
+	createdAt: timestamp("created_at")
+		.$defaultFn(() => new Date())
+		.notNull(),
+});
+
+export const verifications = pgTable("verifications", {
+	id: text("id").primaryKey(),
+	identifier: text("identifier").notNull(),
+	value: text("value").notNull(),
+	expiresAt: timestamp("expires_at").notNull(),
+	createdAt: timestamp("created_at").$defaultFn(
+		() => /* @__PURE__ */ new Date(),
+	),
+	updatedAt: timestamp("updated_at").$defaultFn(
+		() => /* @__PURE__ */ new Date(),
+	),
+}).enableRLS();
-- 
cgit v1.3.1