diff options
| author | Georgios Andreadis <g.andreadis@student.tudelft.nl> | 2017-09-25 08:52:44 +0200 |
|---|---|---|
| committer | Georgios Andreadis <g.andreadis@student.tudelft.nl> | 2017-09-25 08:52:44 +0200 |
| commit | 2ab2f88c4353207f7b99cd77bc478502610f2e9e (patch) | |
| tree | eacc56c0434b76e676065e942819032035890cc1 | |
| parent | 805367fb4c5af4ba40e8c507b788da0078b4f60d (diff) | |
Remove uniqueness constraint on room names
| -rw-r--r-- | database/schema.sql | 4 |
1 files changed, 1 insertions, 3 deletions
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; |