• 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.firebird.addForeignKey.sql Maven / Gradle / Ivy

CREATE TABLE TEST_TABLE_BASE (ID INT NOT NULL, CONSTRAINT PK_TEST_TABLE_BASE PRIMARY KEY (ID));

CREATE TABLE TEST_TABLE_REFERENCE (ID INT NOT NULL, TEST_COLUMN INT NOT NULL, CONSTRAINT PK_TEST_TABLE_REFERENCE PRIMARY KEY (ID));

ALTER TABLE TEST_TABLE_REFERENCE ADD CONSTRAINT TEST_TABLE_REFERENCE_UNIQUE UNIQUE (TEST_COLUMN);

ALTER TABLE TEST_TABLE_BASE ADD CONSTRAINT TEST_FK FOREIGN KEY (ID) REFERENCES TEST_TABLE_REFERENCE (TEST_COLUMN) ON UPDATE NO ACTION ON DELETE CASCADE;