Mercurial > dive4elements > river
diff 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 |
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-minfo.sql Wed Mar 13 16:39:35 2013 +0100 +++ b/flys-backend/doc/schema/oracle-minfo.sql Wed Mar 13 17:06:59 2013 +0100 @@ -27,10 +27,12 @@ name VARCHAR(65) NOT NULL, PRIMARY KEY(id) ); -INSERT INTO bed_height_type VALUES (1, 'Querprofil') -INSERT INTO bed_height_type VALUES (2, 'Flächenpeilung') -INSERT INTO bed_height_type VALUES (3, 'Flächen- u. Querprofilpeilungen') -INSERT INTO bed_height_type VALUES (4, 'DGM') +INSERT INTO bed_height_type VALUES (1, 'Querprofile'); +INSERT INTO bed_height_type VALUES (2, 'Flächenpeilung'); +INSERT INTO bed_height_type VALUES (3, 'Flächen- u. Querprofilpeilungen'); +INSERT INTO bed_height_type VALUES (4, 'DGM'); +INSERT INTO bed_height_type VALUES (5, 'TIN'); +INSERT INTO bed_height_type VALUES (6, 'Modell'); CREATE SEQUENCE BED_HEIGHT_SINGLE_ID_SEQ;