Mercurial > dive4elements > river
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 2339:b28ab244a77d | 2340:c4f090a00178 |
|---|---|
| 9 ); | 9 ); |
| 10 SELECT AddGeometryColumn('river_axes', 'geom', 31466, 'LINESTRING', 2); | 10 SELECT AddGeometryColumn('river_axes', 'geom', 31466, 'LINESTRING', 2); |
| 11 ALTER TABLE river_axes ALTER COLUMN id SET DEFAULT NEXTVAL('RIVER_AXES_ID_SEQ'); | 11 ALTER TABLE river_axes ALTER COLUMN id SET DEFAULT NEXTVAL('RIVER_AXES_ID_SEQ'); |
| 12 | 12 |
| 13 | 13 |
| 14 -- TODO | 14 -- TODO: TestMe. |
| 15 -- Geodaesie/Flussachse+km/km.shp | 15 -- Geodaesie/Flussachse+km/km.shp |
| 16 CREATE SEQUENCE RIVER_AXES_KM_ID_SEQ; | |
| 17 CREATE TABLE river_axes_km ( | |
| 18 id int PRIMARY KEY NOT NULL, | |
| 19 river_id int REFERENCES rivers(id), | |
| 20 km NUMERIC NOT NULL | |
| 21 ); | |
| 22 SELECT AddGeometryColumn('river_axes_km', 'geom', 31466, 'POINT', 2); | |
| 23 ALTER TABLE river_axes_km ALTER COLUMN id SET DEFAULT NEXTVAL('RIVER_AXES_KM_ID_SEQ'); | |
| 16 | 24 |
| 17 | 25 |
| 18 --Geodaesie/Querprofile/QP-Spuren/qps.shp | 26 --Geodaesie/Querprofile/QP-Spuren/qps.shp |
| 19 CREATE SEQUENCE CROSS_SECTION_TRACKS_ID_SEQ; | 27 CREATE SEQUENCE CROSS_SECTION_TRACKS_ID_SEQ; |
| 20 CREATE TABLE cross_section_tracks ( | 28 CREATE TABLE cross_section_tracks ( |