diff options
Diffstat (limited to 'integration-test/src/test/resources/liquibase/test-changelog.yaml')
| -rw-r--r-- | integration-test/src/test/resources/liquibase/test-changelog.yaml | 628 |
1 files changed, 0 insertions, 628 deletions
diff --git a/integration-test/src/test/resources/liquibase/test-changelog.yaml b/integration-test/src/test/resources/liquibase/test-changelog.yaml deleted file mode 100644 index ba639ede01..0000000000 --- a/integration-test/src/test/resources/liquibase/test-changelog.yaml +++ /dev/null @@ -1,628 +0,0 @@ -# ============LICENSE_START======================================================= -# Copyright (c) 2023-2024 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. -# ============LICENSE_END========================================================= - -databaseChangeLog: - - changeSet: - id: 1-1 - author: cps - changes: - - createTable: - columns: - - column: - autoIncrement: true - constraints: - nullable: false - primaryKey: true - primaryKeyName: anchor_pkey - name: id - type: BIGINT - - column: - name: name - type: TEXT - - column: - name: schema_set_id - type: INTEGER - - column: - constraints: - nullable: false - name: dataspace_id - type: INTEGER - tableName: anchor - - changeSet: - id: 1-2 - author: cps - changes: - - createTable: - columns: - - column: - constraints: - nullable: false - name: from_fragment_id - type: BIGINT - - column: - constraints: - nullable: false - name: to_fragment_id - type: BIGINT - - column: - constraints: - nullable: false - name: relation_type_id - type: INTEGER - - column: - constraints: - nullable: false - name: from_rel_xpath - type: TEXT - - column: - constraints: - nullable: false - name: to_rel_xpath - type: TEXT - tableName: relation - - changeSet: - id: 1-3 - author: cps - changes: - - createTable: - columns: - - column: - constraints: - nullable: false - name: relation_type - type: TEXT - - column: - autoIncrement: true - constraints: - nullable: false - primaryKey: true - primaryKeyName: relation_type_pkey - name: id - type: INTEGER - tableName: relation_type - - changeSet: - id: 1-4 - author: cps - changes: - - createTable: - columns: - - column: - autoIncrement: false - constraints: - nullable: false - primaryKey: true - primaryKeyName: fragment_pkey - name: id - type: BIGINT - - column: - constraints: - nullable: false - name: xpath - type: TEXT - - column: - name: attributes - type: JSONB - - column: - constraints: - nullable: false - name: anchor_id - type: BIGINT - - column: - name: parent_id - type: BIGINT - - column: - name: schema_node_id - type: INTEGER - tableName: fragment - - createSequence: - dataType: BIGINT - incrementBy: 100 - sequenceName: fragment_id_seq - startValue: 100 - - changeSet: - id: 1-5 - author: cps - changes: - - createTable: - columns: - - column: - autoIncrement: true - constraints: - nullable: false - primaryKey: true - primaryKeyName: schema_set_pkey - name: id - type: INTEGER - - column: - constraints: - nullable: false - name: name - type: TEXT - - column: - constraints: - nullable: false - name: dataspace_id - type: INTEGER - tableName: schema_set - - changeSet: - id: 1-6 - author: cps - changes: - - createTable: - columns: - - column: - autoIncrement: true - constraints: - nullable: false - primaryKey: true - primaryKeyName: yang_resource_pkey - name: id - type: INTEGER - - column: - constraints: - nullable: false - name: name - type: TEXT - - column: - constraints: - nullable: false - name: content - type: TEXT - - column: - constraints: - nullable: false - name: checksum - type: TEXT - tableName: yang_resource - - changeSet: - id: 1-7 - author: cps - changes: - - createTable: - columns: - - column: - autoIncrement: true - constraints: - nullable: false - primaryKey: true - primaryKeyName: dataspace_pkey - name: id - type: INTEGER - - column: - constraints: - nullable: false - name: name - type: TEXT - tableName: dataspace - - changeSet: - id: 1-8 - author: cps - changes: - - createTable: - columns: - - column: - constraints: - nullable: false - name: schema_node_identifier - type: TEXT - - column: - autoIncrement: true - constraints: - nullable: false - primaryKey: true - primaryKeyName: schema_node_pkey - name: id - type: INTEGER - tableName: schema_node - - changeSet: - id: 1-9 - author: cps - changes: - - createTable: - columns: - - column: - constraints: - nullable: false - name: schema_set_id - type: INTEGER - - column: - constraints: - nullable: false - name: yang_resource_id - type: INTEGER - tableName: schema_set_yang_resources - - changeSet: - id: 1-10 - author: cps - changes: - - createIndex: - columns: - - column: - name: schema_set_id - indexName: FKI_ANCHOR_SCHEMA_SET_ID_FK - tableName: anchor - - changeSet: - id: 1-11 - author: cps - changes: - - addUniqueConstraint: - columnNames: dataspace_id, name - constraintName: anchor_dataspace_id_name_key - tableName: anchor - - changeSet: - id: 1-12 - author: cps - changes: - - addForeignKeyConstraint: - baseColumnNames: anchor_id - baseTableName: fragment - constraintName: fragment_anchor_id_fkey - deferrable: false - initiallyDeferred: false - onDelete: NO ACTION - onUpdate: NO ACTION - referencedColumnNames: id - referencedTableName: anchor - validate: true - - changeSet: - id: 1-13 - author: cps - changes: - - createIndex: - columns: - - column: - name: from_fragment_id - indexName: FKI_RELATIONS_FROM_ID_FK - tableName: relation - - changeSet: - id: 1-14 - author: cps - changes: - - createIndex: - columns: - - column: - name: to_fragment_id - indexName: FKI_RELATIONS_TO_ID_FK - tableName: relation - - changeSet: - id: 1-15 - author: cps - changes: - - createIndex: - columns: - - column: - name: relation_type_id - indexName: FKI_RELATION_TYPE_ID_FK - tableName: relation - - changeSet: - id: 1-16 - author: cps - changes: - - addPrimaryKey: - columnNames: to_fragment_id, from_fragment_id, relation_type_id - constraintName: relation_pkey - tableName: relation - - changeSet: - id: 1-17 - author: cps - changes: - - createIndex: - columns: - - column: - name: anchor_id - indexName: FKI_FRAGMENT_ANCHOR_ID_FK - tableName: fragment - - changeSet: - id: 1-19 - author: cps - changes: - - createIndex: - columns: - - column: - name: parent_id - indexName: FKI_FRAGMENT_PARENT_ID_FK - tableName: fragment - - changeSet: - id: 1-20 - author: cps - changes: - - createIndex: - columns: - - column: - name: schema_node_id - indexName: FKI_SCHEMA_NODE_ID_TO_ID - tableName: fragment - - changeSet: - id: 1-22 - author: cps - changes: - - addUniqueConstraint: - columnNames: anchor_id, xpath - constraintName: fragment_anchor_id_xpath_key - tableName: fragment - - changeSet: - id: 1-23 - author: cps - changes: - - addForeignKeyConstraint: - baseColumnNames: from_fragment_id - baseTableName: relation - constraintName: relation_from_fragment_id_fkey - deferrable: false - initiallyDeferred: false - onDelete: NO ACTION - onUpdate: NO ACTION - referencedColumnNames: id - referencedTableName: fragment - validate: true - - changeSet: - id: 1-24 - author: cps - changes: - - addForeignKeyConstraint: - baseColumnNames: to_fragment_id - baseTableName: relation - constraintName: relation_to_fragment_id_fkey - deferrable: false - initiallyDeferred: false - onDelete: NO ACTION - onUpdate: NO ACTION - referencedColumnNames: id - referencedTableName: fragment - validate: true - - changeSet: - id: 1-25 - author: cps - changes: - - addUniqueConstraint: - columnNames: name, dataspace_id - constraintName: schema_set_name_dataspace_id_key - tableName: schema_set - - changeSet: - id: 1-26 - author: cps - changes: - - addForeignKeyConstraint: - baseColumnNames: schema_set_id - baseTableName: schema_set_yang_resources - constraintName: schema_set_resource - deferrable: false - initiallyDeferred: false - onDelete: CASCADE - onUpdate: NO ACTION - referencedColumnNames: id - referencedTableName: schema_set - validate: true - - changeSet: - id: 1-27 - author: cps - changes: - - addUniqueConstraint: - columnNames: checksum - constraintName: yang_resource_checksum_key - tableName: yang_resource - - changeSet: - id: 1-28 - author: cps - changes: - - addUniqueConstraint: - columnNames: name - constraintName: UQ_NAME - tableName: dataspace - - changeSet: - id: 1-30 - author: cps - changes: - - addForeignKeyConstraint: - baseColumnNames: dataspace_id - baseTableName: schema_set - constraintName: schema_set_dataspace - deferrable: false - initiallyDeferred: false - onDelete: CASCADE - onUpdate: CASCADE - referencedColumnNames: id - referencedTableName: dataspace - validate: true - - changeSet: - id: 1-31 - author: cps - changes: - - createIndex: - columns: - - column: - name: schema_node_identifier - indexName: PERF_SCHEMA_NODE_SCHEMA_NODE_ID - tableName: schema_node - - changeSet: - id: 1-32 - author: cps - changes: - - addForeignKeyConstraint: - baseColumnNames: yang_resource_id - baseTableName: schema_set_yang_resources - constraintName: schema_set_yang_resources_yang_resource_id_fkey - deferrable: false - initiallyDeferred: false - onDelete: NO ACTION - onUpdate: NO ACTION - referencedColumnNames: id - referencedTableName: yang_resource - validate: true - - changeSet: - id: 1-33 - author: cps - changes: - - addForeignKeyConstraint: - baseColumnNames: dataspace_id - baseTableName: anchor - constraintName: anchor_dataspace_id_fkey - deferrable: false - initiallyDeferred: false - onDelete: NO ACTION - onUpdate: NO ACTION - referencedColumnNames: id - referencedTableName: dataspace - validate: true - - changeSet: - id: 1-34 - author: cps - changes: - - addForeignKeyConstraint: - baseColumnNames: schema_set_id - baseTableName: anchor - constraintName: anchor_schema_set_id_fkey - deferrable: false - initiallyDeferred: false - onDelete: NO ACTION - onUpdate: NO ACTION - referencedColumnNames: id - referencedTableName: schema_set - validate: true - - changeSet: - id: 1-35 - author: cps - changes: - - addForeignKeyConstraint: - baseColumnNames: relation_type_id - baseTableName: relation - constraintName: relation_relation_type_id_fkey - deferrable: false - initiallyDeferred: false - onDelete: NO ACTION - onUpdate: NO ACTION - referencedColumnNames: id - referencedTableName: relation_type - validate: true - - changeSet: - id: 1-36 - author: cps - changes: - - addForeignKeyConstraint: - baseColumnNames: parent_id - baseTableName: fragment - constraintName: fragment_parent_id_fkey - deferrable: false - initiallyDeferred: false - onDelete: NO ACTION - onUpdate: NO ACTION - referencedColumnNames: id - referencedTableName: fragment - validate: true - - changeSet: - id: 1-37 - author: cps - changes: - - addForeignKeyConstraint: - baseColumnNames: schema_node_id - baseTableName: fragment - constraintName: fragment_schema_node_id_fkey - deferrable: false - initiallyDeferred: false - onDelete: NO ACTION - onUpdate: NO ACTION - referencedColumnNames: id - referencedTableName: schema_node - validate: true - - - - changeSet: - id: 1-38 - 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: 1-39 - 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' - - - changeSet: - author: cps - label: yang-resource-rename-column - id: 1-40 - changes: - - renameColumn: - tableName: yang_resource - columnDataType: TEXT - oldColumnName: name - newColumnName: file_name - rollback: - - sql: - sql: alter table yang_resource rename column file_name to name - - - changeSet: - author: cps - id: 1-41 - changes: - - createIndex: - columns: - - column: - name: schema_set_id - indexName: FKI_SCHEMA_SET_YANG_RESOURCES_SCHEMA_SET_ID_FK - tableName: schema_set_yang_resources - rollback: - - dropIndex: - indexName: FKI_SCHEMA_SET_YANG_RESOURCES_SCHEMA_SET_ID_FK - tableName: schema_set_yang_resources - - - changeSet: - author: cps - id: 1-42 - changes: - - dropForeignKeyConstraint: - baseTableName: fragment - constraintName: fragment_parent_id_fkey - - addForeignKeyConstraint: - baseColumnNames: parent_id - baseTableName: fragment - constraintName: fragment_parent_id_fkey - deferrable: false - initiallyDeferred: false - onDelete: CASCADE - onUpdate: NO ACTION - referencedColumnNames: id - referencedTableName: fragment - validate: true - rollback: - - dropForeignKeyConstraint: - baseTableName: fragment - constraintName: fragment_parent_id_fkey - - addForeignKeyConstraint: - baseColumnNames: parent_id - baseTableName: fragment - constraintName: fragment_parent_id_fkey - deferrable: false - initiallyDeferred: false - onDelete: NO ACTION - onUpdate: NO ACTION - referencedColumnNames: id - referencedTableName: fragment - validate: true |