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

CREATE TABLE "scenario_labels" (
  "label"       VARCHAR2(254) NOT NULL,
  "scenario_id" INTEGER NOT NULL
);

ALTER TABLE "scenario_labels" ADD CONSTRAINT "pk_scenario_label" PRIMARY KEY ("label", "scenario_id");
ALTER TABLE "scenario_labels" ADD CONSTRAINT "label_scenario_fk" FOREIGN KEY ("scenario_id") REFERENCES "processes" ("id") ON DELETE CASCADE;