Mercurial > dive4elements > river

annotate flys-backend/doc/schema/oracle-spatial-migrate-dami.sql @ 5026:bdef4c74d675 dami

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Update migrators for changes made in the dami branch and add oracle migrator. Both are currently untested!
author Andre Heinecke <aheinecke@intevation.de>
date Tue, 19 Feb 2013 14:59:44 +0100
parents
children 0fd7720e5c7f
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 (
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
38 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
39 GEOM MDSYS.SDO_GEOMETRY,
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
40 ogr_fid NUMBER,
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
41 kind_id NUMBER REFERENCES hws_kinds(id) DEFAULT 2,
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
42 fed_state_id NUMBER REFERENCES fed_states(id),
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
43 river_id NUMBER REFERENCES rivers(id),
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
44 name VARCHAR(256),
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
45 path VARCHAR(256),
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
46 official NUMBER DEFAULT 0,
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
47 agency VARCHAR(256),
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
48 range VARCHAR(256),
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
49 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
50 source VARCHAR(256),
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
51 status_date TIMESTAMP,
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
52 description VARCHAR(256)
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 (
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
92 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
93 GEOM MDSYS.SDO_GEOMETRY,
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
94 ogr_fid NUMBER(2),
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
95 kind_id NUMBER(2) DEFAULT 2 REFERENCES hws_kinds(id),
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
96 fed_state_id NUMBER(2) REFERENCES fed_states(id),
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),
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
111 rated_level NUMBER(19,5)
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
112 );
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 -- Altrications
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
115 ALTER TABLE dem ADD COLUMN srid NUMBER NOT NULL;
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
116 ALTER TABLE hydr_boundaries_poly ADD COLUMN sectie INT REFERENCES sectie_kinds(id);
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
117 ALTER TABLE hydr_boundaries_poly ADD COLUMN sobek INT REFERENCES sobek_kinds(id);
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
118 ALTER TABLE hydr_boundaries ADD COLUMN sectie INT REFERENCES sectie_kinds(id);
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
119 ALTER TABLE hydr_boundaries ADD COLUMN sobek INT REFERENCES sobek_kinds(id);
bdef4c74d675 Update migrators for changes made in the dami branch and add
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
120 ALTER TABLE hydr_boundaries ADD COLUMN kind INT REFERENCES boundary_kinds(id);
http://dive4elements.wald.intevation.org