migrations/20251225_passwordless_accounts.sql at main · lewis.moe/bspds-sandbox

lewis.moe / bspds-sandbox

this repo has no description

bspds-sandbox / migrations / 20251225_passwordless_accounts.sql

at main 367 B view raw

1ALTER TABLE users ALTER COLUMN password_hash DROP NOT NULL;
2ALTER TABLE users ADD COLUMN password_required BOOLEAN NOT NULL DEFAULT TRUE;
3ALTER TABLE users ADD COLUMN recovery_token TEXT;
4ALTER TABLE users ADD COLUMN recovery_token_expires_at TIMESTAMPTZ;
5CREATE INDEX IF NOT EXISTS idx_users_recovery_token ON users(recovery_token) WHERE recovery_token IS NOT NULL;