migrations/2020-12-17-031053_remove_fast_tables_and_views/up.sql

   1 -- Drop triggers
   2 drop trigger if exists refresh_comment on comment;
   3 drop trigger if exists refresh_comment_like on comment_like;
   4 drop trigger if exists refresh_community on community;
   5 drop trigger if exists refresh_community_follower on community_follower;
   6 drop trigger if exists refresh_community_user_ban on community_user_ban;
   7 drop trigger if exists refresh_post on post;
   8 drop trigger if exists refresh_post_like on post_like;
   9 drop trigger if exists refresh_user on user_;
  10
  11 -- Drop functions
  12 drop function if exists
  13 refresh_comment,
  14 refresh_comment_like,
  15 refresh_community,
  16 refresh_community_follower,
  17 refresh_community_user_ban,
  18 refresh_post,
  19 refresh_post_like,
  20 refresh_private_message,
  21 refresh_user
  22 cascade;
  23
  24 -- Drop views
  25 drop view if exists
  26 comment_aggregates_view,
  27 comment_fast_view,
  28 comment_report_view,
  29 comment_view,
  30 community_aggregates_view,
  31 community_fast_view,
  32 community_follower_view,
  33 community_moderator_view,
  34 community_user_ban_view,
  35 community_view,
  36 mod_add_community_view,
  37 mod_add_view,
  38 mod_ban_from_community_view,
  39 mod_ban_view,
  40 mod_lock_post_view,
  41 mod_remove_comment_view,
  42 mod_remove_community_view,
  43 mod_remove_post_view,
  44 mod_sticky_post_view,
  45 post_aggregates_view,
  46 post_fast_view,
  47 post_report_view,
  48 post_view,
  49 private_message_view,
  50 reply_fast_view,
  51 site_view,
  52 user_mention_fast_view,
  53 user_mention_view,
  54 user_view
  55 cascade;
  56
  57 -- Drop fast tables
  58 drop table if exists
  59 comment_aggregates_fast,
  60 community_aggregates_fast,
  61 post_aggregates_fast,
  62 user_fast
  63 cascade;
  64