php-tenant/Migrations
Snider 67b5b14b8e perf: add database indexes for common queries (P2-024)
Add migration with performance indexes for frequently queried columns:
- users.tier for tier-based queries
- namespaces.slug for slug lookups
- workspaces.is_active, type, domain for common filters
- user_workspace.team_id foreign key
- entitlement_usage_records.user_id foreign key
- entitlement_logs.user_id foreign key

Resolves PERF-002 from TODO.md.

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
2026-01-29 16:17:06 +00:00
..
0001_01_01_000000_create_tenant_tables.php fix: namespace to Core\Mod\Tenant, restructure package 2026-01-27 00:58:42 +00:00
2026_01_26_000000_create_workspace_invitations_table.php fix: namespace to Core\Mod\Tenant, restructure package 2026-01-27 00:58:42 +00:00
2026_01_26_120000_create_usage_alert_history_table.php fix: namespace to Core\Mod\Tenant, restructure package 2026-01-27 00:58:42 +00:00
2026_01_26_140000_create_entitlement_webhooks_tables.php fix: namespace to Core\Mod\Tenant, restructure package 2026-01-27 00:58:42 +00:00
2026_01_26_140000_create_workspace_teams_table.php fix: namespace to Core\Mod\Tenant, restructure package 2026-01-27 00:58:42 +00:00
2026_01_29_000000_add_performance_indexes.php perf: add database indexes for common queries (P2-024) 2026-01-29 16:17:06 +00:00