diff options
| author | MohamedBassem <me@mbassem.com> | 2024-03-16 01:02:32 +0000 |
|---|---|---|
| committer | MohamedBassem <me@mbassem.com> | 2024-03-16 01:02:32 +0000 |
| commit | 566486fbd98f81d81c266cda4c9750afa207dc7e (patch) | |
| tree | 5801fa480ee66cec5fd1e62b7bde27d0827934ba /packages/db/drizzle/0008_cloudy_skin.sql | |
| parent | 002d6fcabed32258cba29d71e6d3963aca629fe2 (diff) | |
| download | karakeep-566486fbd98f81d81c266cda4c9750afa207dc7e.tar.zst | |
db: Add missing indicies on db
Diffstat (limited to 'packages/db/drizzle/0008_cloudy_skin.sql')
| -rw-r--r-- | packages/db/drizzle/0008_cloudy_skin.sql | 10 |
1 files changed, 10 insertions, 0 deletions
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 |