Mercurial > gemma

comparison schema/install-db.sh @ 247:946baea3d280

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Add view to list user profiles with role To be able to GRANT privileges ON ALL TABLES IN SCHEMA, use auth.sql last during database setup.
author Tom Gottfried <tom@intevation.de>
date Thu, 26 Jul 2018 19:33:42 +0200
parents 4ebb791b8278
children cc018ad54251
comparison
equal deleted inserted replaced
246:299568ad3c37 247:946baea3d280
69 69
70 # Main ------------------------------------------------------------ 70 # Main ------------------------------------------------------------
71 71
72 psql -p "$port" -f "$BASEDIR/roles.sql" 72 psql -p "$port" -f "$BASEDIR/roles.sql"
73 createdb -p "$port" "$db" 73 createdb -p "$port" "$db"
74 psql -p "$port" -f "$BASEDIR/gemma.sql" \ 74 psql -p "$port" -d "$db" \
75 -f "$BASEDIR/auth.sql" -f "$BASEDIR/manage_users.sql" -d "$db" 75 -f "$BASEDIR/gemma.sql" \
76 -f "$BASEDIR/manage_users.sql" \
77 -f "$BASEDIR/auth.sql"
78
76 if [[ $demo -eq 1 ]] ; then 79 if [[ $demo -eq 1 ]] ; then
77 psql -p "$port" -f "$BASEDIR/demo-data/responsibility_areas.sql" \ 80 psql -p "$port" -f "$BASEDIR/demo-data/responsibility_areas.sql" \
78 -d "$db" 81 -d "$db"
79 psql -p "$port" -f "$BASEDIR/demo-data/roles.sql" \ 82 psql -p "$port" -f "$BASEDIR/demo-data/roles.sql" \
80 -f "$BASEDIR/demo-data/users.sql" -d "$db" 83 -f "$BASEDIR/demo-data/users.sql" -d "$db"