From 2ab2f88c4353207f7b99cd77bc478502610f2e9e Mon Sep 17 00:00:00 2001 From: Georgios Andreadis 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') 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