diff options
| author | MohamedBassem <me@mbassem.com> | 2024-03-17 13:13:46 +0000 |
|---|---|---|
| committer | MohamedBassem <me@mbassem.com> | 2024-03-17 13:13:46 +0000 |
| commit | 19c67633956760096a49275a161f29ca2f6537c0 (patch) | |
| tree | abaa4456c996730a81703382865e6f3e43ed5157 /packages/db/schema.ts | |
| parent | fc8eb79b98bbea558bd614dc71dd66b72ab9b0c0 (diff) | |
| download | karakeep-19c67633956760096a49275a161f29ca2f6537c0.tar.zst | |
db: Create an index on bookmarks.createdAt field given the use in pagination
Diffstat (limited to 'packages/db/schema.ts')
| -rw-r--r-- | packages/db/schema.ts | 1 |
1 files changed, 1 insertions, 0 deletions
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", { |