diff backend/doc/schema/postgresql-minfo.sql @ 5894:62e6598a2c4b

Schema change: make gauges.official_number unique per river as we can have multiple identical gauges for different representations of the same river. Comments and TODOs
author Tom Gottfried <tom@intevation.de>
date Fri, 03 May 2013 10:31:34 +0200
parents 5aa05a7a34b7
children 2d16f4a0bdcc
line wrap: on
line diff
--- a/backend/doc/schema/postgresql-minfo.sql	Fri May 03 07:47:15 2013 +0200
+++ b/backend/doc/schema/postgresql-minfo.sql	Fri May 03 10:31:34 2013 +0200
@@ -65,7 +65,7 @@
     id                      int NOT NULL,
     river_id                int NOT NULL,
     time_interval_id        int NOT NULL,
-    -- sounding_with           int NOT NULL,
+    -- sounding_width           int,
     -- type_id                 int NOT NULL,
     cur_elevation_model_id  int NOT NULL,
     old_elevation_model_id  int,

http://dive4elements.wald.intevation.org