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)

http://dive4elements.wald.intevation.org