Files
multica/server/migrations/195_issue_property_workspace_index.up.sql
Multica Eve f46d5d7ba5 fix(db): make issue property migrations deploy-safe (#5456)
Co-authored-by: Eve <eve@multica-ai.local>
Co-authored-by: multica-agent <github@multica.ai>
2026-07-15 17:40:24 +08:00

6 lines
330 B
SQL

-- Support workspace-scoped property listing and counts without blocking writes.
-- Keep this as the migration's only statement: PostgreSQL rejects CREATE INDEX
-- CONCURRENTLY inside a transaction or multi-command string.
CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_issue_property_workspace
ON issue_property (workspace_id);