Mercurial > dive4elements > river
view backend/doc/schema/oracle_migrations/update_nachtrag_20.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 | eb32f75c65c3 |
children |
line wrap: on
line source
--Neues Feld infrastructure.group_id SET AUTOCOMMIT ON; ALTER TABLE infrastructure ADD (group_id NUMBER(38,0)); UPDATE infrastructure SET group_id=annotation_type_id; ALTER TABLE infrastructure MODIFY (group_id NOT NULL); ALTER TABLE infrastructure ADD CONSTRAINT cInfrastructureGroupAnnoType FOREIGN KEY (group_id) REFERENCES annotation_types; COMMENT ON COLUMN infrastructure.group_id IS 'Reference to the infrastructure type group'; COMMIT;