Mercurial > lada > lada-server
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 986:1f7e40f27103 | 987:35878d9b4321 |
|---|---|
| 656 header character varying(50) NOT NULL, | 656 header character varying(50) NOT NULL, |
| 657 width integer, | 657 width integer, |
| 658 flex boolean, | 658 flex boolean, |
| 659 index integer | 659 index integer |
| 660 ); | 660 ); |
| 661 ALTER TABLE result ADD CONSTRAINT data_index_query_id UNIQUE (query_id, data_index) | |
| 661 | 662 |
| 662 ALTER SEQUENCE result_id_seq OWNED BY result.id; | 663 ALTER SEQUENCE result_id_seq OWNED BY result.id; |
| 663 | 664 |
| 664 | 665 |
| 665 | 666 |