• Home
• pl.touk.nussknacker
• nussknacker-designer_2.13
• 1.16.0
• source code
• V1_010__DeploymentCancel.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

db.migration.postgres.V1_010__DeploymentCancel.sql Maven / Gradle / Ivy

ALTER TABLE "deployed_process_versions" RENAME TO "process_deployment_info";

ALTER TABLE "process_deployment_info" ADD "deployment_action" VARCHAR(256);

UPDATE "process_deployment_info" set "deployment_action" = 'DEPLOY';

ALTER TABLE "process_deployment_info" ALTER COLUMN "deployment_action" set not null;

ALTER TABLE "process_deployment_info" DROP CONSTRAINT "pk_deployed_process_version";

ALTER TABLE "process_deployment_info" ALTER COLUMN "process_version_id" drop not null;

ALTER TABLE "process_deployment_info" ADD CONSTRAINT "pk_process_deployment_info" PRIMARY KEY ("process_id", "deployment_action", "environment", "deploy_at");

ALTER TABLE "process_deployment_info"
ADD CONSTRAINT "process_deployment_info_check" CHECK ("deployment_action" in ('DEPLOY', 'CANCEL'));