jws-backend/prisma/migrations/20241028033351_update_constraints/migration.sql
2024-10-28 10:34:00 +07:00

5 lines
372 B
SQL

-- DropForeignKey
ALTER TABLE "WorkflowTemplateStepUser" DROP CONSTRAINT "WorkflowTemplateStepUser_workflowTemplateStepId_fkey";
-- AddForeignKey
ALTER TABLE "WorkflowTemplateStepUser" ADD CONSTRAINT "WorkflowTemplateStepUser_workflowTemplateStepId_fkey" FOREIGN KEY ("workflowTemplateStepId") REFERENCES "WorkflowTemplateStep"("id") ON DELETE CASCADE ON UPDATE CASCADE;