Mercurial > dive4elements > river
changeset 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 | 1058b3436dad |
| children | d6bf8353e0fc |
| files | backend/doc/schema/oracle.sql backend/doc/schema/postgresql.sql |
| diffstat | 2 files changed, 2 insertions(+), 2 deletions(-) [+] |
line wrap: on
line diff
--- a/backend/doc/schema/oracle.sql Tue May 07 17:32:33 2013 +0200 +++ b/backend/doc/schema/oracle.sql Tue May 07 18:19:57 2013 +0200 @@ -226,7 +226,7 @@ CREATE TABLE named_main_values ( id NUMBER(38,0) NOT NULL, - name VARCHAR2(256) NOT NULL UNIQUE, + name VARCHAR2(256) NOT NULL, type_id NUMBER(38,0) NOT NULL, PRIMARY KEY (id) );
--- 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) );