• Home
• io.spinnaker.keel
• keel-sql
• 0.199.0
• source code
• 20200109-create-task-tracking-table.yml

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

db.changelog.20200109-create-task-tracking-table.yml Maven / Gradle / Ivy

databaseChangeLog:
  - changeSet:
      id: create-task-tracking-table
      author: gyardeni
      changes:
        - createTable:
            tableName: task_tracking
            columns:
              - column:
                  name: task_id
                  type: varchar(255)
                  constraints:
                    nullable: false
              - column:
                  name: task_name
                  type: longtext
                  value: "{}"
                  constraints:
                    nullable: false
              - column:
                  name: subject
                  type: varchar(255)
                  constraints:
                    - nullable: false
              - column:
                  name: timestamp
                  type: bigint
                  constraints:
                    nullable: false
              - modifySql:
                  dbms: mysql
                  append:
                    value: "engine innodb"
      rollback:
        - dropTable:
            tableName: task_tracking
  - changeSet:
      id: create-task_tracking-constraint-indicies
      author: gyardeni
      changes:
        - addPrimaryKey:
            tableName: task_tracking
            constraintName: task_tracking_pk
            columnNames: task_id
      rollback:
        - dropPrimaryKey:
            constraintName: task_tracking_pk
            tableName: task_tracking