Mercurial > dive4elements > river
comparison flys-backend/doc/schema/postgresql-minfo.sql @ 5276:170f514a4f29
SCHEMA CHANGE: lookup table for floodmaps and source-field added, Importer adapted to new directory names
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Wed, 13 Mar 2013 18:39:28 +0100 |
| parents | 911f62917753 |
| children | 6dd354e7abfc |
comparison
equal
deleted
inserted
replaced
| 5275:911f62917753 | 5276:170f514a4f29 |
|---|---|
| 25 CREATE TABLE bed_height_type ( | 25 CREATE TABLE bed_height_type ( |
| 26 id int NOT NULL, | 26 id int NOT NULL, |
| 27 name VARCHAR(64) NOT NULL, | 27 name VARCHAR(64) 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, 'Querprofile'); |
| 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'); |
| 33 INSERT INTO bed_height_type VALUES (4, 'DGM'); | 33 INSERT INTO bed_height_type VALUES (4, 'DGM'); |
| 34 INSERT INTO bed_height_type VALUES (5, 'TIN'); | 34 INSERT INTO bed_height_type VALUES (5, 'TIN'); |
| 35 INSERT INTO bed_height_type VALUES (6, 'Modell'); | 35 INSERT INTO bed_height_type VALUES (6, 'Modell'); |