Mercurial > dive4elements > river
comparison flys-backend/doc/schema/postgresql-spatial.sql @ 1239:07882568cef8
Hint for unifying table names: dgm -> dem
flys-backend/trunk@2630 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Hans Plum <hans.plum@intevation.de> |
|---|---|
| date | Thu, 01 Sep 2011 10:03:58 +0000 |
| parents | 35740d675866 |
| children | 2ef8b67bd68a |
comparison
equal
deleted
inserted
replaced
| 1238:35740d675866 | 1239:07882568cef8 |
|---|---|
| 60 ); | 60 ); |
| 61 SELECT AddGeometryColumn('floodplain', 'geom', 31466, 'MULTIPOLYGON', 2); | 61 SELECT AddGeometryColumn('floodplain', 'geom', 31466, 'MULTIPOLYGON', 2); |
| 62 | 62 |
| 63 | 63 |
| 64 -- Geodaesie/Hoehenmodelle/* | 64 -- Geodaesie/Hoehenmodelle/* |
| 65 -- XXX DGM in englisch DEM, um dies zu vereinheitlichen | |
| 65 CREATE TABLE dgm ( | 66 CREATE TABLE dgm ( |
| 66 id SERIAL PRIMARY KEY NOT NULL, | 67 id SERIAL PRIMARY KEY NOT NULL, |
| 67 river_id int REFERENCES rivers(id), | 68 river_id int REFERENCES rivers(id), |
| 68 -- XXX Should we use the ranges table instead? | 69 -- XXX Should we use the ranges table instead? |
| 69 lower NUMERIC, | 70 lower NUMERIC, |