Mercurial > dive4elements > river
comparison backend/doc/schema/oracle_migrations/update_bedarf_2-3-6-3-B.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 | |
| children | f7738e64fce6 |
comparison
equal
deleted
inserted
replaced
| 9660:f0cad5212f49 | 9661:9b8ba3b83a15 |
|---|---|
| 1 --Neues Feld vegetation_type.de_name | |
| 2 | |
| 3 SET AUTOCOMMIT ON; | |
| 4 | |
| 5 ALTER TABLE vegetation_type ADD (de_name VARCHAR2(256)); | |
| 6 | |
| 7 UPDATE vegetation_type SET de_name='Zonaler Wald' WHERE id=1; | |
| 8 UPDATE vegetation_type SET de_name='Hartholzaue, trocken' WHERE id=2; | |
| 9 UPDATE vegetation_type SET de_name='Hartholzaue, feucht' WHERE id=3; | |
| 10 UPDATE vegetation_type SET de_name='Silberweidenwald' WHERE id=4; | |
| 11 UPDATE vegetation_type SET de_name='Weidengebüsch' WHERE id=5; | |
| 12 UPDATE vegetation_type SET de_name='Uferröhricht' WHERE id=6; | |
| 13 UPDATE vegetation_type SET de_name='Uferpioniere' WHERE id=7; | |
| 14 UPDATE vegetation_type SET de_name='vegetationslos' WHERE id=8; | |
| 15 UPDATE vegetation_type SET de_name='Wasserfläche' WHERE id=9; | |
| 16 | |
| 17 ALTER TABLE vegetation_type MODIFY (de_name NOT NULL); | |
| 18 | |
| 19 COMMIT; |