#!/bin/sh

DB_HOST=localhost
DB_NAME=opensips
DB_USER=opensips
DB_PASS=opensips
CHARSET=latin1

MYSQL_COMMAND="mysql --defaults-extra-file=dbinit.cnf --batch"

SCRIPTS_DIR=$(test -f scripts/mysql/standard-create.sql && echo scripts/mysql || echo /usr/share/opensips/mysql)
MODULES=$(ls -1 --hide=*-migrate.sql --hide=standard-create.sql ${SCRIPTS_DIR} | cut -d- -f 1)

echo "Deleting and re-creating the ${DB_NAME} database..."

$MYSQL_COMMAND << EOF
DROP DATABASE IF EXISTS ${DB_NAME};
CREATE DATABASE ${DB_NAME} CHARACTER SET ${CHARSET};
GRANT ALL PRIVILEGES ON ${DB_NAME}.* TO '${DB_USER}' IDENTIFIED BY '${DB_PASS}';
GRANT ALL PRIVILEGES ON ${DB_NAME}.* TO '${DB_USER}'@'${DB_HOST}' IDENTIFIED BY '${DB_PASS}';
EOF

$MYSQL_COMMAND $DB_NAME < ${SCRIPTS_DIR}/standard-create.sql

echo "Creating tables:"
for MODULE in ${MODULES}; do
    echo "  ${MODULE}"
    $MYSQL_COMMAND $DB_NAME < ${SCRIPTS_DIR}/${MODULE}-create.sql
done
