Mercurial > dive4elements > river
comparison backend/doc/schema/oracle-sinfo-uinfo.sql @ 9664:692f49b7de63
Oracle s-/u-info create script adjusted for special chars
| author | mschaefer |
|---|---|
| date | Fri, 03 Apr 2020 13:15:40 +0200 |
| parents | 9b8ba3b83a15 |
| children |
comparison
equal
deleted
inserted
replaced
| 9663:7c1da1b3f6b8 | 9664:692f49b7de63 |
|---|---|
| 435 INSERT INTO vegetation_type (id, name, de_name) VALUES (1, 'zonal forest', 'Zonaler Wald'); | 435 INSERT INTO vegetation_type (id, name, de_name) VALUES (1, 'zonal forest', 'Zonaler Wald'); |
| 436 INSERT INTO vegetation_type (id, name, de_name) VALUES (1, 'zonal forest', 'Zonaler Wald'); | 436 INSERT INTO vegetation_type (id, name, de_name) VALUES (1, 'zonal forest', 'Zonaler Wald'); |
| 437 INSERT INTO vegetation_type (id, name, de_name) VALUES (2, 'dry hartwood forest floodplain', 'Hartholzaue, trocken'); | 437 INSERT INTO vegetation_type (id, name, de_name) VALUES (2, 'dry hartwood forest floodplain', 'Hartholzaue, trocken'); |
| 438 INSERT INTO vegetation_type (id, name, de_name) VALUES (3, 'wet hartwood forest floodplain', 'Hartholzaue, feucht'); | 438 INSERT INTO vegetation_type (id, name, de_name) VALUES (3, 'wet hartwood forest floodplain', 'Hartholzaue, feucht'); |
| 439 INSERT INTO vegetation_type (id, name, de_name) VALUES (4, 'salix alba forest', 'Silberweidenwald'); | 439 INSERT INTO vegetation_type (id, name, de_name) VALUES (4, 'salix alba forest', 'Silberweidenwald'); |
| 440 INSERT INTO vegetation_type (id, name, de_name) VALUES (5, 'salix shrubs', 'Weidengebüsch'); | 440 INSERT INTO vegetation_type (id, name, de_name) VALUES (5, 'salix shrubs', 'Weidengeb'||CHR(252 USING NCHAR_CS)||'sch'); |
| 441 INSERT INTO vegetation_type (id, name, de_name) VALUES (6, 'reed bed', 'Uferröhricht'); | 441 INSERT INTO vegetation_type (id, name, de_name) VALUES (6, 'reed bed', 'Uferr'||CHR(246 USING NCHAR_CS)||'hricht'); |
| 442 INSERT INTO vegetation_type (id, name, de_name) VALUES (7, 'bank pioneers', 'Uferpioniere'); | 442 INSERT INTO vegetation_type (id, name, de_name) VALUES (7, 'bank pioneers', 'Uferpioniere'); |
| 443 INSERT INTO vegetation_type (id, name, de_name) VALUES (8, 'no vegetation', 'vegetationslos'); | 443 INSERT INTO vegetation_type (id, name, de_name) VALUES (8, 'no vegetation', 'vegetationslos'); |
| 444 INSERT INTO vegetation_type (id, name, de_name) VALUES (9, 'water', 'Wasserfläche'); | 444 INSERT INTO vegetation_type (id, name, de_name) VALUES (9, 'water', 'Wasserfl'||CHR(228 USING NCHAR_CS)||'che'); |
| 445 | 445 |
| 446 | 446 |
| 447 CREATE TABLE vegetation ( | 447 CREATE TABLE vegetation ( |
| 448 id NUMBER(9,0) PRIMARY KEY, | 448 id NUMBER(9,0) PRIMARY KEY, |
| 449 river_id NUMBER(38,0) NOT NULL CONSTRAINT cVegetationRivers REFERENCES rivers(id) ON DELETE CASCADE, | 449 river_id NUMBER(38,0) NOT NULL CONSTRAINT cVegetationRivers REFERENCES rivers(id) ON DELETE CASCADE, |