diff options
Diffstat (limited to 'db/096to097.sql')
-rw-r--r-- | db/096to097.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/db/096to097.sql b/db/096to097.sql index 38e4e958b..4171e9589 100644 --- a/db/096to097.sql +++ b/db/096to097.sql @@ -5,3 +5,6 @@ alter table notice add index notice_created_id_is_local_idx (created,id,is_local -- Allows sorting tag-filtered public timeline by timestamp efficiently alter table notice_tag add index notice_tag_tag_created_notice_id_idx (tag, created, notice_id); + +-- Needed for sorting reply/mentions timelines +alter table reply add index reply_profile_id_modified_notice_id_idx (profile_id, modified, notice_id); |