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,
  CONSTRAINT "FK_04a4db5906fbc5606c71448d912" FOREIGN KEY ("parentFolderId") REFERENCES "folder" ("id") ON DELETE CASCADE 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

Foreign Keys

Column Destination
parentFolderId folder.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_e10425f6ab9964c4c1623a4a03 name SQL 
CREATE INDEX "IDX_e10425f6ab9964c4c1623a4a03"
ON "workflow_entity" ("name")
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"
			BEGIN
				UPDATE workflow_entity
				SET "versionCounter" = "versionCounter" + 1
				WHERE id = NEW.id;
			END
Drop