Files
multica/server/migrations/173_remove_resource_label_foreign_keys.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

8 lines
564 B
SQL

-- A short-lived pre-release deployment may already have applied the original
-- migration 162. Remove those database cascades before this release enables
-- resource labels; application transactions own cleanup from this point on.
ALTER TABLE agent_to_label DROP CONSTRAINT IF EXISTS agent_to_label_agent_id_fkey;
ALTER TABLE agent_to_label DROP CONSTRAINT IF EXISTS agent_to_label_label_id_fkey;
ALTER TABLE skill_to_label DROP CONSTRAINT IF EXISTS skill_to_label_skill_id_fkey;
ALTER TABLE skill_to_label DROP CONSTRAINT IF EXISTS skill_to_label_label_id_fkey;