annotate backend/doc/schema/oracle_migrations/update_bedarf_2-3-6-3-B.sql @ 9700:b2768f367dff

handler for wms theme legend
author dnt_bjoernsen <d.tironi@bjoernsen.de>
date Wed, 20 Jan 2021 19:06:57 +0100
parents f7738e64fce6
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;

http://dive4elements.wald.intevation.org