jws/epibazaar/shop/src/main/resources/db/migration/V1__Init.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

CREATE TABLE IF NOT EXISTS "shop"
(
    id                          SERIAL PRIMARY KEY NOT NULL,

    price_multiplier            FLOAT NOT NULL,
    upgrade_price               FLOAT NOT NULL
);

CREATE TABLE IF NOT EXISTS "item"
(
    id                          SERIAL PRIMARY KEY NOT NULL,

    type                        VARCHAR(64) NOT NULL,
    quantity                    FLOAT NOT NULL
);