/bin/bash
createdb guac_db
cat /guac_scripts/001-create-schema.sql | psql -d guac_db -f -
cat /guac_scripts/002-create-admin-user.sql | psql -d guac_db -f -
echo "CREATE USER admin WITH PASSWORD 'easypassword';" | psql -d guac_db -f -
echo "GRANT SELECT,INSERT,UPDATE,DELETE ON ALL TABLES IN SCHEMA public TO admin;" | psql -d guac_db -f -
echo "GRANT SELECT,USAGE ON ALL SEQUENCES IN SCHEMA public TO admin;" | psql -d guac_db -f -
