Mercurial > dive4elements > river
comparison flys-backend/doc/schema/postgresql.sql @ 194:0f0b98ef9b04
Fixed wrong unique constraint.
flys-backend/trunk@1532 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Mon, 21 Mar 2011 10:52:33 +0000 |
| parents | 249390dd24e7 |
| children | c8c09e31cdb8 |
comparison
equal
deleted
inserted
replaced
| 193:31c48d54f09d | 194:0f0b98ef9b04 |
|---|---|
| 60 datum NUMERIC NOT NULL, | 60 datum NUMERIC NOT NULL, |
| 61 -- Streckengueltigkeit | 61 -- Streckengueltigkeit |
| 62 range_id int NOT NULL REFERENCES ranges (id), | 62 range_id int NOT NULL REFERENCES ranges (id), |
| 63 | 63 |
| 64 UNIQUE (name, river_id), | 64 UNIQUE (name, river_id), |
| 65 UNIQUE (river_id, datum) | 65 UNIQUE (river_id, station) |
| 66 ); | 66 ); |
| 67 | 67 |
| 68 -- Type of a Hauptwert 'W', 'Q', 'D', etc. | 68 -- Type of a Hauptwert 'W', 'Q', 'D', etc. |
| 69 CREATE SEQUENCE MAIN_VALUE_TYPES_ID_SEQ; | 69 CREATE SEQUENCE MAIN_VALUE_TYPES_ID_SEQ; |
| 70 | 70 |