Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
<?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>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment