diff options
Diffstat (limited to 'cps-ri/src/main/resources/changelog/db')
3 files changed, 56 insertions, 2 deletions
diff --git a/cps-ri/src/main/resources/changelog/db/changes/09-loadData-dmi-registry-schema-set.yaml b/cps-ri/src/main/resources/changelog/db/changes/09-loadData-dmi-registry-schema-set.yaml index 7b56e6a65d..d9be36a155 100644 --- a/cps-ri/src/main/resources/changelog/db/changes/09-loadData-dmi-registry-schema-set.yaml +++ b/cps-ri/src/main/resources/changelog/db/changes/09-loadData-dmi-registry-schema-set.yaml @@ -111,5 +111,4 @@ databaseChangeLog: tableName: 'anchor' rollback: - sql: - sql: delete from anchor where name = 'ncmp-dmi-registry' - + sql: delete from anchor where name = 'ncmp-dmi-registry'
\ No newline at end of file diff --git a/cps-ri/src/main/resources/changelog/db/changes/10-loadData-dmi-registry-fragment.yaml b/cps-ri/src/main/resources/changelog/db/changes/10-loadData-dmi-registry-fragment.yaml new file mode 100644 index 0000000000..8325690516 --- /dev/null +++ b/cps-ri/src/main/resources/changelog/db/changes/10-loadData-dmi-registry-fragment.yaml @@ -0,0 +1,53 @@ +databaseChangeLog: + - changeSet: + author: cps + label: dmi-registry-schema-preload + id: 10 + loadUpdateData: + encoding: UTF-8 + file: 'changelog/db/changes/data/dmi/fragment.csv' + onlyUpdate: 'false' + primaryKey: 'id' + quotchar: '"' + separator: '|' + tableName: 'fragment' + columns: + - column: + header: id + name: id + type: NUMERIC + - column: + header: xpath + name: xpath + type: STRING + - column: + header: attributes + name: attributes + type: CLOB + - column: + header: anchor_id + name: anchor_id + type: NUMERIC + - column: + header: parent_id + name: parent_id + type: NUMERIC + - column: + header: dataspace_id + name: dataspace_id + type: NUMERIC + - column: + header: schema_node_id + name: schema_node_id + type: NUMERIC + + - changeSet: + author: cps + label: dmi-registry-schema-preload + id: 10.1 + changes: + - sql: + comment: Fixes the id sequence after data insert with predefined ids + dbms: postgresql + sql: ALTER SEQUENCE IF EXISTS fragment_id_seq RESTART WITH 200 + diff --git a/cps-ri/src/main/resources/changelog/db/changes/data/dmi/fragment.csv b/cps-ri/src/main/resources/changelog/db/changes/data/dmi/fragment.csv new file mode 100644 index 0000000000..52aef0e239 --- /dev/null +++ b/cps-ri/src/main/resources/changelog/db/changes/data/dmi/fragment.csv @@ -0,0 +1,2 @@ +id|xpath|attributes|anchor_id|parent_id|dataspace_id|schema_node_id +144|/dmi-registry|{}|(select id from anchor where name='ncmp-dmi-registry')|null|(select id from dataspace where name='NCMP-Admin')|null
\ No newline at end of file |