Mercurial > dive4elements > river
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 8465:2772a0fc7400 | 8466:cc53aae06303 |
|---|---|
| 370 SELECT HYDR_BOUNDARIES_POLY_ID_SEQ.nextval INTO :new.id FROM dual; | 370 SELECT HYDR_BOUNDARIES_POLY_ID_SEQ.nextval INTO :new.id FROM dual; |
| 371 END; | 371 END; |
| 372 / | 372 / |
| 373 | 373 |
| 374 -- Hydrologie/Streckendaten/ | 374 -- Hydrologie/Streckendaten/ |
| 375 CREATE SEQUENCE GAUGE_LOCATION_ID_SEQ; | |
| 376 CREATE TABLE gauge_location ( | |
| 377 OGR_FID NUMBER(38), | |
| 378 GEOM MDSYS.SDO_GEOMETRY, | |
| 379 river_id NUMBER(38), | |
| 380 name VARCHAR(64), | |
| 381 path VARCHAR(256), | |
| 382 id NUMBER PRIMARY KEY NOT NULL | |
| 383 ); | |
| 384 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); | |
| 385 CREATE OR REPLACE TRIGGER gauge_location_trigger BEFORE INSERT ON gauge_location FOR EACH ROW | |
| 386 BEGIN | |
| 387 SELECT GAUGE_LOCATION_ID_SEQ.nextval INTO :new.id FROM dual; | |
| 388 END; | |
| 389 / | |
| 390 | |
| 391 | |
| 392 CREATE TABLE jetty_kinds( | 375 CREATE TABLE jetty_kinds( |
| 393 id NUMBER PRIMARY KEY NOT NULL, | 376 id NUMBER PRIMARY KEY NOT NULL, |
| 394 name VARCHAR(64) | 377 name VARCHAR(64) |
| 395 ); | 378 ); |
| 396 INSERT INTO jetty_kinds VALUES (0, 'Buhnenkopf'); | 379 INSERT INTO jetty_kinds VALUES (0, 'Buhnenkopf'); |