Mercurial > dive4elements > river
diff backend/doc/schema/postgresql.sql @ 5915:4fafe8d147b2
Schema change: named_main_values.name is not unique, as we can have the same name for different types
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Tue, 07 May 2013 18:19:57 +0200 |
| parents | 62e6598a2c4b |
| children | 131f5f58ff7d |
line wrap: on
line diff
--- a/backend/doc/schema/postgresql.sql Tue May 07 17:32:33 2013 +0200 +++ b/backend/doc/schema/postgresql.sql Tue May 07 18:19:57 2013 +0200 @@ -111,7 +111,7 @@ CREATE TABLE named_main_values ( id int PRIMARY KEY NOT NULL, - name VARCHAR(256) NOT NULL UNIQUE, + name VARCHAR(256) NOT NULL, type_id int NOT NULL REFERENCES main_value_types(id) );