]> Untitled Git - lemmy.git/blob - migrations/2020-12-03-035643_create_user_aggregates/down.sql
improve admin and mod check to not do seq scans and return unnecessary data (#3483)
[lemmy.git] / migrations / 2020-12-03-035643_create_user_aggregates / down.sql
1 -- User aggregates
2 drop table user_aggregates;
3 drop trigger user_aggregates_user on user_;
4 drop trigger user_aggregates_post_count on post;
5 drop trigger user_aggregates_post_score on post_like;
6 drop trigger user_aggregates_comment_count on comment;
7 drop trigger user_aggregates_comment_score on comment_like;
8 drop function 
9   user_aggregates_user, 
10   user_aggregates_post_count,
11   user_aggregates_post_score,
12   user_aggregates_comment_count,
13   user_aggregates_comment_score;