Skip to content

armgit / alook

Public Imported from GitHub
0

Multi-Agent Collaboration for Team and Friends

755 B
Raw Blame
CREATE TABLE IF NOT EXISTS agent_skill (
  id TEXT PRIMARY KEY,
  workspace_id TEXT NOT NULL REFERENCES workspace(id) ON DELETE CASCADE,
  agent_id TEXT,
  runtime TEXT NOT NULL,
  name TEXT NOT NULL,
  description TEXT NOT NULL DEFAULT '',
  synced_at TEXT NOT NULL,
  -- Note: SQLite treats NULLs as distinct in UNIQUE constraints.
  -- Global skill uniqueness (agent_id=NULL) is enforced by atomic DELETE+INSERT in syncGlobalSkills.
  UNIQUE(workspace_id, runtime, name, agent_id),
  FOREIGN KEY (agent_id, workspace_id) REFERENCES agent(id, workspace_id) ON DELETE CASCADE
);

CREATE INDEX IF NOT EXISTS idx_as_workspace_runtime ON agent_skill(workspace_id, runtime);
CREATE INDEX IF NOT EXISTS idx_as_agent_runtime ON agent_skill(agent_id, runtime);