From 967be9e750221ab2ab783f95df79bb26d290a45e Mon Sep 17 00:00:00 2001
From: Martial Simon <msimon_fr@hotmail.com>
Date: Mon, 15 Sep 2025 01:07:58 +0200
Subject: add: added projects

---
 .../src/main/resources/db/migration/V1__Init.sql   | 25 ++++++++++++++++++++++
 1 file changed, 25 insertions(+)
 create mode 100644 jws/epibazaar/item-producer/src/main/resources/db/migration/V1__Init.sql

(limited to 'jws/epibazaar/item-producer/src/main/resources/db/migration/V1__Init.sql')

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
+);
-- 
cgit v1.2.3

