Adding site aggregates unit test.

[lemmy.git] / migrations / 2020-12-04-183345_create_community_aggregates / up.sql

diff --git a/migrations/2020-12-04-183345_create_community_aggregates/up.sql b/migrations/2020-12-04-183345_create_community_aggregates/up.sql
index ec95181917b57dedc232c603aa0adbb508d4d366..34274b0d9621db1d04ee1c2fa173faab3eb1a83f 100644 (file)
--- a/migrations/2020-12-04-183345_create_community_aggregates/up.sql
+++ b/migrations/2020-12-04-183345_create_community_aggregates/up.sql
@@ -50,6 +50,7 @@ end $$;
 
 create trigger community_aggregates_post_count
 after insert or delete on post
+for each row
 execute procedure community_aggregates_post_count();
 
 -- comment count
@@ -69,6 +70,7 @@ end $$;
 
 create trigger community_aggregates_comment_count
 after insert or delete on comment
+for each row
 execute procedure community_aggregates_comment_count();
 
 -- subscriber count
@@ -88,5 +90,6 @@ end $$;
 
 create trigger community_aggregates_subscriber_count
 after insert or delete on community_follower
+for each row
 execute procedure community_aggregates_subscriber_count();