Mercurial > dive4elements > river
changeset 9662:f7738e64fce6
Importer (s/u-info) extensions: oracle script for vegetation_type update improved for special chars
| author | mschaefer |
|---|---|
| date | Fri, 03 Apr 2020 11:55:16 +0200 |
| parents | 9b8ba3b83a15 |
| children | 7c1da1b3f6b8 |
| files | backend/doc/schema/oracle_migrations/update_bedarf_2-3-6-3-B.sql |
| diffstat | 1 files changed, 3 insertions(+), 3 deletions(-) [+] |
line wrap: on
line diff
--- a/backend/doc/schema/oracle_migrations/update_bedarf_2-3-6-3-B.sql Mon Mar 23 16:38:12 2020 +0100 +++ b/backend/doc/schema/oracle_migrations/update_bedarf_2-3-6-3-B.sql Fri Apr 03 11:55:16 2020 +0200 @@ -8,11 +8,11 @@ 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üsch' WHERE id=5; -UPDATE vegetation_type SET de_name='Uferröhricht' WHERE id=6; +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äche' WHERE id=9; +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);