Mercurial > dive4elements > river
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 5259:7a11271f5593 | 5260:8f71fe38977c |
|---|---|
| 150 CREATE SEQUENCE DEM_ID_SEQ; | 150 CREATE SEQUENCE DEM_ID_SEQ; |
| 151 CREATE TABLE dem ( | 151 CREATE TABLE dem ( |
| 152 ID NUMBER PRIMARY KEY NOT NULL, | 152 ID NUMBER PRIMARY KEY NOT NULL, |
| 153 river_id NUMBER(38) REFERENCES rivers(id) ON DELETE CASCADE, | 153 river_id NUMBER(38) REFERENCES rivers(id) ON DELETE CASCADE, |
| 154 name VARCHAR(64), | 154 name VARCHAR(64), |
| 155 range_id NUMBER(38) REFERENCES ranges(id); | 155 range_id NUMBER(38) REFERENCES ranges(id), |
| 156 time_interval_id NUMBER(38) REFERENCES time_intervals(id), | 156 time_interval_id NUMBER(38) REFERENCES time_intervals(id), |
| 157 projection VARCHAR(32), | 157 projection VARCHAR(32), |
| 158 elevation_state VARCHAR(32), | 158 elevation_state VARCHAR(32), |
| 159 srid NUMBER NOT NULL, | 159 srid NUMBER NOT NULL, |
| 160 format VARCHAR(32), | 160 format VARCHAR(32), |