multica/server/migrations/046_agent_unique_name.down.sql at fix/table-wrapper-overflow - multica - Gitea: Git with a cup of tea

highperfocused/multica

mirror of https://github.com/multica-ai/multica.git synced 2026-06-17 03:38:32 +02:00

Files

joyanup 3ea6b5c7b8 fix(agent): return 409 on duplicate agent name (#1182 )

- Migration 046 adds UNIQUE(workspace_id, name) with dedup (keep most recently updated)
- CreateAgent handler returns 409 Conflict scoped to constraint name agent_workspace_name_unique
- Dedup verified as (0 rows) against worktree DB; rerun against staging/production before applying
- Down migration drops the constraint only; deleted rows and cascaded data are not restored

Co-authored-by: Anup Joy <joyanup@gmail.com>
Co-authored-by: Claude Sonnet 4.6 <noreply@anthropic.com>

2026-04-17 13:40:02 +08:00

2 lines

73 B

SQL

Raw Permalink Blame History

ALTER TABLE agent DROP CONSTRAINT IF EXISTS agent_workspace_name_unique;