<?xml version="1.0" encoding="UTF-8"?>
<!--
  ~ Created by Lukas Mansour on 6/19/18 6:53 PM
  ~ This work is licensed under the Creative Commons Attribution-NonCommercial-NoDerivative International License. ( Short Code: CC BY-NC-ND 4.0 )
  ~ To view a copy of this license, visit http://creativecommons.org/licenses/by-nc-nd/4.0/ or send a letter to
  ~ Creative Commons, PO Box 1866, Mountain View, CA 94042, USA.
  -->

<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.4.xsd">
    <changeSet author="Articdive" id="1">
        <createTable tableName="CURRENCIES">
            <column name="name" type="VARCHAR(255)">
                <constraints primaryKey="true"/>
            </column>
            <column name="world" type="VARCHAR(255)">
                <constraints primaryKey="true"/>
            </column>
            <column name="registered" type="BIGINT(20)">
                <constraints nullable="false"/>
            </column>
            <column name="plural" type="VARCHAR(255)"/>
            <column name="symbol" type="VARCHAR(255)"/>
            <column name="isGlobalCurrency" type="BIT(1)"/>
            <column name="isWorldCurrency" type="BIT(1)"/>
            <column name="defaultBalance" type="DECIMAL(19,2)"/>
        </createTable>
        <addUniqueConstraint tableName="CURRENCIES" columnNames="name, world"/>
        <createTable tableName="ACCOUNTS">
            <column name="uuid" type="VARCHAR(36)">
                <constraints nullable="false" unique="true" primaryKey="true"/>
            </column>
            <column name="registered" type="BIGINT(20)">
                <constraints nullable="false"/>
            </column>
            <column name="lastOnline" type="BIGINT(20)"/>
            <column name="lastKnownUsername" type="VARCHAR(255)"/>
            <column name="language" type="VARCHAR(255)"/>
            <column name="isPlayer" type="BIT(1)"/>
        </createTable>
        <createTable tableName="BALANCES">
            <column name="uuid" type="VARCHAR(36)">
                <constraints primaryKey="true"/>
            </column>
            <column name="world" type="VARCHAR(255)">
                <constraints primaryKey="true"/>
            </column>
            <column name="currency" type="VARCHAR(255)">
                <constraints primaryKey="true"/>
            </column>
            <column name="balance" type="DECIMAL(19,2)"/>
        </createTable>
        <addUniqueConstraint tableName="BALANCES" columnNames="uuid, world, currency"/>
    </changeSet>
</databaseChangeLog>