5 DROP COLUMN show_avatars;
8 DROP COLUMN send_notifications_to_email;
11 CREATE VIEW user_view AS
27 p.creator_id = u.id) AS number_of_posts,
30 coalesce(sum(score), 0)
36 AND p.id = pl.post_id) AS post_score,
43 c.creator_id = u.id) AS number_of_comments,
46 coalesce(sum(score), 0)
52 AND c.id = cl.comment_id) AS comment_score