#!/bin/bash
# -----------------------------------------------------------------------------
#
#   Runs sql scripts to insert missing login periods 
#
# -----------------------------------------------------------------------------
#

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=utf8 $DB < $2
	echo
}

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

execute "Add signature column to table PARTY" AlterTablePartyAddSignature.sql
execute "Add missing indexes to table PARTY" AlterTablePartyAddMissingIndexes.sql
execute "Add OJB_CONCRETE_CLASS column to table FILE_ENTRY" AlterFileEntryAddOjbConcreteClass.sql
execute "Initialize OJB_CONCRETE_CLASS in table FILE_ENTRY" InitFileEntryOjbConcreteClassColumn.sql