Files
multica/server/migrations/205_issue_workspace_position_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

5 lines
248 B
SQL

-- Serve the Table API's default keyset order without scanning and sorting the
-- entire workspace on every page.
CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_issue_workspace_position
ON issue (workspace_id, position, created_at DESC, id DESC);