Mercurial > dive4elements > river
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') |