Connection string is now a constant in DataBaseContexts. Fixed MySQL CREATE queries.

1 files changed, 18 insertions, 18 deletions

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