]> Untitled Git - lemmy.git/blob - migrations/2020-12-02-152437_create_site_aggregates/down.sql
Report only local counts in site_view.
[lemmy.git] / migrations / 2020-12-02-152437_create_site_aggregates / down.sql
1 -- Site aggregates
2 drop table site_aggregates;
3 drop trigger site_aggregates_site on site;
4 drop trigger site_aggregates_user_insert on user_;
5 drop trigger site_aggregates_user_delete on user_;
6 drop trigger site_aggregates_post_insert on post;
7 drop trigger site_aggregates_post_delete on post;
8 drop trigger site_aggregates_comment_insert on comment;
9 drop trigger site_aggregates_comment_delete on comment;
10 drop trigger site_aggregates_community_insert on community;
11 drop trigger site_aggregates_community_delete on community;
12 drop function 
13   site_aggregates_site,
14   site_aggregates_user_insert,
15   site_aggregates_user_delete,
16   site_aggregates_post_insert,
17   site_aggregates_post_delete,
18   site_aggregates_comment_insert,
19   site_aggregates_comment_delete,
20   site_aggregates_community_insert,
21   site_aggregates_community_delete;