Query

database.sqlite — agent_history

SQL

CREATE TABLE "agent_history"  (
  "versionId" varchar(36) PRIMARY KEY NOT NULL,
  "agentId" varchar(36) NOT NULL,
  "schema" text,
  "tools" text,
  "skills" text,
  "publishedById" varchar,
  "author" varchar(255) 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_87cd5a8da20304b089ea2f83fec" FOREIGN KEY ("agentId") REFERENCES "agents" ("id") ON DELETE CASCADE,
  CONSTRAINT "FK_8771675f44c58fb40e0feb9ee35" FOREIGN KEY ("publishedById") REFERENCES "user" ("id") ON DELETE SET NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
versionId varchar(36) ✓ Rename | Drop
agentId varchar(36) Rename | Drop
schema TEXT ✓ Rename | Drop
tools TEXT ✓ Rename | Drop
skills TEXT ✓ Rename | Drop
publishedById varchar ✓ Rename | Drop
author varchar(255) Rename | Drop
createdAt datetime(3) Rename | Drop
updatedAt datetime(3) Rename | Drop

Foreign Keys

Column Destination
publishedById user.id
agentId agents.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_87cd5a8da20304b089ea2f83fe agentId SQL 
CREATE INDEX "IDX_87cd5a8da20304b089ea2f83fe"
ON "agent_history" ("agentId")
Drop
sqlite_autoindex_agent_history_1 versionId ✓ SQL
-- no sql found --
 Drop