Update sorting on reply/mentions timeline: added reply_profile_id_modified_notice_id_...

[quix0rs-gnu-social.git] / db / 096to097.sql

diff --git a/db/096to097.sql b/db/096to097.sql
index 38e4e958b8e888b79dcdd1f4920d692a9a32eb98..4171e95897e7f05701abd393896a6d0203b25c13 100644 (file)
--- 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);