Mercurial > lada > lada-server
diff db_schema/stammdaten_schema.sql @ 987:35878d9b4321
Added unique constraint to result.query_id and result.data_index and fixed data
set.
author | Raimund Renkert <raimund.renkert@intevation.de> |
---|---|
date | Wed, 29 Jun 2016 19:23:50 +0200 |
parents | 69b954343acc |
children | 5efb32a41b24 |
line wrap: on
line diff
--- a/db_schema/stammdaten_schema.sql Wed Jun 29 19:06:33 2016 +0200 +++ b/db_schema/stammdaten_schema.sql Wed Jun 29 19:23:50 2016 +0200 @@ -658,6 +658,7 @@ flex boolean, index integer ); +ALTER TABLE result ADD CONSTRAINT data_index_query_id UNIQUE (query_id, data_index) ALTER SEQUENCE result_id_seq OWNED BY result.id;