name: schema_node_id
indexName: FKI_SCHEMA_NODE_ID_TO_ID
tableName: fragment
- - changeSet:
- id: 1-21
- author: cps
- changes:
- - createIndex:
- columns:
- - column:
- name: xpath
- - column:
- name: dataspace_id
- indexName: UQ_FRAGMENT_XPATH
- tableName: fragment
- unique: true
- changeSet:
id: 1-22
author: cps
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