Files
multica/server/migrations/203_issue_workspace_assignee_index.up.sql
Multica Eve 8065cead85 MUL-5198: Restore server-backed issue table grouping (MUL-5100) (#5817)
* revert(issues): restore server-backed table grouping

Co-authored-by: multica-agent <github@multica.ai>

* test(skills): stabilize import completion coverage

Co-authored-by: multica-agent <github@multica.ai>

---------

Co-authored-by: Eve <eve@multica-ai.local>
Co-authored-by: multica-agent <github@multica.ai>
2026-07-23 12:03:27 +08:00

6 lines
334 B
SQL

-- Server-side Table grouping filters by workspace before grouping assignees.
-- Keep the concurrent build isolated so writes to the hot issue table remain
-- available while existing workspaces are indexed.
CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_issue_workspace_assignee
ON issue (workspace_id, assignee_type, assignee_id);