Condense Liquibase steps

[cps.git] / cps-ri / src / main / resources / changelog / db / changes / 19-delete-not-required-dataspace-id-from-fragment.yaml

diff --git a/cps-ri/src/main/resources/changelog/db/changes/19-delete-not-required-dataspace-id-from-fragment.yaml b/cps-ri/src/main/resources/changelog/db/changes/19-delete-not-required-dataspace-id-from-fragment.yaml
deleted file mode 100644 (file)
index 7b91bd5..0000000
--- a/cps-ri/src/main/resources/changelog/db/changes/19-delete-not-required-dataspace-id-from-fragment.yaml
+++ /dev/null
@@ -1,109 +0,0 @@
-# ============LICENSE_START=======================================================
-# Copyright (C) 2023 Nordix Foundation.
-# ================================================================================
-# Licensed under the Apache License, Version 2.0 (the "License");
-# you may not use this file except in compliance with the License.
-# You may obtain a copy of the License at
-#
-#       http://www.apache.org/licenses/LICENSE-2.0
-#
-# Unless required by applicable law or agreed to in writing, software
-# distributed under the License is distributed on an "AS IS" BASIS,
-# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
-# See the License for the specific language governing permissions and
-# limitations under the License.
-#
-# SPDX-License-Identifier: Apache-2.0
-# ============LICENSE_END=========================================================
-
-databaseChangeLog:
-
-  - changeSet:
-      id: 19-1
-      author: cps
-      changes:
-        - dropIndex:
-            indexName: FKI_FRAGMENT_DATASPACE_ID_FK
-            tableName: fragment
-      rollback:
-        - createIndex:
-            columns:
-              - column:
-                  name: dataspace_id
-            indexName: FKI_FRAGMENT_DATASPACE_ID_FK
-            tableName: fragment
-
-  - changeSet:
-      id: 19-2
-      author: cps
-      changes:
-        - dropUniqueConstraint:
-            constraintName: fragment_dataspace_id_anchor_id_xpath_key
-            tableName: fragment
-        - addUniqueConstraint:
-            columnNames: anchor_id, xpath
-            constraintName: fragment_anchor_id_xpath_key
-            tableName: fragment
-      rollback:
-        - dropUniqueConstraint:
-            constraintName: fragment_anchor_id_xpath_key
-            tableName: fragment
-        - addUniqueConstraint:
-            columnNames: dataspace_id, anchor_id, xpath
-            constraintName: fragment_dataspace_id_anchor_id_xpath_key
-            tableName: fragment
-
-  - changeSet:
-      id: 19-3
-      author: cps
-      changes:
-        - dropForeignKeyConstraint:
-            baseTableName: fragment
-            constraintName: fragment_dataspace_id_fkey
-      rollback:
-        - addForeignKeyConstraint:
-            baseColumnNames: dataspace_id
-            baseTableName: fragment
-            constraintName: fragment_dataspace_id_fkey
-            deferrable: false
-            initiallyDeferred: false
-            onDelete: NO ACTION
-            onUpdate: NO ACTION
-            referencedColumnNames: id
-            referencedTableName: dataspace
-            validate: true
-
-  - changeSet:
-      id: 19-4
-      author: cps
-      changes:
-        - dropColumn:
-            columnName: dataspace_id
-            tableName: fragment
-      rollback:
-        - addColumn:
-            tableName: fragment
-            columns:
-              - column:
-                  name: dataspace_id
-                  type: INTEGER
-        - sqlFile:
-            path: changelog/db/changes/19-repopulate-dataspace-id-for-rollback.sql
-        - addNotNullConstraint:
-            tableName: fragment
-            columnName: dataspace_id
-            columnDataType: INTEGER
-
-  - changeSet:
-      id: 19-5
-      author: cps
-      changes:
-        - addNotNullConstraint:
-            tableName: fragment
-            columnName: anchor_id
-            columnDataType: BIGINT
-      rollback:
-        - dropNotNullConstraint:
-            tableName: fragment
-            columnName: anchor_id
-            columnDataType: BIGINT