summaryrefslogtreecommitdiffstats
path: root/cps-ri/src/main/resources/changelog/db/changes/10-loadData-dmi-registry-fragment.yaml
blob: 83256905165ce7d65cc5d8917ac72e592dee3196 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
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