vicwalker.dev.br / tranquil-pds
forked from tranquil.farm/tranquil-pds
Our Personal Data Server from scratch!
0
fork

Configure Feed

Select the types of activity you want to include in your feed.

tranquil-pds / migrations / 20251229_legacy_login_security.sql
at d1902506a592df31497ba6f79afedf57e8452da3 8 lines 419 B view raw
lu5a.myatproto.social Security improvements
d80247ba
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';