commit b80a56c9df1ed6c746109e43fab1462f8cb99349
author Simon Reis <simon.reis@pta.de> Mon Mar 02 19:03:18 2020 +0100
committer Simon Reis <simon.reis@pta.de> Mon Mar 02 19:03:18 2020 +0100
tree 21e78ffc14a3c730e92bf006ac6f2f3da1fc73e0
parent 9d3cafa899a7bf40740671f8dfbbf7aac629fd42

KON-618 HowToRun

deploy/db/02_create_tables_with_example_data.sql

diff --git a/deploy/db/02_create_tables_with_example_data.sql b/deploy/db/02_create_tables_with_example_data.sql
index e2f7bb7..979a88e 100644
--- a/deploy/db/02_create_tables_with_example_data.sql
+++ b/deploy/db/02_create_tables_with_example_data.sql
@@ -671,9 +671,11 @@
 	c.note,
 	s.type as salutation_type,
 	t.type as person_type,
-	a.street,
-	a.housenumber,
-	a.community,
+	COALESCE(a.community, '') ||
+	        CASE WHEN COALESCE(a.street, '') || COALESCE(a.housenumber, '') = '' THEN '' ELSE ', ' END ||
+	        COALESCE(a.street, '') ||
+	        CASE WHEN COALESCE(a.housenumber, '') = '' THEN '' ELSE ' ' END ||
+	        COALESCE(a.housenumber, '') as main_address,
 	com.communication_data as email,
 
 	UPPER(