2 alter table site add column enable_downvotes boolean default true not null;
3 alter table site add column open_registration boolean default true not null;
4 alter table site add column enable_nsfw boolean default true not null;
9 create view site_view as
11 (select name from user_ u where s.creator_id = u.id) as creator_name,
12 (select count(*) from user_) as number_of_users,
13 (select count(*) from post) as number_of_posts,
14 (select count(*) from comment) as number_of_comments,
15 (select count(*) from community) as number_of_communities