Mercurial > gemma
comparison schema/gemma.sql @ 736:34ea9d5df653
Fixed problem with unique constraint for countour lines.
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Mon, 24 Sep 2018 11:24:42 +0200 |
| parents | 4d6329afc1ea |
| children | d32516051d08 |
comparison
equal
deleted
inserted
replaced
| 735:83a9f04f1759 | 736:34ea9d5df653 |
|---|---|
| 411 checksum varchar NOT NULL, | 411 checksum varchar NOT NULL, |
| 412 octree_index bytea NOT NULL | 412 octree_index bytea NOT NULL |
| 413 ) | 413 ) |
| 414 | 414 |
| 415 CREATE TABLE sounding_results_contour_lines ( | 415 CREATE TABLE sounding_results_contour_lines ( |
| 416 sounding_result_id int NOT NULL UNIQUE REFERENCES sounding_results, | 416 sounding_result_id int NOT NULL REFERENCES sounding_results, |
| 417 height numeric NOT NULL, | 417 height numeric NOT NULL, |
| 418 lines geography(multilinestringz, 4326) NOT NULL, | 418 lines geography(multilinestringz, 4326) NOT NULL, |
| 419 UNIQUE (sounding_result_id, height) | 419 UNIQUE (sounding_result_id, height) |
| 420 ) | 420 ) |
| 421 -- | 421 -- |