Mercurial > dive4elements > river
changeset 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 | bcfb30b73f06 |
| children | 170f514a4f29 |
| files | flys-backend/doc/schema/oracle-minfo.sql flys-backend/doc/schema/postgresql-minfo.sql |
| diffstat | 2 files changed, 12 insertions(+), 8 deletions(-) [+] |
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;
--- 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;