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