db.changelog-1.0.xml

<?xml version="1.1" encoding="UTF-8" standalone="no"?>
<databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog" xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.5.xsd">
    <changeSet author="Administrator (generated)" id="1484639745890-1">
        <createTable tableName="m_customer">
            <column name="customer_id" type="CHAR(36)">
                <constraints nullable="false"/>
            </column>
            <column name="nama_customer" type="VARCHAR(50)"/>
            <column name="alamat" type="VARCHAR(100)"/>
            <column name="kontak" type="VARCHAR(50)"/>
            <column name="telepon" type="VARCHAR(20)"/>
            <column defaultValueComputed="0.00" name="plafon_piutang" type="numeric(15, 2)"/>
            <column defaultValueComputed="0.00" name="total_piutang" type="numeric(15, 2)"/>
            <column defaultValueComputed="0.00" name="total_pembayaran_piutang" type="numeric(15, 2)"/>
        </createTable>
    </changeSet>
    <changeSet author="Administrator (generated)" id="1484639745890-2">
        <createTable tableName="m_supplier">
            <column name="supplier_id" type="CHAR(36)">
                <constraints nullable="false"/>
            </column>
            <column name="nama_supplier" type="VARCHAR(50)"/>
            <column name="alamat" type="VARCHAR(100)"/>
            <column name="kontak" type="VARCHAR(50)"/>
            <column name="telepon" type="VARCHAR(20)"/>
            <column defaultValueComputed="0.00" name="total_hutang" type="numeric(15, 2)"/>
            <column defaultValueComputed="0.00" name="total_pembayaran_hutang" type="numeric(15, 2)"/>
        </createTable>
    </changeSet>
</databaseChangeLog>