#!/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 $DB < $2
	echo
}

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

execute "Creating Service Request Tables" CreateServiceRequestsTables.sql
execute "Changing table AccountingEvent" AlterTableAccountingEvent.sql
execute "Changeing cron table" AlterTableCron.sql
execute "Add DocumentRequestType column to AcademicServiceRequest table" AlterTableAcademicServiceRequest.sql
execute "Add AplicableWeekDays column to AssiduousnessRecord table" AlterTableAssiduousnessRecord.sql
execute "Updating Table AccountingEvent" UpdateTableAccountingEvent.sql