Query

database.sqlite — webhook_entity

SQL

CREATE TABLE "webhook_entity"  (
  "workflowId" varchar(36) NOT NULL,
  "webhookPath" varchar NOT NULL,
  "method" varchar NOT NULL,
  "node" varchar NOT NULL,
  "webhookId" varchar,
  "pathLength" integer,
  PRIMARY KEY ("webhookPath", "method")
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
workflowId varchar(36) Rename | Drop
webhookPath varchar ✓ Rename | Drop
method varchar ✓ Rename | Drop
node varchar Rename | Drop
webhookId varchar ✓ Rename | Drop
pathLength INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_webhook_entity_webhook_path_method
  • webhookId
  • method
  • pathLength
 SQL 
CREATE INDEX "idx_webhook_entity_webhook_path_method"
ON "webhook_entity" ("webhookId","method","pathLength")
Drop
sqlite_autoindex_webhook_entity_1
  • webhookPath
  • method
 ✓ SQL
-- no sql found --
 Drop