1 -- add back old registration columns
3 ADD COLUMN open_registration boolean NOT NULL DEFAULT TRUE;
6 ADD COLUMN require_application boolean NOT NULL DEFAULT TRUE;
8 -- regenerate their values
12 CASE WHEN registration_mode = 'closed' THEN
22 open_registration = subquery.case
29 CASE WHEN registration_mode = 'open' THEN
39 require_application = subquery.case
43 -- drop new column and type
44 ALTER TABLE local_site
45 DROP COLUMN registration_mode;
47 DROP TYPE registration_mode_enum;