rckrdmrd/trading-platform-database-v2
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
15 Commits 1 Branch 0 Tags 538 KiB
main
Commit Graph

4 Commits

Author SHA1 Message Date
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
Adrian Flores Cortes
2a6d8367d8 feat: Update DDL schemas and add new structures 
DDL updates:
- Update extensions and schemas configuration
- Add sessions table for auth schema
- Update education schema (videos, install/uninstall scripts)
- Add backtest_runs and llm_signals tables for ML schema

Scripts:
- Update database creation and migration scripts
- Add DDL validation script

New:
- Add migrations directory structure
- Add production seeds for auth, investment, market_data, trading

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
 2026-01-30 12:24:23 -06:00
Adrian Flores Cortes
439489bde4 feat: Add DDL tables for notifications system 
- Add auth.notifications table for storing user notifications
- Add auth.user_push_tokens table for FCM/APNs tokens
- Add investment.distribution_history for daily distribution records
- Add investment.distribution_runs for job execution logs

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
 2026-01-25 03:48:28 -06:00
rckrdmrd
45e77e9a9c feat: Initial commit - Database schemas and scripts 
DDL schemas for Trading Platform:
- User management
- Authentication
- Payments
- Education
- ML predictions
- Trading data

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
 2026-01-18 04:30:23 -06:00