Files
multica/server/migrations/163_agent_builder.up.sql
2026-07-12 15:40:10 +08:00

9 lines
277 B
SQL

ALTER TABLE agent
ADD COLUMN kind TEXT NOT NULL DEFAULT 'user'
CHECK (kind IN ('user', 'system')),
ADD COLUMN system_key TEXT;
CREATE UNIQUE INDEX agent_system_identity_unique
ON agent (workspace_id, owner_id, runtime_id, system_key)
WHERE system_key IS NOT NULL;