diff options
Diffstat (limited to 'backend/db/schema.sql')
| -rw-r--r-- | backend/db/schema.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/backend/db/schema.sql b/backend/db/schema.sql index 07ac72d..2596c84 100644 --- a/backend/db/schema.sql +++ b/backend/db/schema.sql @@ -37,3 +37,5 @@ CREATE INDEX IF NOT EXISTS idx_articles_is_read ON articles(is_read); CREATE INDEX IF NOT EXISTS idx_articles_guid ON articles(guid); CREATE INDEX IF NOT EXISTS idx_feeds_user_id ON feeds(user_id); + +CREATE INDEX IF NOT EXISTS idx_articles_feed_read_id ON articles(feed_id, is_read, id DESC); |