diff options
| author |   Niamh Core <niamh.core@est.tech> | 2021-08-05 13:06:57 +0000 |
|---|---|---|
| committer |   Gerrit Code Review <gerrit@onap.org> | 2021-08-05 13:06:57 +0000 |
| commit | 0e210d77ec39915046a95615f5f9d2a2dc65162b (patch) | |
| tree | 8bda19fd0f944e05b68b34a40595814501826bd0 /cps-ri/src/main/resources/changelog/db/changes/10-loadData-dmi-registry-fragment.yaml | |
| parent | 0fca83f368f3af6b0d909be0982fee29344e0402 (diff) | |
| parent | 4f4178c7af4ca5571a0813a5c79f35b11c825d35 (diff) | |
Merge "Implement DMI Registration (NCMP-Side)"
Diffstat (limited to 'cps-ri/src/main/resources/changelog/db/changes/10-loadData-dmi-registry-fragment.yaml')
| -rw-r--r-- | cps-ri/src/main/resources/changelog/db/changes/10-loadData-dmi-registry-fragment.yaml | 53 |
1 files changed, 53 insertions, 0 deletions
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 + |