Mercurial > gemma

changeset 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 958a0183fa3d
children 51a7917b6a08 079a1d35e076
files schema/gemma.sql
diffstat 1 files changed, 1 insertions(+), 1 deletions(-) [+]
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,