db.changelog.20190803-create-delivery-artifact-version-table.yml Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of keel-sql Show documentation

Spinnaker Keel

There is a newer version: 1.4.1

databaseChangeLog:
  - changeSet:
      id: create-delivery-artifact-version-table
      author: fletch
      changes:
        - createTable:
            tableName: delivery_artifact_version
            columns:
              - column:
                  name: delivery_artifact_uid
                  type: char(26)
                  constraints:
                    nullable: false
              - column:
                  name: version
                  type: varchar(255)
                  constraints:
                    nullable: false
        - modifySql:
            dbms: mysql
            append:
              value: " engine innodb"
      rollback:
        - dropTable:
            tableName: delivery_artifact_version
  - changeSet:
      id: create-delivery-artifact-version-pk
      author: fletch
      changes:
        - addPrimaryKey:
            constraintName: delivery_artifact_version_pk
            tableName: delivery_artifact_version
            columnNames: delivery_artifact_uid, version
  - changeSet:
      id: create-delivery-artifact-version-primary-indicies
      author: fletch
      changes:
        - createIndex:
            indexName: delivery_artifact_version_uid_idx
            tableName: delivery_artifact_version
            columns:
              - column:
                  name: delivery_artifact_uid