mk6i-open-oscar-server/state/migrations/0005_user_settings.up.sql

ALTER TABLE users
    ADD COLUMN confirmStatus     BOOL DEFAULT FALSE;
ALTER TABLE users
    ADD COLUMN emailAddress      VARCHAR(320) NOT NULL DEFAULT '';
ALTER TABLE users
    ADD COLUMN regStatus         INT NOT NULL DEFAULT 3;