#!/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 "Adding unique constraint on AffinityCycleCourseGroup" AlterTableAffinityCycleCourseGroup.sql executeWithTempFile "Create Course Load Table" createCourseLoadTable.sql executeWithTempFile "Create Course Load Table 2" createCourseLoadTable2.sql executeWithTempFile "Create Course Load Table 3" createCourseLoadTable3.sql execute "Alter Table Accountability Type Table" alterTableAccountabilityType.sql