diff options
| author | Dessalines <tyhou13@gmx.com> | 2019-04-21 13:52:55 -0700 |
|---|---|---|
| committer | Dessalines <tyhou13@gmx.com> | 2019-04-21 13:52:55 -0700 |
| commit | 016920aeb7dc47f32412829c70b872c54caf10e3 (patch) | |
| tree | 4bb62c262bec180514fa7631a9b2416046c76edb /server/migrations | |
| parent | 273a38f61f03b4e1316ff2a0a75607dc77aaaf44 (diff) | |
Community moderation fixes.
- Don't show banned communities on main post list. Fixes #95
- Add back in community moderation and editing. Fixes #92
Diffstat (limited to 'server/migrations')
| -rw-r--r-- | server/migrations/2019-03-30-212058_create_post_view/up.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/server/migrations/2019-03-30-212058_create_post_view/up.sql b/server/migrations/2019-03-30-212058_create_post_view/up.sql index 17dc8604..4a4fd146 100644 --- a/server/migrations/2019-03-30-212058_create_post_view/up.sql +++ b/server/migrations/2019-03-30-212058_create_post_view/up.sql @@ -16,6 +16,7 @@ with all_post as p.*, (select name from user_ where p.creator_id = user_.id) as creator_name, (select name from community where p.community_id = community.id) as community_name, + (select removed from community c where p.community_id = c.id) as community_removed, (select count(*) from comment where comment.post_id = p.id) as number_of_comments, coalesce(sum(pl.score), 0) as score, count (case when pl.score = 1 then 1 else null end) as upvotes, |