Files
saltbo__agent-kanban/migrations/0006_add_device_id.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
216 B
SQL

-- Add device_id to machines for hardware fingerprint deduplication
ALTER TABLE machines ADD COLUMN device_id TEXT NOT NULL DEFAULT '';
CREATE UNIQUE INDEX idx_machines_owner_device ON machines(owner_id, device_id);