1 -- create enum for registration modes
2 CREATE TYPE registration_mode_enum AS enum (
8 -- use this enum for registration mode setting
10 ADD COLUMN registration_mode registration_mode_enum NOT NULL DEFAULT 'require_application';
12 -- generate registration mode value from previous settings
17 CASE WHEN open_registration = FALSE THEN
18 'closed'::registration_mode_enum
19 WHEN open_registration = TRUE
20 AND require_application = TRUE THEN
30 registration_mode = subquery.case
34 -- drop old registration settings
35 ALTER TABLE local_site
36 DROP COLUMN open_registration;
38 ALTER TABLE local_site
39 DROP COLUMN require_application;