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

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

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

echo Creating ExecutionYear 2006/2007 ...
mysql -u$2 -f $1 < addNewExecutionYear.sql
echo Creating ExecutionYear 2006/2007 done.

mysql -u$2 -f $1 < createTableAdvise.sql
mysql -u$2 -f $1 < createTableTeacherService.sql
mysql -u$2 -f $1 < createTableTeacherServiceItem.sql
mysql -u$2 -f $1 < updatePersonRoleWithDepartmentMemberRole.sql > res
mysql -u$2 -f $1 < res
rm -r res

echo Alter table Degree...
mysql -u$2 -f $1 < alterDegreeTable.sql

echo Insert Scientific Role...
mysql -u$2 -f $1 < insertScientificCouncilRole.sql

echo done.