changeset 4820:c6d986789253

Recent changes to constraints on users.profiles need change of install-db.sh. We now need to create the db roles first, otherwise the constraint on username will prevent the profile data from being created.
author Sascha Wilde <wilde@intevation.de>
date Mon, 04 Nov 2019 17:51:43 +0100
parents f64fe4c43959
children 99d35b1320a4
files schema/install-db.sh
diffstat 1 files changed, 2 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- a/schema/install-db.sh	Mon Nov 04 17:40:17 2019 +0100
+++ b/schema/install-db.sh	Mon Nov 04 17:51:43 2019 +0100
@@ -142,11 +142,11 @@
        -f "$BASEDIR/std_login_roles.sql"
 
   if [[ $demo -eq 1 ]] ; then
+    psql -q -p "$port" -f "$BASEDIR/demo-data/roles.sql" \
+         -d "$db"
     psql -qv ON_ERROR_STOP= -p "$port" -d "$db" \
          -f "$BASEDIR/demo-data/users.sql" \
          -f "$BASEDIR/demo-data/stretches.sql"
-    psql -q -p "$port" -f "$BASEDIR/demo-data/roles.sql" \
-         -d "$db"
   fi
 
   if [[ $geonames -eq 1 ]] ; then