Mercurial > dive4elements > river
diff flys-backend/doc/schema/postgresql.sql @ 2373:056b3a5aa181
Removed "NOT NULL" constraint from gauges.range_id because there are gauges which dont have a Gueltigkeitsbereich.
flys-backend/trunk@3564 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Mon, 02 Jan 2012 13:42:27 +0000 |
| parents | fe89d6cf55fb |
| children | c3e049961685 |
line wrap: on
line diff
--- a/flys-backend/doc/schema/postgresql.sql Wed Dec 28 12:16:52 2011 +0000 +++ b/flys-backend/doc/schema/postgresql.sql Mon Jan 02 13:42:27 2012 +0000 @@ -88,7 +88,7 @@ -- Pegelnullpunkt datum NUMERIC NOT NULL, -- Streckengueltigkeit - range_id int NOT NULL REFERENCES ranges (id), + range_id int REFERENCES ranges (id), UNIQUE (name, river_id), UNIQUE (river_id, station)