Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle.sql @ 2367:418a0918863b
Fixed flys/issue415: Increased precision of a and b in ranges.
flys-backend/trunk@3292 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Fri, 18 Nov 2011 15:53:07 +0000 |
| parents | cf8dcfaeb756 |
| children | fe89d6cf55fb |
comparison
equal
deleted
inserted
replaced
| 2366:2246348ff90e | 2367:418a0918863b |
|---|---|
| 229 --- RANGES | 229 --- RANGES |
| 230 CREATE SEQUENCE RANGES_ID_SEQ; | 230 CREATE SEQUENCE RANGES_ID_SEQ; |
| 231 | 231 |
| 232 CREATE TABLE ranges ( | 232 CREATE TABLE ranges ( |
| 233 id NUMBER(38,0) NOT NULL, | 233 id NUMBER(38,0) NOT NULL, |
| 234 a NUMBER(38,2), | 234 a NUMBER(38,10), |
| 235 b NUMBER(38,2), | 235 b NUMBER(38,10), |
| 236 river_id NUMBER(38,0), | 236 river_id NUMBER(38,0), |
| 237 PRIMARY KEY (id) | 237 PRIMARY KEY (id) |
| 238 ); | 238 ); |
| 239 | 239 |
| 240 | 240 |