Mercurial > dive4elements > river
comparison backend/doc/schema/oracle.sql @ 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 | 44a9233c62eb |
comparison
equal
deleted
inserted
replaced
| 7005:dddf633fec05 | 7016:28748bb1b676 |
|---|---|
| 120 CREATE TABLE gauges ( | 120 CREATE TABLE gauges ( |
| 121 id NUMBER(38,0) NOT NULL, | 121 id NUMBER(38,0) NOT NULL, |
| 122 aeo NUMBER(38,2) NOT NULL, | 122 aeo NUMBER(38,2) NOT NULL, |
| 123 datum NUMBER(38,2) NOT NULL, | 123 datum NUMBER(38,2) NOT NULL, |
| 124 name VARCHAR2(255) NOT NULL, | 124 name VARCHAR2(255) NOT NULL, |
| 125 station NUMBER(38,2) NOT NULL, | 125 station NUMBER(38,4) NOT NULL, |
| 126 official_number NUMBER(38,0), | 126 official_number NUMBER(38,0), |
| 127 range_id NUMBER(38,0), | 127 range_id NUMBER(38,0), |
| 128 -- TODO: remove river id here because range_id references river already | 128 -- TODO: remove river id here because range_id references river already |
| 129 river_id NUMBER(38,0) NOT NULL, | 129 river_id NUMBER(38,0) NOT NULL, |
| 130 PRIMARY KEY (id), | 130 PRIMARY KEY (id), |