diff options
author | Benjamin Brahmer <info@b-brahmer.de> | 2020-02-29 08:33:54 +0100 |
---|---|---|
committer | GitHub <noreply@github.com> | 2020-02-29 08:33:54 +0100 |
commit | ca3ac1075ac9a80d08a1828ad9fed58c597d5ed6 (patch) | |
tree | 3dbba8df7ce8bc1bc3a5decfb46bb9cb6989272e | |
parent | 61304e54583ed2c1d2a0efaba9ff1658368dbe38 (diff) | |
parent | 7121e559c544154af2393e083b05add9dad4b061 (diff) |
Merge pull request #637 from marco44/index_improvements
Index improvements
-rw-r--r-- | appinfo/database.xml | 33 |
1 files changed, 28 insertions, 5 deletions
diff --git a/appinfo/database.xml b/appinfo/database.xml index adc8f197a..d210d3f45 100644 --- a/appinfo/database.xml +++ b/appinfo/database.xml @@ -402,28 +402,51 @@ </index> <index> - <name>news_items_feed_id_index</name> + <name>news_items_fingerprint_idx</name> + <field> + <name>fingerprint</name> + </field> + </index> + + <index> + <name>news_items_item_guid</name> + <field> + <name>guid_hash</name> + </field> <field> <name>feed_id</name> </field> </index> <index> - <name>news_items_fingerprint_idx</name> + <name>news_items_unread_feed_id</name> <field> - <name>fingerprint</name> + <name>unread</name> + </field> + <field> + <name>feed_id</name> </field> </index> <index> - <name>news_items_item_guid</name> + <name>news_items_starred_feed_id</name> <field> - <name>guid_hash</name> + <name>starred</name> </field> <field> <name>feed_id</name> </field> </index> + + <index> + <name>news_items_unread_id</name> + <field> + <name>unread</name> + </field> + <field> + <name>id</name> + </field> + </index> </declaration> </table> </database> |