#!/bin/bash

host="localhost"
databasename="avdocs_website"

# inicializações
param="-h $host -u avalanche -pavalanche"
mysqladmin $param drop $databasename
mysql $param -e "CREATE DATABASE $databasename CHARSET utf8"
if [ ! -e "../admin/scripts/SITE_DBDump.sql" ] || [ "../admin/scripts/SITE_DBDump.sql.bz2" -nt "../admin/scripts/SITE_DBDump.sql" ]
then
        cd ../admin/scripts/
        echo uncompressing database...
        bunzip2 -fk SITE_DBDump.sql.bz2
        cd ../../bin
fi
echo importing database...
mysql $param $databasename < ../admin/scripts/SITE_DBDump.sql

echo flushing log
rm -f ../admin/log/avalanche.log
touch ../admin/log/avalanche.log
sudo chown apache ../admin/log/avalanche.log
