]> Untitled Git - lemmy.git/blob - migrations/2023-07-19-163511_comment_sort_hot_rank_then_score/down.sql
Revert "Attempt to fix CI building wrong commits (#3830)"
[lemmy.git] / migrations / 2023-07-19-163511_comment_sort_hot_rank_then_score / down.sql
1 DROP INDEX idx_comment_aggregates_hot, idx_comment_aggregates_score;
2
3 CREATE INDEX idx_comment_aggregates_hot ON comment_aggregates (hot_rank DESC, published DESC);
4
5 CREATE INDEX idx_comment_aggregates_score ON comment_aggregates (score DESC, published DESC);
6