• Home
• pl.touk.nussknacker
• nussknacker-designer_2.13
• 1.16.0
• source code
• V1_005__CreateDeployedProcess.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_005__CreateDeployedProcess.sql Maven / Gradle / Ivy

CREATE TABLE "deployed_process_versions" (
  "process_id"         VARCHAR(254) NOT NULL,
  "process_version_id" INTEGER      NOT NULL,
  "environment"        VARCHAR(254) NOT NULL,
  "user"               VARCHAR(254) NOT NULL,
  "deploy_at"          TIMESTAMP    NOT NULL
);

ALTER TABLE "deployed_process_versions"
ADD CONSTRAINT "pk_deployed_process_version" PRIMARY KEY ("process_id", "process_version_id", "environment", "deploy_at");

ALTER TABLE "deployed_process_versions"
ADD CONSTRAINT "proc_ver_in_deployed_proc_fk" FOREIGN KEY ("process_id", "process_version_id") REFERENCES "process_versions" ("process_id", "id");