crdb_keploy/changelog.yml at main · Sonichigo/crdb_keploy · GitHub

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
databaseChangeLog:
  - changeSet:
      id: 1
      author: john-doe
      comment: Create items table
      changes:
        - createTable:
            tableName: items
            columns:
              - column:
                  name: id
                  type: SERIAL
                  autoIncrement: true
                  constraints:
                    primaryKey: true
                    nullable: false
              - column:
                  name: name
                  type: VARCHAR(255)
                  constraints:
                    nullable: false
              - column:
                  name: description
                  type: TEXT
                  constraints:
                    nullable: true

  - changeSet:
      id: 2
      author: john-doe
      comment: Add index on name column for better query performance
      changes:
        - createIndex:
            indexName: idx_items_name
            tableName: items
            columns:
              - column:
                  name: name