Mercurial > dive4elements > river
changeset 5453:303701ab73c6
store name and km of reference gauges in measurement_stations too, as not all are in gauges
| author | Tom Gottfried <tom.gottfried@intevation.de> |
|---|---|
| date | Wed, 27 Mar 2013 12:13:21 +0100 |
| parents | 5287440b57b3 |
| children | 662bcb3bdfd7 |
| files | flys-backend/doc/schema/oracle-minfo.sql flys-backend/doc/schema/postgresql-minfo.sql |
| diffstat | 2 files changed, 6 insertions(+), 0 deletions(-) [+] |
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-minfo.sql Wed Mar 27 11:48:53 2013 +0100 +++ b/flys-backend/doc/schema/oracle-minfo.sql Wed Mar 27 12:13:21 2013 +0100 @@ -287,6 +287,9 @@ measurement_type VARCHAR(64) NOT NULL, riverside VARCHAR(16), reference_gauge_id NUMBER(38), + -- store name and km of reference gauges here too, as not all are in gauges + reference_gauge_name VARCHAR(64), + reference_gauge_station NUMBER(38,3), observation_timerange_id NUMBER(38), operator VARCHAR(64), description VARCHAR(512),
--- a/flys-backend/doc/schema/postgresql-minfo.sql Wed Mar 27 11:48:53 2013 +0100 +++ b/flys-backend/doc/schema/postgresql-minfo.sql Wed Mar 27 12:13:21 2013 +0100 @@ -287,6 +287,9 @@ measurement_type VARCHAR(64) NOT NULL, riverside VARCHAR(16), reference_gauge_id int, + -- store name and km of reference gauges here too, as not all are in gauges + reference_gauge_name VARCHAR(64), + reference_gauge_station NUMERIC, observation_timerange_id int, operator VARCHAR(64), description VARCHAR(512),