#!/bin/sh
# -----------------------------------------------------------------------------
#
#   Runs sql scripts to update database from previous release.
#
# -----------------------------------------------------------------------------
#

echo Using database: $1
echo Enter password for $2:
read -s password

echo Creating BOLONHA Role ...
mysql -u$2 -f $1 < addBolonhaManagerRole.sql
echo BOLONHA Role created.

echo Altering CompetenceCourseInformation table ...
mysql -u$2 -f $1 < alterTableCompetenceCourseInformation.sql
echo CompetenceCourseInformation table modified.

mysql -u$2 -f $1 < alterContractTable.sql
mysql -u$2 -f $1 < alterUnitTable.sql
mysql -u$2 -f $1 < alterPersonFunctionTable.sql

mysql -u$2 -f $1 < alterTableStudent.sql
mysql -u$2 -f $1 < updateStudent.sql > res.sql
mysql -u$2 -f $1 < res.sql