From d85c1233dab14a9239646410d76ca35ed1cd0665 Mon Sep 17 00:00:00 2001
From: Georgios Andreadis <g.andreadis@student.tudelft.nl>
Date: Mon, 25 Sep 2017 10:45:22 +0200
Subject: Fix issue with rack creation

---
 database/schema.sql | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

(limited to 'database/schema.sql')

diff --git a/database/schema.sql b/database/schema.sql
index 0dc27afe..988f527a 100644
--- a/database/schema.sql
+++ b/database/schema.sql
@@ -442,7 +442,7 @@ DELIMITER ;
 -- PSUs on tiles
 DROP TABLE IF EXISTS psus;
 CREATE TABLE psus (
-  id               INTEGER     NOT NULL AUTO_INCREMENT,
+  id               INTEGER     NOT NULL,
   energy_kwh       INTEGER     NOT NULL CHECK (energy_kwh > 0),
   type             VARCHAR(50) NOT NULL,
   failure_model_id INTEGER     NOT NULL,
@@ -464,7 +464,7 @@ CREATE TABLE psus (
 -- Cooling items on tiles
 DROP TABLE IF EXISTS cooling_items;
 CREATE TABLE cooling_items (
-  id                   INTEGER     NOT NULL AUTO_INCREMENT,
+  id                   INTEGER     NOT NULL,
   energy_consumption_w INTEGER     NOT NULL CHECK (energy_consumption_w > 0),
   type                 VARCHAR(50) NOT NULL,
   failure_model_id     INTEGER     NOT NULL,
@@ -486,7 +486,7 @@ CREATE TABLE cooling_items (
 -- Racks on tiles
 DROP TABLE IF EXISTS racks;
 CREATE TABLE racks (
-  id               INTEGER NOT NULL AUTO_INCREMENT,
+  id               INTEGER NOT NULL,
   name             TEXT,
   capacity         INTEGER NOT NULL CHECK (capacity > 0),
   power_capacity_w INTEGER NOT NULL CHECK (power_capacity_w > 0),
-- 
cgit v1.2.3

