Mercurial > dive4elements > river
diff backend/doc/schema/oracle-spatial.sql @ 8466:cc53aae06303
Gauge locations are obsolete since a long time.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Wed, 05 Nov 2014 13:04:53 +0100 |
parents | dcc7a6c8b92c |
children | 6824c447f5b0 |
line wrap: on
line diff
--- a/backend/doc/schema/oracle-spatial.sql Tue Nov 04 17:09:04 2014 +0100 +++ b/backend/doc/schema/oracle-spatial.sql Wed Nov 05 13:04:53 2014 +0100 @@ -372,23 +372,6 @@ / -- Hydrologie/Streckendaten/ -CREATE SEQUENCE GAUGE_LOCATION_ID_SEQ; -CREATE TABLE gauge_location ( - OGR_FID NUMBER(38), - GEOM MDSYS.SDO_GEOMETRY, - river_id NUMBER(38), - name VARCHAR(64), - path VARCHAR(256), - id NUMBER PRIMARY KEY NOT NULL -); -INSERT INTO USER_SDO_GEOM_METADATA VALUES ('gauge_location', 'GEOM', MDSYS.SDO_DIM_ARRAY(MDSYS.SDO_DIM_ELEMENT('X',3282450,3912240,0.001),MDSYS.SDO_DIM_ELEMENT('Y',5248260,6100130,0.001),MDSYS.SDO_DIM_ELEMENT('Z',-100000,100000,0.002)), 31467); -CREATE OR REPLACE TRIGGER gauge_location_trigger BEFORE INSERT ON gauge_location FOR EACH ROW - BEGIN - SELECT GAUGE_LOCATION_ID_SEQ.nextval INTO :new.id FROM dual; - END; -/ - - CREATE TABLE jetty_kinds( id NUMBER PRIMARY KEY NOT NULL, name VARCHAR(64)