summaryrefslogtreecommitdiff
path: root/jws/epibazaar/shop/src/main/resources/db/migration/V1__Init.sql
blob: 0161cb577d4feb593160c7e6d0488d08d3a93da9 (plain)
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
);