Mercurial > gemma

comparison 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
comparison
equal deleted inserted replaced
4924:565da29060e7 4925:b86ce7fc4da3
891 id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY, 891 id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
892 colour varchar, 892 colour varchar,
893 colpat varchar, 893 colpat varchar,
894 conrad int, 894 conrad int,
895 marsys int, 895 marsys int,
896 boyshp int 896 boyshp int,
897 catcam int
897 ) INHERITS (fairway_marks) 898 ) INHERITS (fairway_marks)
898 -- Prevent identical entries using composite type comparison 899 -- Prevent identical entries using composite type comparison
899 -- (i.e. considering two NULL values in a field equal): 900 -- (i.e. considering two NULL values in a field equal):
900 CREATE UNIQUE INDEX fairway_marks_boycar_distinct_rows 901 CREATE UNIQUE INDEX fairway_marks_boycar_distinct_rows
901 ON fairway_marks_boycar 902 ON fairway_marks_boycar
902 ((CAST((geom, 903 ((CAST((geom,
903 datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom, 904 datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom,
904 scamin, picrep, txtdsc, sordat, sorind, 905 scamin, picrep, txtdsc, sordat, sorind,
905 0, colour, colpat, conrad, marsys, boyshp 906 0, colour, colpat, conrad, marsys, boyshp, catcam
906 ) AS fairway_marks_boycar) 907 ) AS fairway_marks_boycar)
907 )) 908 ))
908 909
909 -- Additional attributes for IENC feature BOYLAT 910 -- Additional attributes for IENC feature BOYLAT
910 CREATE TABLE fairway_marks_boylat ( 911 CREATE TABLE fairway_marks_boylat (