• Home
• pl.touk.nussknacker
• nussknacker-designer_2.12
• 1.18.0
• source code
• V1_011__DeleteProcess.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.common.V1_011__DeleteProcess.sql Maven / Gradle / Ivy

ALTER TABLE "tags" DROP CONSTRAINT "tag-process-fk";
ALTER TABLE "tags" ADD CONSTRAINT "tag-process-fk" FOREIGN KEY ("process_id") REFERENCES "processes" ("id") ON DELETE CASCADE;

ALTER TABLE "process_versions" ADD CONSTRAINT "version-process-fk" FOREIGN KEY ("process_id") REFERENCES "processes" ("id") ON DELETE CASCADE;

ALTER TABLE "process_comments" DROP CONSTRAINT "proc_comments_proc_version_fk";
ALTER TABLE "process_comments"
ADD CONSTRAINT "proc_comments_proc_version_fk" FOREIGN KEY ("process_id", "process_version_id") REFERENCES "process_versions" ("process_id", "id") ON DELETE CASCADE;


ALTER TABLE "process_deployment_info"
DROP CONSTRAINT "proc_ver_in_deployed_proc_fk";
ALTER TABLE "process_deployment_info"
ADD CONSTRAINT "proc_ver_in_deployed_proc_fk" FOREIGN KEY ("process_id", "process_version_id") REFERENCES "process_versions" ("process_id", "id") ON DELETE CASCADE;