tom@742: #!/bin/sh
tom@742: DIR=`dirname $0`
tom@742: 
tom@854: ROLE_NAME=${1:-lada}
tom@854: ROLE_PW=${2:-$ROLE_NAME}
tom@854: DB_NAME=${3:-$ROLE_NAME}
tom@742: 
tom@742: psql --command "CREATE USER $ROLE_NAME PASSWORD '$ROLE_PW';"
tom@742: createdb -E UTF-8 $DB_NAME
tom@866: 
tom@866: psql -d $DB_NAME  --command \
tom@866:      "CREATE EXTENSION IF NOT EXISTS postgis WITH SCHEMA public"
tom@866: 
tom@866: psql -d $DB_NAME -f $DIR/stammdaten_schema.sql
tom@742: psql -d $DB_NAME -f $DIR/lada_schema.sql
tom@742: psql -d $DB_NAME --command \
tom@742:      "GRANT USAGE ON SCHEMA stammdaten, bund, land TO $ROLE_NAME;
tom@764:       GRANT USAGE
raimund@752:             ON ALL SEQUENCES IN SCHEMA stammdaten, bund, land TO $ROLE_NAME;
tom@742:       GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES
tom@742:             ON ALL TABLES IN SCHEMA stammdaten, bund, land TO $ROLE_NAME;"