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)

http://dive4elements.wald.intevation.org