#!/bin/bash

mysqladmin -uroot $MYSQL_ROOT_PASSWORD --force drop lavoriagili_development 2> /dev/null
mysqladmin -uroot $MYSQL_ROOT_PASSWORD --force drop lavoriagili_test 2> /dev/null
mysqladmin -uroot $MYSQL_ROOT_PASSWORD create lavoriagili_development || exit 1
mysqladmin -uroot $MYSQL_ROOT_PASSWORD create lavoriagili_test

echo 'grant all on lavoriagili_development.* to lavoriagili@localhost;' |  mysql -uroot $MYSQL_ROOT_PASSWORD
echo 'grant all on lavoriagili_test.* to lavoriagili@localhost;' |  mysql -uroot $MYSQL_ROOT_PASSWORD
 
rake db:migrate