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,