5 DROP COLUMN enable_downvotes;
8 DROP COLUMN open_registration;
11 DROP COLUMN enable_nsfw;
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