migrations/2023-04-23-164732_add_person_details_indexes/down.sql

   1 DROP INDEX idx_person_lower_name;
   2
   3 DROP INDEX idx_community_lower_name;
   4
   5 DROP INDEX idx_community_moderator_published;
   6
   7 DROP INDEX idx_community_moderator_community;
   8
   9 DROP INDEX idx_community_moderator_person;
  10
  11 DROP INDEX idx_comment_saved_comment;
  12
  13 DROP INDEX idx_comment_saved_person;
  14
  15 DROP INDEX idx_community_block_community;
  16
  17 DROP INDEX idx_community_block_person;
  18
  19 DROP INDEX idx_community_follower_community;
  20
  21 DROP INDEX idx_community_follower_person;
  22
  23 DROP INDEX idx_person_block_person;
  24
  25 DROP INDEX idx_person_block_target;
  26
  27 DROP INDEX idx_post_language;
  28
  29 DROP INDEX idx_comment_language;
  30
  31 DROP INDEX idx_person_aggregates_person;
  32
  33 DROP INDEX idx_person_post_aggregates_post;
  34
  35 DROP INDEX idx_person_post_aggregates_person;
  36
  37 DROP INDEX idx_comment_reply_comment;
  38
  39 DROP INDEX idx_comment_reply_recipient;
  40
  41 DROP INDEX idx_comment_reply_published;
  42