3 ADD COLUMN show_avatars boolean DEFAULT TRUE NOT NULL;
6 ADD COLUMN send_notifications_to_email boolean DEFAULT FALSE NOT NULL;
8 -- Rebuild the user_view
11 CREATE VIEW user_view AS
21 send_notifications_to_email,
29 p.creator_id = u.id) AS number_of_posts,
32 coalesce(sum(score), 0)
38 AND p.id = pl.post_id) AS post_score,
45 c.creator_id = u.id) AS number_of_comments,
48 coalesce(sum(score), 0)
54 AND c.id = cl.comment_id) AS comment_score