Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle-minfo.sql @ 5275:911f62917753
additional values in lookup table for bed height types
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Wed, 13 Mar 2013 17:06:59 +0100 |
| parents | db196abd16ca |
| children | 6dd354e7abfc |
comparison
equal
deleted
inserted
replaced
| 5274:bcfb30b73f06 | 5275:911f62917753 |
|---|---|
| 25 CREATE TABLE bed_height_type ( | 25 CREATE TABLE bed_height_type ( |
| 26 id NUMBER(38,0) NOT NULL, | 26 id NUMBER(38,0) NOT NULL, |
| 27 name VARCHAR(65) NOT NULL, | 27 name VARCHAR(65) NOT NULL, |
| 28 PRIMARY KEY(id) | 28 PRIMARY KEY(id) |
| 29 ); | 29 ); |
| 30 INSERT INTO bed_height_type VALUES (1, 'Querprofil') | 30 INSERT INTO bed_height_type VALUES (1, 'Querprofile'); |
| 31 INSERT INTO bed_height_type VALUES (2, 'Flächenpeilung') | 31 INSERT INTO bed_height_type VALUES (2, 'Flächenpeilung'); |
| 32 INSERT INTO bed_height_type VALUES (3, 'Flächen- u. Querprofilpeilungen') | 32 INSERT INTO bed_height_type VALUES (3, 'Flächen- u. Querprofilpeilungen'); |
| 33 INSERT INTO bed_height_type VALUES (4, 'DGM') | 33 INSERT INTO bed_height_type VALUES (4, 'DGM'); |
| 34 INSERT INTO bed_height_type VALUES (5, 'TIN'); | |
| 35 INSERT INTO bed_height_type VALUES (6, 'Modell'); | |
| 34 | 36 |
| 35 | 37 |
| 36 CREATE SEQUENCE BED_HEIGHT_SINGLE_ID_SEQ; | 38 CREATE SEQUENCE BED_HEIGHT_SINGLE_ID_SEQ; |
| 37 | 39 |
| 38 CREATE TABLE bed_height_single ( | 40 CREATE TABLE bed_height_single ( |