Mercurial > gemma

diff schema/default_sysconfig.sql @ 5259:680be197844d

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Merged branch new-fwa.
author Sascha Wilde <wilde@intevation.de>
date Wed, 13 May 2020 11:28:34 +0200
parents 0b051ee3f238
children 6b0274693b48
line wrap: on
line diff
--- a/schema/default_sysconfig.sql	Tue May 12 16:52:08 2020 +0200
+++ b/schema/default_sysconfig.sql	Wed May 13 11:28:34 2020 +0200
@@ -4,7 +4,7 @@
 -- SPDX-License-Identifier: AGPL-3.0-or-later
 -- License-Filename: LICENSES/AGPL-3.0.txt
 
--- Copyright (C) 2018, 2019 by via donau
+-- Copyright (C) 2018, 2019, 2020 by via donau
 --   – Österreichische Wasserstraßen-Gesellschaft mbH
 -- Software engineering by Intevation GmbH
 
@@ -220,6 +220,7 @@
     ('waterway', 'bottleneck_overview', 4326, NULL, $$
         SELECT
             objnam AS name,
+            bn.bottleneck_id,
             ST_Centroid(area) AS point,
             (lower(stretch)).hectometre AS from,
             (upper(stretch)).hectometre AS to,