diff options
Diffstat (limited to 'cps-ri/src/main/resources/changelog/db/changes/14-loadData-dmi-registry-2022-05-10-schema-set.yaml')
| -rw-r--r-- | cps-ri/src/main/resources/changelog/db/changes/14-loadData-dmi-registry-2022-05-10-schema-set.yaml | 113 |
1 files changed, 0 insertions, 113 deletions
diff --git a/cps-ri/src/main/resources/changelog/db/changes/14-loadData-dmi-registry-2022-05-10-schema-set.yaml b/cps-ri/src/main/resources/changelog/db/changes/14-loadData-dmi-registry-2022-05-10-schema-set.yaml deleted file mode 100644 index da39d221c0..0000000000 --- a/cps-ri/src/main/resources/changelog/db/changes/14-loadData-dmi-registry-2022-05-10-schema-set.yaml +++ /dev/null @@ -1,113 +0,0 @@ -# ============LICENSE_START======================================================= -# Copyright (C) 2022 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: - author: cps - label: dmi-registry-schema-delete - id: 14 - sql: DELETE FROM schema_set_yang_resources - where schema_set_id = (select id from schema_set where name = 'ncmp-dmi-registry-model') - and yang_resource_id = (select id from yang_resource where name = 'dmi-registry@2022-02-10.yang') - rollback: - sql: INSERT INTO schema_set_yang_resources (schema_set_id, yang_resource_id) - VALUES ((select id from schema_set where name = 'ncmp-dmi-registry-model'), (select id from yang_resource where name = 'dmi-registry@2022-02-10.yang')); - - - changeSet: - author: cps - label: dmi-registry-schema-delete - id: 14.1 - sql: DELETE FROM yang_resource where name = 'dmi-registry@2022-02-10.yang' - rollback: - loadUpdateData: - encoding: UTF-8 - file: 'changelog/db/changes/data/dmi//generated-csv/generated_yang_resource_dmi-registry@2022-02-10.csv' - onlyUpdate: 'false' - primaryKey: 'id' - quotchar: '"' - separator: '|' - tableName: 'yang_resource' - columns: - - column: - header: name - name: name - type: STRING - - column: - header: content - name: content - type: STRING - - column: - header: checksum - name: checksum - type: STRING - - column: - header: module_name - name: module_name - type: STRING - - column: - header: revision - name: revision - type: STRING - - - changeSet: - author: cps - label: dmi-registry-schema-load-revision-2022-05-10 - id: 14.2 - loadUpdateData: - encoding: UTF-8 - file: 'changelog/db/changes/data/dmi/generated-csv/generated_yang_resource_dmi-registry@2022-05-10.csv' - onlyUpdate: 'false' - primaryKey: 'id' - quotchar: '"' - separator: '|' - tableName: 'yang_resource' - columns: - - column: - header: name - name: name - type: STRING - - column: - header: content - name: content - type: STRING - - column: - header: checksum - name: checksum - type: STRING - - column: - header: module_name - name: module_name - type: STRING - - column: - header: revision - name: revision - type: STRING - rollback: - - sql: - sql: DELETE FROM yang_resource where name = 'dmi-registry@2022-05-10.yang' - - - changeSet: - author: cps - label: dmi-registry-schema-load-revision-2022-05-10 - id: 14.3 - sql: INSERT INTO schema_set_yang_resources (schema_set_id, yang_resource_id) - VALUES ((select id from schema_set where name = 'ncmp-dmi-registry-model'), (select id from yang_resource where name = 'dmi-registry@2022-05-10.yang')); - rollback: - sql: DELETE FROM schema_set_yang_resources - where schema_set_id = (select id from schema_set where name = 'ncmp-dmi-registry-model') - and yang_resource_id = (select id from yang_resource where name = 'dmi-registry@2022-05-10.yang')
\ No newline at end of file |