aboutsummaryrefslogtreecommitdiffstats
path: root/cps-ri/src/main/resources/changelog/db/changes/19-delete-not-required-dataspace-id-from-fragment.yaml
diff options
context:
space:
mode:
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.yaml109
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