Mercurial > dive4elements > river
diff backend/doc/schema/postgresql-minfo.sql @ 8642:9db1f48bfea9
Enforce strings we rely on.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Fri, 27 Mar 2015 18:54:03 +0100 |
| parents | c851d1ea543a |
| children | 1a4ad0d4231a |
line wrap: on
line diff
--- a/backend/doc/schema/postgresql-minfo.sql Fri Mar 27 17:42:27 2015 +0100 +++ b/backend/doc/schema/postgresql-minfo.sql Fri Mar 27 18:54:03 2015 +0100 @@ -325,6 +325,7 @@ operator VARCHAR(64), commentary VARCHAR(512), PRIMARY KEY (id), + CHECK(measurement_type IN ('Geschiebe', 'Schwebstoff')), CONSTRAINT fk_ms_range_id FOREIGN KEY (range_id) REFERENCES ranges(id) ON DELETE CASCADE, CONSTRAINT fk_ms_reference_gauge_id FOREIGN KEY (reference_gauge_id)