1 -- use defaults from db for local user init
3 ALTER COLUMN theme SET DEFAULT 'browser';
6 ALTER COLUMN default_listing_type SET DEFAULT 2;
8 -- add tables and columns for optional email verification
10 ADD COLUMN require_email_verification boolean NOT NULL DEFAULT FALSE;
12 ALTER TABLE local_user
13 ADD COLUMN email_verified boolean NOT NULL DEFAULT FALSE;
15 CREATE TABLE email_verification (
16 id serial PRIMARY KEY,
17 local_user_id int REFERENCES local_user (id) ON UPDATE CASCADE ON DELETE CASCADE NOT NULL,
19 verification_token text NOT NULL