Query

database.sqlite — instance_ai_workflow_...

SQL

CREATE TABLE "instance_ai_workflow_snapshots"  (
  "runId" varchar(36) NOT NULL,
  "workflowName" varchar(255) NOT NULL,
  "resourceId" varchar(255),
  "status" varchar,
  "snapshot" 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')),
  PRIMARY KEY ("runId", "workflowName")
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
runId varchar(36) ✓ Rename | Drop
workflowName varchar(255) ✓ Rename | Drop
resourceId varchar(255) ✓ Rename | Drop
status varchar ✓ Rename | Drop
snapshot TEXT Rename | Drop
createdAt datetime(3) Rename | Drop
updatedAt datetime(3) Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_a371ee6b8e0ebb5635f8baa46d
  • workflowName
  • status
 SQL 
CREATE INDEX "IDX_a371ee6b8e0ebb5635f8baa46d"
ON "instance_ai_workflow_snapshots" ("workflowName", "status")
Drop
sqlite_autoindex_instance_ai_workflow_snapshots_1
  • runId
  • workflowName
 ✓ SQL
-- no sql found --
 Drop