Query

database.sqlite — workflow_statistics

SQL

CREATE TABLE "workflow_statistics"  (
  "count" INTEGER DEFAULT 0,
  "latestEvent" DATETIME,
  "name" VARCHAR(128) NOT NULL,
  "workflowId" VARCHAR(36),
  "rootCount" INTEGER DEFAULT 0,
  PRIMARY KEY("workflowId", "name"),
  FOREIGN KEY("workflowId") REFERENCES "workflow_entity"("id") ON DELETE CASCADE
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
count INTEGER ✓ Rename | Drop
latestEvent DATETIME ✓ Rename | Drop
name VARCHAR(128) ✓ Rename | Drop
workflowId VARCHAR(36) ✓ ✓ Rename | Drop
rootCount INTEGER ✓ Rename | Drop

Foreign Keys

Column Destination
workflowId workflow_entity.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_workflow_statistics_1
  • workflowId
  • name
 ✓ SQL
-- no sql found --
 Drop