Mercurial > gemma
changeset 4965:be713316b47a fairway-marks-import
Fixup rev. 1b309a8e7673
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Fri, 28 Feb 2020 13:50:50 +0100 |
parents | 58dc06e91c39 |
children | 3530d91c3da3 |
files | schema/gemma.sql |
diffstat | 1 files changed, 2 insertions(+), 2 deletions(-) [+] |
line wrap: on
line diff
--- a/schema/gemma.sql Fri Feb 28 13:43:52 2020 +0100 +++ b/schema/gemma.sql Fri Feb 28 13:50:50 2020 +0100 @@ -892,7 +892,7 @@ -- Prevent identical entries using composite type comparison -- (i.e. considering two NULL values in a field equal): CREATE UNIQUE INDEX fairway_marks_bcnlat_hydro_distinct_rows - ON fairway_marks_bcnlat + ON fairway_marks_bcnlat_hydro ((CAST((validity, last_found, geom, datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom, scamin, picrep, txtdsc, sordat, sorind, @@ -906,7 +906,7 @@ -- Prevent identical entries using composite type comparison -- (i.e. considering two NULL values in a field equal): CREATE UNIQUE INDEX fairway_marks_bcnlat_ienc_distinct_rows - ON fairway_marks_bcnlat + ON fairway_marks_bcnlat_ienc ((CAST((validity, last_found, geom, datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom, scamin, picrep, txtdsc, sordat, sorind,