Files
saltbo__agent-kanban/migrations/0017_unique_leader_per_runtime.sql
jarvis a2fa54a729 feat!: rebuild Agent Kanban for Realmroot Toolbox
Replace the v1 Agent/Machine runtime and CLI architecture with the v2 Resource Server, AMA-backed projections, task lifecycle, session observation, BDD specifications, and a single-package layered codebase.

BREAKING CHANGE: remove the v1 CLI, internal Agent/Machine runtime entities, workspace layout, and legacy runtime coordination APIs.
2026-09-02 00:17:52 -04:00

4 lines
209 B
SQL

-- Enforce a single leader per owner/runtime pair while allowing many workers.
CREATE UNIQUE INDEX idx_agents_owner_runtime_leader ON agents(owner_id, runtime)
WHERE kind = 'leader' AND runtime IS NOT NULL;