User Canvas (1/2)

1 files changed, 19 insertions, 0 deletions

diff --git a/apps/web/server/db/schema.ts b/apps/web/server/db/schema.ts
index 69372a35..c40e50f1 100644
--- a/apps/web/server/db/schema.ts
+++ b/apps/web/server/db/schema.ts
@@ -198,5 +198,24 @@ export const chatHistory = createTable(
   }),
 );
 
+export const canvas = createTable(
+  "canvas",
+  {
+    id: text("id")
+      .notNull()
+      .primaryKey()
+      .$defaultFn(() => crypto.randomUUID()),
+    title: text("title").default("Untitled").notNull(),
+    description: text("description").default("Untitled").notNull(),
+    imageUrl: text("url").default("").notNull(),
+    userId: text("userId")
+      .notNull()
+      .references(() => users.id, { onDelete: "cascade" }),
+  },
+  (canvas) => ({
+    userIdx: index("canvas_user_userId").on(canvas.userId),
+  }),
+);
+
 export type ChatThread = typeof chatThreads.$inferSelect;
 export type ChatHistory = typeof chatHistory.$inferSelect;