1 -- Add columns to site table
2 alter table site add column require_application boolean not null default false;
3 alter table site add column application_question text;
4 alter table site add column private_instance boolean not null default false;
6 -- Add pending to local_user
7 alter table local_user add column accepted_application boolean not null default false;
9 create table registration_application (
10 id serial primary key,
11 local_user_id int references local_user on update cascade on delete cascade not null,
13 admin_id int references person on update cascade on delete cascade,
15 published timestamp not null default now(),
19 create index idx_registration_application_published on registration_application (published desc);