db.changelog-1.1.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="1484641393235-1">
        <createTable tableName="m_alasan_penyesuaian_stok">
            <column name="alasan_penyesuaian_stok_id" type="CHAR(36)">
                <constraints nullable="false"/>
            </column>
            <column name="alasan" type="VARCHAR(100)"/>
        </createTable>
    </changeSet>
    <changeSet author="Administrator (generated)" id="1484641393235-2">
        <createTable tableName="m_golongan">
            <column name="golongan_id" type="CHAR(36)">
                <constraints nullable="false"/>
            </column>
            <column name="nama_golongan" type="VARCHAR(50)"/>
        </createTable>
    </changeSet>
    <changeSet author="Administrator (generated)" id="1484641393235-3">
        <createTable tableName="m_produk">
            <column name="produk_id" type="CHAR(36)">
                <constraints nullable="false"/>
            </column>
            <column name="kode_barcode" type="VARCHAR(15)"/>
            <column name="nama_produk" type="VARCHAR(50)"/>
            <column name="satuan" type="VARCHAR(20)"/>
            <column defaultValueComputed="0.00" name="stok" type="numeric(5, 2)"/>
            <column defaultValueComputed="0.00" name="harga_beli" type="numeric(10, 2)"/>
            <column defaultValueComputed="0.00" name="harga_jual" type="numeric(10, 2)"/>
            <column name="golongan_id" type="CHAR(36)"/>
            <column defaultValueComputed="0.00" name="minimal_stok" type="numeric(5, 2)"/>
            <column defaultValueComputed="0.00" name="stok_gudang" type="numeric(5, 2)"/>
            <column defaultValueComputed="0.00" name="minimal_stok_gudang" type="numeric(5, 2)"/>
        </createTable>
    </changeSet>
    <changeSet author="Administrator (generated)" id="1484641393235-4">
        <createTable tableName="t_penyesuaian_stok">
            <column name="penyesuaian_stok_id" type="CHAR(36)">
                <constraints nullable="false"/>
            </column>
            <column name="produk_id" type="CHAR(36)"/>
            <column name="alasan_penyesuaian_id" type="CHAR(36)"/>
            <column name="tanggal" type="date"/>
            <column defaultValueComputed="0.00" name="penambahan_stok" type="numeric(5, 2)"/>
            <column defaultValueComputed="0.00" name="pengurangan_stok" type="numeric(5, 2)"/>
            <column defaultValueComputed="0.00" name="penambahan_stok_gudang" type="numeric(5, 2)"/>
            <column defaultValueComputed="0.00" name="pengurangan_stok_gudang" type="numeric(5, 2)"/>
            <column name="keterangan" type="VARCHAR(100)"/>
            <column defaultValueComputed="now()" name="tanggal_sistem" type="TIMESTAMP(6) WITHOUT TIME ZONE"/>
        </createTable>
    </changeSet>
</databaseChangeLog>