Mercurial > gemma

comparison schema/gemma.sql @ 2015:b4ba751e70a1

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Fix column type to match referenced column
author Tom Gottfried <tom@intevation.de>
date Tue, 29 Jan 2019 12:36:45 +0100
parents 59055c8301df
children 51a7917b6a08
comparison
equal deleted inserted replaced
2014:958a0183fa3d 2015:b4ba751e70a1
502 UNIQUE (bottleneck_id, date_info), 502 UNIQUE (bottleneck_id, date_info),
503 area geography(POLYGON, 4326) NOT NULL 503 area geography(POLYGON, 4326) NOT NULL
504 CHECK(ST_IsValid(CAST(area AS geometry))), 504 CHECK(ST_IsValid(CAST(area AS geometry))),
505 surtyp varchar REFERENCES survey_types, 505 surtyp varchar REFERENCES survey_types,
506 coverage varchar REFERENCES coverage_types, 506 coverage varchar REFERENCES coverage_types,
507 depth_reference char(3) NOT NULL REFERENCES depth_references, 507 depth_reference varchar(4) NOT NULL REFERENCES depth_references,
508 point_cloud geography(MULTIPOINTZ, 4326) NOT NULL 508 point_cloud geography(MULTIPOINTZ, 4326) NOT NULL
509 CHECK(ST_IsSimple(CAST(point_cloud AS geometry))), 509 CHECK(ST_IsSimple(CAST(point_cloud AS geometry))),
510 octree_checksum varchar, 510 octree_checksum varchar,
511 octree_index bytea, 511 octree_index bytea,
512 staging_done boolean NOT NULL DEFAULT false 512 staging_done boolean NOT NULL DEFAULT false