diff schema/install-db.sh @ 4389:5e38667f740c stretches-for-responsibility

Use stretches as areas of responsibility. This is heavily based on a patch by Tom Gottfried (read: >90% of the work was done by Tom).
author Sascha Wilde <wilde@intevation.de>
date Thu, 12 Sep 2019 18:13:47 +0200
parents 42af5ec25a7c
children a554d7ca26ee
line wrap: on
line diff
--- a/schema/install-db.sh	Wed Sep 11 10:32:19 2019 +0200
+++ b/schema/install-db.sh	Thu Sep 12 18:13:47 2019 +0200
@@ -5,7 +5,7 @@
 # SPDX-License-Identifier: AGPL-3.0-or-later
 # License-Filename: LICENSES/AGPL-3.0.txt
 #
-# Copyright (C) 2018 by via donau
+# Copyright (C) 2018, 2019 by via donau
 #   – Österreichische Wasserstraßen-Gesellschaft mbH
 # Software engineering by Intevation GmbH
 #
@@ -134,6 +134,7 @@
        -f "$BASEDIR/auth.sql" \
        -f "$BASEDIR/isrs_functions.sql" \
        -f "$BASEDIR/default_sysconfig.sql" \
+       -f "$BASEDIR/countries.sql" \
        -f "$BASEDIR/version.sql"
 
   # setup initial login roles with given passwords:
@@ -143,10 +144,8 @@
 
   if [[ $demo -eq 1 ]] ; then
     psql -qv ON_ERROR_STOP= -p "$port" -d "$db" \
-         -f "$BASEDIR/demo-data/responsibility_areas.sql" \
          -f "$BASEDIR/demo-data/users.sql" \
-         -f "$BASEDIR/demo-data/published_services.sql" \
-         -f "$BASEDIR/demo-data/fake_stretches.sql"
+         -f "$BASEDIR/demo-data/stretches.sql"
     psql -q -p "$port" -f "$BASEDIR/demo-data/roles.sql" \
          -d "$db"
   fi