From 3143baac875a19a6598100a41db06ea9b162bf3c Mon Sep 17 00:00:00 2001 From: codetorso Date: Sat, 29 Jun 2024 07:02:27 +0530 Subject: User Canvas (1/2) --- apps/web/server/db/schema.ts | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) (limited to 'apps/web/server') 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; -- cgit v1.2.3