# HG changeset patch # User Tom Gottfried # Date 1363190819 -3600 # Node ID 911f6291775371157224e9b22d1da79522517e12 # Parent bcfb30b73f064cd64de2cf565a177c5b8b03f650 additional values in lookup table for bed height types diff -r bcfb30b73f06 -r 911f62917753 flys-backend/doc/schema/oracle-minfo.sql --- 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; diff -r bcfb30b73f06 -r 911f62917753 flys-backend/doc/schema/postgresql-minfo.sql --- a/flys-backend/doc/schema/postgresql-minfo.sql Wed Mar 13 16:39:35 2013 +0100 +++ b/flys-backend/doc/schema/postgresql-minfo.sql Wed Mar 13 17:06:59 2013 +0100 @@ -27,10 +27,12 @@ name VARCHAR(64) 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, '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 (5, 'TIN'); +INSERT INTO bed_height_type VALUES (6, 'Modell'); CREATE SEQUENCE BED_HEIGHT_SINGLE_ID_SEQ;