example-changelog.yml

---
databaseChangeLog:
  - preConditions:
      - runningAs:
          username: root
  - changeSet:
      id: 1
      author: kyawswar
      changes:
        -  tagDatabase:  
            tag:  version_1.0
        - createTable:
            tableName: person
            columns:
              - column:
                  name: id
                  type: int
                  autoIncrement: true
                  constraints:
                    primaryKey: true
                    nullable: false
              - column:
                  name: firstname
                  type: varchar(50)
              - column:
                  name: lastname
                  type: varchar(50)
                  constraints:
                    nullable: false
              - column:
                  name: state
                  type: char(2)
  - changeSet:
      id: 2
      author: kyawswar
      changes:
        -  tagDatabase:  
            tag:  version_1.1
        - addColumn:
            tableName: person
            columns:
              - column:
                  name: username
                  type: varchar(8)
  - changeSet:
      id: 3
      author: kyawswar
      changes:
        -  tagDatabase:  
            tag:  version_1.2
        - addLookupTable:
            existingTableName: person
            existingColumnName: state
            newTableName: state
            newColumnName: id
            newColumnDataType: char(2)