db.changelog.20180515-execution-canceled-column.yml Maven / Gradle / Ivy
databaseChangeLog:
- removeChangeSetProperty:
change: addColumn
dbms: postgresql
remove: afterColumn
- changeSet:
validCheckSum: 8:4c214f01b403163ac014e78ef3603c71
id: add-canceled-column
author: robzienert
changes:
- addColumn:
tableName: pipelines
columns:
- column:
name: canceled
type: boolean
afterColumn: build_time
defaultValueBoolean: false
constraints:
nullable: false
- addColumn:
tableName: orchestrations
columns:
- column:
name: canceled
type: boolean
afterColumn: build_time
defaultValueBoolean: false
constraints:
nullable: false
- createIndex:
indexName: pipeline_canceled_idx
tableName: pipelines
columns:
- column:
name: canceled
- createIndex:
indexName: orchestration_canceled_idx
tableName: orchestrations
columns:
- column:
name: canceled
rollback:
- dropIndex:
indexName: orchestration_canceled_idx
tableName: orchestrations
- dropIndex:
indexName: pipeline_canceled_idx
tableName: pipelines
- dropColumn:
tableName: orchestrations
columnName: canceled
- dropColumn:
tableName: pipelines
columnName: canceled