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

DB=$1
USER=$2

echo Using database: $DB
echo Enter password for $USER:
read -s password

function execute() {
	echo ---------------------------------------- $1
	mysql -u$USER -f -p$password --default-character-set=latin1 $DB < $2
	echo
}

function executeWithTempFile() {
	echo ---------------------------------------- $1
	mysql -u$USER -f -p$password --default-character-set=latin1 $DB < $2 > tmp.sql
	mysql -u$USER -f -p$password --default-character-set=latin1 $DB < tmp.sql	
	rm tmp.sql
	echo
}

execute "Bigger Justification field in unavailable Period" alterTableUnavailablePeriod.sql

execute "Create LoginAlias table" CreateLoginAliasTable.sql

execute "Add new stuff to executin course table" alterExecutionCourseTableToAddKeyAnnouncementBoard.sql
execute "Create new announcement table" createNewAnnouncementTables.sql
execute "Migrate execution course announcements" migrateAnnouncements.sql
execute "Migrate institution site announcements" migrateInstitutionAnnouncements.sql
execute "Update Invalid StudentKind keys" updateRegistrationStudentKind.sql
execute  "Functionality changes" changes-20061010210255.sql

execute  "Fix Mark Table" fixMarkTable.sql
execute  "Fix Final Degree Work Proposal Table" fixFinalDegreeWorkProposalTable.sql