Files
multica/server/migrations/167_resource_label_namespace_index.up.sql
Multica Eve 411a160b99 fix(release): harden v0.3.44 migrations (#5345)
Co-authored-by: Eve <eve@multica-ai.local>
Co-authored-by: multica-agent <github@multica.ai>
2026-07-13 18:13:44 +08:00

5 lines
284 B
SQL

-- This is intentionally a single statement: concurrent index creation cannot
-- run in a transaction or a multi-command migration.
CREATE UNIQUE INDEX CONCURRENTLY IF NOT EXISTS issue_label_workspace_type_name_lower_idx
ON issue_label (workspace_id, resource_type, LOWER(name));