ALTER TABLE users ADD COLUMN activated boolean NOT NULL DEFAULT false; UPDATE users SET activated = true; CREATE INDEX ON users (activated);