fabiosoaza/spring-rest-base

<?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"
    xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
         http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd">


    <changeSet id="1" author="fabio.souza">
        <preConditions onFail="MARK_RAN" onSqlOutput="TEST">
            <not>
                <tableExists tableName="todos" />
            </not>
        </preConditions>
        <sql>
            CREATE TABLE public.todos(
                id bigserial NOT NULL,
                uuid uuid NOT NULL,
                title character varying(256) NOT NULL,
                description text,
                completed boolean NOT NULL DEFAULT false,
                created timestamp with time zone NOT NULL default now(),
                CONSTRAINT pk_todos PRIMARY KEY (id)
            )
            WITH (
                OIDS=FALSE
            );
        </sql>
    </changeSet>

</databaseChangeLog>