Query

database.sqlite — workflow_statistics

SQL

CREATE TABLE "workflow_statistics"  (
  "id" INTEGER PRIMARY KEY AUTOINCREMENT,
  "count" INTEGER DEFAULT 0,
  "latestEvent" DATETIME,
  "name" VARCHAR(128) NOT NULL,
  "workflowId" VARCHAR(36) NOT NULL,
  "workflowName" VARCHAR(128),
  "rootCount" INTEGER DEFAULT 0
)

+ Add column

Columns

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

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_workflow_statistics_workflow_name
  • workflowId
  • name
 ✓ SQL 
CREATE UNIQUE INDEX "IDX_workflow_statistics_workflow_name"
ON "workflow_statistics" ("workflowId", "name")
Drop