Query

database.sqlite — workflow_publication_...

SQL

CREATE TABLE "workflow_publication_outbox"  (
  "id" integer PRIMARY KEY NOT NULL,
  "workflowId" varchar(36) NOT NULL,
  "publishedVersionId" varchar(36) NOT NULL,
  "status" varchar(20) NOT NULL,
  "errorMessage" text,
  "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')),
  CONSTRAINT "CHK_workflow_publication_outbox_status" CHECK ("status" IN ('pending', 'in_progress', 'completed', 'partial_success', 'failed'))
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
workflowId varchar(36) Rename | Drop
publishedVersionId varchar(36) Rename | Drop
status varchar(20) Rename | Drop
errorMessage TEXT ✓ Rename | Drop
createdAt datetime(3) Rename | Drop
updatedAt datetime(3) Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_workflow_publication_outbox_active_workflow_status
  • workflowId
  • status
 ✓ SQL 
CREATE UNIQUE INDEX "IDX_workflow_publication_outbox_active_workflow_status"
ON "workflow_publication_outbox" ("workflowId", "status") WHERE status IN ('pending', 'in_progress')
Drop