]> Untitled Git - lemmy.git/blob - migrations/2023-04-23-164732_add_person_details_indexes/down.sql
Optimize hot rank updates (#3617)
[lemmy.git] / migrations / 2023-04-23-164732_add_person_details_indexes / down.sql
1 drop index idx_person_lower_name;
2 drop index idx_community_lower_name;
3 drop index idx_community_moderator_published;
4 drop index idx_community_moderator_community;
5 drop index idx_community_moderator_person;
6 drop index idx_comment_saved_comment;
7 drop index idx_comment_saved_person;
8 drop index idx_community_block_community;
9 drop index idx_community_block_person;
10 drop index idx_community_follower_community;
11 drop index idx_community_follower_person;
12 drop index idx_person_block_person;
13 drop index idx_person_block_target;
14 drop index idx_post_language;
15 drop index idx_comment_language;
16 drop index idx_person_aggregates_person;
17 drop index idx_person_post_aggregates_post;
18 drop index idx_person_post_aggregates_person;
19 drop index idx_comment_reply_comment;
20 drop index idx_comment_reply_recipient;
21 drop index idx_comment_reply_published;