add: added projectsHEADmain

1 files changed, 25 insertions, 0 deletions

diff --git a/jws/epibazaar/item-producer/src/main/resources/db/migration/V1__Init.sql b/jws/epibazaar/item-producer/src/main/resources/db/migration/V1__Init.sql
new file mode 100644
index 0000000..0eede01
--- /dev/null
+++ b/jws/epibazaar/item-producer/src/main/resources/db/migration/V1__Init.sql
@@ -0,0 +1,25 @@
+CREATE TABLE IF NOT EXISTS "game"
+(
+    id                              SERIAL PRIMARY KEY NOT NULL,
+    map                             TEXT NOT NULL
+);
+
+CREATE TABLE IF NOT EXISTS "item"
+(
+    id                              SERIAL PRIMARY KEY NOT NULL,
+
+    type                            VARCHAR(64) NOT NULL,
+    quantity                        FLOAT NOT NULL
+);
+
+CREATE TABLE IF NOT EXISTS "player"
+(
+    id                              SERIAL PRIMARY KEY NOT NULL,
+    pos_x                           INTEGER NOT NULL,
+    pos_y                           INTEGER NOT NULL,
+    last_move                       TIMESTAMP,
+    last_collect                    TIMESTAMP,
+    move_speed_multiplier           FLOAT NOT NULL,
+    stamina_multiplier              FLOAT NOT NULL,
+    collect_rate_multiplier         FLOAT NOT NULL
+);