From 566486fbd98f81d81c266cda4c9750afa207dc7e Mon Sep 17 00:00:00 2001 From: MohamedBassem 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