Mercurial > gemma

comparison schema/gemma.sql @ 4965:be713316b47a fairway-marks-import

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Fixup rev. 1b309a8e7673
author Tom Gottfried <tom@intevation.de>
date Fri, 28 Feb 2020 13:50:50 +0100
parents 58dc06e91c39
children 3f704ebad0c5
comparison
equal deleted inserted replaced
4964:58dc06e91c39 4965:be713316b47a
890 id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY 890 id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY
891 ) INHERITS (fairway_marks_bcnlat) 891 ) INHERITS (fairway_marks_bcnlat)
892 -- Prevent identical entries using composite type comparison 892 -- Prevent identical entries using composite type comparison
893 -- (i.e. considering two NULL values in a field equal): 893 -- (i.e. considering two NULL values in a field equal):
894 CREATE UNIQUE INDEX fairway_marks_bcnlat_hydro_distinct_rows 894 CREATE UNIQUE INDEX fairway_marks_bcnlat_hydro_distinct_rows
895 ON fairway_marks_bcnlat 895 ON fairway_marks_bcnlat_hydro
896 ((CAST((validity, last_found, geom, 896 ((CAST((validity, last_found, geom,
897 datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom, 897 datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom,
898 scamin, picrep, txtdsc, sordat, sorind, 898 scamin, picrep, txtdsc, sordat, sorind,
899 colour, colpat, condtn, bcnshp, catlam, 0 899 colour, colpat, condtn, bcnshp, catlam, 0
900 ) AS fairway_marks_bcnlat_hydro) 900 ) AS fairway_marks_bcnlat_hydro)
904 id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY 904 id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY
905 ) INHERITS (fairway_marks_bcnlat) 905 ) INHERITS (fairway_marks_bcnlat)
906 -- Prevent identical entries using composite type comparison 906 -- Prevent identical entries using composite type comparison
907 -- (i.e. considering two NULL values in a field equal): 907 -- (i.e. considering two NULL values in a field equal):
908 CREATE UNIQUE INDEX fairway_marks_bcnlat_ienc_distinct_rows 908 CREATE UNIQUE INDEX fairway_marks_bcnlat_ienc_distinct_rows
909 ON fairway_marks_bcnlat 909 ON fairway_marks_bcnlat_ienc
910 ((CAST((validity, last_found, geom, 910 ((CAST((validity, last_found, geom,
911 datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom, 911 datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom,
912 scamin, picrep, txtdsc, sordat, sorind, 912 scamin, picrep, txtdsc, sordat, sorind,
913 colour, colpat, condtn, bcnshp, catlam, 0 913 colour, colpat, condtn, bcnshp, catlam, 0
914 ) AS fairway_marks_bcnlat_ienc) 914 ) AS fairway_marks_bcnlat_ienc)