Mercurial > lada > lada-server
comparison db_schema/stammdaten_schema.sql @ 988:5efb32a41b24
Fix CHECK-Constraint definition.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Fri, 01 Jul 2016 10:32:44 +0200 |
| parents | 35878d9b4321 |
| children | 302f800ba588 299f4ba86090 |
comparison
equal
deleted
inserted
replaced
| 987:35878d9b4321 | 988:5efb32a41b24 |
|---|---|
| 654 query_id integer NOT NULL REFERENCES query ON DELETE CASCADE, | 654 query_id integer NOT NULL REFERENCES query ON DELETE CASCADE, |
| 655 data_index character varying(50) NOT NULL, | 655 data_index character varying(50) NOT NULL, |
| 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 UNIQUE (query_id, data_index) |
| 661 ALTER TABLE result ADD CONSTRAINT data_index_query_id UNIQUE (query_id, data_index) | 661 ); |
| 662 | 662 |
| 663 ALTER SEQUENCE result_id_seq OWNED BY result.id; | 663 ALTER SEQUENCE result_id_seq OWNED BY result.id; |
| 664 | 664 |
| 665 | 665 |
| 666 | 666 |