Mercurial > gemma
diff schema/gemma.sql @ 2015:b4ba751e70a1
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 |
line wrap: on
line diff
--- a/schema/gemma.sql Tue Jan 29 09:33:06 2019 +0100 +++ b/schema/gemma.sql Tue Jan 29 12:36:45 2019 +0100 @@ -504,7 +504,7 @@ CHECK(ST_IsValid(CAST(area AS geometry))), surtyp varchar REFERENCES survey_types, coverage varchar REFERENCES coverage_types, - depth_reference char(3) NOT NULL REFERENCES depth_references, + depth_reference varchar(4) NOT NULL REFERENCES depth_references, point_cloud geography(MULTIPOINTZ, 4326) NOT NULL CHECK(ST_IsSimple(CAST(point_cloud AS geometry))), octree_checksum varchar,