trading-platform-database-v2/ddl/schemas/llm
Adrian Flores Cortes 82d6e608b1 [ST-4.1] feat: Add optimized partial index for auth.users.locked_until
- Create migration 2026-02-03_add_auth_locked_index.sql
- Add partial index on locked_until with active lockout condition
- Replace previous generic locked_until index with optimized version
- Index filters for locked_until IS NOT NULL AND locked_until > NOW()
- Improves query performance for account unlock validation
- Resolves GAP-009

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
2026-02-03 23:56:26 -06:00
..
tables [ST-4.1] feat: Add optimized partial index for auth.users.locked_until 2026-02-03 23:56:26 -06:00
00-enums.sql feat: Initial commit - Database schemas and scripts 2026-01-18 04:30:23 -06:00
00-extensions.sql feat: Initial commit - Database schemas and scripts 2026-01-18 04:30:23 -06:00