Mercurial > dive4elements > river

annotate backend/doc/schema/oracle-spatial-migrate-dami.sql @ 9763:ce7c67445cbb 3.2.x

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
No more hacks for getting description in case of official lines In case the name contained one and only one number, that number had been returned as description because in that case, the name matched WQ.NUMBERS_PATTERN.
author Tom Gottfried <tom@intevation.de>
date Fri, 11 Nov 2022 18:12:26 +0100
parents 5aa05a7a34b7
children
rev   line source
5026
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
1 DROP TRIGGER hws_trigger;
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
2 DROP TABLE hws;
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
3 DROP SEQUENCE HWS_ID_SEQ;
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
4
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
5 --Static lookup tables for Hochwasserschutzanlagen
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
6 CREATE TABLE hws_kinds (
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
7 id NUMBER PRIMARY KEY NOT NULL,
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
8 kind VARCHAR(64) NOT NULL
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
9 );
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
10 INSERT INTO hws_kinds (id, kind) VALUES (1, 'Durchlass');
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
11 INSERT INTO hws_kinds (id, kind) VALUES (2, 'Damm');
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
12 INSERT INTO hws_kinds (id, kind) VALUES (3, 'Graben');
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
13
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
14 CREATE TABLE fed_states (
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
15 id NUMBER PRIMARY KEY NOT NULL,
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
16 name VARCHAR(23) NOT NULL
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
17 );
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
18 INSERT INTO fed_states (id, name) VALUES (1, 'Bayern');
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
19 INSERT INTO fed_states (id, name) VALUES (2, 'Hessen');
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
20 INSERT INTO fed_states (id, name) VALUES (3, 'Niedersachsen');
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
21 INSERT INTO fed_states (id, name) VALUES (4, 'Nordrhein-Westfalen');
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
22 INSERT INTO fed_states (id, name) VALUES (5, 'Rheinland-Pfalz');
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
23 INSERT INTO fed_states (id, name) VALUES (6, 'Saarland');
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
24 INSERT INTO fed_states (id, name) VALUES (7, 'Schleswig-Holstein');
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
25 INSERT INTO fed_states (id, name) VALUES (8, 'Brandenburg');
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
26 INSERT INTO fed_states (id, name) VALUES (9, 'Mecklenburg-Vorpommern');
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
27 INSERT INTO fed_states (id, name) VALUES (10, 'Thüringen');
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
28 INSERT INTO fed_states (id, name) VALUES (11, 'Baden-Württemberg');
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
29 INSERT INTO fed_states (id, name) VALUES (12, 'Sachsen-Anhalt');
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
30 INSERT INTO fed_states (id, name) VALUES (13, 'Sachsen');
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
31 INSERT INTO fed_states (id, name) VALUES (14, 'Berlin');
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
32 INSERT INTO fed_states (id, name) VALUES (15, 'Bremen');
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
33 INSERT INTO fed_states (id, name) VALUES (16, 'Hamburg');
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
34
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
35 -- HWS-Lines
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
36 CREATE SEQUENCE HWS_LINES_ID_SEQ;
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
37 CREATE TABLE hws_lines (
5122
5ba502e78e05 Fix import of hws_* on Oracle
Andre Heinecke <aheinecke@intevation.de>
parents: 5078
diff changeset
38 OGR_FID NUMBER(38),
5026
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
39 GEOM MDSYS.SDO_GEOMETRY,
5122
5ba502e78e05 Fix import of hws_* on Oracle
Andre Heinecke <aheinecke@intevation.de>
parents: 5078
diff changeset
40 kind_id NUMBER(2) DEFAULT 2 REFERENCES hws_kinds(id),
5ba502e78e05 Fix import of hws_* on Oracle
Andre Heinecke <aheinecke@intevation.de>
parents: 5078
diff changeset
41 fed_state_id NUMBER(2) REFERENCES fed_states(id),
5ba502e78e05 Fix import of hws_* on Oracle
Andre Heinecke <aheinecke@intevation.de>
parents: 5078
diff changeset
42 river_id NUMBER(38) REFERENCES rivers(id),
5026
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
43 name VARCHAR(256),
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
44 path VARCHAR(256),
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
45 official NUMBER DEFAULT 0,
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
46 agency VARCHAR(256),
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
47 range VARCHAR(256),
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
48 shore_side NUMBER DEFAULT 0,
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
49 source VARCHAR(256),
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
50 status_date TIMESTAMP,
5122
5ba502e78e05 Fix import of hws_* on Oracle
Andre Heinecke <aheinecke@intevation.de>
parents: 5078
diff changeset
51 description VARCHAR(256),
5ba502e78e05 Fix import of hws_* on Oracle
Andre Heinecke <aheinecke@intevation.de>
parents: 5078
diff changeset
52 id NUMBER PRIMARY KEY NOT NULL
5026
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
53 );
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
54 INSERT INTO USER_SDO_GEOM_METADATA VALUES ('hws_lines', '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);
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
55 CREATE INDEX hws_lines_spatial_idx ON hws_lines(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=LINE');
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
56
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
57 CREATE OR REPLACE TRIGGER hws_lines_trigger BEFORE INSERT ON hws_lines FOR each ROW
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
58 BEGIN
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
59 SELECT HWS_LINES_ID_SEQ.nextval INTO :new.id FROM dual;
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
60 END;
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
61
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
62 -- HWS Points lookup tables
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
63 CREATE TABLE sectie_kinds (
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
64 id NUMBER PRIMARY KEY NOT NULL,
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
65 name VARCHAR(64) NOT NULL
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
66 );
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
67 INSERT INTO sectie_kinds (id, name) VALUES (0, 'Unbekannt');
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
68 INSERT INTO sectie_kinds (id, name) VALUES (1, 'Flussschlauch');
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
69 INSERT INTO sectie_kinds (id, name) VALUES (2, 'Uferbank');
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
70 INSERT INTO sectie_kinds (id, name) VALUES (3, 'Überflutungsbereich');
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
71
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
72 CREATE TABLE sobek_kinds (
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
73 id NUMBER PRIMARY KEY NOT NULL,
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
74 name VARCHAR(64) NOT NULL
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
75 );
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
76 INSERT INTO sobek_kinds (id, name) VALUES (0, 'Unbekannt');
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
77 INSERT INTO sobek_kinds (id, name) VALUES (1, 'Stromführend');
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
78 INSERT INTO sobek_kinds (id, name) VALUES (2, 'Stromspeichernd');
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
79
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
80 CREATE TABLE boundary_kinds (
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
81 id NUMBER PRIMARY KEY NOT NULL,
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
82 name VARCHAR(64) NOT NULL
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
83 );
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
84 INSERT INTO boundary_kinds (id, name) VALUES (0, 'Unbekannt');
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
85 INSERT INTO boundary_kinds (id, name) VALUES (1, 'BfG');
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
86 INSERT INTO boundary_kinds (id, name) VALUES (2, 'Land');
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
87 INSERT INTO boundary_kinds (id, name) VALUES (3, 'Sonstige');
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
88
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
89 -- HWS Points
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
90 CREATE SEQUENCE HWS_POINTS_ID_SEQ;
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
91 CREATE TABLE hws_points (
5122
5ba502e78e05 Fix import of hws_* on Oracle
Andre Heinecke <aheinecke@intevation.de>
parents: 5078
diff changeset
92 OGR_FID NUMBER(38),
5026
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
93 GEOM MDSYS.SDO_GEOMETRY,
5122
5ba502e78e05 Fix import of hws_* on Oracle
Andre Heinecke <aheinecke@intevation.de>
parents: 5078
diff changeset
94 ogr_fid NUMBER,
5ba502e78e05 Fix import of hws_* on Oracle
Andre Heinecke <aheinecke@intevation.de>
parents: 5078
diff changeset
95 kind_id NUMBER DEFAULT 2 REFERENCES hws_kinds(id),
5ba502e78e05 Fix import of hws_* on Oracle
Andre Heinecke <aheinecke@intevation.de>
parents: 5078
diff changeset
96 fed_state_id NUMBER REFERENCES fed_states(id),
5026
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
97 river_id NUMBER(38) REFERENCES rivers(id) ON DELETE CASCADE,
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
98 name VARCHAR(256),
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
99 path VARCHAR(256),
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
100 official NUMBER DEFAULT 0,
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
101 agency VARCHAR(256),
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
102 range VARCHAR(256),
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
103 shore_side NUMBER DEFAULT 0,
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
104 source VARCHAR(256),
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
105 status_date VARCHAR(256),
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
106 description VARCHAR(256),
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
107 freeboard NUMBER(19,5),
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
108 dike_km NUMBER(19,5),
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
109 z NUMBER(19,5),
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
110 z_target NUMBER(19,5),
5122
5ba502e78e05 Fix import of hws_* on Oracle
Andre Heinecke <aheinecke@intevation.de>
parents: 5078
diff changeset
111 rated_level NUMBER(19,5),
5ba502e78e05 Fix import of hws_* on Oracle
Andre Heinecke <aheinecke@intevation.de>
parents: 5078
diff changeset
112 id NUMBER PRIMARY KEY NOT NULL
5026
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
113 );
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
114
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
115 -- Altrications
5078
0fd7720e5c7f Oracle Schema, add overlooked sectie and sobek fields
Andre Heinecke <aheinecke@intevation.de>
parents: 5026
diff changeset
116 ALTER TABLE dem ADD srid NUMBER NOT NULL;
0fd7720e5c7f Oracle Schema, add overlooked sectie and sobek fields
Andre Heinecke <aheinecke@intevation.de>
parents: 5026
diff changeset
117 ALTER TABLE hydr_boundaries_poly ADD sectie NUMBER REFERENCES sectie_kinds(id);
0fd7720e5c7f Oracle Schema, add overlooked sectie and sobek fields
Andre Heinecke <aheinecke@intevation.de>
parents: 5026
diff changeset
118 ALTER TABLE hydr_boundaries_poly ADD sobek NUMBER REFERENCES sobek_kinds(id);
0fd7720e5c7f Oracle Schema, add overlooked sectie and sobek fields
Andre Heinecke <aheinecke@intevation.de>
parents: 5026
diff changeset
119 ALTER TABLE hydr_boundaries ADD sectie NUMBER REFERENCES sectie_kinds(id);
0fd7720e5c7f Oracle Schema, add overlooked sectie and sobek fields
Andre Heinecke <aheinecke@intevation.de>
parents: 5026
diff changeset
120 ALTER TABLE hydr_boundaries ADD sobek NUMBER REFERENCES sobek_kinds(id);
0fd7720e5c7f Oracle Schema, add overlooked sectie and sobek fields
Andre Heinecke <aheinecke@intevation.de>
parents: 5026
diff changeset
121 ALTER TABLE hydr_boundaries ADD kind NUMBER REFERENCES boundary_kinds(id);
0fd7720e5c7f Oracle Schema, add overlooked sectie and sobek fields
Andre Heinecke <aheinecke@intevation.de>
parents: 5026
diff changeset
122 ALTER TABLE hydr_boundaries_poly ADD kind NUMBER REFERENCES boundary_kinds(id);
http://dive4elements.wald.intevation.org