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
)