comparison flys-backend/doc/schema/oracle-minfo.sql @ 5273:db196abd16ca

Use lookup table from bedd_height from database in importer.
author Sascha L. Teichmann <teichmann@intevation.de>
date Wed, 13 Mar 2013 16:39:08 +0100
parents 2594904640c3
children 911f62917753
comparison
equal deleted inserted replaced
5264:731030b69c7e 5273:db196abd16ca
22 22
23 23
24 -- lookup table for bedheight types 24 -- lookup table for bedheight types
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 type 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, 'Querprofil')
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')

http://dive4elements.wald.intevation.org