| # ============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 |