+++ /dev/null
-# ============LICENSE_START=======================================================
-# Copyright (C) 2021-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-preload
- id: 9
- loadUpdateData:
- encoding: UTF-8
- file: 'changelog/db/changes/data/dmi/dataspace.csv'
- onlyUpdate: 'false'
- primaryKey: 'id'
- quotchar: '"'
- separator: '|'
- tableName: 'dataspace'
- rollback:
- - sql:
- sql: delete from dataspace where name = 'NCMP-Admin'
-
- - changeSet:
- author: cps
- label: dmi-registry-schema-preload
- id: 9.1
- loadUpdateData:
- encoding: UTF-8
- file: 'changelog/db/changes/data/dmi/schema_set.csv'
- onlyUpdate: 'false'
- primaryKey: 'id'
- quotchar: '"'
- separator: '|'
- tableName: 'schema_set'
- rollback:
- - sql:
- sql: delete from schema_set where name = 'ncmp-dmi-registry-model'
-
- - changeSet:
- author: cps
- label: dmi-registry-schema-preload
- id: 9.2
- loadUpdateData:
- encoding: UTF-8
- file: 'changelog/db/changes/data/dmi/yang_resource.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
- rollback:
- - sql:
- sql: delete from yang_resource where name = 'dmi-registry@2021-05-20.yang'
-
- - changeSet:
- author: cps
- label: dmi-registry-schema-preload
- id: 9.3
- loadUpdateData:
- encoding: UTF-8
- file: 'changelog/db/changes/data/dmi/schema_set_yang_resources.csv'
- quotchar: '"'
- primaryKey: 'schema_set_id,yang_resource_id'
- separator: '|'
- tableName: 'schema_set_yang_resources'
- usePreparedStatements: true
- rollback:
- - sql:
- 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@2021-05-20.yang')
-
- - changeSet:
- author: cps
- label: dmi-registry-schema-preload
- id: 9.4
- loadUpdateData:
- encoding: UTF-8
- file: 'changelog/db/changes/data/dmi/anchor.csv'
- onlyUpdate: 'false'
- primaryKey: 'id'
- quotchar: '"'
- separator: '|'
- tableName: 'anchor'
- rollback:
- - sql:
- sql: delete from anchor where name = 'ncmp-dmi-registry'
-
- - changeSet:
- author: cps
- label: dmi-registry-schema-preload
- id: 9.5
- loadUpdateData:
- encoding: UTF-8
- file: 'changelog/db/changes/data/dmi/yang_resource@2021-10-20.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
- rollback:
- - sql:
- sql: delete from yang_resource where name = 'dmi-registry@2021-10-20.yang'
-
- - changeSet:
- author: cps
- label: dmi-registry-schema-preload
- id: 9.6
- loadUpdateData:
- encoding: UTF-8
- file: 'changelog/db/changes/data/dmi/schema_set_yang_resources@2021-10-20.csv'
- quotchar: '"'
- primaryKey: 'schema_set_id,yang_resource_id'
- separator: '|'
- tableName: 'schema_set_yang_resources'
- usePreparedStatements: true
- rollback:
- - sql:
- 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@2021-10-20.yang')
-
- - changeSet:
- author: cps
- label: dmi-registry-schema-preload
- id: 9.7
- loadUpdateData:
- encoding: UTF-8
- file: 'changelog/db/changes/data/dmi//generated-csv/generated_yang_resource_dmi-registry@2021-12-13.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
- rollback:
- - sql:
- sql: delete from yang_resource where name = 'dmi-registry@2021-12-13.yang'
-
- - changeSet:
- author: cps
- label: dmi-registry-schema-preload
- id: 9.8
- loadUpdateData:
- encoding: UTF-8
- file: 'changelog/db/changes/data/dmi/schema_set_yang_resources@2021-12-13.csv'
- quotchar: '"'
- primaryKey: 'schema_set_id,yang_resource_id'
- separator: '|'
- tableName: 'schema_set_yang_resources'
- usePreparedStatements: true
- rollback:
- - sql:
- 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@2021-12-13.yang')
\ No newline at end of file
Code Review / cps.git / blobdiff