Mercurial > dive4elements > river
diff flys-backend/doc/schema/postgresql-spatial.sql @ 2340:c4f090a00178
Added missing schemas.
flys-backend/trunk@2818 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Bjoern Schilberg <bjoern@intevation.de> |
|---|---|
| date | Fri, 23 Sep 2011 11:15:20 +0000 |
| parents | b28ab244a77d |
| children | b8e01307c138 |
line wrap: on
line diff
--- a/flys-backend/doc/schema/postgresql-spatial.sql Fri Sep 23 10:42:25 2011 +0000 +++ b/flys-backend/doc/schema/postgresql-spatial.sql Fri Sep 23 11:15:20 2011 +0000 @@ -11,8 +11,16 @@ ALTER TABLE river_axes ALTER COLUMN id SET DEFAULT NEXTVAL('RIVER_AXES_ID_SEQ'); --- TODO +-- TODO: TestMe. -- Geodaesie/Flussachse+km/km.shp +CREATE SEQUENCE RIVER_AXES_KM_ID_SEQ; +CREATE TABLE river_axes_km ( + id int PRIMARY KEY NOT NULL, + river_id int REFERENCES rivers(id), + km NUMERIC NOT NULL +); +SELECT AddGeometryColumn('river_axes_km', 'geom', 31466, 'POINT', 2); +ALTER TABLE river_axes_km ALTER COLUMN id SET DEFAULT NEXTVAL('RIVER_AXES_KM_ID_SEQ'); --Geodaesie/Querprofile/QP-Spuren/qps.shp