1 # ============LICENSE_START=======================================================
2 # Copyright (c) 2021 Bell Canada.
3 # ================================================================================
4 # Licensed under the Apache License, Version 2.0 (the "License");
5 # you may not use this file except in compliance with the License.
6 # You may obtain a copy of the License at
8 # http://www.apache.org/licenses/LICENSE-2.0
10 # Unless required by applicable law or agreed to in writing, software
11 # distributed under the License is distributed on an "AS IS" BASIS,
12 # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
13 # See the License for the specific language governing permissions and
14 # limitations under the License.
15 # ============LICENSE_END=========================================================
17 # For legacy reasons, previous files for changeset Ids: 6, 11, 15, 17-21 have been condensed into this file.
30 primaryKeyName: anchor_pkey
54 name: from_fragment_id
64 name: relation_type_id
93 primaryKeyName: relation_type_pkey
96 tableName: relation_type
108 primaryKeyName: fragment_pkey
145 primaryKeyName: schema_set_pkey
158 tableName: schema_set
170 primaryKeyName: yang_resource_pkey
188 tableName: yang_resource
200 primaryKeyName: dataspace_pkey
218 name: schema_node_identifier
225 primaryKeyName: schema_node_pkey
228 tableName: schema_node
243 name: yang_resource_id
245 tableName: schema_set_yang_resources
254 indexName: FKI_ANCHOR_SCHEMA_SET_ID_FK
260 - addUniqueConstraint:
261 columnNames: dataspace_id, name
262 constraintName: anchor_dataspace_id_name_key
268 - addForeignKeyConstraint:
269 baseColumnNames: anchor_id
270 baseTableName: fragment
271 constraintName: fragment_anchor_id_fkey
273 initiallyDeferred: false
276 referencedColumnNames: id
277 referencedTableName: anchor
286 name: from_fragment_id
287 indexName: FKI_RELATIONS_FROM_ID_FK
297 indexName: FKI_RELATIONS_TO_ID_FK
306 name: relation_type_id
307 indexName: FKI_RELATION_TYPE_ID_FK
314 columnNames: to_fragment_id, from_fragment_id, relation_type_id
315 constraintName: relation_pkey
325 indexName: FKI_FRAGMENT_ANCHOR_ID_FK
335 indexName: FKI_FRAGMENT_DATASPACE_ID_FK
345 indexName: FKI_FRAGMENT_PARENT_ID_FK
355 indexName: FKI_SCHEMA_NODE_ID_TO_ID
367 indexName: UQ_FRAGMENT_XPATH
374 - addUniqueConstraint:
375 columnNames: dataspace_id, anchor_id, xpath
376 constraintName: fragment_dataspace_id_anchor_id_xpath_key
382 - addForeignKeyConstraint:
383 baseColumnNames: from_fragment_id
384 baseTableName: relation
385 constraintName: relation_from_fragment_id_fkey
387 initiallyDeferred: false
390 referencedColumnNames: id
391 referencedTableName: fragment
397 - addForeignKeyConstraint:
398 baseColumnNames: to_fragment_id
399 baseTableName: relation
400 constraintName: relation_to_fragment_id_fkey
402 initiallyDeferred: false
405 referencedColumnNames: id
406 referencedTableName: fragment
412 - addUniqueConstraint:
413 columnNames: name, dataspace_id
414 constraintName: schema_set_name_dataspace_id_key
415 tableName: schema_set
420 - addForeignKeyConstraint:
421 baseColumnNames: schema_set_id
422 baseTableName: schema_set_yang_resources
423 constraintName: schema_set_resource
425 initiallyDeferred: false
428 referencedColumnNames: id
429 referencedTableName: schema_set
435 - addUniqueConstraint:
436 columnNames: checksum
437 constraintName: yang_resource_checksum_key
438 tableName: yang_resource
443 - addUniqueConstraint:
445 constraintName: UQ_NAME
451 - addForeignKeyConstraint:
452 baseColumnNames: dataspace_id
453 baseTableName: fragment
454 constraintName: fragment_dataspace_id_fkey
456 initiallyDeferred: false
459 referencedColumnNames: id
460 referencedTableName: dataspace
466 - addForeignKeyConstraint:
467 baseColumnNames: dataspace_id
468 baseTableName: schema_set
469 constraintName: schema_set_dataspace
471 initiallyDeferred: false
474 referencedColumnNames: id
475 referencedTableName: dataspace
484 name: schema_node_identifier
485 indexName: PERF_SCHEMA_NODE_SCHEMA_NODE_ID
486 tableName: schema_node
491 - addForeignKeyConstraint:
492 baseColumnNames: yang_resource_id
493 baseTableName: schema_set_yang_resources
494 constraintName: schema_set_yang_resources_yang_resource_id_fkey
496 initiallyDeferred: false
499 referencedColumnNames: id
500 referencedTableName: yang_resource
506 - addForeignKeyConstraint:
507 baseColumnNames: dataspace_id
508 baseTableName: anchor
509 constraintName: anchor_dataspace_id_fkey
511 initiallyDeferred: false
514 referencedColumnNames: id
515 referencedTableName: dataspace
521 - addForeignKeyConstraint:
522 baseColumnNames: schema_set_id
523 baseTableName: anchor
524 constraintName: anchor_schema_set_id_fkey
526 initiallyDeferred: false
529 referencedColumnNames: id
530 referencedTableName: schema_set
536 - addForeignKeyConstraint:
537 baseColumnNames: relation_type_id
538 baseTableName: relation
539 constraintName: relation_relation_type_id_fkey
541 initiallyDeferred: false
544 referencedColumnNames: id
545 referencedTableName: relation_type
551 - addForeignKeyConstraint:
552 baseColumnNames: parent_id
553 baseTableName: fragment
554 constraintName: fragment_parent_id_fkey
556 initiallyDeferred: false
559 referencedColumnNames: id
560 referencedTableName: fragment
566 - addForeignKeyConstraint:
567 baseColumnNames: schema_node_id
568 baseTableName: fragment
569 constraintName: fragment_schema_node_id_fkey
571 initiallyDeferred: false
574 referencedColumnNames: id
575 referencedTableName: schema_node
578 logicalFilePath: changelog/db/changes/06-delete-not-required-fragment-index.yaml
581 comment: Drop unique index for dataspace and xpath on fragment table
584 indexName: UQ_FRAGMENT_XPATH
593 indexName: UQ_FRAGMENT_XPATH
598 logicalFilePath: changelog/db/changes/11-add-column-to-yang-resources-table.yaml
600 label: add-module-name-and-revision-column
604 tableName: yang_resource
613 logicalFilePath: changelog/db/changes/11-add-column-to-yang-resources-table.yaml
615 label: update-previous-data-module-name-and-revision
619 sql: update yang_resource set module_name = 'dummy_module_name', revision = '2021-08-04' where module_name is null and revision is null
621 sql: update yang_resource set module_name = null, revision = null where module_name = 'dummy_module_name' and revision = '2021-08-04'
623 logicalFilePath: changelog/db/changes/15-rename-column-yang-resource-table.yaml
625 label: yang-resource-rename-column
629 tableName: yang_resource
632 newColumnName: file_name
635 sql: alter table yang_resource rename column file_name to name
637 logicalFilePath: changelog/db/changes/17-add-index-to-schema-set-yang-resources.yaml
645 indexName: FKI_SCHEMA_SET_YANG_RESOURCES_SCHEMA_SET_ID_FK
646 tableName: schema_set_yang_resources
649 indexName: FKI_SCHEMA_SET_YANG_RESOURCES_SCHEMA_SET_ID_FK
650 tableName: schema_set_yang_resources
652 logicalFilePath: changelog/db/changes/18-cascade-delete-fragment-children.yaml
656 - dropForeignKeyConstraint:
657 baseTableName: fragment
658 constraintName: fragment_parent_id_fkey
659 - addForeignKeyConstraint:
660 baseColumnNames: parent_id
661 baseTableName: fragment
662 constraintName: fragment_parent_id_fkey
664 initiallyDeferred: false
667 referencedColumnNames: id
668 referencedTableName: fragment
671 - dropForeignKeyConstraint:
672 baseTableName: fragment
673 constraintName: fragment_parent_id_fkey
674 - addForeignKeyConstraint:
675 baseColumnNames: parent_id
676 baseTableName: fragment
677 constraintName: fragment_parent_id_fkey
679 initiallyDeferred: false
682 referencedColumnNames: id
683 referencedTableName: fragment
686 logicalFilePath: changelog/db/changes/19-delete-not-required-dataspace-id-from-fragment.yaml
691 indexName: FKI_FRAGMENT_DATASPACE_ID_FK
698 indexName: FKI_FRAGMENT_DATASPACE_ID_FK
701 logicalFilePath: changelog/db/changes/19-delete-not-required-dataspace-id-from-fragment.yaml
705 - dropUniqueConstraint:
706 constraintName: fragment_dataspace_id_anchor_id_xpath_key
708 - addUniqueConstraint:
709 columnNames: anchor_id, xpath
710 constraintName: fragment_anchor_id_xpath_key
713 - dropUniqueConstraint:
714 constraintName: fragment_anchor_id_xpath_key
716 - addUniqueConstraint:
717 columnNames: dataspace_id, anchor_id, xpath
718 constraintName: fragment_dataspace_id_anchor_id_xpath_key
721 logicalFilePath: changelog/db/changes/19-delete-not-required-dataspace-id-from-fragment.yaml
725 - dropForeignKeyConstraint:
726 baseTableName: fragment
727 constraintName: fragment_dataspace_id_fkey
729 - addForeignKeyConstraint:
730 baseColumnNames: dataspace_id
731 baseTableName: fragment
732 constraintName: fragment_dataspace_id_fkey
734 initiallyDeferred: false
737 referencedColumnNames: id
738 referencedTableName: dataspace
741 logicalFilePath: changelog/db/changes/19-delete-not-required-dataspace-id-from-fragment.yaml
746 columnName: dataspace_id
756 path: changelog/db/changes/19-repopulate-dataspace-id-for-rollback.sql
757 - addNotNullConstraint:
759 columnName: dataspace_id
760 columnDataType: INTEGER
763 logicalFilePath: changelog/db/changes/19-delete-not-required-dataspace-id-from-fragment.yaml
767 - addNotNullConstraint:
769 columnName: anchor_id
770 columnDataType: BIGINT
772 - dropNotNullConstraint:
774 columnName: anchor_id
775 columnDataType: BIGINT
778 logicalFilePath: changelog/db/changes/20-change-foreign-key-id-types-to-integer.yaml
782 columnName: dataspace_id
784 tableName: schema_set
786 columnName: schema_set_id
788 tableName: schema_set_yang_resources
790 columnName: yang_resource_id
792 tableName: schema_set_yang_resources
795 columnName: dataspace_id
797 tableName: schema_set
799 columnName: schema_set_id
801 tableName: schema_set_yang_resources
803 columnName: yang_resource_id
805 tableName: schema_set_yang_resources
807 logicalFilePath: changelog/db/changes/21-escape-quotes-in-xpath.yaml
812 path: changelog/db/changes/21-escape-quotes-in-xpath-forward.sql
815 path: changelog/db/changes/21-escape-quotes-in-xpath-rollback.sql