medium-c51d4ee96a6e-s5.groovy

databaseChangeLog = {
    changeSet(author: 'Shashank', id: 'post.description.051020123') {
        comment { 'increase description to 1400 chars' }
        
        modifyDataType(tableName: 'post', columnName: 'description',
                       newDataType: 'varchar(1400)')
        
        // Altering the column removes the not null property (makes it nullable) if your column was non-nullable.
        // To fix this, you can pass "NOT NULL" to newDataType attribute as given below
        // https://stackoverflow.com/questions/35864845/liquibase-modifydatatype-tag-always-makes-the-column-nullable
        
        modifyDataType(tableName: 'post', columnName: 'description',
                       newDataType: 'varchar(1400) NOT NULL')
    }
    
}