Mercurial > gemma

diff schema/gemma.sql @ 4925:b86ce7fc4da3 fairway-marks-import

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Add missing BOYCAR attribute
author Tom Gottfried <tom@intevation.de>
date Fri, 14 Feb 2020 13:01:45 +0100
parents 9bd6a0ca63ea
children 8b83b18a1d49
line wrap: on
line diff
--- a/schema/gemma.sql	Fri Feb 14 12:34:02 2020 +0100
+++ b/schema/gemma.sql	Fri Feb 14 13:01:45 2020 +0100
@@ -893,7 +893,8 @@
         colpat varchar,
         conrad int,
         marsys int,
-        boyshp int
+        boyshp int,
+        catcam int
     ) INHERITS (fairway_marks)
     -- Prevent identical entries using composite type comparison
     -- (i.e. considering two NULL values in a field equal):
@@ -902,7 +903,7 @@
         ((CAST((geom,
                 datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom,
                 scamin, picrep, txtdsc, sordat, sorind,
-                0, colour, colpat, conrad, marsys, boyshp
+                0, colour, colpat, conrad, marsys, boyshp, catcam
             ) AS fairway_marks_boycar)
         ))