From 54054ba622ed7188074e1792ec85808597e6e028 Mon Sep 17 00:00:00 2001
From: Syndamia <kamen.d.mladenov@protonmail.com>
Date: Mon, 11 May 2020 18:17:54 +0300
Subject: Fixed/implimented mob fighting and mob terraforming. Random mob
 movement might be broken though.

---
 CREATE MySQL queries.sql | 18 ++++++++++++------
 1 file changed, 12 insertions(+), 6 deletions(-)

(limited to 'CREATE MySQL queries.sql')

diff --git a/CREATE MySQL queries.sql b/CREATE MySQL queries.sql
index 6d7d585..399eff9 100644
--- a/CREATE MySQL queries.sql	
+++ b/CREATE MySQL queries.sql	
@@ -26,14 +26,16 @@ CREATE TABLE SMobLayer(
 	id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
     XPos INT NOT NULL,
     YPos INT NOT NULL,
-    stock_id VARCHAR(45)
+    stock_id VARCHAR(45),
+    Health INT NOT NULL
 );
 
 CREATE TABLE SStructureLayer(
 	id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
     XPos INT NOT NULL,
     YPos INT NOT NULL,
-    stock_id VARCHAR(45)
+    stock_id VARCHAR(45),
+    Health INT NOT NULL
 );
 
 CREATE TABLE SGroundLayer(
@@ -48,14 +50,16 @@ CREATE TABLE LMobLayer(
 	id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
     XPos INT NOT NULL,
     YPos INT NOT NULL,
-    stock_id VARCHAR(45)
+    stock_id VARCHAR(45),
+    Health INT NOT NULL
 );
 
 CREATE TABLE LStructureLayer(
 	id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
     XPos INT NOT NULL,
     YPos INT NOT NULL,
-    stock_id VARCHAR(45)
+    stock_id VARCHAR(45),
+    Health INT NOT NULL
 );
 
 CREATE TABLE LGroundLayer(
@@ -70,14 +74,16 @@ CREATE TABLE UMobLayer(
 	id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
     XPos INT NOT NULL,
     YPos INT NOT NULL,
-    stock_id VARCHAR(45)
+    stock_id VARCHAR(45),
+    Health INT NOT NULL
 );
 
 CREATE TABLE UStructureLayer(
 	id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
     XPos INT NOT NULL,
     YPos INT NOT NULL,
-    stock_id VARCHAR(45)
+    stock_id VARCHAR(45),
+    Health INT NOT NULL
 );
 
 CREATE TABLE UGroundLayer(
-- 
cgit v1.2.3

