Mercurial > dive4elements > river
comparison backend/doc/schema/oracle-sinfo-uinfo.sql @ 9661:9b8ba3b83a15
Importer (s/u-info) vegetation zones: new database column in vegetation_type table for german type name,
localized vegetation type names by querying the database instead of translating by resource property,
detecting and cancelling the import of a second vegetation zone file for a river,
detecting, logging, cancelling in case of wrong column titles,
detecting, logging and ignoring lines with missing (color) values,
comparing vegetation zone name and class with the database and logging+ignoring in case of inconsistencies,
starting the most elevated zone with 0 instead of -1 overflow days
| author | mschaefer |
|---|---|
| date | Mon, 23 Mar 2020 16:38:12 +0100 |
| parents | d889ffe2fb05 |
| children | 692f49b7de63 |
comparison
equal
deleted
inserted
replaced
| 9660:f0cad5212f49 | 9661:9b8ba3b83a15 |
|---|---|
| 427 | 427 |
| 428 --Vegetation zone | 428 --Vegetation zone |
| 429 | 429 |
| 430 CREATE TABLE vegetation_type ( | 430 CREATE TABLE vegetation_type ( |
| 431 id NUMBER(9,0) PRIMARY KEY, | 431 id NUMBER(9,0) PRIMARY KEY, |
| 432 name VARCHAR2(256) NOT NULL | 432 name VARCHAR2(256) NOT NULL, |
| 433 ); | 433 de_name VARCHAR2(256) NOT NULL |
| 434 INSERT INTO vegetation_type (id, name) VALUES (1, 'zonal forest'); | 434 ); |
| 435 INSERT INTO vegetation_type (id, name) VALUES (2, 'dry hartwood forest floodplain'); | 435 INSERT INTO vegetation_type (id, name, de_name) VALUES (1, 'zonal forest', 'Zonaler Wald'); |
| 436 INSERT INTO vegetation_type (id, name) VALUES (3, 'wet hartwood forest floodplain'); | 436 INSERT INTO vegetation_type (id, name, de_name) VALUES (1, 'zonal forest', 'Zonaler Wald'); |
| 437 INSERT INTO vegetation_type (id, name) VALUES (4, 'salix alba forest'); | 437 INSERT INTO vegetation_type (id, name, de_name) VALUES (2, 'dry hartwood forest floodplain', 'Hartholzaue, trocken'); |
| 438 INSERT INTO vegetation_type (id, name) VALUES (5, 'salix shrubs'); | 438 INSERT INTO vegetation_type (id, name, de_name) VALUES (3, 'wet hartwood forest floodplain', 'Hartholzaue, feucht'); |
| 439 INSERT INTO vegetation_type (id, name) VALUES (6, 'reed bed'); | 439 INSERT INTO vegetation_type (id, name, de_name) VALUES (4, 'salix alba forest', 'Silberweidenwald'); |
| 440 INSERT INTO vegetation_type (id, name) VALUES (7, 'bank pioneers'); | 440 INSERT INTO vegetation_type (id, name, de_name) VALUES (5, 'salix shrubs', 'Weidengebüsch'); |
| 441 INSERT INTO vegetation_type (id, name) VALUES (8, 'no vegetation'); | 441 INSERT INTO vegetation_type (id, name, de_name) VALUES (6, 'reed bed', 'Uferröhricht'); |
| 442 INSERT INTO vegetation_type (id, name) VALUES (9, 'water'); | 442 INSERT INTO vegetation_type (id, name, de_name) VALUES (7, 'bank pioneers', 'Uferpioniere'); |
| 443 INSERT INTO vegetation_type (id, name, de_name) VALUES (8, 'no vegetation', 'vegetationslos'); | |
| 444 INSERT INTO vegetation_type (id, name, de_name) VALUES (9, 'water', 'Wasserfläche'); | |
| 443 | 445 |
| 444 | 446 |
| 445 CREATE TABLE vegetation ( | 447 CREATE TABLE vegetation ( |
| 446 id NUMBER(9,0) PRIMARY KEY, | 448 id NUMBER(9,0) PRIMARY KEY, |
| 447 river_id NUMBER(38,0) NOT NULL CONSTRAINT cVegetationRivers REFERENCES rivers(id) ON DELETE CASCADE, | 449 river_id NUMBER(38,0) NOT NULL CONSTRAINT cVegetationRivers REFERENCES rivers(id) ON DELETE CASCADE, |