From 54054ba622ed7188074e1792ec85808597e6e028 Mon Sep 17 00:00:00 2001 From: Syndamia 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