Mercurial > dive4elements > river
diff flys-backend/doc/schema/postgresql.sql @ 5684:88cbe798cbab
Schema change: fixed constraints
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Fri, 12 Apr 2013 16:13:23 +0200 |
| parents | 6dd354e7abfc |
| children | 153456f84602 |
line wrap: on
line diff
--- a/flys-backend/doc/schema/postgresql.sql Fri Apr 12 15:08:14 2013 +0200 +++ b/flys-backend/doc/schema/postgresql.sql Fri Apr 12 16:13:23 2013 +0200 @@ -111,8 +111,7 @@ CREATE TABLE named_main_values ( id int PRIMARY KEY NOT NULL, name VARCHAR(256) NOT NULL UNIQUE, - type_id int NOT NULL REFERENCES main_value_types(id), - UNIQUE (name, type_id) + type_id int NOT NULL REFERENCES main_value_types(id) ); -- Table for time intervals