Mercurial > dive4elements > river
annotate 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 |
| rev | line source |
|---|---|
|
9661
9b8ba3b83a15
Importer (s/u-info) vegetation zones: new database column in vegetation_type table for german type name,
mschaefer
parents:
diff
changeset
|
1 --Neues Feld vegetation_type.de_name |
|
9b8ba3b83a15
Importer (s/u-info) vegetation zones: new database column in vegetation_type table for german type name,
mschaefer
parents:
diff
changeset
|
2 |
|
9b8ba3b83a15
Importer (s/u-info) vegetation zones: new database column in vegetation_type table for german type name,
mschaefer
parents:
diff
changeset
|
3 SET AUTOCOMMIT ON; |
|
9b8ba3b83a15
Importer (s/u-info) vegetation zones: new database column in vegetation_type table for german type name,
mschaefer
parents:
diff
changeset
|
4 |
|
9b8ba3b83a15
Importer (s/u-info) vegetation zones: new database column in vegetation_type table for german type name,
mschaefer
parents:
diff
changeset
|
5 ALTER TABLE vegetation_type ADD (de_name VARCHAR2(256)); |
|
9b8ba3b83a15
Importer (s/u-info) vegetation zones: new database column in vegetation_type table for german type name,
mschaefer
parents:
diff
changeset
|
6 |
|
9b8ba3b83a15
Importer (s/u-info) vegetation zones: new database column in vegetation_type table for german type name,
mschaefer
parents:
diff
changeset
|
7 UPDATE vegetation_type SET de_name='Zonaler Wald' WHERE id=1; |
|
9b8ba3b83a15
Importer (s/u-info) vegetation zones: new database column in vegetation_type table for german type name,
mschaefer
parents:
diff
changeset
|
8 UPDATE vegetation_type SET de_name='Hartholzaue, trocken' WHERE id=2; |
|
9b8ba3b83a15
Importer (s/u-info) vegetation zones: new database column in vegetation_type table for german type name,
mschaefer
parents:
diff
changeset
|
9 UPDATE vegetation_type SET de_name='Hartholzaue, feucht' WHERE id=3; |
|
9b8ba3b83a15
Importer (s/u-info) vegetation zones: new database column in vegetation_type table for german type name,
mschaefer
parents:
diff
changeset
|
10 UPDATE vegetation_type SET de_name='Silberweidenwald' WHERE id=4; |
|
9662
f7738e64fce6
Importer (s/u-info) extensions: oracle script for vegetation_type update improved for special chars
mschaefer
parents:
9661
diff
changeset
|
11 UPDATE vegetation_type SET de_name='Weidengeb'||CHR(252 USING NCHAR_CS)||'sch' WHERE id=5; |
|
f7738e64fce6
Importer (s/u-info) extensions: oracle script for vegetation_type update improved for special chars
mschaefer
parents:
9661
diff
changeset
|
12 UPDATE vegetation_type SET de_name='Uferr'||CHR(246 USING NCHAR_CS)||'hricht' WHERE id=6; |
|
9661
9b8ba3b83a15
Importer (s/u-info) vegetation zones: new database column in vegetation_type table for german type name,
mschaefer
parents:
diff
changeset
|
13 UPDATE vegetation_type SET de_name='Uferpioniere' WHERE id=7; |
|
9b8ba3b83a15
Importer (s/u-info) vegetation zones: new database column in vegetation_type table for german type name,
mschaefer
parents:
diff
changeset
|
14 UPDATE vegetation_type SET de_name='vegetationslos' WHERE id=8; |
|
9662
f7738e64fce6
Importer (s/u-info) extensions: oracle script for vegetation_type update improved for special chars
mschaefer
parents:
9661
diff
changeset
|
15 UPDATE vegetation_type SET de_name='Wasserfl'||CHR(228 USING NCHAR_CS)||'che' WHERE id=9; |
|
9661
9b8ba3b83a15
Importer (s/u-info) vegetation zones: new database column in vegetation_type table for german type name,
mschaefer
parents:
diff
changeset
|
16 |
|
9b8ba3b83a15
Importer (s/u-info) vegetation zones: new database column in vegetation_type table for german type name,
mschaefer
parents:
diff
changeset
|
17 ALTER TABLE vegetation_type MODIFY (de_name NOT NULL); |
|
9b8ba3b83a15
Importer (s/u-info) vegetation zones: new database column in vegetation_type table for german type name,
mschaefer
parents:
diff
changeset
|
18 |
|
9b8ba3b83a15
Importer (s/u-info) vegetation zones: new database column in vegetation_type table for german type name,
mschaefer
parents:
diff
changeset
|
19 COMMIT; |