Files
saltbo__agent-kanban/migrations/0037_unique_latest_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

5 lines
208 B
SQL

DROP INDEX IF EXISTS idx_agents_owner_runtime_leader;
CREATE UNIQUE INDEX idx_agents_owner_runtime_leader ON agents(owner_id, runtime)
WHERE kind = 'leader' AND runtime IS NOT NULL AND version = 'latest';