feature: Add support for storing and previewing raw notes

1 files changed, 13 insertions, 0 deletions

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),
 }));