canape/migrations/0005__user_activation.up.sql

4 lines
141 B
SQL

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