Mercurial > dive4elements > river
diff flys-backend/doc/schema/oracle-spatial.sql @ 5260:8f71fe38977c
fixed DEM-importer to work with Oracle (made by A. Heinecke)
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Tue, 12 Mar 2013 19:43:11 +0100 |
| parents | b46df0609276 |
| children | 170f514a4f29 |
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-spatial.sql Tue Mar 12 19:16:05 2013 +0100 +++ b/flys-backend/doc/schema/oracle-spatial.sql Tue Mar 12 19:43:11 2013 +0100 @@ -152,7 +152,7 @@ ID NUMBER PRIMARY KEY NOT NULL, river_id NUMBER(38) REFERENCES rivers(id) ON DELETE CASCADE, name VARCHAR(64), - range_id NUMBER(38) REFERENCES ranges(id); + range_id NUMBER(38) REFERENCES ranges(id), time_interval_id NUMBER(38) REFERENCES time_intervals(id), projection VARCHAR(32), elevation_state VARCHAR(32),