diff options
author | 2023-04-21 11:08:01 +0100 | |
---|---|---|
committer | 2023-04-21 11:08:01 +0100 | |
commit | 0d7ae4fe9a27280184e6db3bfa2fd4354ad8f62a (patch) | |
tree | f14e9783a875980c9b7c2b2624bd57f2c87dc7c3 /integration-test/src | |
parent | b3c3d36266493a93cb40a5d76de9fc5b80fec789 (diff) |
Add cascade delete fragments to liquibase test config
Cascade delete was added to fragments table in main DB changelog,
but not to integration-test changelog.
Issue-ID: CPS-1617
Signed-off-by: danielhanrahan <daniel.hanrahan@est.tech>
Change-Id: If85f120dfdc4bf3e9c8a1dde2b982378560d418a
Diffstat (limited to 'integration-test/src')
-rw-r--r-- | integration-test/src/test/resources/liquibase/test-changelog.yaml | 34 |
1 files changed, 34 insertions, 0 deletions
diff --git a/integration-test/src/test/resources/liquibase/test-changelog.yaml b/integration-test/src/test/resources/liquibase/test-changelog.yaml index 8b7422ce5..f53fef70b 100644 --- a/integration-test/src/test/resources/liquibase/test-changelog.yaml +++ b/integration-test/src/test/resources/liquibase/test-changelog.yaml @@ -615,3 +615,37 @@ databaseChangeLog: - dropIndex: indexName: FKI_SCHEMA_SET_YANG_RESOURCES_SCHEMA_SET_ID_FK tableName: schema_set_yang_resources + + - changeSet: + author: cps + id: 1-42 + changes: + - dropForeignKeyConstraint: + baseTableName: fragment + constraintName: fragment_parent_id_fkey + - addForeignKeyConstraint: + baseColumnNames: parent_id + baseTableName: fragment + constraintName: fragment_parent_id_fkey + deferrable: false + initiallyDeferred: false + onDelete: CASCADE + onUpdate: NO ACTION + referencedColumnNames: id + referencedTableName: fragment + validate: true + rollback: + - dropForeignKeyConstraint: + baseTableName: fragment + constraintName: fragment_parent_id_fkey + - addForeignKeyConstraint: + baseColumnNames: parent_id + baseTableName: fragment + constraintName: fragment_parent_id_fkey + deferrable: false + initiallyDeferred: false + onDelete: NO ACTION + onUpdate: NO ACTION + referencedColumnNames: id + referencedTableName: fragment + validate: true |