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

DB=$1
USER=$2

echo Using database: $DB
echo Using user: $USER:
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
}

# ISCTE
executeWithTempFile "ChangeDefaultValuesOfPartyTableAndCorrectExistingOnes.sql" ChangeDefaultValuesOfPartyTableAndCorrectExistingOnes.sql
executeWithTempFile "../R2007/R2007-03-27/createPartyContactTable.sql" ../R2007/R2007-03-27/createPartyContactTable.sql
executeWithTempFile "../R2007/R2007-03-27/migratePartyPhones.sql" ../R2007/R2007-03-27/migratePartyPhones.sql
executeWithTempFile "../R2007/R2007-03-27/migratePartyPhysicalAddress.sql" ../R2007/R2007-03-27/migratePartyPhysicalAddress.sql
executeWithTempFile "../R2007/R2007-03-27/migratePartyWebAddress.sql" ../R2007/R2007-03-27/migratePartyWebAddress.sql
executeWithTempFile "../R2007/R2007-03-27/migratePartyEmails.sql" ../R2007/R2007-03-27/migratePartyEmails.sql

#jpps 2008-03-24
executeWithTempFile "../R2007/R2007-04-01/ChangeThesisFileTable.sql" ../R2007/R2007-04-01/ChangeThesisFileTable.sql

#rjmvo 2008-04-09
executeWithTempFile "../R2007/R2007-04-01/alterTableSpace.sql" ../R2007/R2007-04-01/alterTableSpace.sql

#jpps 2008-04-23
executeWithTempFile "../R2007/R2007-04-01/ChangeThesisTable.sql" ../R2007/R2007-04-01/ChangeThesisTable.sql

