Mercurial > dive4elements > river
changeset 6009:6ea171b6d8d2
Schema change because WST-columns without time interval are useless
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Mon, 13 May 2013 17:48:32 +0200 |
| parents | a45da06797c7 |
| children | db1bb9d44722 d9a1cf0438a5 |
| 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 15:53:36 2013 +0200 +++ b/backend/doc/schema/oracle.sql Mon May 13 17:48:32 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), + time_interval_id NUMBER(38,0) NOT NULL, wst_id NUMBER(38,0) NOT NULL, UNIQUE (wst_id, name), UNIQUE (wst_id, position),
--- a/backend/doc/schema/postgresql.sql Mon May 13 15:53:36 2013 +0200 +++ b/backend/doc/schema/postgresql.sql Mon May 13 17:48:32 2013 +0200 @@ -203,7 +203,7 @@ description VARCHAR(256), position int NOT NULL DEFAULT 0, - time_interval_id int REFERENCES time_intervals(id), + time_interval_id int NOT NULL REFERENCES time_intervals(id), UNIQUE (wst_id, name), UNIQUE (wst_id, position)