Files
multica/server/migrations/172_agent_system_identity_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

6 lines
304 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 agent_system_identity_unique
ON agent (workspace_id, owner_id, runtime_id, system_key)
WHERE system_key IS NOT NULL;