3 ADD COLUMN enable_downvotes boolean DEFAULT TRUE NOT NULL;
6 ADD COLUMN open_registration boolean DEFAULT TRUE NOT NULL;
9 ADD COLUMN enable_nsfw boolean DEFAULT TRUE NOT NULL;
14 CREATE VIEW site_view AS
23 s.creator_id = u.id) AS creator_name,
28 user_) AS number_of_users,
33 post) AS number_of_posts,
38 comment) AS number_of_comments,
43 community) AS number_of_communities