From 19c67633956760096a49275a161f29ca2f6537c0 Mon Sep 17 00:00:00 2001 From: MohamedBassem Date: Sun, 17 Mar 2024 13:13:46 +0000 Subject: db: Create an index on bookmarks.createdAt field given the use in pagination --- packages/db/schema.ts | 1 + 1 file changed, 1 insertion(+) (limited to 'packages/db/schema.ts') diff --git a/packages/db/schema.ts b/packages/db/schema.ts index 69101c09..6063fccc 100644 --- a/packages/db/schema.ts +++ b/packages/db/schema.ts @@ -116,6 +116,7 @@ export const bookmarks = sqliteTable("bookmarks", { userIdIdx: index("bookmarks_userId_idx").on(b.userId), archivedIdx: index("bookmarks_archived_idx").on(b.archived), favIdx: index("bookmarks_favourited_idx").on(b.favourited), + createdAtIdx: index("bookmarks_createdAt_idx").on(b.createdAt), })); export const bookmarkLinks = sqliteTable("bookmarkLinks", { -- cgit v1.2.3-70-g09d2