1 -- create enum for registration modes
2 create type registration_mode_enum as enum
3 ('closed', 'require_application', 'open');
5 -- use this enum for registration mode setting
6 alter table local_site add column
7 registration_mode registration_mode_enum not null default 'require_application';
9 -- generate registration mode value from previous settings
11 select open_registration, require_application,
13 when open_registration=false then 'closed'::registration_mode_enum
14 when open_registration=true and require_application=true then 'require_application'
20 set registration_mode = subquery.case
23 -- drop old registration settings
24 alter table local_site drop column open_registration;
25 alter table local_site drop column require_application;