migrations/20251229_legacy_login_security.sql at 2fe3a324f4bd3b5ef69fb8276acb22e87ab7b1f2 · lewis.moe/bspds-sandbox

lewis.moe / bspds-sandbox

this repo has no description

bspds-sandbox / migrations / 20251229_legacy_login_security.sql

at 2fe3a324f4bd3b5ef69fb8276acb22e87ab7b1f2 419 B view raw

1ALTER TABLE users ADD COLUMN allow_legacy_login BOOLEAN NOT NULL DEFAULT TRUE;
2
3ALTER TABLE session_tokens ADD COLUMN mfa_verified BOOLEAN NOT NULL DEFAULT FALSE;
4ALTER TABLE session_tokens ADD COLUMN legacy_login BOOLEAN NOT NULL DEFAULT FALSE;
5
6CREATE INDEX idx_session_tokens_legacy ON session_tokens(did, legacy_login) WHERE legacy_login = TRUE;
7
8ALTER TYPE comms_type ADD VALUE IF NOT EXISTS 'legacy_login_alert';