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.
7 lines
421 B
SQL
7 lines
421 B
SQL
-- Username must be globally unique (shared email domain @mails.agent-kanban.dev).
|
|
-- Deduplicate: append owner_id prefix to duplicates before adding unique constraint.
|
|
UPDATE agents SET username = username || '-' || SUBSTR(owner_id, 1, 6)
|
|
WHERE rowid NOT IN (SELECT MIN(rowid) FROM agents GROUP BY username);
|
|
DROP INDEX IF EXISTS idx_agents_owner_username;
|
|
CREATE UNIQUE INDEX idx_agents_username ON agents(username);
|