Mercurial > lada > lada-server
changeset 988:5efb32a41b24
Fix CHECK-Constraint definition.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Fri, 01 Jul 2016 10:32:44 +0200 |
| parents | 35878d9b4321 |
| children | b943e956b767 |
| files | db_schema/stammdaten_schema.sql |
| diffstat | 1 files changed, 2 insertions(+), 2 deletions(-) [+] |
line wrap: on
line diff
--- a/db_schema/stammdaten_schema.sql Wed Jun 29 19:23:50 2016 +0200 +++ b/db_schema/stammdaten_schema.sql Fri Jul 01 10:32:44 2016 +0200 @@ -656,9 +656,9 @@ header character varying(50) NOT NULL, width integer, flex boolean, - index integer + index integer, + UNIQUE (query_id, data_index) ); -ALTER TABLE result ADD CONSTRAINT data_index_query_id UNIQUE (query_id, data_index) ALTER SEQUENCE result_id_seq OWNED BY result.id;