From 3208dda3848ad739f54cebf44c423e2b68e85b2d Mon Sep 17 00:00:00 2001
From: MohamedBassem <me@mbassem.com>
Date: Wed, 28 Feb 2024 20:45:28 +0000
Subject: feature: Add support for storing and previewing raw notes

---
 packages/db/schema.ts | 13 +++++++++++++
 1 file changed, 13 insertions(+)

(limited to 'packages/db/schema.ts')

diff --git a/packages/db/schema.ts b/packages/db/schema.ts
index 94467c56..4acd86c4 100644
--- a/packages/db/schema.ts
+++ b/packages/db/schema.ts
@@ -125,6 +125,15 @@ export const bookmarkLinks = sqliteTable("bookmarkLinks", {
   crawledAt: integer("crawledAt", { mode: "timestamp" }),
 });
 
+export const bookmarkTexts = sqliteTable("bookmarkTexts", {
+  id: text("id")
+    .notNull()
+    .primaryKey()
+    .$defaultFn(() => createId())
+    .references(() => bookmarks.id, { onDelete: "cascade" }),
+  text: text("text"),
+});
+
 export const bookmarkTags = sqliteTable(
   "bookmarkTags",
   {
@@ -179,6 +188,10 @@ export const bookmarkRelations = relations(bookmarks, ({ many, one }) => ({
     fields: [bookmarks.id],
     references: [bookmarkLinks.id],
   }),
+  text: one(bookmarkTexts, {
+    fields: [bookmarks.id],
+    references: [bookmarkTexts.id],
+  }),
   tagsOnBookmarks: many(tagsOnBookmarks),
 }));
 
-- 
cgit v1.2.3-70-g09d2