fabiosoaza/spring-rest-base

View on GitHub
database-changelogs/db.changelog-1-0.xml

Summary

Maintainability
Test Coverage
<?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="tests" />
            </not>
        </preConditions>
        <sql>
            CREATE TABLE public.tests(
                id bigserial NOT NULL,
                uuid uuid NOT NULL,
                created timestamp with time zone NOT NULL default now(),
                CONSTRAINT pk_tests PRIMARY KEY (id)
            )
            WITH (
                OIDS=FALSE
            );
        </sql>
    </changeSet>

</databaseChangeLog>