• Home
• org.liquibase
• liquibase-test-harness
• 1.0.11
• source code
• addForeignKey.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.

liquibase.harness.generateChangelog.expectedSql.edb-postgres.addForeignKey.sql Maven / Gradle / Ivy

CREATE TABLE "test_table_reference" ("id" INTEGER NOT NULL, "test_column" INTEGER NOT NULL, CONSTRAINT "test_table_reference_pkey" PRIMARY KEY ("id"));

ALTER TABLE "test_table_reference" ADD CONSTRAINT "test_table_reference_unique" UNIQUE ("test_column");

CREATE TABLE "test_table_base" ("id" INTEGER NOT NULL, CONSTRAINT "test_table_base_pkey" PRIMARY KEY ("id"));

ALTER TABLE "test_table_base" ADD CONSTRAINT "test_fk" FOREIGN KEY ("id") REFERENCES "test_table_reference" ("test_column") ON UPDATE RESTRICT ON DELETE CASCADE;