1 -- Add back site columns
3 ADD COLUMN enable_downvotes boolean DEFAULT TRUE NOT NULL,
4 ADD COLUMN open_registration boolean DEFAULT TRUE NOT NULL,
5 ADD COLUMN enable_nsfw boolean DEFAULT TRUE NOT NULL,
6 ADD COLUMN community_creation_admin_only boolean DEFAULT FALSE NOT NULL,
7 ADD COLUMN require_email_verification boolean DEFAULT FALSE NOT NULL,
8 ADD COLUMN require_application boolean DEFAULT TRUE NOT NULL,
9 ADD COLUMN application_question text DEFAULT 'to verify that you are human, please explain why you want to create an account on this site'::text,
10 ADD COLUMN private_instance boolean DEFAULT FALSE NOT NULL,
11 ADD COLUMN default_theme text DEFAULT 'browser'::text NOT NULL,
12 ADD COLUMN default_post_listing_type text DEFAULT 'Local'::text NOT NULL,
13 ADD COLUMN legal_information text,
14 ADD COLUMN hide_modlog_mod_names boolean DEFAULT TRUE NOT NULL,
15 ADD COLUMN application_email_admins boolean DEFAULT FALSE NOT NULL;
17 -- Insert the data back from local_site
21 enable_downvotes = ls.enable_downvotes,
22 open_registration = ls.open_registration,
23 enable_nsfw = ls.enable_nsfw,
24 community_creation_admin_only = ls.community_creation_admin_only,
25 require_email_verification = ls.require_email_verification,
26 require_application = ls.require_application,
27 application_question = ls.application_question,
28 private_instance = ls.private_instance,
29 default_theme = ls.default_theme,
30 default_post_listing_type = ls.default_post_listing_type,
31 legal_information = ls.legal_information,
32 hide_modlog_mod_names = ls.hide_modlog_mod_names,
33 application_email_admins = ls.application_email_admins,
34 published = ls.published,
42 community_creation_admin_only,
43 require_email_verification,
48 default_post_listing_type,
50 hide_modlog_mod_names,
51 application_email_admins,
59 -- drop instance columns
61 DROP COLUMN instance_id;
64 DROP COLUMN instance_id;
67 DROP COLUMN instance_id;
69 DROP TABLE local_site_rate_limit;
71 DROP TABLE local_site;
73 DROP TABLE federation_allowlist;
75 DROP TABLE federation_blocklist;