view backend/doc/schema/oracle_migrations/update_bedarf_2-3-6-3-B.sql @ 9702:20456a3c92e2

Img -> Image; correct URL for WMS Legend
author dnt_bjoernsen <d.tironi@bjoernsen.de>
date Thu, 21 Jan 2021 13:22:37 +0100
parents f7738e64fce6
children
line wrap: on
line source
--Neues Feld vegetation_type.de_name

SET AUTOCOMMIT ON;

ALTER TABLE vegetation_type ADD (de_name VARCHAR2(256));

UPDATE vegetation_type SET de_name='Zonaler Wald' WHERE id=1;
UPDATE vegetation_type SET de_name='Hartholzaue, trocken' WHERE id=2;
UPDATE vegetation_type SET de_name='Hartholzaue, feucht' WHERE id=3;
UPDATE vegetation_type SET de_name='Silberweidenwald' WHERE id=4;
UPDATE vegetation_type SET de_name='Weidengeb'||CHR(252 USING NCHAR_CS)||'sch' WHERE id=5;
UPDATE vegetation_type SET de_name='Uferr'||CHR(246 USING NCHAR_CS)||'hricht' WHERE id=6;
UPDATE vegetation_type SET de_name='Uferpioniere' WHERE id=7;
UPDATE vegetation_type SET de_name='vegetationslos' WHERE id=8;
UPDATE vegetation_type SET de_name='Wasserfl'||CHR(228 USING NCHAR_CS)||'che' WHERE id=9;

ALTER TABLE vegetation_type MODIFY (de_name NOT NULL);

COMMIT;

http://dive4elements.wald.intevation.org