diff options
Diffstat (limited to 'cps-ri/src/main/resources/changelog/db/changes/19-delete-not-required-dataspace-id-from-fragment.yaml')
-rw-r--r-- | cps-ri/src/main/resources/changelog/db/changes/19-delete-not-required-dataspace-id-from-fragment.yaml | 109 |
1 files changed, 0 insertions, 109 deletions
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 index 7b91bd5b38..0000000000 --- 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 |