Mercurial > dive4elements > river
comparison flys-backend/doc/schema/postgresql.sql @ 1201:4e1b475a8cba
Schema: Dropped unique constraint of x in a single line of a "Querprofil-Spur".
flys-backend/trunk@2306 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Thu, 07 Jul 2011 15:05:30 +0000 |
| parents | 2b4de678e29a |
| children | 44581b40b968 |
comparison
equal
deleted
inserted
replaced
| 1200:7c88650ff548 | 1201:4e1b475a8cba |
|---|---|
| 278 id int PRIMARY KEY NOT NULL, | 278 id int PRIMARY KEY NOT NULL, |
| 279 cross_section_id int NOT NULL REFERENCES cross_sections(id), | 279 cross_section_id int NOT NULL REFERENCES cross_sections(id), |
| 280 col_pos int NOT NULL, | 280 col_pos int NOT NULL, |
| 281 x NUMERIC NOT NULL, | 281 x NUMERIC NOT NULL, |
| 282 y NUMERIC NOT NULL | 282 y NUMERIC NOT NULL |
| 283 UNIQUE (cross_section_id, x), | |
| 284 UNIQUE (cross_section_id, col_pos) | 283 UNIQUE (cross_section_id, col_pos) |
| 285 ); | 284 ); |
| 286 | 285 |
| 287 COMMIT; | 286 COMMIT; |