Mercurial > dive4elements > river
changeset 6011:d9a1cf0438a5
backout 6009:6ea171b6d8d2 because this was only really valid for fixations
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Mon, 13 May 2013 18:21:55 +0200 (2013-05-13) |
parents | 6ea171b6d8d2 |
children | da58da430bed |
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 Mon May 13 17:48:32 2013 +0200 +++ b/backend/doc/schema/oracle.sql Mon May 13 18:21:55 2013 +0200 @@ -325,7 +325,7 @@ description VARCHAR2(255), name VARCHAR2(255) NOT NULL, position NUMBER(38,0) NOT NULL DEFAULT 0, - time_interval_id NUMBER(38,0) NOT NULL, + time_interval_id NUMBER(38,0), wst_id NUMBER(38,0) NOT NULL, UNIQUE (wst_id, name), UNIQUE (wst_id, position),
--- a/backend/doc/schema/postgresql.sql Mon May 13 17:48:32 2013 +0200 +++ b/backend/doc/schema/postgresql.sql Mon May 13 18:21:55 2013 +0200 @@ -203,7 +203,7 @@ description VARCHAR(256), position int NOT NULL DEFAULT 0, - time_interval_id int NOT NULL REFERENCES time_intervals(id), + time_interval_id int REFERENCES time_intervals(id), UNIQUE (wst_id, name), UNIQUE (wst_id, position)