#!/bin/sh
echo '0) drop all tables'
php app/console doctrine:schema:drop -q --force --env=test

echo '1) fixtures schema'
php app/console doctrine:query:sql -q --env=test " $(cat ./app/Resources/dbupdate/starter.sql)"
php app/console doctrine:query:sql -q --env=test " $(cat ./app/Resources/dbupdate/starter2.sql)"


echo '3) db version update'
php app/console es:db:update --env=test

echo '4) create admin'
php app/console fos:user:create --super-admin admin admin@e-surf.pl Admin12346 --env=test
php app/console fos:user:promote --super admin --env=test