From e5cab4f8f638f510077ba7ba936e856197841de6 Mon Sep 17 00:00:00 2001
From: Syndamia <kamen.d.mladenov@protonmail.com>
Date: Mon, 11 May 2020 14:23:15 +0300
Subject: Connection string is now a constant in DataBaseContexts. Fixed MySQL
 CREATE queries.

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

(limited to 'CREATE MySQL queries.sql')

diff --git a/CREATE MySQL queries.sql b/CREATE MySQL queries.sql
index dc5d093..6d7d585 100644
--- a/CREATE MySQL queries.sql	
+++ b/CREATE MySQL queries.sql	
@@ -24,65 +24,65 @@ CREATE TABLE Recipes (
 -- Sky SuperLayer tables
 CREATE TABLE SMobLayer(
 	id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
-    XPos INT NOT NULL UNIQUE,
-    YPos INT NOT NULL UNIQUE,
+    XPos INT NOT NULL,
+    YPos INT NOT NULL,
     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,
+    XPos INT NOT NULL,
+    YPos INT NOT NULL,
     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,
+    XPos INT NOT NULL,
+    YPos INT NOT NULL,
     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,
+    XPos INT NOT NULL,
+    YPos INT NOT NULL,
     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,
+    XPos INT NOT NULL,
+    YPos INT NOT NULL,
     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,
+    XPos INT NOT NULL,
+    YPos INT NOT NULL,
     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,
+    XPos INT NOT NULL,
+    YPos INT NOT NULL,
     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,
+    XPos INT NOT NULL,
+    YPos INT NOT NULL,
     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,
+    XPos INT NOT NULL,
+    YPos INT NOT NULL,
     stock_id VARCHAR(45)
 );
\ No newline at end of file
-- 
cgit v1.2.3