Condense Liquibase steps

[cps.git] / cps-ri / src / main / resources / changelog / db / changes / 11-add-column-to-yang-resources-table.yaml

diff --git a/cps-ri/src/main/resources/changelog/db/changes/11-add-column-to-yang-resources-table.yaml b/cps-ri/src/main/resources/changelog/db/changes/11-add-column-to-yang-resources-table.yaml
deleted file mode 100644 (file)
index 8643a05..0000000
--- a/cps-ri/src/main/resources/changelog/db/changes/11-add-column-to-yang-resources-table.yaml
+++ /dev/null
@@ -1,43 +0,0 @@
-# ============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:
-      id: 11
-      label: add-module-name-and-revision-column
-      author: cps
-      changes:
-        - addColumn:
-            tableName: yang_resource
-            columns:
-              - column:
-                  name: module_name
-                  type: TEXT
-              - column:
-                  name: revision
-                  type: TEXT
-
-  - changeSet:
-      id: 11.1
-      label: update-previous-data-module-name-and-revision
-      author: cps
-      changes:
-        - sql:
-            sql: update yang_resource set module_name = 'dummy_module_name', revision = '2021-08-04' where module_name is null and revision is null
-      rollback:
-        sql: update yang_resource set module_name = null, revision = null where module_name = 'dummy_module_name' and revision = '2021-08-04'
\ No newline at end of file