Query

database.sqlite — workflow_review_activ...

SQL

CREATE TABLE "workflow_review_activity_comment"  (
  "id" integer PRIMARY KEY NOT NULL,
  "activityId" integer NOT NULL,
  "createdById" varchar,
  "body" text,
  "history" text,
  "updatedAt" datetime(3),
  "deletedAt" datetime(3),
  "createdAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')),
  CONSTRAINT "FK_3cd755e8ce44ee49bdf7e9222ec" FOREIGN KEY ("activityId") REFERENCES "workflow_review_activity" ("id") ON DELETE CASCADE,
  CONSTRAINT "FK_9cfac4b106553d0930a1962bea0" FOREIGN KEY ("createdById") REFERENCES "user" ("id") ON DELETE SET NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
activityId INTEGER Rename | Drop
createdById varchar ✓ Rename | Drop
body TEXT ✓ Rename | Drop
history TEXT ✓ Rename | Drop
updatedAt datetime(3) ✓ Rename | Drop
deletedAt datetime(3) ✓ Rename | Drop
createdAt datetime(3) Rename | Drop

Foreign Keys

Column Destination
createdById user.id
activityId workflow_review_activity.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_workflow_review_activity_comment_activity
  • activityId
  • id
 SQL 
CREATE INDEX "IDX_workflow_review_activity_comment_activity"
ON "workflow_review_activity_comment" ("activityId", "id")
Drop