Query

database.sqlite — workflow_entity

SQL

CREATE TABLE "workflow_entity"  (
  "id" varchar(36) PRIMARY KEY NOT NULL,
  "name" varchar(128) NOT NULL,
  "active" boolean NOT NULL,
  "nodes" text,
  "connections" text,
  "settings" text,
  "staticData" text,
  "pinData" text,
  "versionId" varchar(36) NOT NULL,
  "triggerCount" integer DEFAULT (0),
  "meta" text,
  "parentFolderId" varchar(36),
  "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')),
  "isArchived" boolean NOT NULL DEFAULT (FALSE),
  "versionCounter" integer NOT NULL DEFAULT (1),
  "description" text,
  "activeVersionId" varchar(36),
  "nodeGroups" text NOT NULL DEFAULT ('[]'),
  "sourceWorkflowId" varchar,
  CONSTRAINT "FK_04a4db5906fbc5606c71448d912" FOREIGN KEY ("parentFolderId") REFERENCES "folder" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT "FK_08d6c67b7f722b0039d9d5ed620" FOREIGN KEY ("activeVersionId") REFERENCES "workflow_history" ("versionId") ON DELETE RESTRICT ON UPDATE NO ACTION
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id varchar(36) ✓ Rename | Drop
name varchar(128) Rename | Drop
active boolean Rename | Drop
nodes TEXT ✓ Rename | Drop
connections TEXT ✓ Rename | Drop
settings TEXT ✓ Rename | Drop
staticData TEXT ✓ Rename | Drop
pinData TEXT ✓ Rename | Drop
versionId varchar(36) Rename | Drop
triggerCount INTEGER ✓ Rename | Drop
meta TEXT ✓ Rename | Drop
parentFolderId varchar(36) ✓ Rename | Drop
createdAt datetime(3) Rename | Drop
updatedAt datetime(3) Rename | Drop
isArchived boolean Rename | Drop
versionCounter INTEGER Rename | Drop
description TEXT ✓ Rename | Drop
activeVersionId varchar(36) ✓ Rename | Drop
nodeGroups TEXT Rename | Drop
sourceWorkflowId varchar ✓ Rename | Drop

Foreign Keys

Column Destination
activeVersionId workflow_history.versionId
parentFolderId folder.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_e10425f6ab9964c4c1623a4a03 name SQL 
CREATE INDEX "IDX_e10425f6ab9964c4c1623a4a03"
ON "workflow_entity" ("name")
Drop
IDX_workflow_entity_sourceWorkflowId sourceWorkflowId SQL 
CREATE INDEX "IDX_workflow_entity_sourceWorkflowId"
ON "workflow_entity" ("sourceWorkflowId") WHERE "sourceWorkflowId" IS NOT NULL
Drop
sqlite_autoindex_workflow_entity_1 id ✓ SQL
-- no sql found --
 Drop

Triggers

Name SQL Drop?
workflow_version_increment SQL 
CREATE TRIGGER "workflow_version_increment"
			AFTER UPDATE ON "workflow_entity"
			FOR EACH ROW
			WHEN OLD."versionCounter" = NEW."versionCounter"
				AND (OLD."nodes" IS NOT NEW."nodes" OR OLD."settings" IS NOT NEW."settings")
			BEGIN
				UPDATE "workflow_entity"
				SET "versionCounter" = "versionCounter" + 1
				WHERE "id" = NEW."id";
			END
Drop