mirror of
https://github.com/saltbo/agent-kanban.git
synced 2026-09-19 09:01:47 +08:00
jarvis
a2fa54a729
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.
11 lines
458 B
SQL
11 lines
458 B
SQL
-- Agent identity: username for email, gpg_subkey_id for commit signing.
|
|
ALTER TABLE agents ADD COLUMN username TEXT;
|
|
ALTER TABLE agents ADD COLUMN gpg_subkey_id TEXT;
|
|
|
|
-- Backfill username from name
|
|
UPDATE agents SET username = lower(replace(name, ' ', '-'));
|
|
UPDATE agents SET username = 'agent-' || substr(id, 1, 8) WHERE username IS NULL OR username = '';
|
|
|
|
-- Unique per owner
|
|
CREATE UNIQUE INDEX idx_agents_owner_username ON agents(owner_id, username);
|