1 -- Add columns to site table
3 ADD COLUMN require_application boolean NOT NULL DEFAULT FALSE;
6 ADD COLUMN application_question text;
9 ADD COLUMN private_instance boolean NOT NULL DEFAULT FALSE;
11 -- Add pending to local_user
12 ALTER TABLE local_user
13 ADD COLUMN accepted_application boolean NOT NULL DEFAULT FALSE;
15 CREATE TABLE registration_application (
16 id serial PRIMARY KEY,
17 local_user_id int REFERENCES local_user ON UPDATE CASCADE ON DELETE CASCADE NOT NULL,
19 admin_id int REFERENCES person ON UPDATE CASCADE ON DELETE CASCADE,
21 published timestamp NOT NULL DEFAULT now(),
22 UNIQUE (local_user_id)
25 CREATE INDEX idx_registration_application_published ON registration_application (published DESC);