#!/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 "Alter table Parking Request" alterTableParkingRequest.sql
execute "Add some more fields the functionalities tables" AlterFunctionalitiesTables.sql
execute "Add toplevel portals and manager functionalities to the model" AddManagerFuctionalities.sql
execute "Set toplevel portals availability policy" UpdateAvailabilityPolicy.sql
execute "Alter space table" alterSpaceTable.sql