From b36420be0abb05ecdd6b6996e30c09ca19be7b64 Mon Sep 17 00:00:00 2001
From: Syndamia <kamen.d.mladenov@protonmail.com>
Date: Mon, 11 May 2020 14:12:55 +0300
Subject: Added a file with the queries that you need to execute for the
 program to work (queries for creating the database and the different tables).

---
 CREATE MySQL queries.sql | 88 ++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 88 insertions(+)
 create mode 100644 CREATE MySQL queries.sql

(limited to 'CREATE MySQL queries.sql')

diff --git a/CREATE MySQL queries.sql b/CREATE MySQL queries.sql
new file mode 100644
index 0000000..dc5d093
--- /dev/null
+++ b/CREATE MySQL queries.sql	
@@ -0,0 +1,88 @@
+CREATE SCHEMA Mundus;
+USE Mundus;
+
+CREATE TABLE GameEventLogs (
+	id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
+    message VARCHAR(100) NOT NULL
+);
+
+CREATE TABLE Recipes (
+	id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
+	resultitem VARCHAR(45) NOT NULL,
+    count1 INT NOT NULL,
+    reqitem1 VARCHAR(45) NOT NULL,
+    count2 INT,
+    reqitem2 VARCHAR(45),
+    count3 INT,
+    reqitem3 VARCHAR(45),
+    count4 INT,
+    reqitem4 VARCHAR(45),
+    count5 INT,
+    reqitem5 VARCHAR(45)
+);
+
+-- Sky SuperLayer tables
+CREATE TABLE SMobLayer(
+	id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
+    XPos INT NOT NULL UNIQUE,
+    YPos INT NOT NULL UNIQUE,
+    stock_id VARCHAR(45)
+);
+
+CREATE TABLE SStructureLayer(
+	id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
+    XPos INT NOT NULL UNIQUE,
+    YPos INT NOT NULL UNIQUE,
+    stock_id VARCHAR(45)
+);
+
+CREATE TABLE SGroundLayer(
+	id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
+    XPos INT NOT NULL UNIQUE,
+    YPos INT NOT NULL UNIQUE,
+    stock_id VARCHAR(45)
+);
+
+-- Land SuperLayer tables
+CREATE TABLE LMobLayer(
+	id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
+    XPos INT NOT NULL UNIQUE,
+    YPos INT NOT NULL UNIQUE,
+    stock_id VARCHAR(45)
+);
+
+CREATE TABLE LStructureLayer(
+	id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
+    XPos INT NOT NULL UNIQUE,
+    YPos INT NOT NULL UNIQUE,
+    stock_id VARCHAR(45)
+);
+
+CREATE TABLE LGroundLayer(
+	id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
+    XPos INT NOT NULL UNIQUE,
+    YPos INT NOT NULL UNIQUE,
+    stock_id VARCHAR(45)
+);
+
+-- Underground SuperLayer tables
+CREATE TABLE UMobLayer(
+	id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
+    XPos INT NOT NULL UNIQUE,
+    YPos INT NOT NULL UNIQUE,
+    stock_id VARCHAR(45)
+);
+
+CREATE TABLE UStructureLayer(
+	id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
+    XPos INT NOT NULL UNIQUE,
+    YPos INT NOT NULL UNIQUE,
+    stock_id VARCHAR(45)
+);
+
+CREATE TABLE UGroundLayer(
+	id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
+    XPos INT NOT NULL UNIQUE,
+    YPos INT NOT NULL UNIQUE,
+    stock_id VARCHAR(45)
+);
\ No newline at end of file
-- 
cgit v1.2.3

