1 files changed, 4 insertions, 0 deletions
diff --git a/packages/db/schema.ts b/packages/db/schema.ts
index e323c25f..fa0777f4 100644
--- a/packages/db/schema.ts
+++ b/packages/db/schema.ts
@@ -147,6 +147,10 @@ export const bookmarkLinks = sqliteTable("bookmarkLinks", {
   crawlStatus: text("crawlStatus", {
     enum: ["pending", "failure", "success"],
   }).default("pending"),
+}, (bl) => {
+  return {
+    urlIdx: index("bookmarkLinks_url_idx").on(bl.url),
+  };
 });
 
 export const bookmarkTexts = sqliteTable("bookmarkTexts", {