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

27 lines
1.5 KiB
MySQL
Raw Permalink Normal View History

-- Drop triggers
DROP TRIGGER IF EXISTS refresh_comment ON comment;
DROP TRIGGER IF EXISTS refresh_comment_like ON comment_like;
DROP TRIGGER IF EXISTS refresh_community ON community;
DROP TRIGGER IF EXISTS refresh_community_follower ON community_follower;
DROP TRIGGER IF EXISTS refresh_community_user_ban ON community_user_ban;
DROP TRIGGER IF EXISTS refresh_post ON post;
DROP TRIGGER IF EXISTS refresh_post_like ON post_like;
DROP TRIGGER IF EXISTS refresh_user ON user_;
-- Drop functions
DROP FUNCTION IF EXISTS refresh_comment, refresh_comment_like, refresh_community, refresh_community_follower, refresh_community_user_ban, refresh_post, refresh_post_like, refresh_private_message, refresh_user CASCADE;
2020-12-17 03:42:25 +00:00
-- Drop views
DROP VIEW IF EXISTS comment_aggregates_view, comment_fast_view, comment_report_view, comment_view, community_aggregates_view, community_fast_view, community_follower_view, community_moderator_view, community_user_ban_view, community_view, mod_add_community_view, mod_add_view, mod_ban_from_community_view, mod_ban_view, mod_lock_post_view, mod_remove_comment_view, mod_remove_community_view, mod_remove_post_view, mod_sticky_post_view, post_aggregates_view, post_fast_view, post_report_view, post_view, private_message_view, reply_fast_view, site_view, user_mention_fast_view, user_mention_view, user_view CASCADE;
2020-12-17 03:42:25 +00:00
-- Drop fast tables
DROP TABLE IF EXISTS comment_aggregates_fast, community_aggregates_fast, post_aggregates_fast, user_fast CASCADE;
2020-12-17 03:42:25 +00:00