Mercurial > gemma
changeset 4963:1e47ba2a58f2 fairway-marks-import
Fix database migration
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Fri, 28 Feb 2020 12:01:03 +0100 |
parents | 1b309a8e7673 |
children | 58dc06e91c39 |
files | schema/updates/1406/01.distinguish_bcnlat_hydro_ienc.sql |
diffstat | 1 files changed, 2 insertions(+), 2 deletions(-) [+] |
line wrap: on
line diff
--- a/schema/updates/1406/01.distinguish_bcnlat_hydro_ienc.sql Thu Feb 27 21:05:09 2020 +0100 +++ b/schema/updates/1406/01.distinguish_bcnlat_hydro_ienc.sql Fri Feb 28 12:01:03 2020 +0100 @@ -10,7 +10,7 @@ id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY ) INHERITS (waterway.fairway_marks_bcnlat_new); CREATE UNIQUE INDEX fairway_marks_bcnlat_hydro_distinct_rows - ON waterway.fairway_marks_bcnlat + ON waterway.fairway_marks_bcnlat_hydro ((CAST((validity, last_found, geom, datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom, scamin, picrep, txtdsc, sordat, sorind, @@ -22,7 +22,7 @@ id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY ) INHERITS (waterway.fairway_marks_bcnlat_new); CREATE UNIQUE INDEX fairway_marks_bcnlat_ienc_distinct_rows - ON waterway.fairway_marks_bcnlat + ON waterway.fairway_marks_bcnlat_ienc ((CAST((validity, last_found, geom, datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom, scamin, picrep, txtdsc, sordat, sorind,