From 2ab2f88c4353207f7b99cd77bc478502610f2e9e Mon Sep 17 00:00:00 2001
From: Georgios Andreadis <g.andreadis@student.tudelft.nl>
Date: Mon, 25 Sep 2017 08:52:44 +0200
Subject: Remove uniqueness constraint on room names

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

(limited to 'database/schema.sql')

diff --git a/database/schema.sql b/database/schema.sql
index 3fbb7a10..0dc27afe 100644
--- a/database/schema.sql
+++ b/database/schema.sql
@@ -263,9 +263,7 @@ CREATE TABLE rooms (
     ON UPDATE CASCADE,
   FOREIGN KEY (type) REFERENCES room_types (name)
     ON DELETE CASCADE
-    ON UPDATE CASCADE,
-
-  UNIQUE (name, datacenter_id)
+    ON UPDATE CASCADE
 );
 
 DROP TABLE IF EXISTS room_types;
-- 
cgit v1.2.3

