#!/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 "Fix Seminary Tables" fixSeminaryTables.sql
execute "add parking tables" parkingTables.sql

#
# Don't create the seminaries just yet.
# Also this should only be run at IST. So once it is run in production delete
# instead of moving it into a folder with a date.
#
#execute "Create 1st Semester 2006 Seminaries" create2006Sem1Seminaries.sql