add: added projectsHEADmain

1 files changed, 15 insertions, 0 deletions

diff --git a/jws/epibazaar/shop/src/main/resources/db/migration/V1__Init.sql b/jws/epibazaar/shop/src/main/resources/db/migration/V1__Init.sql
new file mode 100644
index 0000000..0161cb5
--- /dev/null
+++ b/jws/epibazaar/shop/src/main/resources/db/migration/V1__Init.sql
@@ -0,0 +1,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
+);