95 lines
4.0 KiB
SQL
95 lines
4.0 KiB
SQL
-- CreateTable
|
|
CREATE TABLE "AgentGraph" (
|
|
"id" TEXT NOT NULL,
|
|
"version" INTEGER NOT NULL DEFAULT 1,
|
|
"name" TEXT,
|
|
"description" TEXT,
|
|
"isActive" BOOLEAN NOT NULL DEFAULT true,
|
|
"isTemplate" BOOLEAN NOT NULL DEFAULT false,
|
|
|
|
PRIMARY KEY ("id", "version")
|
|
);
|
|
|
|
-- CreateTable
|
|
CREATE TABLE "AgentNode" (
|
|
"id" TEXT NOT NULL PRIMARY KEY,
|
|
"agentBlockId" TEXT NOT NULL,
|
|
"agentGraphId" TEXT NOT NULL,
|
|
"agentGraphVersion" INTEGER NOT NULL DEFAULT 1,
|
|
"constantInput" TEXT NOT NULL DEFAULT '{}',
|
|
"metadata" TEXT NOT NULL DEFAULT '{}',
|
|
CONSTRAINT "AgentNode_agentBlockId_fkey" FOREIGN KEY ("agentBlockId") REFERENCES "AgentBlock" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
|
|
CONSTRAINT "AgentNode_agentGraphId_agentGraphVersion_fkey" FOREIGN KEY ("agentGraphId", "agentGraphVersion") REFERENCES "AgentGraph" ("id", "version") ON DELETE RESTRICT ON UPDATE CASCADE
|
|
);
|
|
|
|
-- CreateTable
|
|
CREATE TABLE "AgentNodeLink" (
|
|
"id" TEXT NOT NULL PRIMARY KEY,
|
|
"agentNodeSourceId" TEXT NOT NULL,
|
|
"sourceName" TEXT NOT NULL,
|
|
"agentNodeSinkId" TEXT NOT NULL,
|
|
"sinkName" TEXT NOT NULL,
|
|
CONSTRAINT "AgentNodeLink_agentNodeSourceId_fkey" FOREIGN KEY ("agentNodeSourceId") REFERENCES "AgentNode" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
|
|
CONSTRAINT "AgentNodeLink_agentNodeSinkId_fkey" FOREIGN KEY ("agentNodeSinkId") REFERENCES "AgentNode" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
|
|
);
|
|
|
|
-- CreateTable
|
|
CREATE TABLE "AgentBlock" (
|
|
"id" TEXT NOT NULL PRIMARY KEY,
|
|
"name" TEXT NOT NULL,
|
|
"inputSchema" TEXT NOT NULL,
|
|
"outputSchema" TEXT NOT NULL
|
|
);
|
|
|
|
-- CreateTable
|
|
CREATE TABLE "AgentGraphExecution" (
|
|
"id" TEXT NOT NULL PRIMARY KEY,
|
|
"agentGraphId" TEXT NOT NULL,
|
|
"agentGraphVersion" INTEGER NOT NULL DEFAULT 1,
|
|
CONSTRAINT "AgentGraphExecution_agentGraphId_agentGraphVersion_fkey" FOREIGN KEY ("agentGraphId", "agentGraphVersion") REFERENCES "AgentGraph" ("id", "version") ON DELETE RESTRICT ON UPDATE CASCADE
|
|
);
|
|
|
|
-- CreateTable
|
|
CREATE TABLE "AgentNodeExecution" (
|
|
"id" TEXT NOT NULL PRIMARY KEY,
|
|
"agentGraphExecutionId" TEXT NOT NULL,
|
|
"agentNodeId" TEXT NOT NULL,
|
|
"executionStatus" TEXT NOT NULL,
|
|
"addedTime" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
"queuedTime" DATETIME,
|
|
"startedTime" DATETIME,
|
|
"endedTime" DATETIME,
|
|
CONSTRAINT "AgentNodeExecution_agentGraphExecutionId_fkey" FOREIGN KEY ("agentGraphExecutionId") REFERENCES "AgentGraphExecution" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
|
|
CONSTRAINT "AgentNodeExecution_agentNodeId_fkey" FOREIGN KEY ("agentNodeId") REFERENCES "AgentNode" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
|
|
);
|
|
|
|
-- CreateTable
|
|
CREATE TABLE "AgentNodeExecutionInputOutput" (
|
|
"id" TEXT NOT NULL PRIMARY KEY,
|
|
"name" TEXT NOT NULL,
|
|
"data" TEXT NOT NULL,
|
|
"time" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
"referencedByInputExecId" TEXT,
|
|
"referencedByOutputExecId" TEXT,
|
|
CONSTRAINT "AgentNodeExecutionInputOutput_referencedByInputExecId_fkey" FOREIGN KEY ("referencedByInputExecId") REFERENCES "AgentNodeExecution" ("id") ON DELETE SET NULL ON UPDATE CASCADE,
|
|
CONSTRAINT "AgentNodeExecutionInputOutput_referencedByOutputExecId_fkey" FOREIGN KEY ("referencedByOutputExecId") REFERENCES "AgentNodeExecution" ("id") ON DELETE SET NULL ON UPDATE CASCADE
|
|
);
|
|
|
|
-- CreateTable
|
|
CREATE TABLE "AgentGraphExecutionSchedule" (
|
|
"id" TEXT NOT NULL PRIMARY KEY,
|
|
"agentGraphId" TEXT NOT NULL,
|
|
"agentGraphVersion" INTEGER NOT NULL DEFAULT 1,
|
|
"schedule" TEXT NOT NULL,
|
|
"isEnabled" BOOLEAN NOT NULL DEFAULT true,
|
|
"inputData" TEXT NOT NULL,
|
|
"lastUpdated" DATETIME NOT NULL,
|
|
CONSTRAINT "AgentGraphExecutionSchedule_agentGraphId_agentGraphVersion_fkey" FOREIGN KEY ("agentGraphId", "agentGraphVersion") REFERENCES "AgentGraph" ("id", "version") ON DELETE RESTRICT ON UPDATE CASCADE
|
|
);
|
|
|
|
-- CreateIndex
|
|
CREATE UNIQUE INDEX "AgentBlock_name_key" ON "AgentBlock"("name");
|
|
|
|
-- CreateIndex
|
|
CREATE INDEX "AgentGraphExecutionSchedule_isEnabled_idx" ON "AgentGraphExecutionSchedule"("isEnabled");
|