aboutsummaryrefslogtreecommitdiff
path: root/CREATE MySQL queries.sql
diff options
context:
space:
mode:
Diffstat (limited to 'CREATE MySQL queries.sql')
-rw-r--r--CREATE MySQL queries.sql36
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