diff options
| author |   Toine Siebelink <toine.siebelink@est.tech> | 2023-04-24 08:02:01 +0000 |
|---|---|---|
| committer |   Gerrit Code Review <gerrit@onap.org> | 2023-04-24 08:02:01 +0000 |
| commit | 625707db447ddc390aae7652c353bbc6b88d9dfb (patch) | |
| tree | 2978165dae35231dd232d9f32c09a100a4c5dcac | |
| parent | f5d8051bef715762a31f54d052f7e126e8276fd0 (diff) | |
| parent | 0d7ae4fe9a27280184e6db3bfa2fd4354ad8f62a (diff) | |
Merge "Add cascade delete fragments to liquibase test config"
| -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 8b7422ce54..f53fef70b7 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 |