setup.sh

#!/bin/bash

# Get the directory this file is in (the project base)
basedir=$(cd $(dirname $0) && pwd)

mysql=mysql     # mysql executable
host=localhost  # mysql host
username=       # mysql user
passwd=         # mysql password

# parse the command line parameters
while getopts 'm:h:u:p:d:' OPTION 
do case "$OPTION" in
    m)  mysql="$OPTARG"
        ;;
    h)  host="$OPTARG"
        ;;
    u)  username="$OPTARG"
        ;;
    p)  passwd="$OPTARG"
        ;;
    ?)  printf "Reloads the MMOServerDB install\n"
        printf ""
        exit 2
        ;;
esac
done
shift $(($OPTIND - 1))

for i in $(find . ! -name . -type d -prune)
do
	schema=$(basename $i)
    if [ ! -f $i/create.sql ]; then
        continue;
    fi
    
    if [ -f $i/create_users.sql ]; then
        $mysql -u $username -p$passwd -h $host --default-character-set=utf8 <$i/create_users.sql
        printf "Installing create_users.sql [Done]\n"       
    fi
    
    $mysql -u $username -p$passwd -h $host --default-character-set=utf8 <$i/create.sql
    printf "Installing create.sql [Done]\n"
    
    for j in $(find $i/scripts -name *.sql)
    do
    $mysql -u $username -p$passwd -h $host --database=$schema --default-character-set=utf8 <$j
        printf "Installing $j [Done]\n"
    done
        
    for j in $(find $i/functions -name *.sql)
    do
    $mysql -u $username -p$passwd -h $host --database=$schema --default-character-set=utf8 <$j
        printf "Installing $j [Done]\n"
    done
    
    for j in $(find $i/procedures -name *.sql)
    do
    $mysql -u $username -p$passwd -h $host --database=$schema --default-character-set=utf8 <$j
        printf "Installing $j [Done]\n"
    done
done