executeWithTempFile "../R2007/R2007-04-20/alterTableParty.sql" ../R2007/R2007-04-20/alterTableParty.sql
executeWithTempFile "../R2007/R2007-04-20/alterTableParty.sql" ../R2007/R2007-04-20/alterTableParty.sql
executeWithTempFile "../R2007/R2007-04-24/CreateUnitSiteArtifacts.sql" ../R2007/R2007-04-24/CreateUnitSiteArtifacts.sql
executeWithTempFile "../R2007/R2007-04-24/AddDepartmentSiteConfiguration.sql" ../R2007/R2007-04-24/AddDepartmentSiteConfiguration.sql
executeWithTempFile "../R2007/R2007-04-24/AddShowFunctionalitiesDepartmentSites.sql" ../R2007/R2007-04-24/AddShowFunctionalitiesDepartmentSites.sql
executeWithTempFile "../R2007/R2007-04-24/AlterTableAccountingEvent.sql" ../R2007/R2007-04-24/AlterTableAccountingEvent.sql
executeWithTempFile "../R2007/R2007-04-24/UpdateTableAccountingEvent.sql" ../R2007/R2007-04-24/UpdateTableAccountingEvent.sql
executeWithTempFile "../R2007/R2007-04-26/alterTableSpaceOccupation.sql" ../R2007/R2007-04-26/alterTableSpaceOccupation.sql
executeWithTempFile "../R2007/R2007-04-26/changes-20070423193745.sql" ../R2007/R2007-04-26/changes-20070423193745.sql
executeWithTempFile "../R2007/R2007-04-26/createResearchUnitFunctionalities.sql" ../R2007/R2007-04-26/createResearchUnitFunctionalities.sql
executeWithTempFile "../R2007/R2007-04-26/ChangeDepartmentSite.sql" ../R2007/R2007-04-26/ChangeDepartmentSite.sql
executeWithTempFile "../R2007/R2007-04-27/addParticipationsFunctionality.sql" ../R2007/R2007-04-27/addParticipationsFunctionality.sql
executeWithTempFile "../R2007/R2007-04-27/alterTableFinalDegreeWorkScheduling.sql" ../R2007/R2007-04-27/alterTableFinalDegreeWorkScheduling.sql
executeWithTempFile "../R2007/R2007-04-30/changes-20070427103445.sql" ../R2007/R2007-04-30/changes-20070427103445.sql
executeWithTempFile "../R2007/R2007-05-02/alterTableEnrolmentEvaluation.sql" ../R2007/R2007-05-02/alterTableEnrolmentEvaluation.sql
executeWithTempFile "../R2007/R2007-05-02/createTableEnrolmentNotNeedToEnrol.sql" ../R2007/R2007-05-02/createTableEnrolmentNotNeedToEnrol.sql
executeWithTempFile "../R2007/R2007-05-02/inquieryResponsePeriod.sql" ../R2007/R2007-05-02/inquieryResponsePeriod.sql
executeWithTempFile "../R2007/R2007-05-04/ChangeUnitSite.sql" ../R2007/R2007-05-04/ChangeUnitSite.sql
executeWithTempFile "../R2007/R2007-05-04/AddLinkToUnitSiteBanner.sql" ../R2007/R2007-05-04/AddLinkToUnitSiteBanner.sql
executeWithTempFile "../R2007/R2007-05-04/ChangeItem.sql" ../R2007/R2007-05-04/ChangeItem.sql
executeWithTempFile "../R2007/R2007-05-08/alterTableAccountability.sql" ../R2007/R2007-05-08/alterTableAccountability.sql
executeWithTempFile "../R2007/R2007-05-10/alterTableProjectAccess.sql" ../R2007/R2007-05-10/alterTableProjectAccess.sql
executeWithTempFile "../R2007/R2007-05-10/alterAccountabilityTable.sql" ../R2007/R2007-05-10/alterAccountabilityTable.sql
executeWithTempFile "../R2007/R2007-05-10/alterAccountabilityTable2.sql" ../R2007/R2007-05-10/alterAccountabilityTable2.sql
executeWithTempFile "../R2007/R2007-05-11/cleanupThesisParticipations.sql" ../R2007/R2007-05-11/cleanupThesisParticipations.sql
executeWithTempFile "../R2007/R2007-05-11/resetConvokeStatus.sql" ../R2007/R2007-05-11/resetConvokeStatus.sql
executeWithTempFile "../R2007/R2007-05-11/cleanThesisWithoutEnrolments.sql" ../R2007/R2007-05-11/cleanThesisWithoutEnrolments.sql
executeWithTempFile "../R2007/R2007-05-11/alterTeacherLegalRegimenTable.sql" ../R2007/R2007-05-11/alterTeacherLegalRegimenTable.sql
executeWithTempFile "../R2007/R2007-05-11/alterTeacherServiceExemptionTable.sql" ../R2007/R2007-05-11/alterTeacherServiceExemptionTable.sql
executeWithTempFile "../R2007/R2007-05-14/deleteLooseThesisParticipations.sql" ../R2007/R2007-05-14/deleteLooseThesisParticipations.sql
executeWithTempFile "../R2007/R2007-05-14/increaseThesisProposalTitleSize.sql" ../R2007/R2007-05-14/increaseThesisProposalTitleSize.sql
executeWithTempFile "../R2007/R2007-05-14/alterTableAssiduousnessClosedMonth.sql" ../R2007/R2007-05-14/alterTableAssiduousnessClosedMonth.sql
executeWithTempFile "../R2007/R2007-05-14/alterTableJustificationMotive.sql" ../R2007/R2007-05-14/alterTableJustificationMotive.sql
executeWithTempFile "../R2007/R2007-05-14/createTablesForUnitExtraWork.sql" ../R2007/R2007-05-14/createTablesForUnitExtraWork.sql
executeWithTempFile "../R2007/R2007-05-15/createTableInquiriesStudentExecutionPeriod.sql" ../R2007/R2007-05-15/createTableInquiriesStudentExecutionPeriod.sql
executeWithTempFile "../R2007/R2007-05-16/addResearchFunctionAccountabilityTypes.sql" ../R2007/R2007-05-16/addResearchFunctionAccountabilityTypes.sql
executeWithTempFile "../R2007/R2007-05-16/showResearchMembers.sql" ../R2007/R2007-05-16/showResearchMembers.sql
executeWithTempFile "../R2007/R2007-05-16/changes-20070515114523.sql" ../R2007/R2007-05-16/changes-20070515114523.sql
executeWithTempFile "../R2007/R2007-05-16/ResearchUnitMembersFunctionality.sql" ../R2007/R2007-05-16/ResearchUnitMembersFunctionality.sql
executeWithTempFile "../R2007/R2007-05-16/changes-20070515162927.sql" ../R2007/R2007-05-16/changes-20070515162927.sql
executeWithTempFile "../R2007/R2007-05-16/ResearchUnitPublicationFunctionality.sql" ../R2007/R2007-05-16/ResearchUnitPublicationFunctionality.sql
executeWithTempFile "../R2007/R2007-05-16/addResearchActivityFunctionalities.sql" ../R2007/R2007-05-16/addResearchActivityFunctionalities.sql
executeWithTempFile "../R2007/R2007-05-17/createTableAssiduousnessVacations.sql" ../R2007/R2007-05-17/createTableAssiduousnessVacations.sql
executeWithTempFile "../R2007/R2007-05-21/alterTableAssiduousnessVacations.sql" ../R2007/R2007-05-21/alterTableAssiduousnessVacations.sql
executeWithTempFile "../R2007/R2007-05-21/addRepeatToUnitSiteBanner.sql" ../R2007/R2007-05-21/addRepeatToUnitSiteBanner.sql
executeWithTempFile "../R2007/R2007-05-21/migrateCurriculumGroupsToRootAndCycleGroups.sql" ../R2007/R2007-05-21/migrateCurriculumGroupsToRootAndCycleGroups.sql
executeWithTempFile "../R2007/R2007-05-21/correctDepartmentBoardsWritingPermission.sql" ../R2007/R2007-05-21/correctDepartmentBoardsWritingPermission.sql
executeWithTempFile "../R2007/R2007-05-21/addAffinityCycleCourseGroupTable.sql" ../R2007/R2007-05-21/addAffinityCycleCourseGroupTable.sql
executeWithTempFile "../R2007/R2007-05-21/addCycleTypeColumn.sql" ../R2007/R2007-05-21/addCycleTypeColumn.sql
executeWithTempFile "../R2007/R2007-05-21/alterRootCourseGroupType.sql" ../R2007/R2007-05-21/alterRootCourseGroupType.sql
execute "../R2007/R2007-05-21/changeToCycleCourseGroupType.sql" ../R2007/R2007-05-21/changeToCycleCourseGroupType.sql
executeWithTempFile "../R2007/R2007-05-21/addBooleanToResearchContract.sql" ../R2007/R2007-05-21/addBooleanToResearchContract.sql
executeWithTempFile "../R2007/R2007-05-21/addParticipationSpecification.sql" ../R2007/R2007-05-21/addParticipationSpecification.sql
executeWithTempFile "../R2007/R2007-05-21/modifyResearchActivityParticipations.sql" ../R2007/R2007-05-21/modifyResearchActivityParticipations.sql
executeWithTempFile "../R2007/R2007-05-21/temporaryLoginModifications.sql" ../R2007/R2007-05-21/temporaryLoginModifications.sql
executeWithTempFile "../R2007/R2007-05-21/changeDepartmentSectionNames.sql" ../R2007/R2007-05-21/changeDepartmentSectionNames.sql
executeWithTempFile "../R2007/R2007-05-21/changeDepartmentTeachersPath.sql" ../R2007/R2007-05-21/changeDepartmentTeachersPath.sql
executeWithTempFile "../R2007/R2007-05-23/alterTableUnitExtraWorkMovement.sql" ../R2007/R2007-05-23/alterTableUnitExtraWorkMovement.sql
executeWithTempFile "../R2007/R2007-05-28/persistentGroupMembers.sql" ../R2007/R2007-05-28/persistentGroupMembers.sql
executeWithTempFile "../R2007/R2007-05-28/changeDepartmentSectionNames.sql" ../R2007/R2007-05-28/changeDepartmentSectionNames.sql
executeWithTempFile "../R2007/R2007-05-28/changeDepartmentTeachersPath.sql" ../R2007/R2007-05-28/changeDepartmentTeachersPath.sql
execute "../R2007/R2007-05-28/addEnglishNameToDepartments.sql" ../R2007/R2007-05-28/addEnglishNameToDepartments.sql
executeWithTempFile "../R2007/R2007-05-28/addUnitSiteOption.sql" ../R2007/R2007-05-28/addUnitSiteOption.sql
executeWithTempFile "../R2007/R2007-05-28/addRequestedCycleToAcademicServiceRequestTable.sql" ../R2007/R2007-05-28/addRequestedCycleToAcademicServiceRequestTable.sql
# ISCTE
executeWithTempFile "AddColumnSituationTypeToLegalRegimen.sql" AddColumnSituationTypeToLegalRegimen.sql
executeWithTempFile "../R2007/R2007-05-28/alterTableLegalRegimen.sql" ../R2007/R2007-05-28/alterTableLegalRegimen.sql
executeWithTempFile "../R2007/R2007-05-28/alterTableProfessionalSituation.sql" ../R2007/R2007-05-28/alterTableProfessionalSituation.sql
executeWithTempFile "../R2007/R2007-05-28/AlterTableReceipt.sql" ../R2007/R2007-05-28/AlterTableReceipt.sql
executeWithTempFile "DropEquivalencePlanAndEquivalencePlanEntryTables.sql" DropEquivalencePlanAndEquivalencePlanEntryTables.sql
executeWithTempFile "../R2007/R2007-05-28/CreateEquivalencePlanTables.sql" ../R2007/R2007-05-28/CreateEquivalencePlanTables.sql
executeWithTempFile "../R2007/R2007-05-28/AlterTableDegreeCurricularPlan.sql" ../R2007/R2007-05-28/AlterTableDegreeCurricularPlan.sql
executeWithTempFile "../R2007/R2007-05-28/AlterTableStudentCurricularPlan.sql" ../R2007/R2007-05-28/AlterTableStudentCurricularPlan.sql
executeWithTempFile "../R2007/R2007-05-29/updateJustificationMotive.sql" ../R2007/R2007-05-29/updateJustificationMotive.sql
executeWithTempFile "../R2007/R2007-05-29/fixFileBug.sql" ../R2007/R2007-05-29/fixFileBug.sql
executeWithTempFile "../R2007/R2007-05-29/FixEquivalencePlanTables.sql" ../R2007/R2007-05-29/FixEquivalencePlanTables.sql
executeWithTempFile "../R2007/R2007-05-31/updateRegistrationAgreement.sql" ../R2007/R2007-05-31/updateRegistrationAgreement.sql
executeWithTempFile "../R2007/R2007-05-31/updateStudentCurricularPlans.sql" ../R2007/R2007-05-31/updateStudentCurricularPlans.sql
executeWithTempFile "../R2007/R2007-05-31/addYearMonthDayToScientificJournalParticipation.sql" ../R2007/R2007-05-31/addYearMonthDayToScientificJournalParticipation.sql
executeWithTempFile "../R2007/R2007-05-31/alterFileTable.sql" ../R2007/R2007-05-31/alterFileTable.sql
executeWithTempFile "../R2007/R2007-05-31/modifyPersistentGroupMembers.sql" ../R2007/R2007-05-31/modifyPersistentGroupMembers.sql
executeWithTempFile "../R2007/R2007-05-31/makeSomeUnitSiteSectionsInvisible.sql" ../R2007/R2007-05-31/makeSomeUnitSiteSectionsInvisible.sql
executeWithTempFile "../R2007/R2007-05-31/alterSection.sql" ../R2007/R2007-05-31/alterSection.sql
executeWithTempFile "../R2007/R2007-05-31/addMobilityProgramToAcademicServiceRequestTable.sql" ../R2007/R2007-05-31/addMobilityProgramToAcademicServiceRequestTable.sql
executeWithTempFile "../R2007/R2007-06-01/addGradeColumns.sql" ../R2007/R2007-06-01/addGradeColumns.sql
executeWithTempFile "../R2007/R2007-06-04/addTagToFileTable.sql" ../R2007/R2007-06-04/addTagToFileTable.sql
executeWithTempFile "../R2007/R2007-06-04/createUnitFileTag.sql" ../R2007/R2007-06-04/createUnitFileTag.sql
executeWithTempFile "../R2007/R2007-06-04/createTableExternalEnrolmentNotNeedToEnrol.sql" ../R2007/R2007-06-04/createTableExternalEnrolmentNotNeedToEnrol.sql
executeWithTempFile "../R2007/R2007-06-08/createDomainClassInfoTable.sql" ../R2007/R2007-06-08/createDomainClassInfoTable.sql
executeWithTempFile "../R2007/R2007-06-08/addLibraryRole.sql" ../R2007/R2007-06-08/addLibraryRole.sql
executeWithTempFile "../R2007/R2007-06-08/alterThesis.sql" ../R2007/R2007-06-08/alterThesis.sql
executeWithTempFile "../R2007/R2007-06-08/addLibraryEntries.sql" ../R2007/R2007-06-08/addLibraryEntries.sql
executeWithTempFile "../R2007/R2007-06-08/createPublicationCollaborators.sql" ../R2007/R2007-06-08/createPublicationCollaborators.sql
executeWithTempFile "../R2007/R2007-06-08/createAllowedToUploadFilesInUnit.sql" ../R2007/R2007-06-08/createAllowedToUploadFilesInUnit.sql
executeWithTempFile "../R2007/R2007-06-08/alterTableJustificationMotive.sql" ../R2007/R2007-06-08/alterTableJustificationMotive.sql
executeWithTempFile "../R2007/R2007-06-11/dropEquivalenceCurricularCourseCurricularCourseTable.sql" ../R2007/R2007-06-11/dropEquivalenceCurricularCourseCurricularCourseTable.sql
executeWithTempFile "../R2007/R2007-06-11/removeUnnecessaryPartyColumns.sql" ../R2007/R2007-06-11/removeUnnecessaryPartyColumns.sql
executeWithTempFile "../R2007/R2007-06-11/translateAcademicUnits.sql" ../R2007/R2007-06-11/translateAcademicUnits.sql
executeWithTempFile "../R2007/R2007-06-11/alterTableExtraWorkRequest.sql" ../R2007/R2007-06-11/alterTableExtraWorkRequest.sql
executeWithTempFile "../R2007/R2007-06-11/fixFileEntry.sql" ../R2007/R2007-06-11/fixFileEntry.sql
executeWithTempFile "../R2007/R2007-06-13/alterExternalEnrolmentTable.sql" ../R2007/R2007-06-13/alterExternalEnrolmentTable.sql
executeWithTempFile "../R2007/R2007-06-13/alterTableExtraWorkRequest.sql" ../R2007/R2007-06-13/alterTableExtraWorkRequest.sql
# ISCTE
executeWithTempFile "../R2007/R2007-04-01/RefactorDegreeScientificCommission.sql" ../R2007/R2007-04-01/RefactorDegreeScientificCommission.sql
executeWithTempFile "../R2007/R2007-06-15/fixTableTypes.sql" ../R2007/R2007-06-15/fixTableTypes.sql
executeWithTempFile "../R2007/R2007-06-15/changeSite.sql" ../R2007/R2007-06-15/changeSite.sql
executeWithTempFile "../R2007/R2007-06-15/deleteUnitSiteFunctionalities.sql" ../R2007/R2007-06-15/deleteUnitSiteFunctionalities.sql
executeWithTempFile "../R2007/R2007-06-15/prepareUnitSiteTemplateSections.sql" ../R2007/R2007-06-15/prepareUnitSiteTemplateSections.sql
executeWithTempFile "../R2007/R2007-06-15/copyUnitSiteTemplateSections.sql" ../R2007/R2007-06-15/copyUnitSiteTemplateSections.sql
executeWithTempFile "../R2007/R2007-06-15/deleteUnitSiteTemplateSections.sql" ../R2007/R2007-06-15/deleteUnitSiteTemplateSections.sql
executeWithTempFile "../R2007/R2007-06-15/removeColumnsFromUnitSite.sql" ../R2007/R2007-06-15/removeColumnsFromUnitSite.sql
executeWithTempFile "../R2007/R2007-06-18/AlterTableEquivalencePlan.sql" ../R2007/R2007-06-18/AlterTableEquivalencePlan.sql
executeWithTempFile "../R2007/R2007-06-18/AlterTableEquivalencePlanEntry.sql" ../R2007/R2007-06-18/AlterTableEquivalencePlanEntry.sql
executeWithTempFile "../R2007/R2007-06-18/CreateTableCurricularCourseEquivalencePlanEntryNewCurricularCourse.sql" ../R2007/R2007-06-18/CreateTableCurricularCourseEquivalencePlanEntryNewCurricularCourse.sql
executeWithTempFile "../R2007/R2007-06-18/connectThesisAndPublications.sql" ../R2007/R2007-06-18/connectThesisAndPublications.sql
executeWithTempFile "../R2007/R2007-06-21/alterTableExternalEnrolment.sql" ../R2007/R2007-06-21/alterTableExternalEnrolment.sql
executeWithTempFile "../R2007/R2007-06-21/alterTableCurriculumModule.sql" ../R2007/R2007-06-21/alterTableCurriculumModule.sql
executeWithTempFile "../R2007/R2007-06-21/alterTableRegistration.sql" ../R2007/R2007-06-21/alterTableRegistration.sql
executeWithTempFile "../R2007/R2007-06-21/DropTableCurricularCourseEquivalencePlanEntryNewCurricularCourse.sql" ../R2007/R2007-06-21/DropTableCurricularCourseEquivalencePlanEntryNewCurricularCourse.sql
executeWithTempFile "../R2007/R2007-06-21/Creating Table CurricularCourseEquivalencePlanEntryNewDegreeModule" ../R2007/R2007-06-21/CreateTableCurricularCourseEquivalencePlanEntryNewDegreeModule.sql
executeWithTempFile "../R2007/R2007-06-21/AlterTableEquivalencePlanEntry.sql" ../R2007/R2007-06-21/AlterTableEquivalencePlanEntry.sql
executeWithTempFile "../R2007/R2007-06-22/alterTableProfessionalSitutationTable.sql" ../R2007/R2007-06-22/alterTableProfessionalSitutationTable.sql
executeWithTempFile "../R2007/R2007-06-22/alterTableExtraWorkRequest.sql" ../R2007/R2007-06-22/alterTableExtraWorkRequest.sql
executeWithTempFile "../R2007/R2007-04-13/alterTableParty.sql" ../R2007/R2007-04-13/alterTableParty.sql
executeWithTempFile "../R2007/R2007-04-18/UnitSiteManagers.sql" ../R2007/R2007-04-18/UnitSiteManagers.sql
executeWithTempFile "../R2007/R2007-06-22/updatePedagogicalCouncilClassification.sql" ../R2007/R2007-06-22/updatePedagogicalCouncilClassification.sql
executeWithTempFile "../R2007/R2007-06-25/changeEventEdition.sql" ../R2007/R2007-06-25/changeEventEdition.sql
executeWithTempFile "../R2007/R2007-06-25/createPrizeTables.sql" ../R2007/R2007-06-25/createPrizeTables.sql
executeWithTempFile "../R2007/R2007-06-25/addShowPrizesToHomePage.sql" ../R2007/R2007-06-25/addShowPrizesToHomePage.sql
executeWithTempFile "../R2007/R2007-06-25/changes-20070625183052.sql" ../R2007/R2007-06-25/changes-20070625183052.sql
executeWithTempFile "../R2007/R2007-06-25/addShowPrizesFunctionality.sql" ../R2007/R2007-06-25/addShowPrizesFunctionality.sql
executeWithTempFile "../R2007/R2007-06-25/alterTableGratuitySituation.sql" ../R2007/R2007-06-25/alterTableGratuitySituation.sql
executeWithTempFile "../R2007/R2007-06-25/alterTableRegistration-HomologationDate.sql" ../R2007/R2007-06-25/alterTableRegistration-HomologationDate.sql
executeWithTempFile "../R2007/R2007-06-26/AlterTableEquivalencePlanEntry.sql" ../R2007/R2007-06-26/AlterTableEquivalencePlanEntry.sql
executeWithTempFile "../R2007/R2007-06-27/refactorEquivalencyPlanEntries.sql" ../R2007/R2007-06-27/refactorEquivalencyPlanEntries.sql
executeWithTempFile "../R2007/R2007-06-27/addedResourceManagerRole.sql" ../R2007/R2007-06-27/addedResourceManagerRole.sql
executeWithTempFile "../R2007/R2007-06-27/changeSopRoleToResourceAllocationManager.sql" ../R2007/R2007-06-27/changeSopRoleToResourceAllocationManager.sql
executeWithTempFile "../R2007/R2007-06-27/alterTableSpace.sql" ../R2007/R2007-06-27/alterTableSpace.sql
# ISCTE
execute "ChangeTableRoomOccupation.sql" ChangeTableRoomOccupation.sql
executeWithTempFile "../R2007/R2007-06-27/fillSpaceOccupationWithRoomOccupations.sql" ../R2007/R2007-06-27/fillSpaceOccupationWithRoomOccupations.sql
executeWithTempFile "../R2007/R2007-06-27/alterTableLesson.sql" ../R2007/R2007-06-27/alterTableLesson.sql
executeWithTempFile "../R2007/R2007-06-27/changes-20070330115513.sql" ../R2007/R2007-06-27/changes-20070330115513.sql
executeWithTempFile "../R2007/R2007-06-27/alterResourceTable.sql" ../R2007/R2007-06-27/alterResourceTable.sql
executeWithTempFile "../R2007/R2007-06-27/alterResourceAllocationTable.sql" ../R2007/R2007-06-27/alterResourceAllocationTable.sql
executeWithTempFile "../R2007/R2007-06-27/alterSpaceResponsibilityTable.sql" ../R2007/R2007-06-27/alterSpaceResponsibilityTable.sql
executeWithTempFile "../R2007/R2007-06-27/alterResourceTable2.sql" ../R2007/R2007-06-27/alterResourceTable2.sql
executeWithTempFile "../R2007/R2007-06-27/changes-20070621160050.sql" ../R2007/R2007-06-27/changes-20070621160050.sql
executeWithTempFile "../R2007/R2007-06-28/modifyPrizeTable.sql" ../R2007/R2007-06-28/modifyPrizeTable.sql
executeWithTempFile "../R2007/R2007-06-28/createFileDeleteRequest.sql" ../R2007/R2007-06-28/createFileDeleteRequest.sql
executeWithTempFile "../R2007/R2007-06-28/alterTableUnit.sql" ../R2007/R2007-06-28/alterTableUnit.sql
executeWithTempFile "../R2007/R2007-06-28/createPedagogicalCouncilUnit.sql" ../R2007/R2007-06-28/createPedagogicalCouncilUnit.sql
executeWithTempFile "../R2007/R2007-06-28/createScientificCouncilUnit.sql" ../R2007/R2007-06-28/createScientificCouncilUnit.sql
executeWithTempFile "../R2007/R2007-06-29/alterTableCreditsDismissal.sql" ../R2007/R2007-06-29/alterTableCreditsDismissal.sql
executeWithTempFile "../R2007/R2007-07-03/addGraduateTitleSuffixToDegreeModuleTable.sql" ../R2007/R2007-07-03/addGraduateTitleSuffixToDegreeModuleTable.sql
executeWithTempFile "../R2007/R2007-02-12/createResearchActivityTable.sql" ../R2007/R2007-02-12/createResearchActivityTable.sql
executeWithTempFile "../R2007/R2007-03-05/ResearchModifications.sql" ../R2007/R2007-03-05/ResearchModifications.sql
executeWithTempFile "../R2007/R2007-03-28/createResearchTables.sql" ../R2007/R2007-03-28/createResearchTables.sql
executeWithTempFile "../R2007/R2007-07-09/fixMappingsAndNormalizeTableNames.sql" ../R2007/R2007-07-09/fixMappingsAndNormalizeTableNames.sql
executeWithTempFile "../R2007/R2007-07-10/updateSiteTemplate.sql" ../R2007/R2007-07-10/updateSiteTemplate.sql
executeWithTempFile "../R2007/R2007-07-11/changeDegreeSections.sql" ../R2007/R2007-07-11/changeDegreeSections.sql
executeWithTempFile "../R2007/R2007-07-11/createDegreeSection.sql" ../R2007/R2007-07-11/createDegreeSection.sql
executeWithTempFile "../R2007/R2007-07-11/createTableLessonInstance1.sql" ../R2007/R2007-07-11/createTableLessonInstance1.sql
executeWithTempFile "../R2007/R2007-07-11/createTableLessonInstance2.sql" ../R2007/R2007-07-11/createTableLessonInstance2.sql
executeWithTempFile "../R2007/R2007-07-11/createTableLessonInstance3.sql" ../R2007/R2007-07-11/createTableLessonInstance3.sql
executeWithTempFile "../R2007/R2007-07-11/createTableLessonInstance4.sql" ../R2007/R2007-07-11/createTableLessonInstance4.sql
executeWithTempFile "../R2007/R2007-07-11/createTableLessonInstance5.sql" ../R2007/R2007-07-11/createTableLessonInstance5.sql
executeWithTempFile "../R2007/R2007-07-11/createTableLessonInstance6.sql" ../R2007/R2007-07-11/createTableLessonInstance6.sql
executeWithTempFile "../R2007/R2007-07-12/addComptenceCourseInformationChangeRequestTable.sql" ../R2007/R2007-07-12/addComptenceCourseInformationChangeRequestTable.sql
executeWithTempFile "../R2007/R2007-07-12/modifyCompetenceCourseInformation.sql" ../R2007/R2007-07-12/modifyCompetenceCourseInformation.sql
executeWithTempFile "../R2007/R2007-07-13/updateThesesFilesGroups.sql" ../R2007/R2007-07-13/updateThesesFilesGroups.sql
executeWithTempFile "../R2007/R2007-07-13/alterTableExternalEnrolment.sql" ../R2007/R2007-07-13/alterTableExternalEnrolment.sql
executeWithTempFile "../R2007/R2007-07-16/AlterTableEquivalencePlanEntry.sql" ../R2007/R2007-07-16/AlterTableEquivalencePlanEntry.sql
executeWithTempFile "../R2007/R2007-07-16/insertCountry.sql" ../R2007/R2007-07-16/insertCountry.sql
executeWithTempFile "../R2007/R2007-07-17/alterTableExtraWorkRequest.sql" ../R2007/R2007-07-17/alterTableExtraWorkRequest.sql
executeWithTempFile "../R2007/R2007-07-18/alterResourceAllocationTable.sql" ../R2007/R2007-07-18/alterResourceAllocationTable.sql
executeWithTempFile "../R2007/R2007-07-18/alterTransactionStatisticsTable.sql" ../R2007/R2007-07-18/alterTransactionStatisticsTable.sql
executeWithTempFile "../R2007/R2007-07-19/AddOrderToFunctions.sql" ../R2007/R2007-07-19/AddOrderToFunctions.sql
executeWithTempFile "../R2007/R2007-07-19/createSiteFunctionalities.sql" ../R2007/R2007-07-19/createSiteFunctionalities.sql
executeWithTempFile "../R2007/R2007-07-19/createTemplates.sql" ../R2007/R2007-07-19/createTemplates.sql
executeWithTempFile "../R2007/R2007-07-20/AddManagerBolonhaTransitionFunctionalities.sql" ../R2007/R2007-07-20/AddManagerBolonhaTransitionFunctionalities.sql
executeWithTempFile "../R2007/R2007-07-24/alterTableTutorship.sql" ../R2007/R2007-07-24/alterTableTutorship.sql
executeWithTempFile "../R2007/R2007-07-24/updateRole.sql" ../R2007/R2007-07-24/updateRole.sql
executeWithTempFile "../R2007/R2007-07-24/createBonusTables.sql" ../R2007/R2007-07-24/createBonusTables.sql
executeWithTempFile "../R2007/R2007-07-24/alterTableJustificationMotive.sql" ../R2007/R2007-07-24/alterTableJustificationMotive.sql
executeWithTempFile "../R2007/R2007-07-24/alterTableAssiduousnessClosedMonth.sql" ../R2007/R2007-07-24/alterTableAssiduousnessClosedMonth.sql
executeWithTempFile "../R2007/R2007-04-10/alterTableStaffManagementSection.sql" ../R2007/R2007-04-10/alterTableStaffManagementSection.sql
executeWithTempFile "../R2007/R2007-07-24/alterTableManagementGroups.sql" ../R2007/R2007-07-24/alterTableManagementGroups.sql
executeWithTempFile "../R2007/R2007-07-24/convertedAssiduousnessPortalToFunctionalities.sql" ../R2007/R2007-07-24/convertedAssiduousnessPortalToFunctionalities.sql
executeWithTempFile "../R2007/R2007-07-24/changeSiteManagement.sql" ../R2007/R2007-07-24/changeSiteManagement.sql
executeWithTempFile "../R2007/R2007-07-24/bugFixPersonnelSectionPortal.sql" ../R2007/R2007-07-24/bugFixPersonnelSectionPortal.sql
executeWithTempFile "../R2007/R2007-07-24/changeThesis.sql" ../R2007/R2007-07-24/changeThesis.sql
executeWithTempFile "../R2007/R2007-07-26/updateAvailabilityPolicy.sql" ../R2007/R2007-07-26/updateAvailabilityPolicy.sql
executeWithTempFile "../R2007/R2007-07-26/alterBonusTables.sql" ../R2007/R2007-07-26/alterBonusTables.sql
executeWithTempFile "../R2007/R2007-07-27/changes-20070726182053.sql" ../R2007/R2007-07-27/changes-20070726182053.sql
executeWithTempFile "../R2007/R2007-08-02/changes-20070730163712.sql" ../R2007/R2007-08-02/changes-20070730163712.sql
executeWithTempFile "../R2007/R2007-08-02/createCreditsDismissalNoEnrolCurricularCourseTable.sql" ../R2007/R2007-08-02/createCreditsDismissalNoEnrolCurricularCourseTable.sql
executeWithTempFile "../R2007/R2007-08-02/updateCreditsDismissalClass.sql" ../R2007/R2007-08-02/updateCreditsDismissalClass.sql
executeWithTempFile "../R2007/R2007-08-09/alterTableEmployeeMonthlyBonusInstallment.sql" ../R2007/R2007-08-09/alterTableEmployeeMonthlyBonusInstallment.sql
executeWithTempFile "../R2007/R2007-08-09/alterTableAnualBonusInstallment.sql" ../R2007/R2007-08-09/alterTableAnualBonusInstallment.sql
executeWithTempFile "../R2007/R2007-08-21/alterTableEmployeeBonusInstallment.sql" ../R2007/R2007-08-21/alterTableEmployeeBonusInstallment.sql
executeWithTempFile "../R2007/R2007-08-23/AlterTableAffinityCycleCourseGroup.sql" ../R2007/R2007-08-23/AlterTableAffinityCycleCourseGroup.sql
executeWithTempFile "../R2007/R2007-08-23/createCourseLoadTable.sql" ../R2007/R2007-08-23/createCourseLoadTable.sql
executeWithTempFile "../R2007/R2007-08-23/createCourseLoadTable2.sql" ../R2007/R2007-08-23/createCourseLoadTable2.sql
executeWithTempFile "../R2007/R2007-08-23/createCourseLoadTable3.sql" ../R2007/R2007-08-23/createCourseLoadTable3.sql
executeWithTempFile "../R2007/R2007-08-23/alterTableAccountabilityType.sql" ../R2007/R2007-08-23/alterTableAccountabilityType.sql
executeWithTempFile "../R2007/R2007-08-24/alterTableSummary.sql" ../R2007/R2007-08-24/alterTableSummary.sql
executeWithTempFile "../R2007/R2007-08-26/cleanup.sql" ../R2007/R2007-08-26/cleanup.sql
executeWithTempFile "../R2007/R2007-08-28/updates.sql" ../R2007/R2007-08-28/updates.sql
executeWithTempFile "../R2007/R2007-08-29/updates.sql" ../R2007/R2007-08-29/updates.sql
executeWithTempFile "../R2007/R2007-08-30/removeTimeStamps.sql" ../R2007/R2007-08-30/removeTimeStamps.sql
executeWithTempFile "../R2007/R2007-08-31/ChangeTableDegreeCurricularPlan.sql" ../R2007/R2007-08-31/ChangeTableDegreeCurricularPlan.sql
executeWithTempFile "../R2007/R2007-09-03/alterTableParty.sql" ../R2007/R2007-09-03/alterTableParty.sql
executeWithTempFile "../R2007/R2007-09-03/alterTableCurricularRuleAddEven.sql" ../R2007/R2007-09-03/alterTableCurricularRuleAddEven.sql
executeWithTempFile "../R2007/R2007-09-04/createLibraryCardTable.sql" ../R2007/R2007-09-04/createLibraryCardTable.sql
executeWithTempFile "../R2007/R2007-09-05/removeContractTableAndExecutionCourseHours.sql" ../R2007/R2007-09-05/removeContractTableAndExecutionCourseHours.sql
executeWithTempFile "../R2007/R2007-09-05/changes-20070905162158.sql" ../R2007/R2007-09-05/changes-20070905162158.sql
executeWithTempFile "../R2007/R2007-09-05/updateLibraryIndexes.sql" ../R2007/R2007-09-05/updateLibraryIndexes.sql
executeWithTempFile "../R2007/R2007-09-05/changes-20070904170412.sql" ../R2007/R2007-09-05/changes-20070904170412.sql
executeWithTempFile "../R2007/R2007-09-11/cleanupDegreeInfoTable.sql" ../R2007/R2007-09-11/cleanupDegreeInfoTable.sql
executeWithTempFile "../R2007/R2007-09-11/updateLibraryCardFunctionalities.sql" ../R2007/R2007-09-11/updateLibraryCardFunctionalities.sql
executeWithTempFile "../R2007/R2007-09-11/updateLibraryCardTable.sql" ../R2007/R2007-09-11/updateLibraryCardTable.sql
executeWithTempFile "../R2007/R2007-09-11/createElectionAndVoteTables.sql" ../R2007/R2007-09-11/createElectionAndVoteTables.sql
executeWithTempFile "../R2007/R2007-09-11/alterAccountabilityTable.sql" ../R2007/R2007-09-11/alterAccountabilityTable.sql
executeWithTempFile "../R2007/R2007-09-12/alterAcademicServiceRequest.sql" ../R2007/R2007-09-12/alterAcademicServiceRequest.sql
executeWithTempFile "../R2007/R2007-09-12/alterTableCandidacy.sql" ../R2007/R2007-09-12/alterTableCandidacy.sql
executeWithTempFile "../R2007/R2007-09-12/alterTableEvent.sql" ../R2007/R2007-09-12/alterTableEvent.sql
executeWithTempFile "../R2007/R2007-09-12/alterTablePostingRule.sql" ../R2007/R2007-09-12/alterTablePostingRule.sql
executeWithTempFile "../R2007/R2007-09-12/alterTableRegistration.sql" ../R2007/R2007-09-12/alterTableRegistration.sql
executeWithTempFile "../R2007/R2007-09-12/updatePermissions.sql" ../R2007/R2007-09-12/updatePermissions.sql
executeWithTempFile "../R2007/R2007-09-12/updateAccountabilityTypes.sql" ../R2007/R2007-09-12/updateAccountabilityTypes.sql
executeWithTempFile "../R2007/R2007-09-12/updateResearchContracts.sql" ../R2007/R2007-09-12/updateResearchContracts.sql
executeWithTempFile "../R2007/R2007-09-17/removeDissertationsAP.sql" ../R2007/R2007-09-17/removeDissertationsAP.sql
executeWithTempFile "../R2007/R2007-09-17/alterTableLibraryCard.sql" ../R2007/R2007-09-17/alterTableLibraryCard.sql
executeWithTempFile "../R2007/R2007-09-19/newDissertationsAP.sql" ../R2007/R2007-09-19/newDissertationsAP.sql
executeWithTempFile "../R2007/R2007-09-24/addAnalyticsToUnitSite.sql" ../R2007/R2007-09-24/addAnalyticsToUnitSite.sql
executeWithTempFile "../R2007/R2007-09-24/correctUnitFile.sql" ../R2007/R2007-09-24/correctUnitFile.sql
executeWithTempFile "../R2007/R2007-09-24/updateLibraryPortalMenu.sql" ../R2007/R2007-09-24/updateLibraryPortalMenu.sql
executeWithTempFile "../R2007/R2007-09-28/clean.sql" ../R2007/R2007-09-28/clean.sql
executeWithTempFile "../R2007/R2007-09-28/alterTableShift.sql" ../R2007/R2007-09-28/alterTableShift.sql
executeWithTempFile "../R2007/R2007-10-01/changesToBolonhaFunctionalities.20070927.sql" ../R2007/R2007-10-01/changesToBolonhaFunctionalities.20070927.sql
executeWithTempFile "../R2007/R2007-10-01/createTableParkingRequestPeriod.sql" ../R2007/R2007-10-01/createTableParkingRequestPeriod.sql
executeWithTempFile "../R2007/R2007-10-01/changeCompetenceCourseInformationChangeRequests.sql" ../R2007/R2007-10-01/changeCompetenceCourseInformationChangeRequests.sql
executeWithTempFile "../R2007/R2007-10-03/alterRegistrationTable.sql" ../R2007/R2007-10-03/alterRegistrationTable.sql
executeWithTempFile "../R2007/R2007-10-04/alterTableLibraryCard.sql" ../R2007/R2007-10-04/alterTableLibraryCard.sql
executeWithTempFile "../R2007/R2007-10-10/changes-20071010180558.sql" ../R2007/R2007-10-10/changes-20071010180558.sql
executeWithTempFile "../R2007/R2007-10-10/createTemplateForScientificAreas.sql" ../R2007/R2007-10-10/createTemplateForScientificAreas.sql
executeWithTempFile "../R2007/R2007-10-11/updateAccountabilityType.sql" ../R2007/R2007-10-11/updateAccountabilityType.sql
executeWithTempFile "../R2007/R2007-10-15/alterTableClosedMonthJustification.sql" ../R2007/R2007-10-15/alterTableClosedMonthJustification.sql
executeWithTempFile "../R2007/R2007-10-16/changes-20071011184610.sql" ../R2007/R2007-10-16/changes-20071011184610.sql
executeWithTempFile "../R2007/R2007-10-16/removeOldContributorFromReceipts.sql" ../R2007/R2007-10-16/removeOldContributorFromReceipts.sql
executeWithTempFile "../R2007/R2007-10-18/alterTableAcademicCalendarEntry.sql" ../R2007/R2007-10-18/alterTableAcademicCalendarEntry.sql
executeWithTempFile "../R2007/R2007-10-18/renameDegreesManagementFunctionalityNames.sql" ../R2007/R2007-10-18/renameDegreesManagementFunctionalityNames.sql
executeWithTempFile "../R2007/R2007-10-22/alterTableAcademicCalendarEntry.sql" ../R2007/R2007-10-22/alterTableAcademicCalendarEntry.sql
executeWithTempFile "../R2007/R2007-10-22/dropUnnecessaryDegreeColumns.sql" ../R2007/R2007-10-22/dropUnnecessaryDegreeColumns.sql
executeWithTempFile "../R2007/R2007-10-22/changes-20071018120101.sql" ../R2007/R2007-10-22/changes-20071018120101.sql
executeWithTempFile "../R2007/R2007-10-22/addedResourceInternationRelationOfficeRole.sql" ../R2007/R2007-10-22/addedResourceInternationRelationOfficeRole.sql
executeWithTempFile "../R2007/R2007-11-02/changes-20071102135504.sql" ../R2007/R2007-11-02/changes-20071102135504.sql
executeWithTempFile "../R2007/R2007-11-02/deleteLEECEnrolmentEquivalenceTables.sql" ../R2007/R2007-11-02/deleteLEECEnrolmentEquivalenceTables.sql
executeWithTempFile "../R2007/R2007-11-05/alterAcademicServiceRequestTable.sql" ../R2007/R2007-11-05/alterAcademicServiceRequestTable.sql
executeWithTempFile "../R2007/R2007-11-08/alterDelegateElectionTable.sql" ../R2007/R2007-11-08/alterDelegateElectionTable.sql
executeWithTempFile "../R2007/R2007-11-08/alterAcademicServiceRequestSituationTable.sql" ../R2007/R2007-11-08/alterAcademicServiceRequestSituationTable.sql
executeWithTempFile "../R2007/R2007-11-08/alterTableAccountability.sql" ../R2007/R2007-11-08/alterTableAccountability.sql
executeWithTempFile "../R2007/R2007-11-09/updateAcademicServiceRequestSituation.sql" ../R2007/R2007-11-09/updateAcademicServiceRequestSituation.sql
executeWithTempFile "../R2007/R2007-11-12/addNewAcademicIntervalSlots1.sql" ../R2007/R2007-11-12/addNewAcademicIntervalSlots1.sql
executeWithTempFile "../R2007/R2007-11-12/addNewAcademicIntervalSlots2.sql" ../R2007/R2007-11-12/addNewAcademicIntervalSlots2.sql
executeWithTempFile "../R2007/R2007-11-12/addNewAcademicIntervalSlots3.sql" ../R2007/R2007-11-12/addNewAcademicIntervalSlots3.sql
executeWithTempFile "../R2007/R2007-11-12/addNewAcademicIntervalSlots4.sql" ../R2007/R2007-11-12/addNewAcademicIntervalSlots4.sql
executeWithTempFile "../R2007/R2007-11-12/alterRoleTable.sql" ../R2007/R2007-11-12/alterRoleTable.sql
executeWithTempFile "../R2007/R2007-11-12/alterRoleTable2.sql" ../R2007/R2007-11-12/alterRoleTable2.sql
executeWithTempFile "../R2007/R2007-11-12/alterTableExecutionPeriodAddEntryPhase.sql" ../R2007/R2007-11-12/alterTableExecutionPeriodAddEntryPhase.sql
executeWithTempFile "../R2007/R2007-11-12/rollBackPeriods.sql" ../R2007/R2007-11-12/rollBackPeriods.sql
executeWithTempFile "../R2007/R2007-11-12/alterAcademicServiceRequest.sql" ../R2007/R2007-11-12/alterAcademicServiceRequest.sql
executeWithTempFile "../R2007/R2007-11-14/changes-20071113151117.sql" ../R2007/R2007-11-14/changes-20071113151117.sql
executeWithTempFile "../R2007/R2007-11-15/alterTableTeacherServiceItem.sql" ../R2007/R2007-11-15/alterTableTeacherServiceItem.sql
executeWithTempFile "../R2007/R2007-11-15/cleanOldParkingDocuments.sql" ../R2007/R2007-11-15/cleanOldParkingDocuments.sql
executeWithTempFile "../R2007/R2007-11-15/changes-20071115121117.sql" ../R2007/R2007-11-15/changes-20071115121117.sql
executeWithTempFile "../R2007/R2007-11-15/alterTableAcademicCalendarEntry.sql" ../R2007/R2007-11-15/alterTableAcademicCalendarEntry.sql
executeWithTempFile "../R2007/R2007-11-20/alterTableAcademicServiceRequest.sql" ../R2007/R2007-11-20/alterTableAcademicServiceRequest.sql
executeWithTempFile "../R2007/R2007-11-21/alterTableEnrolmentWrapper.sql" ../R2007/R2007-11-21/alterTableEnrolmentWrapper.sql
executeWithTempFile "../R2007/R2007-11-21/migrateEnrolmentWrapperData.sql" ../R2007/R2007-11-21/migrateEnrolmentWrapperData.sql
executeWithTempFile "../R2007/R2007-11-21/alterExecutionPeriodTable.sql" ../R2007/R2007-11-21/alterExecutionPeriodTable.sql
executeWithTempFile "../R2007/R2007-11-21/alterAcademicCalendarEntryTable.sql" ../R2007/R2007-11-21/alterAcademicCalendarEntryTable.sql
executeWithTempFile "../R2007/R2007-11-21/alterExecutionPeriodTable2.sql" ../R2007/R2007-11-21/alterExecutionPeriodTable2.sql
executeWithTempFile "../R2007/R2007-11-21/alterExecutionPeriodAndYearTables.sql" ../R2007/R2007-11-21/alterExecutionPeriodAndYearTables.sql
executeWithTempFile "../R2007/R2007-11-21/AlterTableEvent.sql" ../R2007/R2007-11-21/AlterTableEvent.sql
executeWithTempFile "../R2007/R2007-11-22/createAcademicPeriodTable.sql" ../R2007/R2007-11-22/createAcademicPeriodTable.sql
executeWithTempFile "../R2007/R2007-11-22/alterTableAcademicCalendarEntry.sql" ../R2007/R2007-11-22/alterTableAcademicCalendarEntry.sql
executeWithTempFile "../R2007/R2007-11-23/alterTableEnrolmentWrapper2.sql" ../R2007/R2007-11-23/alterTableEnrolmentWrapper2.sql
executeWithTempFile "../R2007/R2007-11-26/cardGeneration.sql" ../R2007/R2007-11-26/cardGeneration.sql
executeWithTempFile "../R2007/R2007-11-26/changes-20071126180446.sql" ../R2007/R2007-11-26/changes-20071126180446.sql
executeWithTempFile "../R2007/R2007-11-27/alterResourceAllocationTable.sql" ../R2007/R2007-11-27/alterResourceAllocationTable.sql
executeWithTempFile "../R2007/R2007-11-29/updates.sql" ../R2007/R2007-11-29/updates.sql
executeWithTempFile "../R2007/R2007-11-29/alterExecutionDegreeTable.sql" ../R2007/R2007-11-29/alterExecutionDegreeTable.sql
executeWithTempFile "../R2007/R2007-12-03/deleteOldAssiduousnessTables.sql" ../R2007/R2007-12-03/deleteOldAssiduousnessTables.sql
executeWithTempFile "../R2007/R2007-12-03/alterTableCurriculumModule.sql" ../R2007/R2007-12-03/alterTableCurriculumModule.sql
executeWithTempFile "../R2007/R2007-12-03/alterTableRegistration.sql" ../R2007/R2007-12-03/alterTableRegistration.sql
executeWithTempFile "../R2007/R2007-12-04/alterAcademicPeriodTable.sql" ../R2007/R2007-12-04/alterAcademicPeriodTable.sql
executeWithTempFile "../R2007/R2007-12-04/changes-20071203165336.sql" ../R2007/R2007-12-04/changes-20071203165336.sql
executeWithTempFile "../R2007/R2007-12-05/createTableClosedMonthDocument.sql" ../R2007/R2007-12-05/createTableClosedMonthDocument.sql
executeWithTempFile "../R2007/R2007-12-07/createProtocolResponsibleFunction.sql" ../R2007/R2007-12-07/createProtocolResponsibleFunction.sql
executeWithTempFile "../R2007/R2007-12-12/updatePersonnelSectionPortalName.sql" ../R2007/R2007-12-12/updatePersonnelSectionPortalName.sql
executeWithTempFile "../R2007/R2007-12-21/updateBolonhaFunctionalities.sql" ../R2007/R2007-12-21/updateBolonhaFunctionalities.sql
executeWithTempFile "../R2007/R2007-12-21/addConclusionProcessResponsibleColumns.sql" ../R2007/R2007-12-21/addConclusionProcessResponsibleColumns.sql
executeWithTempFile "../R2007/R2007-12-28/deleteConversationMessageByTeacherRequest.sql" ../R2007/R2007-12-28/deleteConversationMessageByTeacherRequest.sql
# ISCTE
execute "AlterClosedYearMonthColumnType.sql" AlterClosedYearMonthColumnType.sql
executeWithTempFile "../R2008/R2008-01-03/alterTableClosedMonth.sql" ../R2008/R2008-01-03/alterTableClosedMonth.sql
executeWithTempFile "../R2008/R2008-01-04/alterTableDistributedTest.sql" ../R2008/R2008-01-04/alterTableDistributedTest.sql
executeWithTempFile "../R2008/R2008-01-08/insertCountry.sql" ../R2008/R2008-01-08/insertCountry.sql
executeWithTempFile "../R2008/R2008-01-08/alterTableAssiduousnessClosedMonth.sql" ../R2008/R2008-01-08/alterTableAssiduousnessClosedMonth.sql
executeWithTempFile "../R2008/R2008-01-10/alterTableLibraryCard.sql" ../R2008/R2008-01-10/alterTableLibraryCard.sql
executeWithTempFile "../R2008/R2008-01-14/fixScientificAreaSiteConcreteClass.sql" ../R2008/R2008-01-14/fixScientificAreaSiteConcreteClass.sql
executeWithTempFile "../R2008/R2008-01-14/createContentAndNodeTable.sql" ../R2008/R2008-01-14/createContentAndNodeTable.sql
executeWithTempFile "../R2008/R2008-01-14/prepareContentsForItemsAndSections.sql" ../R2008/R2008-01-14/prepareContentsForItemsAndSections.sql
executeWithTempFile "../R2008/R2008-01-14/updates.sql" ../R2008/R2008-01-14/updates.sql
executeWithTempFile "ChangeTableForum.sql" ChangeTableForum.sql
executeWithTempFile "../R2008/R2008-01-14/prepareForum.sql" ../R2008/R2008-01-14/prepareForum.sql
executeWithTempFile "../R2008/R2008-01-14/prepareConversationThread.sql" ../R2008/R2008-01-14/prepareConversationThread.sql
executeWithTempFile "../R2008/R2008-01-14/prepareConversationMessage.sql" ../R2008/R2008-01-14/prepareConversationMessage.sql
executeWithTempFile "../R2008/R2008-01-14/prepareContents.sql" ../R2008/R2008-01-14/prepareContents.sql
executeWithTempFile "../R2008/R2008-01-14/prepareNode.sql" ../R2008/R2008-01-14/prepareNode.sql
executeWithTempFile "../R2008/R2008-01-14/migrateForuns.sql" ../R2008/R2008-01-14/migrateForuns.sql
executeWithTempFile "../R2008/R2008-01-14/mergeFunctionalityInContent.sql" ../R2008/R2008-01-14/mergeFunctionalityInContent.sql
executeWithTempFile "../R2008/R2008-01-14/createFunctionalityParameter.sql" ../R2008/R2008-01-14/createFunctionalityParameter.sql
executeWithTempFile "../R2008/R2008-01-14/connectRootModule.sql" ../R2008/R2008-01-14/connectRootModule.sql
executeWithTempFile "../R2008/R2008-01-14/createPortal.sql" ../R2008/R2008-01-14/createPortal.sql
executeWithTempFile "../R2008/R2008-01-14/connectRootPortal.sql" ../R2008/R2008-01-14/connectRootPortal.sql
# ISCTE
executeWithTempFile "../R2007/R2007-04-13/addShowParticipationsToSite.sql" ../R2007/R2007-04-13/addShowParticipationsToSite.sql
executeWithTempFile "../R2008/R2008-01-14/migrateSites.sql" ../R2008/R2008-01-14/migrateSites.sql
executeWithTempFile "../R2008/R2008-01-14/migrateSectionsAndItems.sql" ../R2008/R2008-01-14/migrateSectionsAndItems.sql
executeWithTempFile "../R2008/R2008-01-14/moveTempSectionsToSections.sql" ../R2008/R2008-01-14/moveTempSectionsToSections.sql
executeWithTempFile "../R2008/R2008-01-14/createExecutionPathTable.sql" ../R2008/R2008-01-14/createExecutionPathTable.sql
executeWithTempFile "../R2008/R2008-01-14/copyModuleStructure.sql" ../R2008/R2008-01-14/copyModuleStructure.sql
execute "../R2008/R2008-01-14/createMissingModules.sql" ../R2008/R2008-01-14/createMissingModules.sql
executeWithTempFile "../R2008/R2008-01-14/metaDomainObject.sql" ../R2008/R2008-01-14/metaDomainObject.sql
executeWithTempFile "../R2008/R2008-01-14/addMetaDomainObject3.sql" ../R2008/R2008-01-14/addMetaDomainObject3.sql
executeWithTempFile "../R2008/R2008-01-14/updateMissingInformationInSites.sql" ../R2008/R2008-01-14/updateMissingInformationInSites.sql
executeWithTempFile "../R2008/R2008-01-14/createMetaDomainObjectsFromSiteTemplates.sql" ../R2008/R2008-01-14/createMetaDomainObjectsFromSiteTemplates.sql
executeWithTempFile "../R2008/R2008-01-14/updateRole.sql" ../R2008/R2008-01-14/updateRole.sql
executeWithTempFile "../R2008/R2008-01-14/migrateTopSections.sql" ../R2008/R2008-01-14/migrateTopSections.sql
executeWithTempFile "../R2008/R2008-01-14/createKeysForPool.sql" ../R2008/R2008-01-14/createKeysForPool.sql
executeWithTempFile "../R2008/R2008-01-14/createPools.sql" ../R2008/R2008-01-14/createPools.sql
execute "../R2008/R2008-01-14/initPortals.sql" ../R2008/R2008-01-14/initPortals.sql
execute "../R2008/R2008-01-14/initiateOldPortals.sql" ../R2008/R2008-01-14/initiateOldPortals.sql
executeWithTempFile "../R2008/R2008-01-14/namePortals.sql" ../R2008/R2008-01-14/namePortals.sql
executeWithTempFile "../R2008/R2008-01-14/addContentId.sql" ../R2008/R2008-01-14/addContentId.sql
executeWithTempFile "../R2008/R2008-01-14/addAttachment.sql" ../R2008/R2008-01-14/addAttachment.sql
executeWithTempFile "../R2008/R2008-01-14/addAttachment2.sql" ../R2008/R2008-01-14/addAttachment2.sql
executeWithTempFile "../R2008/R2008-01-14/addAttachment3.sql" ../R2008/R2008-01-14/addAttachment3.sql
executeWithTempFile "../R2008/R2008-01-14/connectExecutionCourseForumToExecutionCourseSite.sql" ../R2008/R2008-01-14/connectExecutionCourseForumToExecutionCourseSite.sql
executeWithTempFile "../R2008/R2008-01-14/removeAvailabilityPolicyFromHomepagePortal.sql" ../R2008/R2008-01-14/removeAvailabilityPolicyFromHomepagePortal.sql
executeWithTempFile "../R2008/R2008-01-14/fixAnnouncementsWRitersGroups.sql" ../R2008/R2008-01-14/fixAnnouncementsWRitersGroups.sql
executeWithTempFile "../R2008/R2008-01-14/newTSDTableDefinitions.sql" ../R2008/R2008-01-14/newTSDTableDefinitions.sql
executeWithTempFile "../R2008/R2008-01-14/createUnitAcronym.sql" ../R2008/R2008-01-14/createUnitAcronym.sql
executeWithTempFile "../R2008/R2008-01-14/generateMissingPresentationFunctionalities.sql" ../R2008/R2008-01-14/generateMissingPresentationFunctionalities.sql
execute "../R2008/R2008-01-14/migrateFunctionalitiesInSites.sql" ../R2008/R2008-01-14/migrateFunctionalitiesInSites.sql
execute "../R2008/R2008-01-14/generateTemplatePortalsStructure.sql" ../R2008/R2008-01-14/generateTemplatePortalsStructure.sql
executeWithTempFile "../R2008/R2008-01-14/initializePools.sql" ../R2008/R2008-01-14/initializePools.sql
executeWithTempFile "../R2008/R2008-01-14/fixAssiduinessPolicies.sql" ../R2008/R2008-01-14/fixAssiduinessPolicies.sql
executeWithTempFile "../R2008/R2008-01-14/fixAmpsInExecutionPaths.sql" ../R2008/R2008-01-14/fixAmpsInExecutionPaths.sql
executeWithTempFile "../R2008/R2008-01-14/createTreasuryInitialPage.sql" ../R2008/R2008-01-14/createTreasuryInitialPage.sql
executeWithTempFile "../R2008/R2008-01-14/populateExecutionPathTable.sql" ../R2008/R2008-01-14/populateExecutionPathTable.sql
executeWithTempFile "../R2008/R2008-01-14/removeSlashFromContentNames.sql" ../R2008/R2008-01-14/removeSlashFromContentNames.sql
executeWithTempFile "../R2008/R2008-01-14/fixManagerMenu.sql" ../R2008/R2008-01-14/fixManagerMenu.sql
executeWithTempFile "../R2008/R2008-01-14/fixDeparments.sql" ../R2008/R2008-01-14/fixDeparments.sql
executeWithTempFile "../R2008/R2008-01-14/addMissingIndexes.sql" ../R2008/R2008-01-14/addMissingIndexes.sql
executeWithTempFile "../R2008/R2008-01-16/addConclusionProcessNotes.sql" ../R2008/R2008-01-16/addConclusionProcessNotes.sql
executeWithTempFile "../R2008/R2008-01-16/fixAmpInPersonnelSection.sql" ../R2008/R2008-01-16/fixAmpInPersonnelSection.sql
executeWithTempFile "../R2008/R2008-01-17/alterTableContent.sql" ../R2008/R2008-01-17/alterTableContent.sql
executeWithTempFile "../R2008/R2008-01-17/createInternationalRelatOffice.sql" ../R2008/R2008-01-17/createInternationalRelatOffice.sql
executeWithTempFile "../R2008/R2008-01-17/alterTableAcademicServiceRequest.sql" ../R2008/R2008-01-17/alterTableAcademicServiceRequest.sql
executeWithTempFile "../R2008/R2008-01-17/createCourseLoadEnrolments.sql" ../R2008/R2008-01-17/createCourseLoadEnrolments.sql
executeWithTempFile "../R2008/R2008-01-17/AddExamCertificateRequestEnrolmentTable.sql" ../R2008/R2008-01-17/AddExamCertificateRequestEnrolmentTable.sql
executeWithTempFile "../R2008/R2008-01-17/updateExecutionCoursesSiglas.sql" ../R2008/R2008-01-17/updateExecutionCoursesSiglas.sql
executeWithTempFile "updateExecutionCoursesSiglas.sql" updateExecutionCoursesSiglas.sql
executeWithTempFile "AddKeyExecutionPeriodToAcademicServiceRequest.sql" AddKeyExecutionPeriodToAcademicServiceRequest.sql
executeWithTempFile "resolveProblemWithContentNames.sql" resolveProblemWithContentNames.sql

# ISCTE
execute "AddMissingCreationEntityColumnsToTables.sql" AddMissingCreationEntityColumnsToTables.sql

executeWithTempFile "../R2007/R2007-04-13/alterTableParty2.sql" ../R2007/R2007-04-13/alterTableParty2.sql

execute "Remove overlaping versions from inquiries scripts" removeVersionsInFenixVersionTable.sql

execute "Deleting data having errors in the nodes (the problem has not been fixed, though!)" deleteErrorDataInNodes.sql