#!/bin/tcsh

echo "Drop FreeZone DBspace, and clearing some garbage :)"
dropdb FreeZone  >& /dev/null
dropuser tony    >>& /dev/null 
dropuser sasha   >>& /dev/null
dropuser djos    >>& /dev/null

./delete_products | psql FreeZone >& /dev/null

echo "Creating *NEW* FreeZone DBspace" 
createdb FreeZone            >>& /dev/null
echo "Adding PL/pgSQL language"
createlang plpgsql FreeZone  >>& /dev/null
echo "Creating users ..."
createuser -a -D -q tony      >>& /dev/null
createuser -a -D -q djos      >>& /dev/null
createuser -a -D -q sasha     >>& /dev/null
echo "Creating tables ..."
psql FreeZone < SQL-table  >& SQL-err
echo "Creating functions ..."
psql FreeZone -U tony < SQL-funct >>& SQL-err
echo "Granting priviledges ..."
psql FreeZone -U tony < SQL-auth  >>& SQL-err

echo "Vacuumdb -a ..."
vacuumdb -a >& /dev/null
echo "Database setup complete!"
