<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<databaseChangeLog logicalFilePath="database-schema.xml" 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="fmguler" id="init">
    </changeSet>
    <changeSet author="fmguler" id="0">
        <tagDatabase tag="tag-init"/>
    </changeSet>
    <!-- TEST SCHEMA >> -->
    <changeSet author="fmguler" id="1">
        <createTable schemaName="public" tableName="some_domain_object">
            <column autoIncrement="true" name="id" type="serial">
                <constraints nullable="false" primaryKey="true" primaryKeyName="some_domain_object_pkey"/>
            </column>
            <column name="name" type="VARCHAR(100)"/>
            <column name="description" type="TEXT(2147483647)"/>
            <column name="date" type="TIMESTAMP WITHOUT TIME ZONE"/>
            <column name="another_domain_object_id" type="int"/>
        </createTable>
    </changeSet>
    <changeSet author="fmguler" id="2">
        <createTable schemaName="public" tableName="another_domain_object">
            <column autoIncrement="true" name="id" type="serial">
                <constraints nullable="false" primaryKey="true" primaryKeyName="another_domain_object_pkey"/>
            </column>
            <column name="name" type="VARCHAR(100)"/>
            <column name="description" type="TEXT(2147483647)"/>
            <column name="date" type="TIMESTAMP WITHOUT TIME ZONE"/>
            <column name="some_domain_object_id" type="int"/>
        </createTable>
    </changeSet>
    <changeSet author="fmguler" id="3">
        <tagDatabase tag="tag-no-data"/>
    </changeSet>
    <changeSet author="fmguler" id="4">
        <insert schemaName="public" tableName="some_domain_object">
            <column name="name" value="sdo1"/>
            <column name="description" value="sdo desc1"/>
            <column name="date" value="2010-10-13"/>
            <column name="another_domain_object_id" value="1"/>
        </insert>
        <rollback>
            delete from some_domain_object;
        </rollback>
    </changeSet>
    <changeSet author="fmguler" id="5">
        <insert schemaName="public" tableName="another_domain_object">
            <column name="name" value="ado1"/>
            <column name="description" value="ado desc1"/>
            <column name="date" value="2011-01-19"/>
            <column name="some_domain_object_id" value="1"/>
        </insert>
        <insert schemaName="public" tableName="another_domain_object">
            <column name="name" value="ado2"/>
            <column name="description" value="ado desc2"/>
            <column name="date" value="2011-02-09"/>
            <column name="some_domain_object_id" value="1"/>
        </insert>
        <rollback>
            delete from another_domain_object;
        </rollback>
    </changeSet>
    <changeSet author="fmguler" id="6">
        <tagDatabase tag="tag-data"/>
    </changeSet>
    <!-- << TEST SCHEMA -->
</databaseChangeLog>