From 566486fbd98f81d81c266cda4c9750afa207dc7e Mon Sep 17 00:00:00 2001
From: MohamedBassem <me@mbassem.com>
Date: Sat, 16 Mar 2024 01:02:32 +0000
Subject: db: Add missing indicies on db

---
 packages/db/drizzle/0008_cloudy_skin.sql | 10 ++++++++++
 1 file changed, 10 insertions(+)
 create mode 100644 packages/db/drizzle/0008_cloudy_skin.sql

(limited to 'packages/db/drizzle/0008_cloudy_skin.sql')

diff --git a/packages/db/drizzle/0008_cloudy_skin.sql b/packages/db/drizzle/0008_cloudy_skin.sql
new file mode 100644
index 00000000..6fb80fb0
--- /dev/null
+++ b/packages/db/drizzle/0008_cloudy_skin.sql
@@ -0,0 +1,10 @@
+CREATE INDEX `bookmarkLists_userId_idx` ON `bookmarkLists` (`userId`);--> statement-breakpoint
+CREATE INDEX `bookmarkTags_name_idx` ON `bookmarkTags` (`name`);--> statement-breakpoint
+CREATE INDEX `bookmarkTags_userId_idx` ON `bookmarkTags` (`userId`);--> statement-breakpoint
+CREATE INDEX `bookmarks_userId_idx` ON `bookmarks` (`userId`);--> statement-breakpoint
+CREATE INDEX `bookmarks_archived_idx` ON `bookmarks` (`archived`);--> statement-breakpoint
+CREATE INDEX `bookmarks_favourited_idx` ON `bookmarks` (`favourited`);--> statement-breakpoint
+CREATE INDEX `bookmarksInLists_bookmarkId_idx` ON `bookmarksInLists` (`bookmarkId`);--> statement-breakpoint
+CREATE INDEX `bookmarksInLists_listId_idx` ON `bookmarksInLists` (`listId`);--> statement-breakpoint
+CREATE INDEX `tagsOnBookmarks_tagId_idx` ON `tagsOnBookmarks` (`bookmarkId`);--> statement-breakpoint
+CREATE INDEX `tagsOnBookmarks_bookmarkId_idx` ON `tagsOnBookmarks` (`bookmarkId`);
\ No newline at end of file
-- 
cgit v1.2.3-70-g09d2

