openpkg-packages/punbb/punbb-setup.sh

#!/bin/sh
##
##  punbb-setup.sh -- PunBB RDBMS Setup Utility
##

#   determine database details
db_dir="@l_prefix@/var/punbb/db"
db_name="punbb"
db_user="punbb"
db_pass="punbb"
db_suser="postgresql"

#   dispatch operation
cmd="${1:-"install"}"
case "$cmd" in
    install )
        ( echo "CREATE ROLE $db_user LOGIN ENCRYPTED PASSWORD '$db_pass' NOCREATEDB NOCREATEUSER;"
          echo "CREATE TABLESPACE $db_name OWNER $db_user LOCATION '$db_dir';"
          echo "CREATE DATABASE $db_name OWNER $db_user TABLESPACE $db_name;"
        ) | @l_prefix@/bin/psql -U "$db_suser" -d template1 -f-
        ;;
    uninstall )
        ( echo "DROP DATABASE $db_name;"
          echo "DROP TABLESPACE $db_name;"
          echo "DROP ROLE $db_user;"
        ) | @l_prefix@/bin/psql -U "$db_suser" -d template1 -f-
        rm -rf @l_prefix@/var/punbb/db/* >/dev/null 2>&1 || true
        ;;
esac