Mercurial > dive4elements > river
diff flys-backend/doc/schema/postgresql.sql @ 496:4f2d8980415f
Schema: Dropped constraint which forces discharge tables to have a unique time interval for a given gauge and kind.
flys-backend/trunk@1850 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Sun, 08 May 2011 11:20:39 +0000 |
| parents | b35c5dc0f8b7 |
| children | ce9c6f05f464 |
line wrap: on
line diff
--- a/flys-backend/doc/schema/postgresql.sql Sun May 08 11:07:22 2011 +0000 +++ b/flys-backend/doc/schema/postgresql.sql Sun May 08 11:20:39 2011 +0000 @@ -116,10 +116,10 @@ gauge_id int NOT NULL REFERENCES gauges(id), description VARCHAR(256) NOT NULL, kind int NOT NULL DEFAULT 0, - time_interval_id int REFERENCES time_intervals(id), + time_interval_id int REFERENCES time_intervals(id) -- TODO: better checks - UNIQUE (gauge_id, time_interval_id) + -- UNIQUE (gauge_id, kind, time_interval_id) ); -- Values of the Abflusstafeln