Merge "Add cascade delete fragments to liquibase test config"

[cps.git] / integration-test / src / test / resources / liquibase / test-changelog.yaml

diff --git a/integration-test/src/test/resources/liquibase/test-changelog.yaml b/integration-test/src/test/resources/liquibase/test-changelog.yaml
index 0c881b8..f53fef7 100644 (file)
--- a/integration-test/src/test/resources/liquibase/test-changelog.yaml
+++ b/integration-test/src/test/resources/liquibase/test-changelog.yaml
@@ -353,19 +353,6 @@ databaseChangeLog:
                   name: schema_node_id
             indexName: FKI_SCHEMA_NODE_ID_TO_ID
             tableName: fragment
-  - changeSet:
-      id: 1-21
-      author: cps
-      changes:
-        - createIndex:
-            columns:
-              - column:
-                  name: xpath
-              - column:
-                  name: dataspace_id
-            indexName: UQ_FRAGMENT_XPATH
-            tableName: fragment
-            unique: true
   - changeSet:
       id: 1-22
       author: cps
@@ -613,3 +600,52 @@ databaseChangeLog:
       rollback:
         - sql:
             sql: alter table yang_resource rename column file_name to name
+
+  - changeSet:
+      author: cps
+      id: 1-41
+      changes:
+        - createIndex:
+            columns:
+              - column:
+                  name: schema_set_id
+            indexName: FKI_SCHEMA_SET_YANG_RESOURCES_SCHEMA_SET_ID_FK
+            tableName: schema_set_yang_resources
+      rollback:
+        - 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