Query

database.sqlite — agent_execution_threads

SQL

CREATE TABLE "agent_execution_threads"  (
  "id" varchar(128) PRIMARY KEY NOT NULL,
  "agentId" varchar(36) NOT NULL,
  "agentName" varchar(255) NOT NULL,
  "projectId" varchar(255) NOT NULL,
  "sessionNumber" integer NOT NULL DEFAULT (0),
  "totalPromptTokens" integer NOT NULL DEFAULT (0),
  "totalCompletionTokens" integer NOT NULL DEFAULT (0),
  "totalCost" real NOT NULL DEFAULT (0),
  "totalDuration" integer NOT NULL DEFAULT (0),
  "title" varchar(255),
  "emoji" varchar(8),
  "createdAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')),
  "updatedAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')),
  "taskId" varchar(32),
  "taskVersionId" varchar(36),
  "parentThreadId" varchar(128),
  "parentAgentId" varchar(36),
  CONSTRAINT "FK_0e2f8bf92a7a9c88b89670f701c" FOREIGN KEY ("projectId") REFERENCES "project" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT "FK_0468a9dc35597314e641d4722aa" FOREIGN KEY ("agentId") REFERENCES "agents" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT "FK_f00b52d74fe11838e1fe086deea" FOREIGN KEY ("taskVersionId") REFERENCES "agent_history" ("versionId") ON DELETE SET NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id varchar(128) ✓ Rename | Drop
agentId varchar(36) Rename | Drop
agentName varchar(255) Rename | Drop
projectId varchar(255) Rename | Drop
sessionNumber INTEGER Rename | Drop
totalPromptTokens INTEGER Rename | Drop
totalCompletionTokens INTEGER Rename | Drop
totalCost REAL Rename | Drop
totalDuration INTEGER Rename | Drop
title varchar(255) ✓ Rename | Drop
emoji varchar(8) ✓ Rename | Drop
createdAt datetime(3) Rename | Drop
updatedAt datetime(3) Rename | Drop
taskId varchar(32) ✓ Rename | Drop
taskVersionId varchar(36) ✓ Rename | Drop
parentThreadId varchar(128) ✓ Rename | Drop
parentAgentId varchar(36) ✓ Rename | Drop

Foreign Keys

Column Destination
taskVersionId agent_history.versionId
agentId agents.id
projectId project.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_0468a9dc35597314e641d4722a agentId SQL 
CREATE INDEX "IDX_0468a9dc35597314e641d4722a"
ON "agent_execution_threads" ("agentId")
Drop
IDX_0e2f8bf92a7a9c88b89670f701 projectId SQL 
CREATE INDEX "IDX_0e2f8bf92a7a9c88b89670f701"
ON "agent_execution_threads" ("projectId")
Drop
IDX_agent_execution_threads_taskVersionId taskVersionId SQL 
CREATE INDEX "IDX_agent_execution_threads_taskVersionId"
ON "agent_execution_threads" ("taskVersionId")
Drop
sqlite_autoindex_agent_execution_threads_1 id ✓ SQL
-- no sql found --
 Drop