Adding site aggregates unit test.

[lemmy.git] / migrations / 2020-12-03-035643_create_user_aggregates / up.sql

diff --git a/migrations/2020-12-03-035643_create_user_aggregates/up.sql b/migrations/2020-12-03-035643_create_user_aggregates/up.sql
index bc7e6394d11f2210b00257ca6e9f6981bd7a4a9e..e0c39be60176d5d1035dddd90c8a95f355382807 100644 (file)
--- a/migrations/2020-12-03-035643_create_user_aggregates/up.sql
+++ b/migrations/2020-12-03-035643_create_user_aggregates/up.sql
@@ -52,6 +52,7 @@ end $$;
 
 create trigger user_aggregates_post_count
 after insert or delete on post
+for each row
 execute procedure user_aggregates_post_count();
 
 -- post score
@@ -77,6 +78,7 @@ end $$;
 
 create trigger user_aggregates_post_score
 after insert or delete on post_like
+for each row
 execute procedure user_aggregates_post_score();
 
 -- comment count
@@ -96,6 +98,7 @@ end $$;
 
 create trigger user_aggregates_comment_count
 after insert or delete on comment
+for each row
 execute procedure user_aggregates_comment_count();
 
 -- comment score