diff options
Diffstat (limited to 'CREATE MySQL queries.sql')
| -rw-r--r-- | CREATE MySQL queries.sql | 36 |
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 |
