Mercurial > dive4elements > river
changeset 7016:28748bb1b676 double-precision
Schema change: increase precision of gauges.station to be able to hold nearby gauges.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Fri, 13 Sep 2013 18:29:01 +0200 |
| parents | dddf633fec05 |
| children | 7fabae60428b |
| files | backend/doc/schema/oracle.sql |
| diffstat | 1 files changed, 1 insertions(+), 1 deletions(-) [+] |
line wrap: on
line diff
--- a/backend/doc/schema/oracle.sql Thu Sep 12 21:12:59 2013 +0200 +++ b/backend/doc/schema/oracle.sql Fri Sep 13 18:29:01 2013 +0200 @@ -122,7 +122,7 @@ aeo NUMBER(38,2) NOT NULL, datum NUMBER(38,2) NOT NULL, name VARCHAR2(255) NOT NULL, - station NUMBER(38,2) NOT NULL, + station NUMBER(38,4) NOT NULL, official_number NUMBER(38,0), range_id NUMBER(38,0), -- TODO: remove river id here because range_id references river already