diff options
Diffstat (limited to 'cps-ri/src/main/resources/changelog/db/changes/05-loadData-fragment.yaml')
| -rw-r--r-- | cps-ri/src/main/resources/changelog/db/changes/05-loadData-fragment.yaml | 84 |
1 files changed, 0 insertions, 84 deletions
diff --git a/cps-ri/src/main/resources/changelog/db/changes/05-loadData-fragment.yaml b/cps-ri/src/main/resources/changelog/db/changes/05-loadData-fragment.yaml deleted file mode 100644 index bd95a00e37..0000000000 --- a/cps-ri/src/main/resources/changelog/db/changes/05-loadData-fragment.yaml +++ /dev/null @@ -1,84 +0,0 @@ -# ============LICENSE_START======================================================= -# Copyright (C) 2021-2022 Nordix Foundation -# Modifications Copyright (C) 2021 Pantheon.tech -# ================================================================================ -# 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: xnf-data-preload - id: 5 - loadUpdateData: - encoding: UTF-8 - file: 'changelog/db/changes/data/fragment.csv' - onlyUpdate: 'false' - primaryKey: 'id' - quotchar: '"' - separator: '|' - tableName: 'fragment' - columns: - - column: - header: id - name: id - type: NUMERIC - - column: - header: xpath - name: xpath - type: STRING - - column: - header: attributes - name: attributes - type: CLOB - - column: - header: anchor_id - name: anchor_id - type: NUMERIC - - column: - header: parent_id - name: parent_id - type: NUMERIC - - column: - header: dataspace_id - name: dataspace_id - type: NUMERIC - - column: - header: schema_node_id - name: schema_node_id - type: NUMERIC - - - changeSet: - author: cps - label: xnf-data-preload - id: 5.1 - changes: - - sql: - comment: Fixes the id sequence after data insert with predefined ids - dbms: postgresql - sql: ALTER SEQUENCE IF EXISTS fragment_id_seq RESTART WITH 200 - - - changeSet: - author: cps - label: dmi-registry-schema-preload - id: 5.2 - changes: - - sql: - comment: Sets sequence value to current max value of the ID from the fragment table - dbms: postgresql - sql: SELECT setval('fragment_id_seq', (SELECT MAX(ID) FROM fragment)) - rollback: - sql: SELECT setval('fragment_id_seq', 200) - comment: Rollback Sequence to restart with the sequence number in the last changeset
\ No newline at end of file |