#!/bin/sh
#
# Clean up the mysql databases

DSPAMCONF=/etc/dspam/dspam.conf
MYSQLCONF=/etc/dspam/dspam.d/mysql.conf
PURGE=/usr/share/doc/libdspam7-drv-mysql/purge-4.1.sql

if grep -q "^StorageDriver.*mysql_drv.so" $DSPAMCONF; then
  if [ -x /usr/bin/mysql ]; then
    MYSQL_USER=`grep "^MySQLUser" $MYSQLCONF | awk '{print $2}'`
    MYSQL_PASS=`grep "^MySQLPass" $MYSQLCONF | awk '{print $2}'`
    MYSQL_DB=`grep "^MySQLDb" $MYSQLCONF | awk '{print $2}'`
    /usr/bin/mysql --user=$MYSQL_USER --pass=$MYSQL_PASS $MYSQL_DB < $PURGE
  fi
fi

exit 0