Liquibase. Training

<?xml version="1.0" encoding="utf-8"?>
<databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog/1.9"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog/1.9
        http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-1.9.xsd">

    <changeSet author="ipetrov" id="1">
        <preConditions>
            <not>
                <tableExists tableName="QUESTION" />
                <tableExists tableName="ANSWER" />
                <tableExists tableName="CHOISE" />
            </not>
        </preConditions>
        <createTable tableName="QUESTION">
            <column name="QUESTION_ID" type="java.sql.Types.INTEGER"
                autoIncrement="true">
                <constraints nullable="false" primaryKey="true" />
            </column>
            <column name="QUESTION_TITLE" type="java.sql.Types.VARCHAR(1024)">
                <constraints nullable="true"/>
            </column>
            <column name="QUESTION_TEXT" type="java.sql.Types.VARCHAR(1024)">
                <constraints nullable="false" />
            </column>
        </createTable>
        <createTable tableName="ANSWER">
            <column name="ANSWER_ID" type="java.sql.Types.INTEGER"
                autoIncrement="true">
                <constraints nullable="false" primaryKey="true" />
            </column>
            <column name="QUESTION_ID" type="java.sql.Types.Integer">
                <constraints nullable="true" />
            </column>
            <column name="ANSWER_TEXT" type="java.sql.Types.VARCHAR(1024)">
                <constraints nullable="false" />
            </column>
        </createTable>
        <createTable tableName="CHOISE">
            <column name="UUID" type="java.sql.Types.INTEGER"
                autoIncrement="false">
                <constraints nullable="false" />
            </column>
            <column name="ANSWER_ID" type="java.sql.Types.INTEGER">
                <constraints nullable="false" />
            </column>
        </createTable>
        <addPrimaryKey tableName="CHOISE" columnNames="UUID,ANSWER_ID" />
    </changeSet>

    <changeSet author="ipetrov" id="2">
        <preConditions>
            <tableExists tableName="QUESTION" />
            <tableExists tableName="ANSWER" />
            <tableExists tableName="CHOISE" />
        </preConditions>
        <addForeignKeyConstraint constraintName="FK_QuestionID"
            referencedTableName="QUESTION" baseColumnNames="QUESTION_ID"
            baseTableName="ANSWER" referencedColumnNames="QUESTION_ID" />
        <addForeignKeyConstraint constraintName="FK_AnswerID"
            referencedTableName="ANSWER" baseColumnNames="ANSWER_ID"
            baseTableName="CHOISE" referencedColumnNames="ANSWER_ID" />
    </changeSet>

    <changeSet author="ipetrov" id="3">
        <preConditions>
            <tableExists tableName="QUESTION" />
            <tableExists tableName="ANSWER" />
            <tableExists tableName="CHOISE" />
        </preConditions>
        <insert tableName="QUESTION">
            <column name="QUESTION_ID" valueNumeric="1" />
            <column name="QUESTION_TEXT" value="Question-1" />
        </insert>
        <insert tableName="QUESTION">
            <column name="QUESTION_ID" valueNumeric="2" />
            <column name="QUESTION_TEXT" value="Question-2" />
        </insert>
        <insert tableName="QUESTION">
            <column name="QUESTION_ID" valueNumeric="3" />
            <column name="QUESTION_TEXT" value="Question-3" />
        </insert>
    </changeSet>

    <changeSet author="ipetrov" id="4">
        <preConditions>
            <tableExists tableName="QUESTION" />
            <tableExists tableName="ANSWER" />
            <tableExists tableName="CHOISE" />
        </preConditions>
        <insert tableName="ANSWER">
            <column name="ANSWER_ID" valueNumeric="1" />
            <column name="QUESTION_ID" valueNumeric="1" />
            <column name="ANSWER_TEXT" value="Answer-1" />
        </insert>
        <insert tableName="ANSWER">
            <column name="ANSWER_ID" valueNumeric="2" />
            <column name="QUESTION_ID" valueNumeric="1" />
            <column name="ANSWER_TEXT" value="Answer-1" />
        </insert>
        <insert tableName="ANSWER">
            <column name="ANSWER_ID" valueNumeric="3" />
            <column name="QUESTION_ID" valueNumeric="1" />
            <column name="ANSWER_TEXT" value="Answer-3" />
        </insert>
        <insert tableName="ANSWER">
            <column name="ANSWER_ID" valueNumeric="4" />
            <column name="QUESTION_ID" valueNumeric="2" />
            <column name="ANSWER_TEXT" value="Answer-4" />
        </insert>
        <insert tableName="ANSWER">
            <column name="ANSWER_ID" valueNumeric="5" />
            <column name="QUESTION_ID" valueNumeric="2" />
            <column name="ANSWER_TEXT" value="Answer-5" />
        </insert>
        <insert tableName="ANSWER">
            <column name="ANSWER_ID" valueNumeric="6" />
            <column name="QUESTION_ID" valueNumeric="2" />
            <column name="ANSWER_TEXT" value="Answer-6" />
        </insert>
        <insert tableName="ANSWER">
            <column name="ANSWER_ID" valueNumeric="7" />
            <column name="QUESTION_ID" valueNumeric="3" />
            <column name="ANSWER_TEXT" value="Answer-7" />
        </insert>
        <insert tableName="ANSWER">
            <column name="ANSWER_ID" valueNumeric="8" />
            <column name="QUESTION_ID" valueNumeric="3" />
            <column name="ANSWER_TEXT" value="Answer-8" />
        </insert>
    </changeSet>

    <changeSet author="ipetrov" id="5">
        <preConditions>
            <tableExists tableName="QUESTION" />
            <tableExists tableName="ANSWER" />
            <tableExists tableName="CHOISE" />
        </preConditions>
        <insert tableName="CHOISE">
            <column name="UUID" valueNumeric="1" />
            <column name="ANSWER_ID" valueNumeric="1" />
        </insert>
        <insert tableName="CHOISE">
            <column name="UUID" valueNumeric="1" />
            <column name="ANSWER_ID" valueNumeric="2" />
        </insert>
        <insert tableName="CHOISE">
            <column name="UUID" valueNumeric="1" />
            <column name="ANSWER_ID" valueNumeric="3" />
        </insert>
        <insert tableName="CHOISE">
            <column name="UUID" valueNumeric="1" />
            <column name="ANSWER_ID" valueNumeric="5" />
        </insert>
        <insert tableName="CHOISE">
            <column name="UUID" valueNumeric="1" />
            <column name="ANSWER_ID" valueNumeric="8" />
        </insert>
    </changeSet>
</databaseChangeLog>