# HG changeset patch
# User Markus Kottlaender <markus@intevation.de>
# Date 1553601732 -3600
# Node ID 3b1bdbbc0225b09e08a7d3a45a87327c3e01b4a3
# Parent  97cf32cf2562c23ae1cc6244190092cd80206441
added responsible_country to bottleneck_overview

diff -r 97cf32cf2562 -r 3b1bdbbc0225 schema/gemma.sql
--- a/schema/gemma.sql	Tue Mar 26 12:59:29 2019 +0100
+++ b/schema/gemma.sql	Tue Mar 26 13:02:12 2019 +0100
@@ -641,7 +641,8 @@
       ST_Centroid(area)::Geometry(POINT, 4326) AS point,
       (lower(stretch)).hectometre AS from,
       (upper(stretch)).hectometre AS to,
-      sr.current::text
+      sr.current::text,
+      responsible_country
     FROM bottlenecks bn LEFT JOIN (
       SELECT bottleneck_id, max(date_info) AS current FROM sounding_results
       GROUP BY bottleneck_id) sr ON sr.bottleneck_id = bn.id