Mercurial > dive4elements > river
comparison backend/doc/schema/postgresql.sql @ 6143:6cdb3ee687a9
Schema change: remove UNIQUE-constraint which allows importing cross sections only from PRF
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Fri, 31 May 2013 17:24:22 +0200 |
| parents | 176664f84d86 |
| children | 573112007ec7 |
comparison
equal
deleted
inserted
replaced
| 6142:a8adf19fbde3 | 6143:6cdb3ee687a9 |
|---|---|
| 313 id int PRIMARY KEY NOT NULL, | 313 id int PRIMARY KEY NOT NULL, |
| 314 cross_section_line_id int NOT NULL REFERENCES cross_section_lines(id) ON DELETE CASCADE, | 314 cross_section_line_id int NOT NULL REFERENCES cross_section_lines(id) ON DELETE CASCADE, |
| 315 col_pos int NOT NULL, | 315 col_pos int NOT NULL, |
| 316 x NUMERIC NOT NULL, | 316 x NUMERIC NOT NULL, |
| 317 y NUMERIC NOT NULL, | 317 y NUMERIC NOT NULL, |
| 318 UNIQUE (cross_section_line_id, col_pos) | |
| 319 ); | 318 ); |
| 320 | 319 |
| 321 -- Indices for faster access of the points | 320 -- Indices for faster access of the points |
| 322 CREATE INDEX cross_section_lines_km_idx | 321 CREATE INDEX cross_section_lines_km_idx |
| 323 ON cross_section_lines(km); | 322 ON cross_section_lines(km); |