Mercurial > dive4elements > river
diff backend/doc/schema/postgresql-spatial.sql @ 8466:cc53aae06303
Gauge locations are obsolete since a long time.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Wed, 05 Nov 2014 13:04:53 +0100 |
parents | f4e32ac4e55c |
children | 71b17f731762 6824c447f5b0 |
line wrap: on
line diff
--- a/backend/doc/schema/postgresql-spatial.sql Tue Nov 04 17:09:04 2014 +0100 +++ b/backend/doc/schema/postgresql-spatial.sql Wed Nov 05 13:04:53 2014 +0100 @@ -300,17 +300,6 @@ ALTER TABLE hydr_boundaries_poly ALTER COLUMN id SET DEFAULT NEXTVAL('HYDR_BOUNDARIES_POLY_ID_SEQ'); -CREATE SEQUENCE GAUGE_LOCATION_ID_SEQ; -CREATE TABLE gauge_location ( - id int PRIMARY KEY NOT NULL, - river_id int REFERENCES rivers(id) ON DELETE CASCADE, - name VARCHAR(255), - path VARCHAR(256) -); -SELECT AddGeometryColumn('gauge_location','geom',31467,'POINT',2); -ALTER TABLE gauge_location ALTER COLUMN id SET DEFAULT NEXTVAL('GAUGE_LOCATION_ID_SEQ'); - - CREATE TABLE jetty_kinds( id int PRIMARY KEY NOT NULL, name VARCHAR(64)