migrations/202512212100_password_reset.sql at 45f7f2c14c227bc9e573ca1284b3673b796825db · lewis.moe/bspds-sandbox

lewis.moe / bspds-sandbox

this repo has no description

bspds-sandbox / migrations / 202512212100_password_reset.sql

at 45f7f2c14c227bc9e573ca1284b3673b796825db 283 B view raw

1ALTER TABLE users ADD COLUMN IF NOT EXISTS password_reset_code TEXT;
2ALTER TABLE users ADD COLUMN IF NOT EXISTS password_reset_code_expires_at TIMESTAMPTZ;
3
4CREATE INDEX IF NOT EXISTS idx_users_password_reset_code ON users(password_reset_code) WHERE password_reset_code IS NOT NULL;