GitFOSS

-- AlterTable
ALTER TABLE "Artefact" ADD COLUMN     "stageId" TEXT NOT NULL DEFAULT '';

-- AlterTable
ALTER TABLE "Pipeline" ADD COLUMN     "closedAt" TIMESTAMP(3),
ADD COLUMN     "triggeredByUserId" TEXT;

-- AlterTable
ALTER TABLE "Stage" ADD COLUMN     "closedAt" TIMESTAMP(3),
ADD COLUMN     "exitCode" INTEGER;

-- AddForeignKey
ALTER TABLE "Pipeline" ADD CONSTRAINT "Pipeline_triggeredByUserId_fkey" FOREIGN KEY ("triggeredByUserId") REFERENCES "User"("id") ON DELETE SET NULL ON UPDATE CASCADE;

-- AddForeignKey
ALTER TABLE "Artefact" ADD CONSTRAINT "Artefact_stageId_fkey" FOREIGN KEY ("stageId") REFERENCES "Stage"("id") ON DELETE RESTRICT ON UPDATE CASCADE;