liquibase: mls_status
When using addColumn
the change must test if the column already exists.
- changeSet:
id: 1624977790584-1
author: mborodenko
changes:
- addColumn:
columns:
- column:
name: mls_status
type: varchar(50)
tableName: accession
needs to include a precondition:
preConditions:
- onFail: MARK_RAN
- not:
- columnExists:
columnName: mls_status
tableName: accession
And the id needs to be changed from id: 1624977790584-1
to id: 1624977790584-1x
.