Files
saltbo__agent-kanban/migrations/0012_gpg_keys.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

12 lines
418 B
SQL

-- GPG root key per owner — trust anchor for agent subkey signing.
CREATE TABLE gpg_keys (
id TEXT PRIMARY KEY,
owner_id TEXT NOT NULL REFERENCES "user"(id) ON DELETE CASCADE,
armored_private_key TEXT NOT NULL,
armored_public_key TEXT NOT NULL,
fingerprint TEXT NOT NULL,
created_at TEXT NOT NULL,
updated_at TEXT NOT NULL,
UNIQUE (owner_id)
);