CREATE TABLE "agents_messages" (
"id" varchar(36) PRIMARY KEY NOT NULL,
"threadId" varchar(255) NOT NULL,
"resourceId" varchar(255) NOT NULL,
"role" varchar(36) NOT NULL,
"type" varchar(36),
"content" text NOT NULL,
"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')),
CONSTRAINT "FK_0a8057a61afabd2999608ffd0d9" FOREIGN KEY ("threadId") REFERENCES "agents_threads" ("id") ON DELETE CASCADE
)