Mercurial > dive4elements > river
comparison flys-backend/doc/schema/postgresql-spatial.sql @ 5303:08b3109c637b
fixed spatial schema for hydraulic boundaries
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Thu, 14 Mar 2013 15:32:50 +0100 |
| parents | 3dc4c2798212 |
| children | aa407dfb9949 |
comparison
equal
deleted
inserted
replaced
| 5302:71a24278322c | 5303:08b3109c637b |
|---|---|
| 284 kind int REFERENCES boundary_kinds(id), | 284 kind int REFERENCES boundary_kinds(id), |
| 285 sectie int REFERENCES sectie_kinds(id), | 285 sectie int REFERENCES sectie_kinds(id), |
| 286 sobek int REFERENCES sobek_kinds(id), | 286 sobek int REFERENCES sobek_kinds(id), |
| 287 path VARCHAR(256) | 287 path VARCHAR(256) |
| 288 ); | 288 ); |
| 289 SELECT AddGeometryColumn('hydr_boundaries_poly','geom',31467,'POLYGON',3); | 289 SELECT AddGeometryColumn('hydr_boundaries_poly','geom',31467,'MULTIPOLYGON',3); |
| 290 ALTER TABLE hydr_boundaries_poly ALTER COLUMN id SET DEFAULT NEXTVAL('HYDR_BOUNDARIES_POLY_ID_SEQ'); | 290 ALTER TABLE hydr_boundaries_poly ALTER COLUMN id SET DEFAULT NEXTVAL('HYDR_BOUNDARIES_POLY_ID_SEQ'); |
| 291 | 291 |
| 292 | 292 |
| 293 CREATE SEQUENCE GAUGE_LOCATION_ID_SEQ; | 293 CREATE SEQUENCE GAUGE_LOCATION_ID_SEQ; |
| 294 CREATE TABLE gauge_location ( | 294 CREATE TABLE gauge_location ( |