Mercurial > dive4elements > river
diff backend/doc/schema/oracle-spatial.sql @ 5886:6a63456b99d9
Schema change, importer, i18n: additional field for federal state stations
| author | Tom Gottfried <tom.gottfried@intevation.de> |
|---|---|
| date | Tue, 30 Apr 2013 19:27:15 +0200 |
| parents | 249b8766a178 |
| children | 97145ec4e33c |
line wrap: on
line diff
--- a/backend/doc/schema/oracle-spatial.sql Tue Apr 30 19:03:44 2013 +0200 +++ b/backend/doc/schema/oracle-spatial.sql Tue Apr 30 19:27:15 2013 +0200 @@ -35,6 +35,7 @@ GEOM MDSYS.SDO_GEOMETRY, river_id NUMBER(38) REFERENCES rivers(id) ON DELETE CASCADE, km NUMBER(7,3) NOT NULL, + fedstate_km NUMBER(7,3), name VARCHAR(64), path VARCHAR(256), ID NUMBER PRIMARY KEY NOT NULL