Tohuwabohu excorcism

Tool to track B changes

TO clean up the checksum after the change do

update databasechangelog set md5sum = null where filename = '2014_10_27.xml';

• There is the syntax of the liquibase call.
• The Driver name: org.h2.Driver
• THe location of the Driver is: c:\doj\materials\Liquibase\h2jar\h2-1.4.197.jar

liquibase --driver=org.h2.Driver --classpath="c:\doj\materials\Liquibase\h2jar\h2-1.4.197.jar"  --changeLogFile=../changelogs/extend.user.changelog.liquibase.xml --url="jdbc:h2:tcp://localhost:9092/mem:dbname" --username=mydbuser --password=mydbpass migrate

<?xml version="1.0" encoding="UTF-8"?>

<databaseChangeLog
        xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext"
        xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd
        http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd">

    <changeSet author="alf" id="add-nickname-to-users" >
        <addColumn tableName="User">
            <column name="nickname" type="varchar(8)"/>
        </addColumn>
    </changeSet>

    <changeSet author="alf" id="sqlfile-usernames-add-nicknames">
        <sqlFile dbms="h2, oracle"
                encoding="utf8"
                endDelimiter="\nGO"
                path="extend.user.changelog.liquibase.sql"
                relativeToChangelogFile="true"
                splitStatements="true"
                stripComments="true"/>
    </changeSet>

</databaseChangeLog>