Mercurial > dive4elements > river
changeset 5456:e47c4e9b050e
Schema corrected: measurement_station.reference_gauge_station is not needed
| author | Tom Gottfried <tom.gottfried@intevation.de> |
|---|---|
| date | Wed, 27 Mar 2013 12:55:57 +0100 |
| parents | 45c5b8b08ffd |
| children | 1b676aefaf3a |
| files | flys-backend/doc/schema/oracle-minfo.sql flys-backend/doc/schema/postgresql-minfo.sql |
| diffstat | 2 files changed, 2 insertions(+), 4 deletions(-) [+] |
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-minfo.sql Wed Mar 27 12:45:52 2013 +0100 +++ b/flys-backend/doc/schema/oracle-minfo.sql Wed Mar 27 12:55:57 2013 +0100 @@ -287,9 +287,8 @@ 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 + -- store name 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 12:45:52 2013 +0100 +++ b/flys-backend/doc/schema/postgresql-minfo.sql Wed Mar 27 12:55:57 2013 +0100 @@ -287,9 +287,8 @@ 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 + -- store name 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),