#!/bin/sh
# -----------------------------------------------------------------------------
#
#   Runs sql scripts to update database from previous release.
#
# -----------------------------------------------------------------------------
#

echo Using database: $1
echo Enter password for $2:
read -s password

# Alter TeacherServiceExemption Table
mysql -u$2 -f $1 < renameTableServiceExemptionsCreditLine.sql

# Add Teacher Expectation Definition Period
mysql -u$2 -f $1 < CreateTableTeacherExpectationDefinitionPeriod.sql
mysql -u$2 -f $1 < CreateTeacherExpectationDefinitionPeriodForDEI.sql > res
mysql -u$2 -f $1 < res
rm -r res