Liquibase Cheatsheet

liquibase-cheatsheet.xml

// Precondition to execute a changelog
<preConditions onFail="MARK_RAN">
    <changeSetExecuted id="1" author="peter" changeLogFile="details/dbchangelog-01.00.00.00.xml"/>
    <columnExists tableName="user" columnName="username" />
</preConditions>

// Precondition to execute a changelog when the specific changelog hasn't been executed yet
<preConditions onFail="MARK_RAN">
    <not>
        <changeSetExecuted id="1" author="peter" changeLogFile="details/dbchangelog-01.00.00.00.xml"/>
        <columnExists tableName="user" columnName="username" />
    </not>
</preConditions>

// Drop Column "username" from table "user"
<changeSet author="peter" id="2">
    <dropColumn 
        columnName="username"
        tableName="user" />
</changeSet>