CREATE TABLE "agents" (
"id" varchar(36) PRIMARY KEY NOT NULL,
"name" varchar(128) NOT NULL,
"projectId" varchar(255) NOT NULL,
"integrations" text NOT NULL DEFAULT ('[]'),
"schema" text,
"tools" text NOT NULL DEFAULT ('{}'),
"skills" text NOT NULL DEFAULT ('{}'),
"versionId" varchar(36),
"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')),
"activeVersionId" varchar(36),
"availableInMCP" boolean NOT NULL DEFAULT (false),
CONSTRAINT "FK_a30d560207c4071d98aa03c179c" FOREIGN KEY ("projectId") REFERENCES "project" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
CONSTRAINT "FK_940597dfe9753375309ce6aeea0" FOREIGN KEY ("activeVersionId") REFERENCES "agent_history" ("versionId") ON DELETE SET NULL ON UPDATE NO ACTION
)