Mercurial > dive4elements > river
diff 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 |
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-spatial.sql Fri Apr 05 14:56:36 2013 +0200 +++ b/flys-backend/doc/schema/oracle-spatial.sql Fri Apr 05 15:42:15 2013 +0200 @@ -219,7 +219,7 @@ GEOM MDSYS.SDO_GEOMETRY, kind_id NUMBER(2) DEFAULT 2 REFERENCES hws_kinds(id), fed_state_id NUMBER(2) REFERENCES fed_states(id), - river_id NUMBER(38) REFERENCES rivers(id), + river_id NUMBER(38) REFERENCES rivers(id) ON DELETE CASCADE, name VARCHAR(256), path VARCHAR(256), official NUMBER DEFAULT 0,