#!/bin/sh # ----------------------------------------------------------------------------- # # Runs sql scripts to update database from previous release. # # ----------------------------------------------------------------------------- # DB=$1 USER=$2 DB_HOST=$3 INSTITUTION=ipt echo Using host=$DB_HOST echo Using database: $DB echo Using user $USER: echo Institution: $INSTITUTION # Linkare - Added to read the password read -s password function execute() { if [ -z $3 ] then echo $1 mysql -u$USER -p$password -f -h$DB_HOST --default-character-set=latin1 $DB < $2 echo else if [ "$INSTITUTION" == "$3" ] then echo $1 mysql -u$USER -p$password -f -h$DB_HOST --default-character-set=latin1 $DB < $2 echo fi fi } function executeWithTempFile() { echo $1 mysql -u$USER -p$password -f -h$DB_HOST --default-character-set=latin1 $DB < $2 > tmp.sql mysql -u$USER -p$password -f -h$DB_HOST --default-character-set=latin1 $DB < tmp.sql rm tmp.sql echo } # Linkare - Added to change the type of data in the table FENIX_VERSION_INSTALLER. execute "AlterTableFenixVersionInstaller.sql" AlterTableFenixVersionInstaller.sql # Linkare - Added to fix the external instituition unit that was being pointed from in the Root Domain Object table execute "fixExternalInstitutionUnitPointerInRootDomainObject.sql" fixExternalInstitutionUnitPointerInRootDomainObject.sql # Linkare - Added to fix persons without nationality (make Portugal be the default) execute "setDefaultCountryPortugalForNationalities.sql" setDefaultCountryPortugalForNationalities.sql # Linkare - Added to change the column KEY_ROOT_DOMAIN_OBJECT in all tables so they all have the default value 1. execute "changeDefaultValueForRootDomainObjectInAllTables.sql" changeDefaultValueForRootDomainObjectInAllTables.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 # Linkare - Fixed SQL original final and used the fixed one in the local folder executeWithTempFile "alterResourceAllocationTable.sql" 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 # Linkare - Fixed SQL original final and used the fixed one in the local folder executeWithTempFile "createTemplates.sql" 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-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 # Linkare - Fixed SQL original final and used the fixed one in the local folder executeWithTempFile "cleanup-2007-08-26.sql" cleanup-2007-08-26.sql # Linkare - Fixed SQL original final and used the fixed one in the local folder executeWithTempFile "updates-2007-08-28.sql" updates-2007-08-28.sql # Linkare - Removed replication of file. File in day 29 is the same in 28. #executeWithTempFile "../R2007/R2007-08-29/updates.sql" ../R2007/R2007-08-29/updates.sql # Linkare - Fixed SQL original final and used the fixed one in the local folder executeWithTempFile "removeTimeStamps.sql" 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 # Linkare - Fixed SQL original final and used the fixed one in the local folder executeWithTempFile "removeContractTableAndExecutionCourseHours.sql" 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 # Linkare - Fixed SQL original final and used the fixed one in the local folder executeWithTempFile "cleanupDegreeInfoTable.sql" 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 # Linkare - This file was not included in the original run file from IST. It was included here manually... executeWithTempFile "../R2007/R2007-09-11/updatesToLibraryPortal.sql" ../R2007/R2007-09-11/updatesToLibraryPortal.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 # Linkare - This file was not included in the original run file from IST. It was included here manually... executeWithTempFile "../R2007/R2007-09-26/addDissertationsToDepartment.sql" ../R2007/R2007-09-26/addDissertationsToDepartment.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 # Linkare - Fixed SQL original final and used the fixed one in the local folder executeWithTempFile "deleteOldAssiduousnessTables.sql" 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 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 # Linkare - Fixed SQL original final and used the fixed one in the local folder executeWithTempFile "prepareForum.sql" 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 # Linkare - Changed to execute insteaf of executeWithTempFile execute "../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 # Linkare - Changed to execute insteaf of executeWithTempFile 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 # Linkare - Changed to execute insteaf of executeWithTempFile execute "../R2008/R2008-01-14/initPortals.sql" ../R2008/R2008-01-14/initPortals.sql # Linkare - Changed to execute insteaf of executeWithTempFile 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 # Linkare - Fixed SQL original final and used the fixed one in the local folder (it changes the size of the ACRONYM column to 200). executeWithTempFile "createUnitAcronym.sql" createUnitAcronym.sql executeWithTempFile "../R2008/R2008-01-14/generateMissingPresentationFunctionalities.sql" ../R2008/R2008-01-14/generateMissingPresentationFunctionalities.sql # Linkare - Changed to execute insteaf of executeWithTempFile execute "../R2008/R2008-01-14/migrateFunctionalitiesInSites.sql" ../R2008/R2008-01-14/migrateFunctionalitiesInSites.sql # Linkare - Changed to execute insteaf of executeWithTempFile execute "../R2008/R2008-01-14/generateTemplatePortalsStructure.sql" ../R2008/R2008-01-14/generateTemplatePortalsStructure.sql # Linkare - Changed to execute insteaf of executeWithTempFile execute "../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 # Linkare - Changed to execute insteaf of executeWithTempFile execute "../R2008/R2008-01-14/fixDeparments.sql" ../R2008/R2008-01-14/fixDeparments.sql # Linkare - Changed to execute insteaf of executeWithTempFile execute "../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 "../R2008/R2008-01-22/updateExecutionCoursesSiglas.sql" ../R2008/R2008-01-22/updateExecutionCoursesSiglas.sql executeWithTempFile "../R2008/R2008-01-22/AddKeyExecutionPeriodToAcademicServiceRequest.sql" ../R2008/R2008-01-22/AddKeyExecutionPeriodToAcademicServiceRequest.sql executeWithTempFile "../R2008/R2008-01-22/resolveProblemWithContentNames.sql" ../R2008/R2008-01-22/resolveProblemWithContentNames.sql executeWithTempFile "../R2008/R2008-01-22/fixAvailabilityPoliciesUUID.sql" ../R2008/R2008-01-22/fixAvailabilityPoliciesUUID.sql executeWithTempFile "../R2008/R2008-01-22/hardcoreFixOnAcademicServiceRequestData.sql" ../R2008/R2008-01-22/hardcoreFixOnAcademicServiceRequestData.sql executeWithTempFile "../R2008/R2008-01-23/updateCountry.sql" ../R2008/R2008-01-23/updateCountry.sql executeWithTempFile "../R2008/R2008-01-24/AlterTableAcademicServiceRequest.sql" ../R2008/R2008-01-24/AlterTableAcademicServiceRequest.sql # Linkare - Fixed SQL original final and used the fixed one in the local folder executeWithTempFile "alterCategoryTable.sql" alterCategoryTable.sql # Linkare - Fixed SQL original final and used the fixed one in the local folder executeWithTempFile "addServiceRequestYearToAcademicServiceRequest.sql" addServiceRequestYearToAcademicServiceRequest.sql executeWithTempFile "../R2008/R2008-01-24/addTinyintsToAcademicServiceRequest.sql" ../R2008/R2008-01-24/addTinyintsToAcademicServiceRequest.sql executeWithTempFile "../R2008/R2008-01-25/alterTableParkingParty.sql" ../R2008/R2008-01-25/alterTableParkingParty.sql # Linkare - Changed to execute insteaf of executeWithTempFile execute "../R2008/R2008-01-25/migrateTutorUnit.sql" ../R2008/R2008-01-25/migrateTutorUnit.sql executeWithTempFile "../R2008/R2008-01-25/alterTableProfessionalSituation.sql" ../R2008/R2008-01-25/alterTableProfessionalSituation.sql executeWithTempFile "../R2008/R2008-02-01/createFindSpacesFunctionality.sql" ../R2008/R2008-02-01/createFindSpacesFunctionality.sql executeWithTempFile "../R2008/R2008-02-06/alterTableExecutionPath.sql" ../R2008/R2008-02-06/alterTableExecutionPath.sql executeWithTempFile "../R2008/R2008-02-06/identificationCardStuff.sql" ../R2008/R2008-02-06/identificationCardStuff.sql executeWithTempFile "../R2008/R2008-02-06/addPastAmountOnEventTable.sql" ../R2008/R2008-02-06/addPastAmountOnEventTable.sql executeWithTempFile "../R2008/R2008-02-06/changeServiceRequestYearOnAcademicServiceRequestTable.sql" ../R2008/R2008-02-06/changeServiceRequestYearOnAcademicServiceRequestTable.sql executeWithTempFile "../R2008/R2008-02-07/createProgramCertificateRequestTable.sql" ../R2008/R2008-02-07/createProgramCertificateRequestTable.sql executeWithTempFile "../R2008/R2008-02-07/removeDuplicatedNodes.sql" ../R2008/R2008-02-07/removeDuplicatedNodes.sql executeWithTempFile "../R2008/R2008-02-19/changeCompetenceCourseInformationChangeRequests.sql" ../R2008/R2008-02-19/changeCompetenceCourseInformationChangeRequests.sql executeWithTempFile "../R2008/R2008-02-21/createEnrolmentLogsMenu.sql" ../R2008/R2008-02-21/createEnrolmentLogsMenu.sql executeWithTempFile "../R2008/R2008-02-26/fixCompetenceCourseInformationBibliograficReferences.sql" ../R2008/R2008-02-26/fixCompetenceCourseInformationBibliograficReferences.sql executeWithTempFile "../R2008/R2008-02-27/addAssiduousnessFunctionality.sql" ../R2008/R2008-02-27/addAssiduousnessFunctionality.sql executeWithTempFile "../R2008/R2008-02-27/changeAssiduousnessFuncionalities.sql" ../R2008/R2008-02-27/changeAssiduousnessFuncionalities.sql # Linkare - Fixed SQL original final and used the fixed one in the local folder executeWithTempFile "alterTableAssiduousnessClosedMonth-2008-02-27.sql" alterTableAssiduousnessClosedMonth-2008-02-27.sql executeWithTempFile "../R2008/R2008-02-29/AddTableExamDateCertificateRequestExam.sql" ../R2008/R2008-02-29/AddTableExamDateCertificateRequestExam.sql # Linkare - Changed to execute insteaf of executeWithTempFile execute "../R2008/R2008-03-03/setupStudentsSite.sql" ../R2008/R2008-03-03/setupStudentsSite.sql executeWithTempFile "../R2008/R2008-03-03/ViewStudentsSiteFunctionality.sql" ../R2008/R2008-03-03/ViewStudentsSiteFunctionality.sql executeWithTempFile "../R2008/R2008-03-06/AlterTableAcademicServiceRequest.sql" ../R2008/R2008-03-06/AlterTableAcademicServiceRequest.sql executeWithTempFile "../R2008/R2008-03-06/AlterTableAcademicServiceRequestSituation.sql" ../R2008/R2008-03-06/AlterTableAcademicServiceRequestSituation.sql executeWithTempFile "../R2008/R2008-03-06/dataFix.sql" ../R2008/R2008-03-06/dataFix.sql executeWithTempFile "../R2008/R2008-03-06/AlterTableEvent.sql" ../R2008/R2008-03-06/AlterTableEvent.sql executeWithTempFile "../R2008/R2008-03-06/AlterTablePostingRule.sql" ../R2008/R2008-03-06/AlterTablePostingRule.sql executeWithTempFile "../R2008/R2008-03-07/alterTableContentAddAnnouncementBoardApprovers.sql" ../R2008/R2008-03-07/alterTableContentAddAnnouncementBoardApprovers.sql executeWithTempFile "../R2008/R2008-03-07/setApproversGroup.sql" ../R2008/R2008-03-07/setApproversGroup.sql executeWithTempFile "../R2008/R2008-03-11/alterTableThesis.sql" ../R2008/R2008-03-11/alterTableThesis.sql # Linkare - This file was not included in the original run file from IST. It was included here manually... executeWithTempFile "../R2008/R2008-03-11/addDismissedPointsForTeacher.sql" ../R2008/R2008-03-11/addDismissedPointsForTeacher.sql # Linkare - This file was not included in the original run file from IST. It was included here manually... executeWithTempFile "../R2008/R2008-03-11/updateTSD.sql" ../R2008/R2008-03-11/updateTSD.sql executeWithTempFile "../R2008/R2008-03-12/updateTSD.sql" ../R2008/R2008-03-12/updateTSD.sql executeWithTempFile "../R2008/R2008-03-13/alterTableEvaluationAddCreationDate.sql" ../R2008/R2008-03-13/alterTableEvaluationAddCreationDate.sql executeWithTempFile "../R2008/R2008-03-13/addKeyRootDomainObjectToTSDCurricularLoad.sql" ../R2008/R2008-03-13/addKeyRootDomainObjectToTSDCurricularLoad.sql executeWithTempFile "../R2008/R2008-03-13/correctCertificateRequestsConcreteClass.sql" ../R2008/R2008-03-13/correctCertificateRequestsConcreteClass.sql executeWithTempFile "../R2008/R2008-03-17/fixBrokenData.sql" ../R2008/R2008-03-17/fixBrokenData.sql executeWithTempFile "../R2008/R2008-03-17/deployNotifier.sql" ../R2008/R2008-03-17/deployNotifier.sql executeWithTempFile "../R2008/R2008-03-20/createNewFunctionalityViewCourseTeachers.sql" ../R2008/R2008-03-20/createNewFunctionalityViewCourseTeachers.sql executeWithTempFile "../R2008/R2008-03-20/createNewFunctionalityViewCourseTeachers2.sql" ../R2008/R2008-03-20/createNewFunctionalityViewCourseTeachers2.sql executeWithTempFile "../R2008/R2008-03-20/updates.sql" ../R2008/R2008-03-20/updates.sql executeWithTempFile "../R2008/R2008-03-31/createCardIdentificationFunctionalityStuff.sql" ../R2008/R2008-03-31/createCardIdentificationFunctionalityStuff.sql executeWithTempFile "../R2008/R2008-03-31/createCardIdentificationFunctionalityStuff2.sql" ../R2008/R2008-03-31/createCardIdentificationFunctionalityStuff2.sql executeWithTempFile "../R2008/R2008-04-02/createRequestLoggingTables.sql" ../R2008/R2008-04-02/createRequestLoggingTables.sql executeWithTempFile "../R2008/R2008-04-08/addRefererToRequestMapping.sql" ../R2008/R2008-04-08/addRefererToRequestMapping.sql executeWithTempFile "../R2008/R2008-04-08/addEmailPrefixToConvokeEmails.sql" ../R2008/R2008-04-08/addEmailPrefixToConvokeEmails.sql executeWithTempFile "../R2008/R2008-04-08/alterTablePaymentPlan.sql" ../R2008/R2008-04-08/alterTablePaymentPlan.sql executeWithTempFile "../R2008/R2008-04-08/alterTableExemption.sql" ../R2008/R2008-04-08/alterTableExemption.sql # Linkare - Fixed SQL original final and used the fixed one in the local folder executeWithTempFile "fixTablesInDatabase.sql" fixTablesInDatabase.sql executeWithTempFile "../R2008/R2008-04-13/alterProposalTable.sql" ../R2008/R2008-04-13/alterProposalTable.sql executeWithTempFile "../R2008/R2008-04-16/AlterTableAcademicServiceRequest.sql" ../R2008/R2008-04-16/AlterTableAcademicServiceRequest.sql executeWithTempFile "../R2008/R2008-04-16/AlterTableAcademicServiceRequestSituation.sql" ../R2008/R2008-04-16/AlterTableAcademicServiceRequestSituation.sql executeWithTempFile "../R2008/R2008-04-21/createProcessTables.sql" ../R2008/R2008-04-21/createProcessTables.sql executeWithTempFile "../R2008/R2008-04-22/removeManageSitesFunctionality.sql" ../R2008/R2008-04-22/removeManageSitesFunctionality.sql executeWithTempFile "../R2008/R2008-04-22/fixNodeContentId.sql" ../R2008/R2008-04-22/fixNodeContentId.sql executeWithTempFile "../R2008/R2008-04-22/createFunctionalityCalls.sql" ../R2008/R2008-04-22/createFunctionalityCalls.sql executeWithTempFile "../R2008/R2008-04-22/alterInitialContents.sql" ../R2008/R2008-04-22/alterInitialContents.sql executeWithTempFile "../R2008/R2008-04-22/AlterTableAcademicServiceRequest.sql" ../R2008/R2008-04-22/AlterTableAcademicServiceRequest.sql executeWithTempFile "../R2008/R2008-04-22/clearOJBids.sql" ../R2008/R2008-04-22/clearOJBids.sql executeWithTempFile "../R2008/R2008-04-23/AlterTableAcademicServiceRequest.sql" ../R2008/R2008-04-23/AlterTableAcademicServiceRequest.sql executeWithTempFile "../R2008/R2008-04-23/alterTableJustificationMotive.sql" ../R2008/R2008-04-23/alterTableJustificationMotive.sql executeWithTempFile "../R2008/R2008-04-23/alterTableAssiduousnessClosedMonth.sql" ../R2008/R2008-04-23/alterTableAssiduousnessClosedMonth.sql executeWithTempFile "../R2008/R2008-04-29/modifyFileItemKeyToFile.sql" ../R2008/R2008-04-29/modifyFileItemKeyToFile.sql executeWithTempFile "../R2008/R2008-04-29/AlterTableTransaction.sql" ../R2008/R2008-04-29/AlterTableTransaction.sql executeWithTempFile "../R2008/R2008-04-29/AlterTableGratuitySituation.sql" ../R2008/R2008-04-29/AlterTableGratuitySituation.sql executeWithTempFile "../R2008/R2008-04-29/AlterTableSibsPaymentFileEntry.sql" ../R2008/R2008-04-29/AlterTableSibsPaymentFileEntry.sql executeWithTempFile "../R2008/R2008-04-29/AlterTableGratuityValues.sql" ../R2008/R2008-04-29/AlterTableGratuityValues.sql executeWithTempFile "../R2008/R2008-04-29/alterTableVigilantGroup.sql" ../R2008/R2008-04-29/alterTableVigilantGroup.sql executeWithTempFile "../R2008/R2008-04-29/alterTableUnavailablePeriod.sql" ../R2008/R2008-04-29/alterTableUnavailablePeriod.sql executeWithTempFile "../R2008/R2008-04-29/alterTableDeployNotifier.sql" ../R2008/R2008-04-29/alterTableDeployNotifier.sql executeWithTempFile "../R2008/R2008-04-29/createCandidacyTables.sql" ../R2008/R2008-04-29/createCandidacyTables.sql executeWithTempFile "../R2008/R2008-04-29/alterCandidacyTables.sql" ../R2008/R2008-04-29/alterCandidacyTables.sql executeWithTempFile "../R2008/R2008-05-03/addSearchInterfaceToIdentificationCardsPortal.sql" ../R2008/R2008-05-03/addSearchInterfaceToIdentificationCardsPortal.sql executeWithTempFile "../R2008/R2008-05-05/updates.sql" ../R2008/R2008-05-05/updates.sql executeWithTempFile "../R2008/R2008-05-06/createPublicRelationsOffice.sql" ../R2008/R2008-05-06/createPublicRelationsOffice.sql executeWithTempFile "../R2008/R2008-05-06/alterCandidacyTables.sql" ../R2008/R2008-05-06/alterCandidacyTables.sql executeWithTempFile "../R2008/R2008-05-07/modified-mappings.sql" ../R2008/R2008-05-07/modified-mappings.sql executeWithTempFile "../R2008/R2008-05-08/updates.sql" ../R2008/R2008-05-08/updates.sql executeWithTempFile "../R2008/R2008-05-09/FixPartySocialSecurityNumber.sql" ../R2008/R2008-05-09/FixPartySocialSecurityNumber.sql executeWithTempFile "../R2008/R2008-05-09/updateJustificationMotive.sql" ../R2008/R2008-05-09/updateJustificationMotive.sql executeWithTempFile "../R2008/R2008-05-13/createDegreeContextTable.sql" ../R2008/R2008-05-13/createDegreeContextTable.sql executeWithTempFile "../R2008/R2008-05-13/editPermissionsForInstitutionBoards.sql" ../R2008/R2008-05-13/editPermissionsForInstitutionBoards.sql executeWithTempFile "../R2008/R2008-05-13/addAssiduousnessStatusFunctionality.sql" ../R2008/R2008-05-13/addAssiduousnessStatusFunctionality.sql executeWithTempFile "../R2008/R2008-05-13/addExportVacationsFunctionality.sql" ../R2008/R2008-05-13/addExportVacationsFunctionality.sql executeWithTempFile "../R2008/R2008-05-13/alterTableAssiduousnessVacations.sql" ../R2008/R2008-05-13/alterTableAssiduousnessVacations.sql executeWithTempFile "../R2008/R2008-05-13/alterTableAssiduousnessClosedMonth.sql" ../R2008/R2008-05-13/alterTableAssiduousnessClosedMonth.sql executeWithTempFile "../R2008/R2008-05-13/createTableAssiduousnessExemption.sql" ../R2008/R2008-05-13/createTableAssiduousnessExemption.sql executeWithTempFile "../R2008/R2008-05-13/alterTableAnualBonusInstallment.sql" ../R2008/R2008-05-13/alterTableAnualBonusInstallment.sql executeWithTempFile "../R2008/R2008-05-13/addAssiduousnessExemptionsFunctionality.sql" ../R2008/R2008-05-13/addAssiduousnessExemptionsFunctionality.sql executeWithTempFile "../R2008/R2008-05-13/addVacationsFunctionalities.sql" ../R2008/R2008-05-13/addVacationsFunctionalities.sql executeWithTempFile "../R2008/R2008-05-13/updates.sql" ../R2008/R2008-05-13/updates.sql executeWithTempFile "../R2008/R2008-05-15/executionPeriodRefactoring.sql" ../R2008/R2008-05-15/executionPeriodRefactoring.sql executeWithTempFile "../R2008/R2008-05-15/alterTimestamps.sql" ../R2008/R2008-05-15/alterTimestamps.sql executeWithTempFile "../R2008/R2008-05-15/changeSendEmailPath.sql" ../R2008/R2008-05-15/changeSendEmailPath.sql executeWithTempFile "../R2008/R2008-05-20/dataFix.sql" ../R2008/R2008-05-20/dataFix.sql executeWithTempFile "../R2008/R2008-05-20/alterTableParty.sql" ../R2008/R2008-05-20/alterTableParty.sql executeWithTempFile "../R2008/R2008-05-26/updateWeightInOldLMACEnrolment.sql" ../R2008/R2008-05-26/updateWeightInOldLMACEnrolment.sql executeWithTempFile "../R2008/R2008-05-26/updateRegistrationConclusionProcess.sql" ../R2008/R2008-05-26/updateRegistrationConclusionProcess.sql # Linkare - Fixed SQL original final and used the fixed one in the local folder executeWithTempFile "migrateIngressionAndEntryPhaseToRegistration.sql" migrateIngressionAndEntryPhaseToRegistration.sql executeWithTempFile "../R2008/R2008-05-28/changeCurricularPeriodTypeToAcademicPeriod.sql" ../R2008/R2008-05-28/changeCurricularPeriodTypeToAcademicPeriod.sql executeWithTempFile "../R2008/R2008-05-28/AlterTableJustificationMotive.sql" ../R2008/R2008-05-28/AlterTableJustificationMotive.sql executeWithTempFile "../R2008/R2008-05-28/createPublicRelationsFeatures.sql" ../R2008/R2008-05-28/createPublicRelationsFeatures.sql executeWithTempFile "../R2008/R2008-05-30/AlterTableStudentTestLog.sql" ../R2008/R2008-05-30/AlterTableStudentTestLog.sql executeWithTempFile "../R2008/R2008-05-30/CreateTableTestChecksum.sql" ../R2008/R2008-05-30/CreateTableTestChecksum.sql executeWithTempFile "../R2008/R2008-06-03/changeCompetenceCourseInformationChangeRequests.sql" ../R2008/R2008-06-03/changeCompetenceCourseInformationChangeRequests.sql executeWithTempFile "../R2008/R2008-06-03/removeSentSMSTable.sql" ../R2008/R2008-06-03/removeSentSMSTable.sql executeWithTempFile "../R2008/R2008-06-03/createResearcherTable.sql" ../R2008/R2008-06-03/createResearcherTable.sql executeWithTempFile "../R2008/R2008-06-05/removeOldPublicationsTables.sql" ../R2008/R2008-06-05/removeOldPublicationsTables.sql executeWithTempFile "../R2008/R2008-06-09/ConvertContactVisibility.sql" ../R2008/R2008-06-09/ConvertContactVisibility.sql executeWithTempFile "../R2008/R2008-06-12/changeColumnNameInTSD.sql" ../R2008/R2008-06-12/changeColumnNameInTSD.sql executeWithTempFile "../R2008/R2008-06-12/createAcademicServiceRequestYear.sql" ../R2008/R2008-06-12/createAcademicServiceRequestYear.sql executeWithTempFile "../R2008/R2008-06-17/AlterTableReceipt.sql" ../R2008/R2008-06-17/AlterTableReceipt.sql executeWithTempFile "../R2008/R2008-06-17/dataFixTransaction.sql" ../R2008/R2008-06-17/dataFixTransaction.sql executeWithTempFile "../R2008/R2008-06-17/AlterAccountingTransaction.sql" ../R2008/R2008-06-17/AlterAccountingTransaction.sql executeWithTempFile "../R2008/R2008-06-17/RemoveTreasuryPaymentsFunctionalities.sql" ../R2008/R2008-06-17/RemoveTreasuryPaymentsFunctionalities.sql executeWithTempFile "../R2008/R2008-06-17/alterPartyContact.sql" ../R2008/R2008-06-17/alterPartyContact.sql executeWithTempFile "../R2008/R2008-06-17/fixResearcherData.sql" ../R2008/R2008-06-17/fixResearcherData.sql executeWithTempFile "../R2008/R2008-06-17/updateWeightInOldEnrolments.sql" ../R2008/R2008-06-17/updateWeightInOldEnrolments.sql executeWithTempFile "../R2008/R2008-06-20/InsertCountry.sql" ../R2008/R2008-06-20/InsertCountry.sql executeWithTempFile "../R2008/R2008-06-20/removeDegreeAdminOfficeContents.sql" ../R2008/R2008-06-20/removeDegreeAdminOfficeContents.sql executeWithTempFile "../R2008/R2008-06-20/alterTableRegistration.sql" ../R2008/R2008-06-20/alterTableRegistration.sql executeWithTempFile "../R2008/R2008-06-20/updateWeightInOldEnrolments.sql" ../R2008/R2008-06-20/updateWeightInOldEnrolments.sql executeWithTempFile "../R2008/R2008-06-23/alterInquiriesTables.sql" ../R2008/R2008-06-23/alterInquiriesTables.sql executeWithTempFile "../R2008/R2008-06-26/alterTablePostingRules.sql" ../R2008/R2008-06-26/alterTablePostingRules.sql # Linkare - Missing script which is specific of IST. Not supposed to run in our database. # executeWithTempFile "../R2008/R2008-07-01/updateWeightInOldEnrolments.sql" ../R2008/R2008-07-01/updateWeightInOldEnrolments.sql # Linkare - Missing script which is specific of IST. Not supposed to run in our database. # executeWithTempFile "../R2008/R2008-07-01/dataFix.sql" ../R2008/R2008-07-01/dataFix.sql executeWithTempFile "../R2008/R2008-07-04/deleteInvalidWebAddresses.sql" ../R2008/R2008-07-04/deleteInvalidWebAddresses.sql executeWithTempFile "../R2008/R2008-07-04/initializeResidencePortal.sql" ../R2008/R2008-07-04/initializeResidencePortal.sql executeWithTempFile "../R2008/R2008-07-04/residencePortalAvailabilityPolicySetup.sql" ../R2008/R2008-07-04/residencePortalAvailabilityPolicySetup.sql executeWithTempFile "../R2008/R2008-07-04/alterSpecialSeasonCodeTable.sql" ../R2008/R2008-07-04/alterSpecialSeasonCodeTable.sql executeWithTempFile "../R2008/R2008-07-08/fixAcademicServiceRequestDates.sql" ../R2008/R2008-07-08/fixAcademicServiceRequestDates.sql executeWithTempFile "../R2008/R2008-07-08/importDataFunctionalityInResidenceManagement.sql" ../R2008/R2008-07-08/importDataFunctionalityInResidenceManagement.sql executeWithTempFile "../R2008/R2008-07-08/createResidenceDomain.sql" ../R2008/R2008-07-08/createResidenceDomain.sql # Linkare - Missing script which is specific of IST. Not supposed to run in our database. # executeWithTempFile "../R2008/R2008-07-08/modifySpecificUnitType.sql" ../R2008/R2008-07-08/modifySpecificUnitType.sql executeWithTempFile "../R2008/R2008-07-09/fixResidenceYearTable.sql" ../R2008/R2008-07-09/fixResidenceYearTable.sql executeWithTempFile "../R2008/R2008-07-09/alterTableExtraWorkRequest.sql" ../R2008/R2008-07-09/alterTableExtraWorkRequest.sql executeWithTempFile "../R2008/R2008-07-09/alterTableAssiduousnessExtraWork.sql" ../R2008/R2008-07-09/alterTableAssiduousnessExtraWork.sql executeWithTempFile "../R2008/R2008-07-09/addPaymentLimitDayToResidenceMonth.sql" ../R2008/R2008-07-09/addPaymentLimitDayToResidenceMonth.sql executeWithTempFile "../R2008/R2008-07-10/addEventManagementMenuItem.sql" ../R2008/R2008-07-10/addEventManagementMenuItem.sql executeWithTempFile "../R2008/R2008-07-10/alterTablePostingRule.sql" ../R2008/R2008-07-10/alterTablePostingRule.sql executeWithTempFile "../R2008/R2008-07-10/alterTableAcademicServiceRequest.sql" ../R2008/R2008-07-10/alterTableAcademicServiceRequest.sql # Linkare - This file was not included in the original run file from IST. It was included here manually... executeWithTempFile "../R2008/R2008-07-10/updatePostingRulesInformation.sql" ../R2008/R2008-07-10/updatePostingRulesInformation.sql executeWithTempFile "../R2008/R2008-07-15/alterTableAcademicServiceRequest.sql" ../R2008/R2008-07-15/alterTableAcademicServiceRequest.sql executeWithTempFile "../R2008/R2008-07-15/alterCandidacyPrecedentDegreeInformation.sql" ../R2008/R2008-07-15/alterCandidacyPrecedentDegreeInformation.sql executeWithTempFile "../R2008/R2008-07-16/alterTableExemptionJustification.sql" ../R2008/R2008-07-16/alterTableExemptionJustification.sql executeWithTempFile "../R2008/R2008-07-16/updatePostingRuleConcreteClass.sql" ../R2008/R2008-07-16/updatePostingRuleConcreteClass.sql executeWithTempFile "../R2008/R2008-07-17/alterResidenceYearAndMonth.sql" ../R2008/R2008-07-17/alterResidenceYearAndMonth.sql executeWithTempFile "../R2008/R2008-07-17/changeContactVisibilitySettings.sql" ../R2008/R2008-07-17/changeContactVisibilitySettings.sql # Linkare - Missing script which is specific of IST. Not supposed to run in our database. # executeWithTempFile "../R2008/R2008-07-17/updateCountryName.sql" ../R2008/R2008-07-17/updateCountryName.sql executeWithTempFile "../R2008/R2008-07-22/createAlumniTables.sql" ../R2008/R2008-07-22/createAlumniTables.sql executeWithTempFile "../R2008/R2008-07-22/alterTableStudent.sql" ../R2008/R2008-07-22/alterTableStudent.sql executeWithTempFile "../R2008/R2008-07-22/alterTableQualification.sql" ../R2008/R2008-07-22/alterTableQualification.sql executeWithTempFile "../R2008/R2008-07-22/alterTableParty.sql" ../R2008/R2008-07-22/alterTableParty.sql executeWithTempFile "../R2008/R2008-07-22/createTableJob.sql" ../R2008/R2008-07-22/createTableJob.sql executeWithTempFile "../R2008/R2008-07-22/createTableSupportRequest.sql" ../R2008/R2008-07-22/createTableSupportRequest.sql executeWithTempFile "../R2008/R2008-07-22/intercepted.sql" ../R2008/R2008-07-22/intercepted.sql executeWithTempFile "../R2008/R2008-07-22/removeImportDataFunctionality.sql" ../R2008/R2008-07-22/removeImportDataFunctionality.sql executeWithTempFile "../R2008/R2008-07-22/alterTableIndividualCandidacy.sql" ../R2008/R2008-07-22/alterTableIndividualCandidacy.sql executeWithTempFile "../R2008/R2008-07-22/addResidenceAmountToReport.sql" ../R2008/R2008-07-22/addResidenceAmountToReport.sql executeWithTempFile "../R2008/R2008-07-22/alterInquiriesTables.sql" ../R2008/R2008-07-22/alterInquiriesTables.sql # Linkare - Missing script which is specific of IST. Not supposed to run in our database. # executeWithTempFile "../R2008/R2008-07-22/dataFix.sql" ../R2008/R2008-07-22/dataFix.sql executeWithTempFile "../R2008/R2008-07-23/alterDoublesFromIndividualCandidacy.sql" ../R2008/R2008-07-23/alterDoublesFromIndividualCandidacy.sql executeWithTempFile "../R2008/R2008-07-23/alterInquiriesTables.sql" ../R2008/R2008-07-23/alterInquiriesTables.sql # Linkare - Missing script which is specific of IST. Not supposed to run in our database. # executeWithTempFile "../R2008/R2008-07-24/fixConcreteClassForCycleCurricumGroups.sql" ../R2008/R2008-07-24/fixConcreteClassForCycleCurricumGroups.sql executeWithTempFile "../R2008/R2008-07-29/createTableThesisLibraryOperation.sql" ../R2008/R2008-07-29/createTableThesisLibraryOperation.sql executeWithTempFile "../R2008/R2008-07-29/migrateDegreeNameToDegreeInfo.sql" ../R2008/R2008-07-29/migrateDegreeNameToDegreeInfo.sql # Linkare - Missing script which is specific of IST. Not supposed to run in our database. # executeWithTempFile "../R2008/R2008-07-29/dataFix.sql" ../R2008/R2008-07-29/dataFix.sql # Linkare - Missing script which is specific of IST. Not supposed to run in our database. # executeWithTempFile "../R2008/R2008-07-29/fixDegreeInfos.sql" ../R2008/R2008-07-29/fixDegreeInfos.sql # Linkare - Missing script which is specific of IST. Not supposed to run in our database. # executeWithTempFile "../R2008/R2008-07-30/updateWeightInEnrolment.sql" ../R2008/R2008-07-30/updateWeightInEnrolment.sql # Linkare - This file was not included in the original run file from IST. It was included here manually... executeWithTempFile "../R2008/R2008-07-30/alterTableErrorLog.sql" ../R2008/R2008-07-30/alterTableErrorLog.sql executeWithTempFile "../R2008/R2008-08-01/createResidecePriceTable.sql" ../R2008/R2008-08-01/createResidecePriceTable.sql # Linkare - Missing script which is specific of IST. Not supposed to run in our database. # executeWithTempFile "../R2008/R2008-08-01/specificResidencePriceTableSetup.sql" ../R2008/R2008-08-01/specificResidencePriceTableSetup.sql executeWithTempFile "../R2008/R2008-08-06/libraryFunctionalitiesModification.sql" ../R2008/R2008-08-06/libraryFunctionalitiesModification.sql executeWithTempFile "../R2008/R2008-08-07/alterTableCurricularRule.sql" ../R2008/R2008-08-07/alterTableCurricularRule.sql executeWithTempFile "../R2008/R2008-08-12/interceptedExtraWork.sql" ../R2008/R2008-08-12/interceptedExtraWork.sql # Linkare - Missing script which is specific of IST. Not supposed to run in our database. # executeWithTempFile "../R2008/R2008-08-13/libraryPermissions.sql" ../R2008/R2008-08-13/libraryPermissions.sql executeWithTempFile "../R2008/R2008-08-17/alterInquiriesTables.sql" ../R2008/R2008-08-17/alterInquiriesTables.sql executeWithTempFile "../R2008/R2008-08-17/addRaidesColumns.sql" ../R2008/R2008-08-17/addRaidesColumns.sql executeWithTempFile "../R2008/R2008-08-17/SetDefaultCountry.sql" ../R2008/R2008-08-17/SetDefaultCountry.sql executeWithTempFile "../R2008/R2008-08-17/updates.sql" ../R2008/R2008-08-17/updates.sql executeWithTempFile "../R2008/R2008-08-19/createRegistrationRegimeTable.sql" ../R2008/R2008-08-19/createRegistrationRegimeTable.sql executeWithTempFile "../R2008/R2008-08-19/alterInquiryRegistryTable.sql" ../R2008/R2008-08-19/alterInquiryRegistryTable.sql executeWithTempFile "../R2008/R2008-08-27/photographTable.sql" ../R2008/R2008-08-27/photographTable.sql # Linkare - Missing script which is specific of IST. Not supposed to run in our database. # executeWithTempFile "../R2008/R2008-08-27/InsertCountry.sql" ../R2008/R2008-08-27/InsertCountry.sql executeWithTempFile "../R2008/R2008-08-28/alterInquiriesCourseTable.sql" ../R2008/R2008-08-28/alterInquiriesCourseTable.sql executeWithTempFile "../R2008/R2008-08-29/updates.sql" ../R2008/R2008-08-29/updates.sql executeWithTempFile "../R2008/R2008-09-05/generatedDocuments.sql" ../R2008/R2008-09-05/generatedDocuments.sql executeWithTempFile "../R2008/R2008-09-05/cleanUpThesisLibrary.sql" ../R2008/R2008-09-05/cleanUpThesisLibrary.sql executeWithTempFile "../R2008/R2008-09-08/updates.sql" ../R2008/R2008-09-08/updates.sql executeWithTempFile "../R2008/R2008-09-08/InsertForeignDistrict.sql" ../R2008/R2008-09-08/InsertForeignDistrict.sql # Linkare - Fixed SQL original final and used the fixed one in the local folder executeWithTempFile "AlterTableDistrict.sql" AlterTableDistrict.sql executeWithTempFile "../R2008/R2008-09-08/CreateTableDistrictSubdivision.sql" ../R2008/R2008-09-08/CreateTableDistrictSubdivision.sql executeWithTempFile "../R2008/R2008-09-08/UpdateDistrictCodes.sql" ../R2008/R2008-09-08/UpdateDistrictCodes.sql # Linkare - Missing script which is specific of IST. Not supposed to run in our database. # executeWithTempFile "../R2008/R2008-09-08/updateWeightInOldEnrolments.sql" ../R2008/R2008-09-08/updateWeightInOldEnrolments.sql # Linkare - Missing script which is specific of IST. Not supposed to run in our database. # executeWithTempFile "../R2008/R2008-09-08/InsertCountry.sql" ../R2008/R2008-09-08/InsertCountry.sql # Linkare - This file was not included in the original run file from IST. It was included here manually... executeWithTempFile "../R2008/R2008-09-08/AlterTableAcademicServiceRequest.sql" ../R2008/R2008-09-08/AlterTableAcademicServiceRequest.sql executeWithTempFile "../R2008/R2008-09-09/fixCountryDataSetDefaultColumn.sql" ../R2008/R2008-09-09/fixCountryDataSetDefaultColumn.sql executeWithTempFile "../R2008/R2008-09-09/updates.sql" ../R2008/R2008-09-09/updates.sql executeWithTempFile "../R2008/R2008-09-11/AlterTableCountry.sql" ../R2008/R2008-09-11/AlterTableCountry.sql executeWithTempFile "../R2008/R2008-09-11/AlterTableCandidacy.sql" ../R2008/R2008-09-11/AlterTableCandidacy.sql executeWithTempFile "../R2008/R2008-09-11/alterTableEnrolmentLog.sql" ../R2008/R2008-09-11/alterTableEnrolmentLog.sql executeWithTempFile "../R2008/R2008-09-11/updateEnrolmentLogInformation.sql" ../R2008/R2008-09-11/updateEnrolmentLogInformation.sql executeWithTempFile "../R2008/R2008-09-11/alterTableCountry2.sql" ../R2008/R2008-09-11/alterTableCountry2.sql # Linkare - Missing script which is specific of IST. Not supposed to run in our database. # executeWithTempFile "../R2008/R2008-09-11/AlterDegreeCodes.sql" ../R2008/R2008-09-11/AlterDegreeCodes.sql # Linkare - Fixed SQL original final and used the fixed one in the local folder executeWithTempFile "AlterTableCandidacy-2008-09-12.sql" AlterTableCandidacy-2008-09-12.sql executeWithTempFile "../R2008/R2008-09-12/updatePostingRuleOJBConcClassValues.sql" ../R2008/R2008-09-12/updatePostingRuleOJBConcClassValues.sql # Linkare - Missing script which is specific of IST. Not supposed to run in our database. # executeWithTempFile "../R2008/R2008-09-17/updateDegreeEcts.sql" ../R2008/R2008-09-17/updateDegreeEcts.sql executeWithTempFile "../R2008/R2008-09-23/thesisSite.sql" ../R2008/R2008-09-23/thesisSite.sql executeWithTempFile "../R2008/R2008-09-23/thesisSitePortal.sql" ../R2008/R2008-09-23/thesisSitePortal.sql executeWithTempFile "../R2008/R2008-09-25/updateAlumniIdentityCheckRequest.sql" ../R2008/R2008-09-25/updateAlumniIdentityCheckRequest.sql executeWithTempFile "../R2008/R2008-09-25/addOJBColumnsToDegreeAndDCP.sql" ../R2008/R2008-09-25/addOJBColumnsToDegreeAndDCP.sql executeWithTempFile "../R2008/R2008-09-25/insertEmptyDegreeAndDCP.sql" ../R2008/R2008-09-25/insertEmptyDegreeAndDCP.sql executeWithTempFile "../R2008/R2008-09-25/residenceUnitHack.sql" ../R2008/R2008-09-25/residenceUnitHack.sql # Linkare - Missing script which is specific of IST. Not supposed to run in our database. # executeWithTempFile "../R2008/R2008-09-25/updateWeightInOldEnrolments.sql" ../R2008/R2008-09-25/updateWeightInOldEnrolments.sql # Linkare - Missing script which is specific of IST. Not supposed to run in our database. # executeWithTempFile "../R2008/R2008-09-25/dataFix.sql" ../R2008/R2008-09-25/dataFix.sql executeWithTempFile "../R2008/R2008-09-29/deleteDanglingPhotos.sql" ../R2008/R2008-09-29/deleteDanglingPhotos.sql executeWithTempFile "../R2008/R2008-09-30/changeParkingTables.sql" ../R2008/R2008-09-30/changeParkingTables.sql executeWithTempFile "../R2008/R2008-10-03/generatedDocumentsPortal.sql" ../R2008/R2008-10-03/generatedDocumentsPortal.sql executeWithTempFile "../R2008/R2008-10-03/photoHistoryPortal.sql" ../R2008/R2008-10-03/photoHistoryPortal.sql executeWithTempFile "../R2008/R2008-10-03/photoRejector.sql" ../R2008/R2008-10-03/photoRejector.sql executeWithTempFile "../R2008/R2008-10-07/updates.sql" ../R2008/R2008-10-07/updates.sql executeWithTempFile "../R2008/R2008-10-07/alterTableEnrolmentLog.sql" ../R2008/R2008-10-07/alterTableEnrolmentLog.sql # Linkare - This file was not included in the original run file from IST. It was included here manually... executeWithTempFile "../R2008/R2008-10-07/setEmptyDegreeDegreeType.sql" ../R2008/R2008-10-07/setEmptyDegreeDegreeType.sql # Linkare - Missing script which is specific of IST. Not supposed to run in our database. # executeWithTempFile "../R2008/R2008-10-07/updateCountryData.sql" ../R2008/R2008-10-07/updateCountryData.sql executeWithTempFile "../R2008/R2008-10-08/deleteDanglingPhotos.sql" ../R2008/R2008-10-08/deleteDanglingPhotos.sql executeWithTempFile "../R2008/R2008-10-12/UpdateWrongEventTypeAndEntryType.sql" ../R2008/R2008-10-12/UpdateWrongEventTypeAndEntryType.sql executeWithTempFile "../R2008/R2008-10-12/AlterTablePostingRule.sql" ../R2008/R2008-10-12/AlterTablePostingRule.sql executeWithTempFile "../R2008/R2008-10-12/AlterTableInstallment.sql" ../R2008/R2008-10-12/AlterTableInstallment.sql executeWithTempFile "../R2008/R2008-10-12/CreateTablePartialRegimeInstallmentExecutionSemester.sql" ../R2008/R2008-10-12/CreateTablePartialRegimeInstallmentExecutionSemester.sql executeWithTempFile "../R2008/R2008-10-12/UpdateRegistrationRegime.sql" ../R2008/R2008-10-12/UpdateRegistrationRegime.sql executeWithTempFile "../R2008/R2008-10-13/alterWrittenEvaluation.sql" ../R2008/R2008-10-13/alterWrittenEvaluation.sql executeWithTempFile "../R2008/R2008-10-14/vigilancyDataFix.sql" ../R2008/R2008-10-14/vigilancyDataFix.sql executeWithTempFile "../R2008/R2008-10-17/yetAnotherVigilancyFix.sql" ../R2008/R2008-10-17/yetAnotherVigilancyFix.sql executeWithTempFile "../R2008/R2008-10-21/resetNames.sql" ../R2008/R2008-10-21/resetNames.sql executeWithTempFile "../R2008/R2008-10-23/updates14102008.sql" ../R2008/R2008-10-23/updates14102008.sql executeWithTempFile "../R2008/R2008-10-24/updateCandidacyPeriodExecutionInterval.sql" ../R2008/R2008-10-24/updateCandidacyPeriodExecutionInterval.sql executeWithTempFile "../R2008/R2008-10-28/alterTableAcademicServiceRequestAddLanguage.sql" ../R2008/R2008-10-28/alterTableAcademicServiceRequestAddLanguage.sql executeWithTempFile "../R2008/R2008-10-28/alterTablePartyContact.sql" ../R2008/R2008-10-28/alterTablePartyContact.sql # Linkare - It was not included initially. Therefore, it has been included in another R-LINKARE folder # executeWithTempFile "../R2008/R2008-10-29/alterDegreeModuleChangeGraduateSuffixToMultiLanguageString.sql" ../R2008/R2008-10-29/alterDegreeModuleChangeGraduateSuffixToMultiLanguageString.sql # Linkare - It was not included initially. Therefore, it has been included in another R-LINKARE folder # executeWithTempFile "../R2008/R2008-10-29/alterCountryAlterNationalityToMultiLanguageString.sql" ../R2008/R2008-10-29/alterCountryAlterNationalityToMultiLanguageString.sql executeWithTempFile "../R2008/R2008-10-30/addOJBConcreteClassToMarkSheet.sql" ../R2008/R2008-10-30/addOJBConcreteClassToMarkSheet.sql executeWithTempFile "../R2008/R2008-10-30/teachingInquiryTables.sql" ../R2008/R2008-10-30/teachingInquiryTables.sql executeWithTempFile "../R2008/R2008-10-30/updates.sql" ../R2008/R2008-10-30/updates.sql executeWithTempFile "../R2008/R2008-10-31/updates.sql" ../R2008/R2008-10-31/updates.sql executeWithTempFile "../R2008/R2008-11-03/alterTableAcademicServiceRequestAddNumberOfUnits.sql" ../R2008/R2008-11-03/alterTableAcademicServiceRequestAddNumberOfUnits.sql executeWithTempFile "../R2008/R2008-11-03/updates.sql" ../R2008/R2008-11-03/updates.sql executeWithTempFile "../R2008/R2008-11-05/teachingInquiriesChanges.sql" ../R2008/R2008-11-05/teachingInquiriesChanges.sql # Linkare - Missing script which is specific of IST. Not supposed to run in our database. # executeWithTempFile "../R2008/R2008-11-05/correctOnlineTests.sql" ../R2008/R2008-11-05/correctOnlineTests.sql executeWithTempFile "../R2008/R2008-11-06/inquiriesResults.sql" ../R2008/R2008-11-06/inquiriesResults.sql # Linkare - Missing script which is specific of IST. Not supposed to run in our database. # executeWithTempFile "../R2008/R2008-11-06/dataFix" ../R2008/R2008-11-06/dataFix.sql executeWithTempFile "../R2008/R2008-11-09/alterTableAcademicServiceRequestAddIgnoreExternalEntries.sql" ../R2008/R2008-11-09/alterTableAcademicServiceRequestAddIgnoreExternalEntries.sql executeWithTempFile "../R2008/R2008-11-09/intercepted.sql" ../R2008/R2008-11-09/intercepted.sql executeWithTempFile "../R2008/R2008-11-09/internshipCandidacy.sql" ../R2008/R2008-11-09/internshipCandidacy.sql executeWithTempFile "../R2008/R2008-11-12/alterTeachingInquiries.sql" ../R2008/R2008-11-12/alterTeachingInquiries.sql executeWithTempFile "../R2008/R2008-11-12/internshipCandidacyDate.sql" ../R2008/R2008-11-12/internshipCandidacyDate.sql executeWithTempFile "../R2008/R2008-11-12/AlterTableExemptionJustification.sql" ../R2008/R2008-11-12/AlterTableExemptionJustification.sql executeWithTempFile "../R2008/R2008-11-14/alterTeachingInquiries.sql" ../R2008/R2008-11-14/alterTeachingInquiries.sql executeWithTempFile "../R2008/R2008-11-14/intercepted.sql" ../R2008/R2008-11-14/intercepted.sql executeWithTempFile "../R2008/R2008-11-14/updates.sql" ../R2008/R2008-11-14/updates.sql executeWithTempFile "../R2008/R2008-11-14/alterTableJob.sql" ../R2008/R2008-11-14/alterTableJob.sql executeWithTempFile "../R2008/R2008-11-21/alterTableAlumni.sql" ../R2008/R2008-11-21/alterTableAlumni.sql executeWithTempFile "../R2008/R2008-11-28/addValidToStudentGroup.sql" ../R2008/R2008-11-28/addValidToStudentGroup.sql executeWithTempFile "../R2008/R2008-11-28/createPaymentCodeMappingTable.sql" ../R2008/R2008-11-28/createPaymentCodeMappingTable.sql executeWithTempFile "../R2008/R2008-11-28/paymentsFunctionality.sql" ../R2008/R2008-11-28/paymentsFunctionality.sql executeWithTempFile "../R2008/R2008-11-28/createAccountingDiscountTable.sql" ../R2008/R2008-11-28/createAccountingDiscountTable.sql executeWithTempFile "../R2008/R2008-12-02/addItProjectManagerRole.sql" ../R2008/R2008-12-02/addItProjectManagerRole.sql executeWithTempFile "../R2008/R2008-12-02/addItProjectManagerFunctionalities.sql" ../R2008/R2008-12-02/addItProjectManagerFunctionalities.sql # Linkare - Fixed SQL original final and used the fixed one in the local folder executeWithTempFile "addNewLanguageToCountryNationality.sql" addNewLanguageToCountryNationality.sql executeWithTempFile "../R2008/R2008-12-04/createConclusionProcessTableAndRelations.sql" ../R2008/R2008-12-04/createConclusionProcessTableAndRelations.sql executeWithTempFile "../R2008/R2008-12-04/dataFix.sql" ../R2008/R2008-12-04/dataFix.sql executeWithTempFile "../R2008/R2008-12-05/alterConclusionProcessTable.sql" ../R2008/R2008-12-05/alterConclusionProcessTable.sql executeWithTempFile "../R2008/R2008-12-05/initConclusionProcessLastVersionRelation.sql" ../R2008/R2008-12-05/initConclusionProcessLastVersionRelation.sql executeWithTempFile "../R2008/R2008-12-09/alterExtraWorkTables.sql" ../R2008/R2008-12-09/alterExtraWorkTables.sql # Linkare - Fixed SQL original final and used the fixed one in the local folder executeWithTempFile "alterTableAlumniIdentityCheckRequest.sql" alterTableAlumniIdentityCheckRequest.sql # Linkare - Missing script which is specific of IST. Not supposed to run in our database. # executeWithTempFile "../R2008/R2008-12-12/dataFix.sql" ../R2008/R2008-12-12/dataFix.sql executeWithTempFile "../R2008/R2008-12-15/assiduousnessStatusFunctionalities.sql" ../R2008/R2008-12-15/assiduousnessStatusFunctionalities.sql executeWithTempFile "../R2008/R2008-12-15/fixConclusionProcessLastVersionRelation.sql" ../R2008/R2008-12-15/fixConclusionProcessLastVersionRelation.sql # Linkare - Missing script which is specific of IST. Not supposed to run in our database. # executeWithTempFile "../R2008/R2008-12-17/correctOnlineTestMarks.sql" ../R2008/R2008-12-17/correctOnlineTestMarks.sql # Linkare - Missing script which is specific of IST. Not supposed to run in our database. # executeWithTempFile "../R2008/R2008-12-30/dataFix.sql" ../R2008/R2008-12-30/dataFix.sql executeWithTempFile "../R2009/R2009-01-05/tutorship.role.sql" ../R2009/R2009-01-05/tutorship.role.sql executeWithTempFile "../R2009/R2009-01-05/tutorship.access.sql" ../R2009/R2009-01-05/tutorship.access.sql executeWithTempFile "../R2009/R2009-01-10/AlterTableFile.sql" ../R2009/R2009-01-10/AlterTableFile.sql executeWithTempFile "../R2009/R2009-01-10/defaultAcademicCalendar.sql" ../R2009/R2009-01-10/defaultAcademicCalendar.sql # Linkare - Missing script which is specific of IST. Not supposed to run in our database. # executeWithTempFile "../R2009/R2009-01-15/createISTAssemblySite.sql" ../R2009/R2009-01-15/createISTAssemblySite.sql executeWithTempFile "../R2009/R2009-01-16/createDelegateTables.sql" ../R2009/R2009-01-16/createDelegateTables.sql executeWithTempFile "../R2009/R2009-01-16/updates.sql" ../R2009/R2009-01-16/updates.sql executeWithTempFile "../R2009/R2009-01-22/alterTableDelegateCourseInquiry.sql" ../R2009/R2009-01-22/alterTableDelegateCourseInquiry.sql executeWithTempFile "../R2009/R2009-01-27/alterTableInquiriesCourse.sql" ../R2009/R2009-01-27/alterTableInquiriesCourse.sql executeWithTempFile "../R2009/R2009-01-27/alterJustificationColumn.sql" ../R2009/R2009-01-27/alterJustificationColumn.sql executeWithTempFile "../R2009/R2009-01-27/alterCandidacyTables.sql" ../R2009/R2009-01-27/alterCandidacyTables.sql executeWithTempFile "../R2009/R2009-01-28/alterTableInquiriesCourse.sql" ../R2009/R2009-01-28/alterTableInquiriesCourse.sql executeWithTempFile "../R2009/R2009-01-28/updates.sql" ../R2009/R2009-01-28/updates.sql executeWithTempFile "../R2009/R2009-02-06/correctQueueJobTables.sql" ../R2009/R2009-02-06/correctQueueJobTables.sql executeWithTempFile "../R2009/R2009-02-09/alterTableJustificationMotive.sql" ../R2009/R2009-02-09/alterTableJustificationMotive.sql executeWithTempFile "../R2009/R2009-02-10/alterTableJustificationMotive.sql" ../R2009/R2009-02-10/alterTableJustificationMotive.sql executeWithTempFile "../R2009/R2009-02-12/movePhotographContentsToAnotherTable.sql" ../R2009/R2009-02-12/movePhotographContentsToAnotherTable.sql executeWithTempFile "../R2009/R2009-02-16/addPRQueueJob.sql" ../R2009/R2009-02-16/addPRQueueJob.sql executeWithTempFile "../R2009/R2009-02-19/updates.sql" ../R2009/R2009-02-19/updates.sql executeWithTempFile "../R2009/R2009-02-19/FileLocalContents.sql" ../R2009/R2009-02-19/FileLocalContents.sql executeWithTempFile "../R2009/R2009-02-19/filePublicAccess.sql" ../R2009/R2009-02-19/filePublicAccess.sql executeWithTempFile "../R2009/R2009-02-27/addPrivateKeySlotToUser.sql" ../R2009/R2009-02-27/addPrivateKeySlotToUser.sql executeWithTempFile "../R2009/R2009-02-27/addGroupDescriptionParking.sql" ../R2009/R2009-02-27/addGroupDescriptionParking.sql executeWithTempFile "../R2009/R2009-02-27/addLibraryMissingDocumentsTables.sql" ../R2009/R2009-02-27/addLibraryMissingDocumentsTables.sql # Linkare - This file was not included in the original run file from IST. It was included here manually... executeWithTempFile "../R2009/R2009-02-27/parkingGroupDescriptionData.sql" ../R2009/R2009-02-27/parkingGroupDescriptionData.sql executeWithTempFile "../R2009/R2009-03-04/dropOldPhotographContent.sql" ../R2009/R2009-03-04/dropOldPhotographContent.sql # Linkare - Fixed SQL original final and used the fixed one in the local folder executeWithTempFile "createPermissionsTables.sql" createPermissionsTables.sql executeWithTempFile "../R2009/R2009-03-11/alterTableGrantType.sql" ../R2009/R2009-03-11/alterTableGrantType.sql executeWithTempFile "../R2009/R2009-03-11/updateDegreeSiteUnit.sql" ../R2009/R2009-03-11/updateDegreeSiteUnit.sql executeWithTempFile "../R2009/R2009-03-18/updateGradeNullObjects.sql" ../R2009/R2009-03-18/updateGradeNullObjects.sql executeWithTempFile "../R2009/R2009-03-19/changeResearcherTableAndValues.sql" ../R2009/R2009-03-19/changeResearcherTableAndValues.sql executeWithTempFile "../R2009/R2009-03-25/setResearcherDefaultValues.sql" ../R2009/R2009-03-25/setResearcherDefaultValues.sql execute "../R2009/R2009-03-25/alterAdministrativeOfficePermissionsTables.sql" ../R2009/R2009-03-25/alterAdministrativeOfficePermissionsTables.sql executeWithTempFile "../R2009/R2009-03-25/alterInquiriesResults.sql" ../R2009/R2009-03-25/alterInquiriesResults.sql executeWithTempFile "../R2009/R2009-03-25/changeEmailsDocenciaStructure.sql" ../R2009/R2009-03-25/changeEmailsDocenciaStructure.sql executeWithTempFile "../R2009/R2009-03-25/updateReplyToConcreteClass.sql" ../R2009/R2009-03-25/updateReplyToConcreteClass.sql executeWithTempFile "../R2009/R2009-03-25/alterAdministrativeOfficePemissionTables.sql" ../R2009/R2009-03-25/alterAdministrativeOfficePemissionTables.sql # Linkare - This file was not included in the original run file from IST. It was included here manually, and changed according to our needs. execute "createAdministrativeOfficePermissions.sql" createAdministrativeOfficePermissions.sql executeWithTempFile "../R2009/R2009-03-26/alterStudentInquiriesResultsTable.sql" ../R2009/R2009-03-26/alterStudentInquiriesResultsTable.sql executeWithTempFile "../R2009/R2009-03-26/EmailCoordinatorSender.sql" ../R2009/R2009-03-26/EmailCoordinatorSender.sql executeWithTempFile "../R2009/R2009-03-30/vigilancyUpdates.sql" ../R2009/R2009-03-30/vigilancyUpdates.sql executeWithTempFile "../R2009/R2009-03-30/candidacy-person-indirection.sql" ../R2009/R2009-03-30/candidacy-person-indirection.sql executeWithTempFile "../R2009/R2009-03-30/AlterTableAssiduousnessVacations.sql" ../R2009/R2009-03-30/AlterTableAssiduousnessVacations.sql # Linkare - Fixed SQL original final and used the fixed one in the local folder executeWithTempFile "updates-2009-03-30.sql" updates-2009-03-30.sql executeWithTempFile "../R2009/R2009-04-06/vigilancyUpdates.sql" ../R2009/R2009-04-06/vigilancyUpdates.sql executeWithTempFile "../R2009/R2009-04-06/createAnnouncementCategory.sql" ../R2009/R2009-04-06/createAnnouncementCategory.sql executeWithTempFile "../R2009/R2009-04-06/createPersonFunctionSender.sql" ../R2009/R2009-04-06/createPersonFunctionSender.sql executeWithTempFile "../R2009/R2009-04-08/alterTableEnrolmentLogs.sql" ../R2009/R2009-04-08/alterTableEnrolmentLogs.sql executeWithTempFile "../R2009/R2009-04-08/alterEnrolmentLogsModule.sql" ../R2009/R2009-04-08/alterEnrolmentLogsModule.sql executeWithTempFile "../R2009/R2009-04-08/alterEnrolmentLogsModule2.sql" ../R2009/R2009-04-08/alterEnrolmentLogsModule2.sql executeWithTempFile "../R2009/R2009-04-21/addVacationsMapFunctionality.sql" ../R2009/R2009-04-21/addVacationsMapFunctionality.sql # Linkare - Fixed SQL original final and used the fixed one in the local folder executeWithTempFile "updateGeneratedDocuments.sql" updateGeneratedDocuments.sql executeWithTempFile "../R2009-04-27/changingRelationBetweenTeacherAndProfessorship.sql" ../R2009-04-27/changingRelationBetweenTeacherAndProfessorship.sql executeWithTempFile "../R2009-04-27/degreeFinalizationBranch.sql" ../R2009-04-27/degreeFinalizationBranch.sql executeWithTempFile "../R2009-04-27/updates.sql" ../R2009-04-27/updates.sql executeWithTempFile "../R2009-04-28/FixPhdOldTables.sql" ../R2009-04-28/FixPhdOldTables.sql executeWithTempFile "../R2009-04-28/AddPhdProgramTables.sql" ../R2009-04-28/AddPhdProgramTables.sql # Linkare - Fixed SQL original final and used the fixed one in the local folder executeWithTempFile "alterCandidacyRelatedTables.sql" alterCandidacyRelatedTables.sql # Linkare - Fixed SQL original final and used the fixed one in the local folder executeWithTempFile "alterNationality.sql" alterNationality.sql executeWithTempFile "../R2009-04-30/updateCountriesLocalizedNames.sql" ../R2009-04-30/updateCountriesLocalizedNames.sql executeWithTempFile "../R2009-04-30/candidacies_functions_section.sql" ../R2009-04-30/candidacies_functions_section.sql executeWithTempFile "../R2009-05-03/missingTables.sql" ../R2009-05-03/missingTables.sql # Linkare - Added new file to remove duplicated indexes execute "removeDuplicatedIndexesInTables.sql" removeDuplicatedIndexesInTables.sql # Linkare - Generated our own file, from the ant task: ant -f build_dataBaseUtils.xml OidSqlGenerator execute "alterTables.sql" alterTables.sql executeWithTempFile "../R2009-05-05/AlterTablePhdIndividualProgramProcess.sql" ../R2009-05-05/AlterTablePhdIndividualProgramProcess.sql executeWithTempFile "../R2009-05-05/addCandidaciesAccessRootPortal.sql" ../R2009-05-05/addCandidaciesAccessRootPortal.sql executeWithTempFile "../R2009-05-05/addCandidaciesSubmissionRootPortal.sql" ../R2009-05-05/addCandidaciesSubmissionRootPortal.sql executeWithTempFile "../R2009-05-05/alterIndividualCandidacyTable.sql" ../R2009-05-05/alterIndividualCandidacyTable.sql executeWithTempFile "../R2009-05-06/updates.sql" ../R2009-05-06/updates.sql executeWithTempFile "../R2009-05-06/departmentStatisticsOptimizationReset.sql" ../R2009-05-06/departmentStatisticsOptimizationReset.sql executeWithTempFile "../R2009-05-06/removeInvalidTutorships.sql" ../R2009-05-06/removeInvalidTutorships.sql executeWithTempFile "../R2009-05-07/CreateEmployeeContractsTables.sql" ../R2009-05-07/CreateEmployeeContractsTables.sql executeWithTempFile "../R2009-05-09/addProcessCodeToProcessTable.sql" ../R2009-05-09/addProcessCodeToProcessTable.sql # Linkare - Missing script which is specific of IST. Not supposed to run in our database. # executeWithTempFile "../R2009-05-09/dataFix.sql" ../R2009-05-09/dataFix.sql executeWithTempFile "../R2009-05-12/changeDegreeTypeValue.sql" ../R2009-05-12/changeDegreeTypeValue.sql executeWithTempFile "../R2009-05-12/removeUnusedPhdInformation.sql" ../R2009-05-12/removeUnusedPhdInformation.sql executeWithTempFile "../R2009-05-12/alterTablePhdProgram.sql" ../R2009-05-12/alterTablePhdProgram.sql executeWithTempFile "../R2009-05-17/addSystemSender.sql" ../R2009-05-17/addSystemSender.sql executeWithTempFile "../R2009-05-17/rename-system-tables.sql" ../R2009-05-17/rename-system-tables.sql executeWithTempFile "../R2009-05-17/updatePartyClassification.sql" ../R2009-05-17/updatePartyClassification.sql executeWithTempFile "../R2009-05-17/AddPhdProgramServiceAgreementTemplateKeys.sql" ../R2009-05-17/AddPhdProgramServiceAgreementTemplateKeys.sql executeWithTempFile "../R2009-05-17/AddPhdCandidacyProcessDocumentKeys.sql" ../R2009-05-17/AddPhdCandidacyProcessDocumentKeys.sql executeWithTempFile "../R2009-05-20/addMissingOIDColumnToDegree.sql" ../R2009-05-20/addMissingOIDColumnToDegree.sql executeWithTempFile "../R2009-05-25/alterTablePhdIndividualProgramProcess.sql" ../R2009-05-25/alterTablePhdIndividualProgramProcess.sql executeWithTempFile "../R2009-05-25/raidesAdditions.sql" ../R2009-05-25/raidesAdditions.sql executeWithTempFile "../R2009-05-25/createServiceExemptionsTables.sql" ../R2009-05-25/createServiceExemptionsTables.sql executeWithTempFile "../R2009-05-25/AddRemarksColumnToPhdCandidacyProcessDocument.sql" ../R2009-05-25/AddRemarksColumnToPhdCandidacyProcessDocument.sql executeWithTempFile "../R2009-05-25/AddPhdIndividualProcessNumber.sql" ../R2009-05-25/AddPhdIndividualProcessNumber.sql executeWithTempFile "../R2009-05-26/addEditorNotesToContentTable.sql" ../R2009-05-26/addEditorNotesToContentTable.sql executeWithTempFile "../R2009-05-28/addColumnToStudentCourseResult.sql" ../R2009-05-28/addColumnToStudentCourseResult.sql executeWithTempFile "../R2009-05-28/createTableCoordinatorExecutionDegreeCoursesReport.sql" ../R2009-05-28/createTableCoordinatorExecutionDegreeCoursesReport.sql executeWithTempFile "../R2009-05-28/alterTableProcess.sql" ../R2009-05-28/alterTableProcess.sql executeWithTempFile "../R2009-05-28/addColumnsToJobAndQualification.sql" ../R2009-05-28/addColumnsToJobAndQualification.sql executeWithTempFile "../R2009-05-29/createTableAssiduousnessClosedDay.sql" ../R2009-05-29/createTableAssiduousnessClosedDay.sql # Linkare - This file was not included in the original run file from IST. It was included here manually... executeWithTempFile "../R2009-06-02/addToIndividualCandidacyProcess.sql" ../R2009-06-02/addToIndividualCandidacyProcess.sql executeWithTempFile "../R2009-06-03/addTosAndCcsRecipientsToMessage.sql" ../R2009-06-03/addTosAndCcsRecipientsToMessage.sql executeWithTempFile "../R2009-06-03/correctPhdProgramGuiding.sql" ../R2009-06-03/correctPhdProgramGuiding.sql executeWithTempFile "../R2009-06-03/alterTableCurriculumModule.sql" ../R2009-06-03/alterTableCurriculumModule.sql executeWithTempFile "../R2009-06-05/alterTableStudentInquiriesCourseResult.sql" ../R2009-06-05/alterTableStudentInquiriesCourseResult.sql executeWithTempFile "../R2009-06-05/changedDegreesManagementMenu.sql" ../R2009-06-05/changedDegreesManagementMenu.sql executeWithTempFile "../R2009-06-08/alterTablePublicCandidacyHashCode.sql" ../R2009-06-08/alterTablePublicCandidacyHashCode.sql executeWithTempFile "../R2009-06-08/createPhdProgramFocusAreaTable.sql" ../R2009-06-08/createPhdProgramFocusAreaTable.sql executeWithTempFile "../R2009-06-08/alterPublicCandidacyHashCodeTable.sql" ../R2009-06-08/alterPublicCandidacyHashCodeTable.sql # Linkare - Fixed SQL original final and used the fixed one in the local folder executeWithTempFile "dropTeacherColumnInProfessorship.sql" dropTeacherColumnInProfessorship.sql executeWithTempFile "../R2009-06-15/createPhdCandidacyRefereeLetterTable.sql" ../R2009-06-15/createPhdCandidacyRefereeLetterTable.sql executeWithTempFile "../R2009-06-15/addColumnsToQualificationTable.sql" ../R2009-06-15/addColumnsToQualificationTable.sql executeWithTempFile "../R2009-06-15/FunctionalitiesUploadSIBSFiles.sql" ../R2009-06-15/FunctionalitiesUploadSIBSFiles.sql executeWithTempFile "../R2009-06-15/alterPhdCandidacyRefereeLetterTable.sql" ../R2009-06-15/alterPhdCandidacyRefereeLetterTable.sql executeWithTempFile "../R2009-06-15/alterTableCoordinatorExecutionDegreeCoursesReport.sql" ../R2009-06-15/alterTableCoordinatorExecutionDegreeCoursesReport.sql executeWithTempFile "../R2009-06-18/addRoomSlot.sql" ../R2009-06-18/addRoomSlot.sql executeWithTempFile "../R2009-06-23/resetPublicCandidacyHashCodeOID.sql" ../R2009-06-23/resetPublicCandidacyHashCodeOID.sql executeWithTempFile "../R2009-06-23/addCitizenCardIdDocumentTypeObject.sql" ../R2009-06-23/addCitizenCardIdDocumentTypeObject.sql executeWithTempFile "../R2009-06-25/AddPhdAlertsTables.sql" ../R2009-06-25/AddPhdAlertsTables.sql # Linkare - Generated our own file, from the ant task: ant -f build_dataBaseUtils.xml OidSqlGenerator. Changed to execute insteaf of executeWithTempFile execute "updates-2009-06-28.sql" updates-2009-06-28.sql executeWithTempFile "../R2009-07-02/AlterTablePhdAlertMessage.sql" ../R2009-07-02/AlterTablePhdAlertMessage.sql executeWithTempFile "../R2009-07-02/updateQualificationsCreator.sql" ../R2009-07-02/updateQualificationsCreator.sql executeWithTempFile "../R2009-07-02/addPhdProgramFunctionalities.sql" ../R2009-07-02/addPhdProgramFunctionalities.sql executeWithTempFile "../R2009-07-07/addExternalTeacherPremissions.sql" ../R2009-07-07/addExternalTeacherPremissions.sql # Linkare - Fixed SQL original final and used the fixed one in the local folder executeWithTempFile "alterTablePhdAlert.sql" alterTablePhdAlert.sql executeWithTempFile "../R2009-07-08/addPartyType.sql" ../R2009-07-08/addPartyType.sql executeWithTempFile "../R2009-07-09/createPersistentRootTable.sql" ../R2009-07-09/createPersistentRootTable.sql executeWithTempFile "../R2009-07-09/alterTableProcess.sql" ../R2009-07-09/alterTableProcess.sql # Linkare - Missing script which is specific of IST. Not supposed to run in our database. # executeWithTempFile "../R2009-07-10/deleteInvalidPhoto.sql" ../R2009-07-10/deleteInvalidPhoto.sql executeWithTempFile "../R2009-07-13/alterTableCandidacyReferee.sql" ../R2009-07-13/alterTableCandidacyReferee.sql # Linkare - Changed to execute insteaf of executeWithTempFile execute "../R2009-07-14/updates.sql" ../R2009-07-14/updates.sql executeWithTempFile "../R2009-07-15/alterAssiduousnessClosedMonthTables.sql" ../R2009-07-15/alterAssiduousnessClosedMonthTables.sql executeWithTempFile "../R2009-07-19/AddPhdStudyPlanTables.sql" ../R2009-07-19/AddPhdStudyPlanTables.sql # Linkare - Missing script which is specific of IST. Not supposed to run in our database. # executeWithTempFile "../R2009-07-23/dataFix.sql" ../R2009-07-23/dataFix.sql executeWithTempFile "../R2009-07-27/alterTablePublicCandidacyHashCode.sql" ../R2009-07-27/alterTablePublicCandidacyHashCode.sql executeWithTempFile "../R2009-07-27/updates.sql" ../R2009-07-27/updates.sql executeWithTempFile "../R2009-07-27/addFieldsToSibsPaymentFileProcessReport.sql" ../R2009-07-27/addFieldsToSibsPaymentFileProcessReport.sql executeWithTempFile "../R2009-07-27/addUtlStudentToIndividualCandidacy.sql" ../R2009-07-27/addUtlStudentToIndividualCandidacy.sql # Linkare - Fixed SQL original final and used the fixed one in the local folder executeWithTempFile "changeStudentToPersonInPaymentCodeTable.sql" changeStudentToPersonInPaymentCodeTable.sql executeWithTempFile "../R2009-07-29/updates.sql" ../R2009-07-29/updates.sql # Linkare - Changed to execute insteaf of executeWithTempFile execute "../R2009-07-29/createPhdProgramStateInformation.sql" ../R2009-07-29/createPhdProgramStateInformation.sql executeWithTempFile "../R2009-07-30/changePhdAlertTable.sql" ../R2009-07-30/changePhdAlertTable.sql executeWithTempFile "../R2009-07-31/updates.sql" ../R2009-07-31/updates.sql