#!/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 "Create banners and custom links for UnitSite" CreateUnitSiteArtifacts.sql
execute "Add department site configuration" AddDepartmentSiteConfiguration.sql
execute "Add show functionalities to department site" AddShowFunctionalitiesDepartmentSites.sql

execute "Alter table AccountingEvent" AlterTableAccountingEvent.sql
execute "Updating table AccountingEvent" UpdateTableAccountingEvent.sql