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

   1 -- Drop views
   2 drop view if exists
   3 comment_aggregates_view,
   4 comment_fast_view,
   5 comment_report_view,
   6 comment_view,
   7 community_aggregates_view,
   8 community_fast_view,
   9 community_follower_view,
  10 community_moderator_view,
  11 community_user_ban_view,
  12 community_view,
  13 mod_add_community_view,
  14 mod_add_view,
  15 mod_ban_from_community_view,
  16 mod_ban_view,
  17 mod_lock_post_view,
  18 mod_remove_comment_view,
  19 mod_remove_community_view,
  20 mod_remove_post_view,
  21 mod_sticky_post_view,
  22 post_aggregates_view,
  23 post_fast_view,
  24 post_report_view,
  25 post_view,
  26 private_message_view,
  27 reply_fast_view,
  28 site_view,
  29 user_mention_fast_view,
  30 user_mention_view,
  31 user_view
  32 cascade;
  33
  34 -- Drop fast tables
  35 drop table if exists
  36 comment_aggregates_fast,
  37 community_aggregates_fast,
  38 post_aggregates_fast,
  39 user_fast
  40 cascade;
  41