Mercurial > dive4elements > river
diff flys-backend/doc/schema/oracle.sql @ 3946:948c7289fc42
Backend: Added 'official_number' column to rivers table to model the 'Bundeswasserstrassen Identnummer'.
flys-backend/trunk@5571 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Sat, 22 Sep 2012 13:45:51 +0000 |
| parents | 3442304b430a |
| children | 83a42e6a562d |
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle.sql Fri Sep 21 10:47:32 2012 +0000 +++ b/flys-backend/doc/schema/oracle.sql Sat Sep 22 13:45:51 2012 +0000 @@ -249,6 +249,7 @@ CREATE TABLE rivers ( id NUMBER(38,0) NOT NULL, + official_number NUMBER(38,0), km_up NUMBER(38,0), name VARCHAR2(255), wst_unit_id NUMBER(38,0),