diff flys-backend/doc/schema/postgresql-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 170f514a4f29
line wrap: on
line diff
--- 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;

http://dive4elements.wald.intevation.org