Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle-spatial.sql @ 5577:5f91881124ba
added missing ON DELETE CASCADE to Oracle schema
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Fri, 05 Apr 2013 15:42:15 +0200 |
| parents | 16afd4613f9d |
| children | 0aaed46a88be |
comparison
equal
deleted
inserted
replaced
| 5576:ec60249bd679 | 5577:5f91881124ba |
|---|---|
| 217 CREATE TABLE hws_lines ( | 217 CREATE TABLE hws_lines ( |
| 218 OGR_FID NUMBER(38), | 218 OGR_FID NUMBER(38), |
| 219 GEOM MDSYS.SDO_GEOMETRY, | 219 GEOM MDSYS.SDO_GEOMETRY, |
| 220 kind_id NUMBER(2) DEFAULT 2 REFERENCES hws_kinds(id), | 220 kind_id NUMBER(2) DEFAULT 2 REFERENCES hws_kinds(id), |
| 221 fed_state_id NUMBER(2) REFERENCES fed_states(id), | 221 fed_state_id NUMBER(2) REFERENCES fed_states(id), |
| 222 river_id NUMBER(38) REFERENCES rivers(id), | 222 river_id NUMBER(38) REFERENCES rivers(id) ON DELETE CASCADE, |
| 223 name VARCHAR(256), | 223 name VARCHAR(256), |
| 224 path VARCHAR(256), | 224 path VARCHAR(256), |
| 225 official NUMBER DEFAULT 0, | 225 official NUMBER DEFAULT 0, |
| 226 agency VARCHAR(256), | 226 agency VARCHAR(256), |
| 227 range VARCHAR(256), | 227 range VARCHAR(256), |