#!/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 "Functionalities Changes 1" changes-20061128174648.sql
execute "Functionalities Changes 2" changes-20061130123539.sql
execute "Create Table Student Statutes" CreateTableStudentStatutes.sql
execute "Create Login Periods Table" createLoginPeriodsTable.sql
execute "Alter table Registration State" alterTableRegistrationState.sql

execute "Alter table LoginPeriod" alterTableLoginPeriod.sql
execute "Creating Table GratuityExemption" CreateTableGratuityExemption.sql
execute "Changing Table AccountingEvent" AlterTableAccountingEvent.sql
execute "Migrate GratuityEvents to DfaGratuityEvents" MigrateGratuityEventsToDfaGratuityEvents.sql