package com.aconex.install.shell;
import com.aconex.install.commandline.*;
import com.aconex.install.tasks.install.*;
import com.aconex.install.tasks.install_2_2_10.*;
import com.aconex.install.tasks.install_2_2_11.*;
import com.aconex.install.tasks.install_2_2_4.*;
import com.aconex.install.tasks.install_2_2_9.*;
import com.aconex.install.tasks.install_2_3_0.*;
import com.aconex.install.tasks.install_2_3_1.*;
import com.aconex.install.tasks.install_2_3_11.*;
import com.aconex.install.tasks.install_2_3_14.*;
import com.aconex.install.tasks.install_2_3_18.*;
import com.aconex.install.tasks.install_2_3_5.*;
import com.aconex.install.tasks.install_2_3_6.*;
import com.aconex.install.tasks.install_2_3_8.*;
import com.aconex.install.tasks.install_2_3_9.*;
import com.aconex.install.tasks.install_2_4_0.*;
import com.aconex.install.tasks.install_2_4_18.*;
import com.aconex.install.tasks.install_2_4_19.*;
import com.aconex.install.tasks.install_2_4_2.*;
import com.aconex.install.tasks.install_2_4_21.*;
import com.aconex.install.tasks.install_2_4_22.*;
import com.aconex.install.tasks.install_2_4_24.*;
import com.aconex.install.tasks.install_2_4_25.*;
import com.aconex.install.tasks.install_2_4_26.*;
import com.aconex.install.tasks.install_2_4_29.*;
import com.aconex.install.tasks.install_2_4_30.*;
import com.aconex.install.tasks.install_2_4_31.*;
import com.aconex.install.tasks.install_2_4_32.*;
import com.aconex.install.tasks.install_2_4_37.*;
import com.aconex.install.tasks.install_2_4_4.*;
import com.aconex.install.tasks.install_2_4_5.*;
import com.aconex.install.tasks.install_2_4_7.*;
import com.aconex.install.tasks.install_2_5_0.*;
import com.aconex.install.tasks.install_2_5_1.*;
import com.aconex.install.tasks.install_2_5_2.*;
import com.aconex.install.tasks.install_Hack.*;
import com.aconex.install.tasks.install_5_1_0.*;
import com.aconex.install.tasks.install_5_2_0.*;
import com.aconex.install.tasks.install_5_3_0.*;
import com.aconex.install.tasks.install_5_4_0.*;
import com.aconex.install.tasks.install_5_4_1.*;
import com.aconex.install.tasks.install_5_4_2.*;
import com.aconex.install.tasks.install_5_4_3.*;
import com.aconex.install.tasks.install_5_5_0.*;
import com.aconex.install.tasks.install_5_5_1.*;
import com.aconex.install.tasks.install_5_5_2.*;
import com.aconex.install.tasks.install_5_6_0.*;
import com.aconex.install.tasks.install_5_6_2.*;
import com.aconex.install.tasks.install_5_7_0.*;
import com.aconex.install.tasks.install_5_7_1.*;
import com.aconex.install.tasks.install_5_7_2.*;
import com.aconex.install.tasks.install_6_0_0.*;
import com.aconex.install.tasks.install_6_1_0.*;
import com.aconex.install.tasks.install_6_2_0.*;
import com.aconex.install.tasks.install_6_3_0.*;
import com.aconex.install.tasks.install_6_4_0.*;
import com.aconex.install.tasks.install_6_4_1.*;
import com.aconex.install.tasks.install_6_3_1.*;
import com.aconex.install.tasks.install_6_3_2.*;
import com.aconex.install.tasks.install_6_5_0.*;
import com.aconex.install.tasks.install_6_5_2.*;
import com.aconex.install.tasks.install_6_5_3.*;
import com.aconex.install.tasks.install_6_5_4.*;
import com.aconex.install.tasks.install_6_5_5.*;
import com.aconex.install.tasks.install_6_5_6.*;
import com.aconex.install.tasks.install_7_0_0.*;
import com.aconex.install.tasks.install_7_0_1.*;
import com.aconex.install.tasks.install_7_0_4.*;
import com.aconex.install.tasks.install_7_0_5.*;
import com.aconex.install.tasks.install_7_0_6.*;
import com.aconex.install.tasks.install_7_1_0.*;
import com.aconex.install.tasks.install_8_0_0.*;
/**
* pGal Component
*
* User: Mark Williamson
* Date: Feb 22, 2003
* Time: 5:53:30 PM
* Copy Right 2003 Gator Enterprizes
*/
public class Install extends Startup {
public Install() {
}
/**
* Sets up the command line and the availble options for this program
*
* @param arguments A set of arguments
*/
public void setupCommandLine(Arguments arguments) {
arguments.setPreambleHelp("Aconex MS SQL Server Installer \r\n" +
"install --db --version [other options] \r\n" +
"The database installer for Aconex\r\n\r\nUsage:");
arguments.setPostambleHelp("\r\n " +
"\r\n " +
"eg install -d mydb --version 2.1.9\r\n" +
"Will install all of the database changes up to version 2.1.9 to a dabase called mydb\r\n" +
"The installer rocks");
try {
Argument arg = new Argument();
arg = new Argument();
arg.setLetterCode("D");
arg.setLongCode("driver");
arg.setShortHelp("The JDBC Driver to use Default com.inet.tds.TdsDriver");
arg.setMinParameterCount(1);
arg.setMaxParameterCount(1);
arg.setArgumentType(ArgumentDataType.STRING);
arg.setDefault("com.inet.tds.TdsDriver");
arguments.addArgument(arg);
arg = new Argument();
arg.setLetterCode("s");
arg.setLongCode("server");
arg.setShortHelp("The name of the database server Default jdbc:inetdae7:localhost?database=");
arg.setMinParameterCount(1);
arg.setMaxParameterCount(1);
arg.setArgumentType(ArgumentDataType.STRING);
arg.setDefault("jdbc:inetdae7:localhost?database=");
arguments.addArgument(arg);
arg = new Argument();
arg.setLetterCode("d");
arg.setLongCode("db");
arg.setShortHelp("The name of the database which is required eg MyDataBase");
arg.setMinParameterCount(1);
arg.setMaxParameterCount(1);
arg.setArgumentType(ArgumentDataType.STRING);
arg.setMandatory(true);
arguments.addArgument(arg);
arg = new Argument();
arg.setLetterCode("u");
arg.setLongCode("user");
arg.setShortHelp("The user to connect to the database with. Default aconexsql");
arg.setMinParameterCount(1);
arg.setMaxParameterCount(1);
arg.setArgumentType(ArgumentDataType.STRING);
arg.setDefault("aconexsql");
arguments.addArgument(arg);
arg = new Argument();
arg.setLetterCode("p");
arg.setLongCode("password");
arg.setShortHelp("The password to use. Default ******");
arg.setMinParameterCount(1);
arg.setMaxParameterCount(1);
arg.setArgumentType(ArgumentDataType.STRING);
arg.setDefault("aconexsql");
arguments.addArgument(arg);
arg = new Argument();
arg.setLetterCode("v");
arg.setLongCode("version");
arg.setShortHelp("The version to install up to in the form major.ninor.patch eg 2.16.17 If ommitte" +
"d then all patches are installed");
arg.setMinParameterCount(1);
arg.setMaxParameterCount(1);
arg.setArgumentType(ArgumentDataType.STRING);
arg.setMandatory(true);
arguments.addArgument(arg);
arg = new Argument();
arg.setLetterCode("t");
arg.setLongCode("target");
arg.setShortHelp("The target to install. If present any target tasks are included otherwise these " +
"tasks are ommitted");
arg.setMinParameterCount(0);
arg.setMaxParameterCount(1);
arg.setArgumentType(ArgumentDataType.STRING);
arguments.addArgument(arg);
arg = new Argument();
arg.setLetterCode("r");
arg.setLongCode("report");
arg.setShortHelp("Doesn't execute any SQL but reports on the SQL that would be executed");
arg.setMinParameterCount(0);
arg.setMaxParameterCount(0);
arg.setArgumentType(ArgumentDataType.BOOELAN);
arg.setDefault("false");
arg.setMandatory(true);
arguments.addArgument(arg);
arg = new Argument();
arg.setLetterCode("h");
arg.setLongCode("help");
arg.setShortHelp("This help message");
arg.setMinParameterCount(0);
arg.setMaxParameterCount(0);
arg.setArgumentType(ArgumentDataType.BOOELAN);
arg.setDefault("false");
arguments.addArgument(arg);
arg = new Argument();
arg.setLetterCode("a");
arg.setLongCode("arglist");
arg.setShortHelp("A list of the arguments as parsed from the command line");
arg.setMinParameterCount(0);
arg.setMaxParameterCount(0);
arg.setArgumentType(ArgumentDataType.BOOELAN);
arg.setDefault("false");
arguments.addArgument(arg);
arg = new Argument();
arg.setLetterCode("f");
arg.setLongCode("force");
arg.setShortHelp("Force a task to run even if it has already run");
arg.setMinParameterCount(0);
arg.setMaxParameterCount(0);
arg.setArgumentType(ArgumentDataType.BOOELAN);
arg.setDefault("false");
arguments.addArgument(arg);
arg = new Argument();
arg.setLetterCode("T");
arg.setLongCode("targetlist");
arg.setShortHelp("Displays a list of the valid targets");
arg.setMinParameterCount(0);
arg.setMaxParameterCount(0);
arg.setArgumentType(ArgumentDataType.BOOELAN);
arg.setDefault("false");
arguments.addArgument(arg);
arg = new Argument();
arg.setLetterCode("S");
arg.setLongCode("singletask");
arg.setShortHelp("Runs only the named single task. Use quotes for tasks with spaces");
arg.setMinParameterCount(1);
arg.setMaxParameterCount(1);
arg.setDefault("false");
arg.setArgumentType(ArgumentDataType.STRING);
arguments.addArgument(arg);
arg = new Argument();
arg.setLetterCode("M");
arg.setLongCode("mode");
arg.setShortHelp("Run offline/online or all tasks, defaule online");
arg.setMinParameterCount(1);
arg.setMaxParameterCount(1);
arg.setArgumentType(ArgumentDataType.STRING);
arg.setDefault("both");//After 2.5.3 release this has to chnage to online
arguments.addArgument(arg);
} catch (ArgumentException ex) {
cat.error("Bad argument while seting up command line", ex);
}
// return arguments;
}
public void taskManifest() {
// base tasks
addTask(new IndexForeignKeys());
addTask(new IndexLookUps());
addTask(new TableAccessibleAsset());
addTask(new TableAccessLog());
addTask(new TableAconexOrg());
addTask(new TableAconexUser());
addTask(new TableAction_Summary_Item());
addTask(new TableApprovable_Item());
addTask(new TableApproval_Request());
addTask(new TableApprover());
addTask(new TableAttributeMapping());
addTask(new TableAvailableCorr());
addTask(new TableBillCalendar());
addTask(new TableCart());
addTask(new TableCartItem());
addTask(new TableCDDocType());
addTask(new TableCDLog());
addTask(new TableCDStatus());
addTask(new TableCD_Tracking());
addTask(new TableControlledDoc());
addTask(new TableCorrAttachment());
addTask(new TableCorrespondence());
addTask(new TableCorrespondenceField());
addTask(new TableCorrespondenceViewElement());
addTask(new TableCorrespondence_Field_Data());
addTask(new TableCorrespondence_Reply_Ref());
addTask(new TableCorrespondence_View());
addTask(new TableCorr_Footer());
addTask(new TableCorr_Link());
addTask(new TableCorr_Reason());
addTask(new TableCorr_rspmsg());
addTask(new TableCorr_Status());
addTask(new TableCorr_Type());
addTask(new TableCorr_Type_Group());
addTask(new TableCorr_Type_Group_Element());
addTask(new TableCorr_Type_Scheme());
addTask(new TableDirectoryOrganization());
addTask(new TableDistribution());
addTask(new TableDocSize());
addTask(new TableDocumentImport());
addTask(new TableDocumentType());
addTask(new TableDocument_Import_Discipline());
addTask(new TableDocument_Import_Type());
addTask(new TableEventLog());
addTask(new TableEventLogType());
addTask(new TableExtTender());
addTask(new TableExt_Participant());
addTask(new TableFaxAddress());
addTask(new TableField_Enumeration());
addTask(new TableField_Type());
addTask(new TableFileX());
addTask(new TableFolder());
addTask(new TableFolderItem());
addTask(new TableGrantLog());
addTask(new TableGroups());
addTask(new TableGroupUser());
addTask(new TableKeyTbl());
addTask(new TableLogo());
addTask(new TableNext_Doc_Num());
addTask(new TableNext_Doc_Num_Field());
addTask(new TableNotifications());
addTask(new TableOrganization());
addTask(new TablePerformance_Stat());
addTask(new TablePeriodicTxn());
addTask(new TablePreference());
addTask(new TablePreferenceType());
addTask(new TableProject());
addTask(new TableProjectOrganization());
addTask(new TableProjectUser());
addTask(new TablePrtJob());
addTask(new TablePrtJobLn());
addTask(new TablePrtJob_Address());
addTask(new TablePrtShop());
addTask(new TablePublication());
addTask(new TablePurchaseOrder());
addTask(new TablePurchaseOrderAccountNumber());
addTask(new TablePurchaseOrderItem());
addTask(new TableRequest_Approver());
addTask(new TableRole());
addTask(new TableRoleSecuredAsset());
addTask(new TableSecuredAsset());
addTask(new TableSecurityRule());
addTask(new TableShare());
addTask(new TableStylesheet());
addTask(new TableTdrAddendum());
addTask(new TableTdrAttachment());
addTask(new TableTdrNotify());
addTask(new TableTdrResponse());
addTask(new TableTdrRFI());
addTask(new TableTdrTemplate());
addTask(new TableTdrTender());
addTask(new TableTransmittalHist());
addTask(new TableTxn());
addTask(new TableTxnAtnm());
addTask(new TableTxnAttr());
addTask(new TableTxnLimit());
addTask(new TableTxnRule());
addTask(new TableTxnRun());
addTask(new TableTxnType());
addTask(new TableUserRole());
addTask(new TableUserX());
addTask(new TableVolume());
addTask(new TableVolume_Item());
// Release 2.2.4
addTask(new AddSecuredAssets2_2_4());
addTask(new AlterRole2_2_4());
addTask(new AddRoles2_2_4());
addTask(new CreateActionSummaryItem2_2_4());
addTask(new AlterActionSummaryItem2_2_4());
addTask(new AlterActionSummaryItem2_2_4_b());
addTask(new CreateNotification2_2_4());
addTask(new InsertNotificationKey2_2_4());
addTask(new AlterControlledDoc2_2_4());
addTask(new AlterControlledDocAgain2_2_4());
//addTask(new UpdateTrackingIdOrgInControlledDoc());
addTask(new UpdateTrackingIdOrgInDocucopyCD());
addTask(new AlterMailTypesForAconexCRMSystem());
addTask(new AlterNotification2_2_4());
addTask(new FixOrganizationCodes2_2_4());
addTask(new ClearAltDocumentNos2_2_4());
addTask(new ClearActionSummaryItems2_2_4());
addTask(new AddUnregisteredDocsActionSummaryItems2_2_4());
addTask(new AddUnreadMailActionSummaryItems2_2_4());
addTask(new AddOverdueReadMailActionSummaryItems2_2_4());
addTask(new AddActiveTendersActionSummaryItems2_2_4());
addTask(new AddIncomingTendersActionSummaryItems2_2_4());
addTask(new AddIncomingTendersResponseActionSummaryItems2_2_4());
addTask(new AddOverdueTendersRFIActionSummaryItems2_2_4());
addTask(new RemovePrefType2_2_4());
addTask(new AddIndexes2_2_4());
addTask(new ResetPublicDocs2_2_4());
addTask(new RemoveOutstandingActionSummaryItems2_2_4());
addTask(new AddOutstandingMailActionSummaryItems2_2_4());
addTask(new RemoveUnreadActionSummaryItems2_2_4());
addTask(new AddUnreadMailActionSummaryItems2_2_4b());
addTask(new AddOutstandingMailActionSummaryItems2_2_4b());
// N/A addTask(new ResetMorePublicDocs2_2_4());
// N/A addTask(new RemoveJackKerlin2_2_4());
// N/A addTask(new RemoveHolmesAndHarris2_2_4());
// addTask(new AddDocType2_2_4());
// addTask(new RemoveOutstandingActionSummaryItemsForMel());
// addTask(new AddOutstandingMailActionSummaryItemsForMel());
addTask(new AddCDStatus2_2_4());
// N/A addTask(new AlterMailTypesForAconexCRMSystem_2_2_4b());
// addTask(new AddUserToFolder2_2_4());
addTask(new FixActionSummaryDBTaskEntries2_2_4());
// N/A addTask(new UnlockHassellCDs2_2_4());
// N/A addTask(new RenameFileTable2_2_4());
// N/A addTask(new RenameRuleTable2_2_4());
// Release 2.2.5
// N/A addTask(new RenameFileTable2_2_5());
// N/A addTask(new RenameRuleTable2_2_5());
// N/A addTask(new UpdateProjectImage2_2_5());
// Release 2.2.7
// addTask(new AddPrintCentersUK2_2_7());
// addTask(new AddCorrTypesUK2_2_7());
// addTask(new AddPrintShop2_2_7());
// addTask(new AddWebcamForProximity2_2_7());
// Release 2.2.9
// addTask(new AddMaccasOrgsToProjects2_2_9());
// addTask(new AddCorrType2_2_9());
// addTask(new RemoveProjUser2_2_9());
// addTask(new AddUserToProjects2_2_9());
// addTask(new UpdateCDTrackingIDs2_2_9());
// addTask(new RemoveUserFromProject2_2_9());
// addTask(new AddCorrType2_2_9b());
// addTask(new UpdateMaccasDocs2_2_9());
// addTask(new AddMaccasOrgsToNewProjects2_2_9());
// addTask(new AddCorrType2_2_9c());
// addTask(new RemoveMaccasDuplicates2_2_9());
// addTask(new UpdateMaccasDocsTakeII2_2_9());
// addTask(new AddMaccasUsersToAllProjects2_2_9());
addTask(new CreateWorkFlow2_2_9());
addTask(new CreateWorkFlowStep2_2_9());
addTask(new CreateWorkerPool2_2_9());
addTask(new CreateWorkerPoolUser2_2_9());
addTask(new CreateWorkFlowRequest2_2_9());
addTask(new CreateWorkFlowQueue2_2_9());
// addTask(new UpdateMaccasMasterFileNames2_2_9());
// addTask(new AddMaccasUsersToTASProjects2_2_9());
// addTask(new MaccasCloneProject2_2_9());
// addTask(new MaccasCloneProjectTakeII2_2_9());
// addTask(new UpdatePrintCentersUK2_2_9());
// addTask(new MaccasAddStudio9ToSAProjects2_2_9());
// addTask(new MaccasAddSaltechToVICProjects2_2_9());
// addTask(new AddMaccasUsersToAllProjectsAgain1());
// addTask(new MaccasAddPeterWrightToVICProjects2_2_9());
// addTask(new MaccasMakePublic16Aug());
// addTask(new MaccasMakePublic23July());
// addTask(new MaccasMoveDocs23July());
// addTask(new MaccasAddIdeaToNSWProjects2_2_9());
// addTask(new MaccasMakePublicJuly30());
// addTask(new MaccasAddTimeBombToQLDProjects2_2_9());
// addTask(new MaccasAddDavenportToNSWProjects2_2_9());
// addTask(new MaccasAddPAArchitectsToQLDProjects2_2_9());
// addTask(new AddMaccasUsersToAllProjectsAgain2());
// addTask(new MaccasMakePublic6July());
// addTask(new MaccasAddStudio9ToSAProjectsAgain2_2_9());
// addTask(new MaccasAddOttoToNSWProjects2_2_9());
// addTask(new MaccasMakePublic13Aug());
// addTask(new MaccasAddEdgeToNSWProjects2_2_9()); //42
// addTask(new MaccasMakePublic21Aug()); //43
// addTask(new MaccasCloneMasterToLoganholme()); //44
// addTask(new MaccasAddHKToALLProjects2_2_9()); // 45
// addTask(new MaccasAddDesignEstateToNSWProjects2_2_9()); // 46
// addTask(new MaccasInviteNewBaldassoUsers()); // 47
// addTask(new MaccasMakePublic()); // 1000 - always run last.
//Release 2.2.10
addTask(new AddFieldType2_2_10());
// addTask(new AddCMRTemplateScheme2_2_10());
// addTask(new RemoveTwoUsersFromProject2_2_10());
// addTask(new UpdateTwoCorrTypes2_2_10());
addTask(new AddCorrTypeForAconexCRMSystem_2_2_10());
// addTask(new AddCorrType2_2_10());
// addTask(new RenumberMemos2_2_10());
// addTask(new FixDefProjForMiraruTenders_2_2_10());
// addTask(new FixDefProjForMiraruTenders_2_2_10b());
// addTask(new RemoveUsersFromProjects2_2_10b());
// addTask(new AddCorrType2_2_10b());
// addTask(new RemoveUsersFromProjects2_2_10c());
//Release 2.2.11
addTask(new MakeOverdueAndOutstandingCorrOrgBeans2_2_11());
// addTask(new UndoUserMerge2_2_11());
// addTask(new RemoveActionSummaryItem_2_2_11());
// addTask(new AddPrintCenterMattronics2_2_11());
// addTask(new RemoveApprovalRequest2_2_11());
// addTask(new RemoveUsersFromProjects2_2_11());
// addTask(new UpdateCorrespondenceConfidential2_2_11());
// addTask(new AddCorrType2_2_11());
// addTask(new RenubmerRFI2_2_11());
// addTask(new UpdateProjLogo2_2_11());
// addTask(new AddPrintCenterTJs2_2_11());
// addTask(new UndoProjLogo2_2_11());
// addTask(new AddABCUsersToProjects2_2_11());
// addTask(new RemoveUsersFromProjects2_2_11a());
// addTask(new AddDocType2_2_11());
// addTask(new AddCorrType2_2_11a());
// addTask(new AddPrintCenterMetroD2_2_11());
// addTask(new AddBectonMailTypeAndAutoNumber2_2_11());
// addTask(new AddDocType2_2_11a());
// addTask(new UpdatePrintCenterMetroD2_2_11());
// addTask(new RemoveUsersFromProjects2_2_11b());
// addTask(new UpdateProjectOwner2_2_11());
// addTask(new UpdatePrintCenters2_2_11()); // 23
// addTask(new AddCorrReson2_2_11()); //24
// addTask(new AddPrintCenterPlanScan2_2_11()); //25
// addTask(new AddCorrType2_2_11b());//26
// addTask(new AddDocType2_2_11b());//27
// addTask(new RemoveOrganizationFromProjects2_2_11());//28
// Release 2.3
addTask(new AlterPrintShop());
// addTask(new PopulatePrintShopEmails());
addTask(new RemoveSharedDocCopies2_3_0());
addTask(new AlterProjOrganization2_3_0());
addTask(new AddPreferenceType2_3_0());
// addTask(new PopulatePrintShopEmailsUK());
addTask(new AlterNotification());
addTask(new PopulateMcDonaldsPrintShopEmails());
addTask(new PopulateDocucopyPrintShopEmails());
addTask(new AddPreferenceType2_3_0b());
addTask(new TableScheduled_Task());
addTask(new TableWebcam());
addTask(new AlterBillingCalendar2_3_0());
// addTask(new AddFileRepliesScheduledTask2_3());
addTask(new CreateTask2_3_0());
addTask(new CreateCDProjectCopyHist2_3());
addTask(new AlterDocumentImport_2_3_0());
addTask(new AlterDocumentImport_2_3_0b());
addTask(new AlterDocumentImport_2_3_0c());
addTask(new InsertImportNames2_3_0());
addTask(new TableDocFile2_3_0());
addTask(new ViewerAssets2_3_0());
addTask(new CreateFileUploadEntry2_3_0());
addTask(new CreateFileUpload2_3_0());
addTask(new CreateDocApprovalTransmittal2_3_0());
addTask(new CreateDocApprovalTransAttach2_3_0());
addTask(new AlterTask2_3_0());
addTask(new AlterWorkFlowQueue2_3_0());
addTask(new AlterWorkFlowRequest2_3_0());
addTask(new AlterWorkFlowStep2_3_0());
addTask(new FixFileUploadKey2_3_0());
addTask(new AddRegisteredFlagToCD2_3_0());
addTask(new AlterFileUploadEntry2_3_0());
addTask(new ModifyCDLog2_3_0());
addTask(new AddSecuredAssets2_3_0());
addTask(new AddRoles2_3_0());
addTask(new AddCorrType2_3_0());
addTask(new AlterDocApprovalTransmittal2_3_0());
addTask(new AlterControlleddoc2_3_0());
addTask(new DeleteDistribution2_3_0());
addTask(new ModifyPrintJobLn2_3_0());
addTask(new AlterOrganization2_3_0());
addTask(new FixOrgNotPrivate2_3_0());
addTask(new CreateDocApprovalTransCorr2_3_0());
addTask(new AddApprovableItem2_3_0());
addTask(new ModifyCorrespondence2_2_3());
addTask(new AddDefaultRichTextPreference2_3_0());
addTask(new AddCorrAttribPrefType2_3_0());
addTask(new AlterCorrespondence2_3_0());
addTask(new UpdateMailAttribute2_3_0());
addTask(new AlterWorkFlowQueue2_3_0_b());
addTask(new AlterTaskForActionSummary2_3_0());
addTask(new AddCorrType2_3_0b());
addTask(new AddCorrAttribPrefType2_3_0b());
addTask(new ModifyCorrAddReplyType2_2_3());
addTask(new AlterTaskForActionSummary1_2_3_0());
addTask(new ViewerAssets2_3_0b());
addTask(new AddViewerRoles2_3_0());
addTask(new ModifyCorrespondenceTypes2_3_0());
addTask(new ModifyDefaultRoles2_3_0());
addTask(new AddNextDocNumFieldRecords2_3_0());
addTask(new ModifyControlledDoc2_3_0());
// This task was moved up in the order so the indexes
// would apply to the subsequent scripts. To facilitate
// this (and avoid shuffling the 16 scripts between 64
// and 82), the TableAlert() script is moved to 82
addTask(new RecreateIndexes2_3_0()); // New 64
//addTask(new TableAlert()); // Was 64
addTask(new FixViewerRoles2_3_0()); //65
addTask(new AlterDocumentImport_2_3_0d()); //66
addTask(new FixCorrType2_3_0()); //67
addTask(new AlterDocumentImport_2_3_0e()); //68
addTask(new AddCorrType2_3_0c()); //69
addTask(new FixApprovableItem2_3_0()); //70
addTask(new UpdateTask2_3_0()); //71
addTask(new FixApprovableItemDuplicate2_3_0()); //72
addTask(new AlterTaskForActionSummary2_3_0c()); //73
addTask(new UpdateCorrType2_3_0()); //74
addTask(new ConvertActionSummaryItemToTask2_3_0()); //75
addTask(new AddCorrType2_3_0d()); //76
addTask(new UpdateTransmittedInCD2_3_0()); //77
addTask(new UpdateTask2_3_0b()); //78
// addTask(new UpdateProjectImage2_3_0()); //79
addTask(new UpdateTransmittedInCD2_3_0b()); //80
// addTask(new AddPrintShopUserIds2_3_0()); //81
// 'TableAlert' moved from pos 64 (see earlier comment)
// addTask(new RecreateIndexes2_3_0()); // Was 82
addTask(new TableAlert()); // New 82
addTask(new UpdateTransmittingOrgId2_3_0()); //83
addTask(new AddRoles2_3_0b()); //84
addTask(new AddRoles2_3_0c()); //85
addTask(new AlterCorrespondence2_3_0b()); //86
addTask(new ModifyIndexes2_3_0()); //87
addTask(new AddMailTemplatePreference2_3_0()); //88
// addTask(new UpdatePrintCenterPlanScan2_3_0()); //89
// addTask(new UpdateTransmittingOrgId2_3_0b()); //90
// addTask(new AddDocType2_3_0()); //91
// addTask(new RevokeShares2_3_0()); //92
//Release 2.3.1
addTask(new ModifyCDLogData2_3_1()); // 1
// addTask(new RemoveUsersFromProjects2_3_1()); //2
addTask(new RemoveUsersFromProjects2_3_1a()); //3
// Release 2.3.3
// addTask(new ModifyDefaultRichTextPreference2_3_3()); //1
// addTask(new RemoveBuggyFaxes2_3_3()); //2
// Release 2.3.4
// addTask(new AddCorrType2_3_4()); //1
// Release 2_3_5
addTask(new AddPreferenceForTasks2_3_5()); // 1
// addTask(new AddPrintShopStaging2_3_5()); // 2
addTask(new RemoveDuplicateUnregisteredDocTasks2_3_5()); //3
// addTask(new RemoveApprovalRequest2_3_5()); //4
// addTask(new FixShanisMistake2_3_5()); // 5
// Release 2_3_6
// addTask(new RemoveDuplicateUnregisteredDocTasks2_3_6()); //1
// addTask(new FixGroupUsers2_3_6()); //2
addTask(new RemoveNullRevisionInControlledDoc2_3_6()); //3
// addTask(new FixPrintShopUK2_3_6()); //4
// addTask(new AddCorrType2_3_6()); //5
// addTask(new RemoveUsersFromProjects2_3_6()); //6
// addTask(new RevokeShares2_3_6()); //7
// addTask(new AddDisciplineType2_3_6()); //8
// addTask(new DeleteDistributionGroup2_3_6()); //9
// addTask(new AddCorrType2_3_6a()); //10
//////////////////////////////////////////////////////////////////
// Release 2_3_8
//////////////////////////////////////////////////////////////////
addTask(new AlterDocumentImport_2_3_8()); //1
addTask(new AddCDStatus2_3_8()); //2
// addTask(new RemoveIncompleteLHRBulkUploads_2_3_8()); //3
addTask(new CorrectOrgIdAndStatusForTask2_3_8()); //4
//////////////////////////////////////////////////////////////////
// Release 2_3_9
//////////////////////////////////////////////////////////////////
addTask(new AlterNotification2_3_9()); //1
// addTask(new AddProjectImageQueensPlaza_2_3_9()); //2
// addTask(new RemoveUsersFromProjects2_3_9()); //3
// addTask(new AddCorrType2_3_9()); //4
// addTask(new RemoveOutStandingOverdueMailTransmittalTasks2_3_9 ()); //5
addTask(new CorrectStatusAndFinishTimeForTask2_3_9()); //6
// addTask(new AddCorrType2_3_9a()); //7
// addTask(new AddDocType2_3_9()); //8
// addTask(new AddPrintShopAlberto2_3_9()); //9
// addTask(new RemovePrtjobs2_3_9()); //10
// addTask(new AddCorrType2_3_9b()); //11
// addTask(new AddDocType2_3_9b()); //12
// addTask(new AddCorrType2_3_9c()); //13
// addTask(new AddDocType2_3_9c()); //14
// addTask(new AddDocType2_3_9d()); //15
// addTask(new AddCorrType2_3_9d()); //16
// addTask(new UpdatePrjOrgPhoneAndFax2_3_9()); //17
// addTask(new UpdateCorrespondenceDocNo2_3_9()); //18
//commented by Indu on James request
// addTask(new FixTrackingId_2_3_9a()); //19
addTask(new TaskIndexes2_3_9()); //20
// addTask(new UpdateEurekaPhoneAndFax2_3_9()); //21
// addTask(new UpdateWooliesData_2_3_9()); //22
// addTask(new FixWebcams2_3_9()); //22
// addTask(new FixWebcams2_3_9a()); //23
//////////////////////////////////////////////////////////////////
// Release 2_3_11
//////////////////////////////////////////////////////////////////
// addTask(new AddIndexToNotifications2_3_11()); // 1
// addTask(new AddProjectImage740Swanston_2_3_11()); // 2
//addTask(new AddIndexToNotifications2_3_11b()); // 3
addTask(new AddIndexToNotifications2_3_11c()); // 4
// addTask(new AddProjectImageDarwinCityWF_2_3_11()); // 5
addTask(new AddDocType2_3_11()); // 6
// addTask(new RemoveTenders2_3_11()); // 7
// addTask(new UpdateExtOrgFaxAndPhones2_3_11()); // 8
// addTask(new AddCustomerContactMailTemplate2_3_11()); // 9
// addTask(new RemoveCorrType2_3_11()); //10
addTask(new RevokeShare2_3_11()); //11
// addTask(new RevokeShareFolderItem2_3_11()); //12
//////////////////////////////////////////////////////////////////
// Release 2_3_13
//////////////////////////////////////////////////////////////////
// addTask(new AddCorrType2_3_13()); // 1
// addTask(new RemoveApprovalRequest2_3_13()); // 2
// addTask(new AddNextDocNumber2_3_13()); // 3
// addTask(new RemovePendingApprovalCorrespondence2_3_13()); // 4
// addTask(new FixApprovalsForCorrespondenceTypes2_3_13()); // 5
// addTask(new AddCorrType2_3_13a()); // 6
//////////////////////////////////////////////////////////////////
// Release 2_3_14
//////////////////////////////////////////////////////////////////
// addTask(new AddCorrType2_3_14()); // 1
// addTask(new AddCorrTypeUK2_3_14()); // 2
// addTask(new AddCorrType2_3_14b()); // 3
// addTask(new AddNextDocNumber2_3_14()); // 4
addTask(new AddIndexToDocumentImport2_3_14()); // 5
// addTask(new AddDocType2_3_14()); // 6
// addTask(new FixTdrResponseStatus2_3_14()); // 7
// addTask(new FixCorruptFilestoreDocs_2_3_14()); // 8 WORK IN PROGRESS on JASE's BOX
// addTask(new FixCorruptFilestoreDocs_2_3_14b()); // 9 WORK IN PROGRESS on JASE's BOX
// addTask(new FixCorruptFilestoreDocs_2_3_14c()); // 10 WORK IN PROGRESS on JASE's BOX
// addTask(new FixCorruptFilestoreDocs_2_3_14d()); // 11 WORK IN PROGRESS on JASE's BOX
// //addTask(new AddCorrTypeApprovableItem2_3_14()); // 12
// addTask(new FixHilliersNextDocNumber2_3_14()); // 13
// addTask(new RemoveUsersFromProjects2_3_14()); // 14
// addTask(new RemoveUsersFromProjects2_3_14a()); // 15
// addTask(new RemoveIncorrectProjectLogoOnJindalee2_3_14()); // 16
// addTask(new AddProjectImageJindalee_2_3_14()); // 17
// addTask(new RemoveDuplicateCorioProject2_3_14()); // 18
// addTask(new FixFolderName2_3_14()); // 19
// addTask(new FixApprovalOnFax136ForGrocon2_3_14()); // 20
// addTask(new AddCorrType2_3_14c()); // 21
// addTask(new ProjectImageForQUT2_3_14()); // 22
// addTask(new RemoveDuplicateApprovalRecordForMultiplex2_3_14()); // 23
// addTask(new ProjectImageForQUT2_3_14b()); // 24
//////////////////////////////////////////////////////////////////
// Release 2_3_15
//////////////////////////////////////////////////////////////////
//addTask(new ConvertActionSummaryItemToTask2_3_15()); //1
//////////////////////////////////////////////////////////////////
// Release 2_3_16
//////////////////////////////////////////////////////////////////
// addTask(new AddCorrType2_3_16()); // 1
// addTask(new ChangeDocTypesForCRM_2_3_16()); // 2
// addTask(new AddCorrTypeCRM2_3_16()); // 3
// addTask(new AddDocType2_3_16()); // 4
// addTask(new RemoveUsersFromProjects2_3_16()); // 5
// addTask(new FixPreferenceType2_3_16()); // 6
//////////////////////////////////////////////////////////////////
// Release 2_3_18
//////////////////////////////////////////////////////////////////
addTask(new CreateTablesForAutoRegRepairs2_3_18()); // 1
// addTask(new FixApprovals2_3_18()); // 2
addTask(new RemoveBinarySpacesFromCorrespondence_2_3_18()); // 3
// addTask(new AddDocType2_3_18()); // 5
// addTask(new RemoveUsersFromProjects2_3_18()); // 6
// addTask(new AddDocStatus2_3_18()); // 7
// addTask(new RemoveUsersFromProjects2_3_18b()); // 8
// addTask(new RemoveUsersFromProjects2_3_18c()); // 9
// addTask(new FixApprovals2_3_18b()); // 10
// addTask(new RemovePublicShareUK2_3_18()); // 11
// addTask(new RevokeShare2_3_18()); // 12
// addTask(new AddPrintCenterUK2_3_18()); // 13
// addTask(new AddDocTypeUK2_3_18()); // 14
//////////////////////////////////////////////////////////////////
// Release 2_4_0
//////////////////////////////////////////////////////////////////
addTask(new AlterPhoneFax2_4_0()); // 1
addTask(new CreateDocApprovalHistory2_4_0()); // 3
//addTask(new AconexBot2_4_0()); // 4
addTask(new CreateDocApprovalHistory2_4_0b()); // 5
addTask(new AlterWorkFlowStep2_4_0()); // 6
addTask(new AlterWorkFlowQueue2_4_0()); // 7
addTask(new AlterWorkFlow2_4_0()); // 8
addTask(new AddSecuredAssets2_4_0()); // 9
addTask(new AddRoles2_4_0()); //10
addTask(new AlterWorkFlowRequest2_4_0()); //11
addTask(new CreateDistributionLogTable2_4_0()); //12
addTask(new WorkFlowQueueWorkerUserIdFix2_4_0()); //13
addTask(new AddSecuredAssets2_4_0b()); //14
addTask(new AddRoles2_4_0b()); //15
addTask(new AlterSecuredAsset2_4_0()); //16
addTask(new CreateSecuredAssetGroup2_4_0()); //17
addTask(new AddSecuredAssetGroups2_4_0()); //18
addTask(new AddSecuredAssets2_4_0c()); //19
// addTask(new CompleteTaskForExternalUsers2_4_0()); // 20 In Progress
addTask(new AlterWorkFlowRequest2_4_0b()); // 21
addTask(new AddRoles2_4_0c()); //22
addTask(new AddPreferenceTypeForDocApprovalWorkFlow2_4_0());//23
addTask(new AlterUser2_4_0()); //24
addTask(new CreateApprovableItemKeyMapping2_4_0()); //25
// addTask(new CreateApprovableItemKeyMappingMel2_4_0()); //26
// addTask(new CreateApprovableItemKeyMappingUK2_4_0()); //27
// addTask(new CreateApprovableItemKeyMappingMel2_4_0b()); //28
addTask(new CreateApprovableItemKeyMapping2_4_0_Part2()); // 29
//////////////////////////////////////////////////////////////////
// Release 2_4_1
//////////////////////////////////////////////////////////////////
// addTask(new CopyCustomerMailTemplate2_4_1()); // 1
// // Do not uncomment until ready to run // addTask(new RollBackDWGBufferOverrunFixes_2_4_0()); //1
// addTask(new ReinstallWebcamForProximity2_4_1()); // 3
// addTask(new RemoveActionSummaryItems2_4_1()); // 4
// addTask(new FixMissingTrackingId_2_4_1()); // 5
// addTask(new FixMailViewForTasso2_4_1()); // 6
// addTask(new CopyCustomerMailTemplate2_4_1b()); // 7
// addTask(new AddNewCorrType_2_4_1()); // 8
// addTask(new RemovePeterCarrickFromSXDev_2_4_1()); // 9
// addTask(new RemoveServicePointNonPrintCenters_2_4_1()); // 10
// addTask(new AddPrintShop2_4_1()); // 11
// addTask(new RemoveJanetSmartFromKnightsbridgeUK_2_4_1()); // 12
// addTask(new AddProjectImageNSBypassTunnel_2_4_1()); // 13
// addTask(new FixWebcams_2_4_1()); // 14
// addTask(new AddDocType2_4_1()); // 15
// addTask(new RemoveMikeWrightFromCommLaw_2_4_1()); // 16
// addTask(new AddNewCorrTypes2_4_1b()); // 17
// addTask(new AddProjectImageQUTPBlock_2_4_1()); // 18
// addTask(new RemoveDuplicateMemoTasksForMultiplex_2_4_1());// 19
//////////////////////////////////////////////////////////////////
// Release 2_4_2
//////////////////////////////////////////////////////////////////
addTask(new CreateFileUploadError_2_4_2()); // 2
addTask(new FixMissingTrackingIdsFromTransHistory2_4_2()); // 3
addTask(new AlterTransHistory2_4_2()); // 4
addTask(new UpdateTransHistDateSent2_4_2()); // 5
addTask(new CreatePrtShopNotify2_4_2()); // 6
addTask(new CopyPrintShopNotificationUsers_2_4_2()); // 7
// addTask(new AddHeatherColeToAllServicePointNotifications_2_4_2()); // 8
addTask(new RemoveDSNCorrTypeFromPreferences_2_4_2()); // 9
addTask(new RemoveCurrencySymbolsFromOldTenders_2_4_2()); // 10
// addTask(new FixNullDisciplines2_4_2()); // 11
addTask(new AlterNotifications2_4_2()); // 12
//////////////////////////////////////////////////////////////////
// Release 2_4_3
//////////////////////////////////////////////////////////////////
// addTask(new ModifyNCRTemplateForMultiplex2_4_3()); // 1
// addTask(new AddDocType2_4_3()); // 2
// addTask(new IncludeMailTypeForProbuild2_4_3()); // 3
// addTask(new RenameCorrespondenceType2_4_3()); // 4
//////////////////////////////////////////////////////////////////
// Release 2_4_4
//////////////////////////////////////////////////////////////////
addTask(new FixNullDisciplines2_4_4()); // 1
// addTask(new RemovePreferenceTypeFromStaging2_4_4()); // 2
//////////////////////////////////////////////////////////////////
// Release 2_4_5
//////////////////////////////////////////////////////////////////
addTask(new AddPreferenceType2_4_5()); // 4
//////////////////////////////////////////////////////////////////
// Release 2_4_7
//////////////////////////////////////////////////////////////////
addTask(new AlterPeriodicTransaction2_4_7()); // 1
addTask(new AlterApprovalRequest_2_4_7()); // 2
addTask(new FixKeyTableEntries2_4_7()); // 3
addTask(new FixDateProblems()); // 4
addTask(new FixControlledDocIndexes2_4_7()); // 5
addTask(new FixUnRegisteredRcds2_4_7()); // 6
addTask(new AlterControlledDocTable2_4_7()); // 7
addTask(new FixUserNameSensitivity2_4_7()); // 8
addTask(new FixControlledDocIndexes2_4_7b()); // 9
//////////////////////////////////////////////////////////////////
// Release 2_4_18
//////////////////////////////////////////////////////////////////
addTask(new RemoveExternalUser_2_4_18()); // 1
//addTask(new AddLogoForBrisbaneCouncil_2_4_18()); // 2
//addTask(new CreateMailTemplateForBrisbaneCityCouncil_2_4_18()); // 3
//////////////////////////////////////////////////////////////////
// Release 2_4_19
//////////////////////////////////////////////////////////////////
addTask(new ModifyIndexes2_4_19()); // 1
addTask(new ModifyDocumentImport2_4_19()); //2
//////////////////////////////////////////////////////////////////
// Release 2_4_21
//////////////////////////////////////////////////////////////////
addTask(new AlterFileX_2_4_21()); // 1
addTask(new AddDocType2_4_21()); // 2
addTask(new AlterProjectOrganization_2_4_21()); // 3
addTask(new FixDraftDocuments_2_4_21()); // 4
addTask(new FixFunnyCharInControlledDoc_2_4_21()); // 5
addTask(new AddDocumentStatus_2_4_21()); // 6
//////////////////////////////////////////////////////////////////
// Release 2_4_22
//////////////////////////////////////////////////////////////////
addTask(new AddCorrType2_4_22()); // 1
addTask(new AddProjectImageMudgee2_4_22()); // 2
addTask(new FixWebcams2_4_22()); // 3
addTask(new ModifyCorrespondenceTable2_4_22()); // 4
addTask(new RemoveUserFromProject2_4_22()); // 5
addTask(new AddPrintShopKwikCopy2_4_22()); // 6
addTask(new ModifyCorrespondenceTable2_4_22b()); // 7
addTask(new AddBillingCalendarEntries2_4_22()); // 8
addTask(new FixTaskStatus2_4_22()); // 9
addTask(new ModifyKeyTbl2_4_22()); // 10
addTask(new ModifySizeOfOrg2_4_22()); // 11
addTask(new FixAlertTitle2_4_22()); // 12
addTask(new RemoveUserFromProject2_4_22b()); // 13
addTask(new AddDocType2_4_22()); // 14
addTask(new ModifyKeyTbl2_4_22b()); // 15
//////////////////////////////////////////////////////////////////
// Release 2_4_24
//////////////////////////////////////////////////////////////////
//
// This task does not need to be run, it has been replaced by the FixTransmittalhistTable2_4_24b
// task due to an error in it.
//addTask(new FixTransmittalhistTable2_4_24()); // 1
addTask(new NewCorrespondenceTypeRSI2_4_24()); // 2
addTask(new FixTransmittalhistTable2_4_24b()); // 3
addTask(new I866_AddHowardArchiToSAMaccasProjects2_4_24()); // 4
addTask(new I1062_AddRichmondRossToAllMaccasProjects2_4_24()); // 5
//////////////////////////////////////////////////////////////////
// Release 2_4_25
//////////////////////////////////////////////////////////////////
addTask(new IncreaseCorrTypeTitleSize2_4_25()); // 1
addTask(new AddCorrType2_4_25()); // 2
addTask(new AddCorrType2_4_25b()); // 3
addTask(new AddCorrType2_4_25c()); // 4
addTask(new AlterNextDocNo2_4_25()); // 5
addTask(new AlterNextDocNo2_4_25b()); // 6
addTask(new AddCorrType2_4_25d()); // 7
addTask(new AddDocType2_4_25()); // 8
addTask(new AddDocType2_4_25b()); // 9
addTask(new ModifyPrtshopTable2_4_25()); // 10
addTask(new AddPrintShopTomKibble2_4_25()); // 11
// addTask(new AlterNextDocNo2_4_25c()); // 12 // Request cancelled by user.
addTask(new FixUnregDocCurrentversion2_4_25()); // 13
addTask(new CopyCustomerMailTemplate2_4_25()); // 14
addTask(new TurnMailBackIntoDraft2_4_25()); // 15
addTask(new CopyMultiplexMailTemplate2_4_25()); // 16
addTask(new AddProjectImageVSpace2_4_25()); // 17
addTask(new AddDocType2_4_25c()); // 18
//
// The script below has been run, and should not run again - or on any developer's machine
addTask(new CompleteCorrAndDocMerge2_4_25()); // 19
addTask(new RemoveUserFromProject2_4_25()); // 20
addTask(new FixMultiplexTemplateView2_4_25()); // 21
//////////////////////////////////////////////////////////////////
// Release 2_4_26
//////////////////////////////////////////////////////////////////
// Commented out as they got run on staging before they were complete.
//addTask(new CreateCorrAttribute2_4_26()); // 1
//addTask(new CopyAttributeToCorrAttributeTable2_3_26()); // 2
addTask(new PrintToPDFAllowedForBrisbaneCouncil_2_4_26()); // 3
addTask(new PrintToPDFAllowedForStaging_2_4_26()); // 4
addTask(new CreateProjectEmail2_4_26()); // 5
addTask(new PrintToPDFAllowedForStaging_2_4_26b()); // 6
//addTask(new AddPreferenceType2_4_26()); // 7
addTask(new DropCorrAttribute_2_4_26()); // 8
addTask(new CreateCorrAttribute2_4_26b()); // 9
addTask(new CopyAttributeToCorrAttributeTable2_3_26b()); // 10
addTask(new PrintToPDFAllowedForAconex2_4_26()); // 11
addTask(new RenameRFIs2_4_26()); // 12
//////////////////////////////////////////////////////////////////
// Release 2_4_29
//////////////////////////////////////////////////////////////////
addTask(new CopyMultiplexMailTemplate2_4_29()); // 1
addTask(new CompleteCorrAndDocMerge2_4_29()); // 2
addTask(new CompleteCorrAndDocMerge2_4_29b()); // 3
//addTask(new AddProjectImageSOPA2_4_29()); faulty- dfc // 5
addTask(new AddProjectImageSOPA2_4_29b());
addTask(new UnlockGarbledControlledDocs2_4_29()); // 6
//addTask(new AddCorrType2_4_29()); // 7 Hold off on this one - kwines.
addTask(new AddProjectImageProximityPC2_4_29()); // 8
addTask(new AddCorrType2_4_29b()); // 10
addTask(new CopyMultiplexMailTemplate2_4_29b()); // 11
addTask(new AddCorrType2_4_29c()); // 12
addTask(new MaccasMakePublic()); // 1000 - always run last.
addTask(new MaccasManuals()); // 1001 - always run last.
addTask(new AddMaccasUsersToAllProjects()); // 1002 - always run last.
addTask(new MaccasAddUsersToStates()); //1003 - always run last.
//////////////////////////////////////////////////////////////////
// Release 2_4_30
//////////////////////////////////////////////////////////////////
addTask(new AddProjectImageAdvertizer2_4_30()); // 1
addTask(new CopyMultiplexMailTemplate2_4_30()); // 2
addTask(new FixMissingAwaitingTransmittal2_4_30()); // 3
addTask(new AddDocTypesRAAF2_4_30()); // 4
addTask(new RemoveUserFromAcnxRlltProject2_4_30()); // 5
addTask(new RemoveUsersFromGCCCAccProject2_4_30()); // 6
addTask(new AddPrintCentreSnapFootscray2_4_30()); // 7
addTask(new RemoveUserFromGCCCAccProjectB2_4_30()); // 8
addTask(new CondenseMailAttrsStHilliers2_4_30()); // 9
addTask(new SetOttowayMailToBryanTidswell2_4_30()); // 10
addTask(new FixWorkFlowRequest2_4_30()); // 11
addTask(new AddProjectImageOceanic2_4_30()); // 12
addTask(new I823_RemoveUsersFromProject2_4_30()); // 13
addTask(new I854_AddMegatoyPlaysystemsUsersToAllMaccasProjects2_4_30()); //14
addTask(new I848_AddDocType2_4_30()); // 15
addTask(new I871_RemoveUserFromProject2_4_30()); // 16
addTask(new I877_AddCDStatus2_4_30()); // 17
addTask(new I880_AddProjectImage2_4_30()); // 18
addTask(new I882_AddCorrespondenceType2_4_30()); // 19
addTask(new I887_AddNewCorrType2_4_30()); // 20
addTask(new I887_AddDocTypes2_4_30()); // 21
// addTask(new I878_AddDocType2_4_30()); // 22 -- this is a mistake! this adds corr types where it should have been doc types.
addTask(new I878_AddDocTypeB2_4_30()); // 23
addTask(new I907_AddDocStatus2_4_30()); // 25
addTask(new I907_AddDocType2_4_30()); // 26
addTask(new I907_AddReasonForTransmittal2_4_30()); // 27
// addTask(new I931_NewCorrType2_4_30()); // 28 -- added corr type instead of doc type AGAIN
addTask(new I924_RemoveUsersFromProject2_4_30()); // 29
addTask(new CopyMultiplexMailTemplate2_4_30b()); //30
addTask(new I927_AddCorrespondenceType2_4_30()); // 31
addTask(new I944_AddDocType2_4_30()); // 32
addTask(new I920_AddProjectImageTRESBC2_4_30()); // 33
addTask(new I948_RemoveUserFromProject2_4_30()); // 34
addTask(new I949_RemoveUsersFromProjects2_4_30()); // 35
addTask(new I931_AddDocType2_4_30()); // 36
addTask(new I958_NewCorrType2_4_30()); // 37
addTask(new I947_CompleteWorkRequest2_4_30()); // 38
addTask(new I956_FixDocumentMerge2_4_30()); // 39
addTask(new I956_FixDocumentMerge2_4_30b()); // 40
addTask(new I956_FixDocumentMerge2_4_30c()); // 41
addTask(new I956_FixDocumentMerge2_4_30d()); // 42
addTask(new RemoveMcDonaldsUK2_4_30()); // 43
addTask(new I990_RemoveUserFromProject2_4_30()); // 44
addTask(new I1002_AddCorrType2_4_30()); // 45
addTask(new I1002_AddCorrTypeLHR2_4_30()); // 46
addTask(new I1015_AddBluestoneOrgAdminsToAllProjects2_4_30()); // 47
addTask(new I1029_EnableTenderEdgeAsPrintShop2_4_30()); // 48
addTask(new I1021_AddProjectImageSandsOfByron2_4_30()); // 49
addTask(new I1020_AddProjectImageJuniper()); // 50
addTask(new WidenTaskField2_4_30()); // 51
addTask(new I1007_AddProjectImageSeaTemple2_4_30()); // 52
addTask(new I1011_AddProjectImageSeaTempleRB2_4_30()); // 53
addTask(new I1047_RemoveDuplicateDoctype2_4_30()); // 54
addTask(new I1055_AddPrintCentre2_4_30()); // 55
addTask(new I1055_FixPrtshopEntry2_4_30()); // 56
//////////////////////////////////////////////////////////////////
// Release 2_4_31
//////////////////////////////////////////////////////////////////
addTask(new AddPreferenceTypeForBluestoneDocFields2_4_31()); // 1
addTask(new WidenPrintJobNameField2_4_31()); // 3
addTask(new I766_ExportMultiplexMailTemplate_2_4_31()); // 4
addTask(new MergeMultiplexProjects2_4_31()); // 5 DONT RUN UNTIL PLANNED FURTHER!! - Ian.
addTask(new I766_ExportMultiplexMailViews_2_4_31()); // 6
// addTask(new I766_ImportMultiplexMailTemplate_2_4_31()); // 99 test target
// addTask(new I766_ImportMultiplexMailViews_2_4_31()); // 100 test target
//////////////////////////////////////////////////////////////////
// Release 2_4_32
//////////////////////////////////////////////////////////////////
addTask(new UpdateRapidCopyDetails2_4_32()); // 1
addTask(new CopyMultiplexMailTemplate2_4_32()); // 2
addTask(new CopyMultiplexMailTemplate2_4_32b()); // 3
addTask(new CopyMultiplexMailTemplate2_4_32c()); // 4
addTask(new AlterWorkFlowRequest2_4_32()); // 5
addTask(new CopyMultiplexMailTemplate2_4_32d()); // 6
addTask(new CopyMultiplexMailTemplate2_4_32e()); // 7
addTask(new CopyMultiplexMailTemplate2_4_32f()); // 8
addTask(new CopyMultiplexMailTemplate2_4_32g()); // 9
addTask(new CopyMultiplexMailTemplate2_4_32h()); // 10
addTask(new UpdateMultiplexFaxNos2_4_32()); // 11
addTask(new CopyMultiplexMailTemplate2_4_32i()); // 12
addTask(new AddPrintShopDigitalColour2_4_32()); // 13
addTask(new RemoveDodgyTasks2_4_32()); // 14
addTask(new EditMultiplexMailScheme_preproc2_4_32()); // 15
addTask(new EditMultiplexMailScheme2_4_32()); // 16
addTask(new EditMultiplexMailScheme_postproc2_4_32()); // 17
addTask(new RemoveProject26261_2_4_32()); // 18
addTask(new RemoveProject26309_2_4_32()); // 19
addTask(new I1017_UpdateProjectOwner2_4_32()); // 20
addTask(new I1018_ReleaseDocFromWorkflow2_4_32()); // 21
addTask(new AddPrintShopMultiplex2_4_32()); // 22
addTask(new ResetDraft2_4_32()); // 23
addTask(new AddPrintShopMytec2_4_32()); // 24
addTask(new AddCDStatus2_4_32()); // 25
addTask(new I800_AddCorrReason2_4_32()); // 26
addTask(new I864_AddDocTypes2_4_32()); // 27
addTask(new AddPrintShopGlobalCopyAndPrint2_4_32()); // 28
addTask(new AlterCorrType2_4_32()); // 29
addTask(new UpdateMangledDistribution2_4_32()); // 30
addTask(new CopyUKMultiplexMailTemplate2_4_32()); // 31
//////////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////////////////
// Release 2_4_37 (UK)
//////////////////////////////////////////////////////////////////
addTask(new I1059_AddProjectImageWembley2_4_37()); // 1
addTask(new I1058_FixSQLDatetimes2_4_37()); // 2
for(int i=0;i<20;i++){
I1004_FixMangledData2_4_37 mangledDataScript = new I1004_FixMangledData2_4_37();
mangledDataScript.setStep(3+i);
addTask(mangledDataScript);
}//3..22
for(int i=0;i<10;i++){
I1004_FixMangledData2_4_37b mangledDataScript = new I1004_FixMangledData2_4_37b();
mangledDataScript.setStep(24+i);
addTask(mangledDataScript);
}//23..32
addTask(new FixTransmittalhistTable2_4_37()); // 33
addTask(new I1032_ChangeExtUserOwnershipWhitecity2_4_37()); // 34
for(int i=0;i<10;i++){
I1004_FixMangledData2_4_37b mangledDataScript = new I1004_FixMangledData2_4_37b();
mangledDataScript.setStep(35+i);
addTask(mangledDataScript);
}//35..44
for(int i=0;i<10;i++){
I1004_FixMangledData2_4_37b mangledDataScript = new I1004_FixMangledData2_4_37b();
mangledDataScript.setStep(45+i);
mangledDataScript.setTarget("lhrfix");
addTask(mangledDataScript);
}//45..54
addTask(new I1169_ResetTemplateKeys2_4_37(55,"melfix")); // 55
addTask(new I1169_ResetTemplateKeys2_4_37(56,"lhrfix")); // 56
addTask(new I1004_ControlledDocReset2_4_37(57,"melfix")); // 57
addTask(new I1004_ControlledDocReset2_4_37(58,"lhrfix")); // 58
addTask(new I1004_FixMangledDataRecurring2_4_37(59,"melfix")); // 59
addTask(new I1004_FixMangledDataRecurring2_4_37(60,"lhrfix")); // 60
// Release 2_5_0
//////////////////////////////////////////////////////////////////
addTask(new AlterWorkFlowRequest2_5_0()); // 1
addTask(new AlterWorkFlow2_5_0()); // 2
addTask(new CreateCostItem2_5_0()); // 4
addTask(new Log4JDBAppender2_5_0()); // 5
addTask(new AlterAccessibleAsset2_5_0()); // 8
addTask(new AlterRole2_5_0()); // 9
addTask(new AlterSecuredAsset2_5_0()); // 10
addTask(new AddContractSecuredAssets2_5_0()); // 11
addTask(new AddContractRoles2_5_0()); // 12
addTask(new AlterCostItem2_5_0()); // 14
addTask(new CreatePrintJob2_5_0()); // 15
addTask(new CreatePrintRequestRecipient2_5_0()); // 16
addTask(new CopyPrintJobsFromOldVersion2_5_0()); // 17
addTask(new CopyPrintRequestRecipientsFromOldVersion2_5_0()); // 18
addTask(new I975_IndexPrintJob2_5_0()); // 19
addTask(new I975_IndexPrintRequestRecipient2_5_0()); // 20
// **Print Request tasks - Not required for 2_5_0
// addTask(new CreatePrintRequest2_5_0()); // 17 - to be completed by Hao
// addTask(new CreatePrintNote2_5_0()); // 18
// addTask(new CreatePrintGroup2_5_0()); // 19
// addTask(new CreatePrintAccount2_5_0()); // 20
// addTask(new CreatePricingSchedule2_5_0()); // 21
// **Print Request tasks - Not required for 2_5_0
addTask(new AddPreferenceTypeForCompulsoryMailAttribute2_5_0()); // 22
addTask(new AddContractSecuredAssets2_5_0b()); // 23
addTask(new AddSrvKeyEntryForFieldEnumGroup2_5_0()); // 28
addTask(new I879_FixUnregDocCurrentversion2_5_0()); // 29
addTask(new RemoveDuplicatePreferences2_5_0()); // 30
addTask(new UpdateApprovableItems2_5_0()); // 31
addTask(new UpdateWorkflowSeqNumbers2_5_0()); // 32
addTask(new I1024_Indexes()); // 33
addTask(new I1024_IndexesB()); // 34
addTask(new I1090_DeleteOldDraftPrintJobs2_5_0()); // 35
addTask(new I1090_FixPrintMediaPaperValues()); // 36
addTask(new I1079_DeleteSpuriousTemplates2_5_0()); // 37
addTask(new CopyMultiplexMailTemplate2_5_0()); // 38
addTask(new I1092_AlterNextDocNo2_5_0()); // 39
addTask(new I1116_EnableCairnsPrintingAsPrintshop2_5_0()); // 40
addTask(new I1074_RemoveStrangeCorrespondenceItem2_5_0()); // 41
addTask(new I1115_AddRamcoAsPrintshop2_5_0()); // 42
addTask(new ResetDraft2_5_0()); // 43
addTask(new I1129_AddPrintCentre2_5_0()); // 44
addTask(new I1128_AddPrintCentre2_5_0()); // 45
addTask(new I1127_AddPrintCentre2_5_0()); // 46
addTask(new I1039_ResetDraft2_5_0()); // 47
addTask(new FixTemplateNulls2_5_0()); // 48
addTask(new I1149_AddPrintCentreNevilleNewcomb2_5_0()); // 49
//addTask(new EditMultiplexMailScheme2_5_0()); // 50
//addTask(new CopyMultiplexMailTemplate2_5_0b()); // 51
//addTask(new I1148_CopyMultiplexMailTemplate2_5_0()); // 52
addTask(new I1068_AddPrintCentre2_5_0()); // 53
addTask(new I1067_AddCorrespondenceType2_5_0()); // 54
addTask(new I1123_AddCorrespondenceType2_5_0()); // 55
addTask(new I1170_RemoveUsersFromProject2_5_0()); // 56
addTask(new I1175_DeleteMail2_5_0()); // 57
addTask(new I1004_FixMangledData2_5_0 ()); // 58
//addTask(new I986_CopyMultiplexMailTemplate2_5_0()); // 59
//addTask(new I1122_CopyMultiplexMailTemplate2_5_0()); // 60
//don't put any more scripts here ... start again after 1002
addTask(new TestMailTemplateSuport_2_5_0()); // 100 - target test
addTask(new MultiServerKeyPoolConvert2_5_0()); // 1000
addTask(new AddNewServer2_5_0()); // 1001
//addTask(new I1008_FixKeyTableEntriesForPrints2_5_0()); // 1002
//addTask(new CopyMultiplexMailTemplate2_5_0c()); // 1003
/*
* NOTE:Important
* When you are adding scripts for 2.5.0 make sure,
* 1. Step should be one higher that 1000
* 2. Use getNextAvailableKey(table, column) all the time
* 3. And it comes after this set of comments :)
*
* Reason: 2.5.0 release, step 1000 and 1001 changed the structure of
* the keyPool. Above 1,2 could directly or indirectly effect the
* database integrity
*/
//////////////////////////////////////////////////////////////////
// Release 2_5_0
//////////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////////////////
// Release 2_5_1
//////////////////////////////////////////////////////////////////
// ***********New Print Shop Feature*******************
addTask(new Create_Print_MediaType_2_5_1()); //1
addTask(new Create_Print_PaperSize2_5_1()); //2
addTask(new Create_Print_Group2_5_1()); //3
addTask(new Create_Print_Shop2_5_1()); //4
addTask(new Create_Print_PriceSchedule2_5_1()); //5
addTask(new Create_PriceSchedule_Attribute2_5_1()); //6
addTask(new Create_PriceSchedule_AttributeCost2_5_1()); //7
addTask(new Create_PriceSchedule_DeliveryCategory2_5_1()); //8
addTask(new Create_PriceSchedule_DeliveryCost_2_5_1()); //9
addTask(new Create_Print_Account2_5_1()); //10
addTask(new Create_Print_Note2_5_1()); //11
addTask(new Create_Print_Request2_5_1()); //12
addTask(new AlterTablePrintRequestRecipient2_5_1()); //13
addTask(new AlterTablePrintJob2_5_1()); //14
addTask(new CopyPrintShopsFromOldVersion2_5_1()); //15
addTask(new AddPreferenceTypeForPrintShops2_5_1()); //16
addTask(new AddPreferenceForPrintShops2_5_1()); //17
addTask(new InsertDefaultMediaTypes2_5_1()); //18
addTask(new InsertDefaultPaperSizes2_5_1()); //19
addTask(new InsertDefaultPriceScheduleAttributes2_5_1()); //20
addTask(new InsertDefaultDeliveryCategory2_5_1()); //21
addTask(new CleanInconsistentPrintRequests2_5_1()); //22
addTask(new CopyPrintRequestFromOldVersion2_5_1()) ; //23
addTask(new InsertDefaultPriceSchedulesForAllPrintShops2_5_1()) ; //24
addTask(new UpdateEmailUserForPrintShops2_5_1()) ; //25
addTask(new CreateServicePointPrintGroup2_5_1()) ; //26
addTask(new I943_AddTenderTransmittalCorrType2_5_1()); // 32
addTask(new I943_AddTransmittalHistoryCorrType2_5_1()); // 33
addTask(new I943_AddCorrRspMsgTypeTenderDueBy_2_5_1()); // 34
addTask(new InsertTenderTransmittalType2_5_1()); // 35
addTask(new I943_FixCorrRspMsgTypeTenderDueBy_2_5_1()); // 36
addTask(new I1244_UndoMerge_2_5_1()); // 37
addTask(new I1232_AddPrintCentre2_5_1()); // 38
addTask(new I1242_RemoveDuplicateGlobalPrintCentre2_5_1()); // 39
addTask(new I1245_RenumberMail_2_5_1()); // 40
addTask(new RemoveProject26562_2_5_1()); // 41
addTask(new RemoveSXTemplatedMail_2_5_1()); // 42
addTask(new AlterPhoneFaxColumnSize2_5_1()); // 43
addTask(new Wembley_AddDocType2_5_1()); // 44
addTask(new CopyUKMultiplexMailTemplatesToOrg2_5_1()); // 45
addTask(new AlterCorrespondenceActionNoteColumnSize2_5_1()); // 46
addTask(new AddNewCorrespondenceTypesUK2_5_1()); // 47
addTask(new I1177AddCorrespondenceType2_5_1()); // 48
addTask(new I1273AddItncToAllMaccasProjects2_5_1()); // 49
addTask(new Wembley_AddDocStatus2_5_1()); // 50
addTask(new AlterPhoneFaxColumnSizeInProjectOrg2_5_1()); // 51
addTask(new Wembley_SetTemplatesOnOldMail2_5_1()); // 52
addTask(new Wembley_SetTemplatesOnOldMailAsDefault2_5_1()); // 53
addTask(new I1254_SetTransmittalsAsReplied2_5_1()); // 54
addTask(new Wembley_DocNo0505VersionFix2_5_1()); // 55
addTask(new AddHobsPrintGroup2_5_1()); // 56
addTask(new AddHPCPrintroomWembley2_5_1()); // 57
addTask(new AddHPCPrintroomWhitecity2_5_1()); // 58
addTask(new Wembley_DocNo05and5VersionFix2_5_1()); // 59
addTask(new Wembley_SetNullsToZero2_5_1()); // 60
addTask(new CopyMultiplexMailTemplate2_5_1()); // 61
addTask(new ACX24_NewTransmittalTemplateDropdown2_5_1()); // 62
addTask(new ACX17_AddProjectUsersToRenmark2_5_1()); // 63
addTask(new ACX56_MailNumbering2_5_1()); // 64
addTask(new ACX17_AddProjectUsersToTrinity2_5_1()); // 65
//////////////////////////////////////////////////////////////////
// Release 2_5_2
//////////////////////////////////////////////////////////////////
addTask(new InsertPreferenceType2_5_2()); // 1
addTask(new AlterWorkerPoolUser2_5_2()); // 2
addTask(new AlterUserTable2_5_2()); // 3
addTask(new CreateParserProviderTable2_5_2()); // 4
addTask(new CreatePreferenceOptionTable2_5_2()); // 5
addTask(new ConfigureFaxParserProviderGateway2_5_2()); // 6
addTask(new DefaultFaxINGatewayUK2_5_2()); // 7
addTask(new AddNewProjectProperties2_5_2()) ; // 8
addTask(new InsertMailSignaturePreferenceType2_5_2()) ; // 9
addTask(new InsertDefaultValueNotificationPreference2_5_2()) ; // 10
addTask(new I892_AlterWorkerPoolUser2_5_2()); // 11
addTask(new InsertMailAutoTextPreferenceType2_5_2()); // 12
addTask(new I704_AlterNZFaxSender2_5_2()); // 13
//////////////////////////////////////////////////////////////////
// Release 5_1_0
//////////////////////////////////////////////////////////////////
addTask(new ACX50_DeleteSmorgonSteelProject5_1_0()); // 1
addTask(new ACX254ChangePrintShopName5_1_0()); // 2
addTask(new ACX251_RemoveUserFromProject_5_1_0()); // 3
addTask(new ACX185_NewMultiplexTemplateGroup_5_1_0()); // 4
addTask(new ACX257_McDonaldsDocTypesAttributesDisciplines5_1_0()); // 5
addTask(new ACX267_ResetMailNumbering_5_1_0()); // 6
addTask(new ACX257_McDonaldsDocTypesAttributesDisciplines5_1_0b()); // 7
addTask(new ACX310_McDonaldsFixAttributesDisciplines5_1_0()); // 8
addTask(new ACX257_McDonaldsDocTypesAttributesDisciplines5_1_0c()); // 9
addTask(new ACX_182_AlterSchedulerTask5_3_0()); // 10
//////////////////////////////////////////////////////////////////
// Release 2_6_0
//////////////////////////////////////////////////////////////////
/*
addTask(new CreateBudgetCodeMask2_6_0()); // 1
addTask(new CreateBudgetItem2_6_0()); // 2
*/
//////////////////////////////////////////////////////////////////
// Release 5_2_0
//////////////////////////////////////////////////////////////////
addTask(new ACX_29_DropUnusedPrintShopTablesForMel()); //1
addTask(new ACX_31_AddPreferenceTypeForSpellCheck()); //2
addTask(new IACX_53FixTransmittalResponseStatus()); //3
addTask(new ACX247_RemoveWembleyFiles()); //4
addTask(new ACX_29_DropUnusedPrintShopTablesForUK()); //5
addTask(new ACX_218_MoveWorkflows()); //6
addTask(new ACX_266_AddCorrespondenceType()); //7
// addTask(new ACX264_FilexReport5_2_0()); // 8
addTask(new ACX330_RemoveUnintendedCorrespondence5_2_0()); // 9
addTask(new ACX_312_UnconflateCDStreams()); // 10
addTask(new ACX_266_ExtraFieldsForLDN()); // 11
//THIS TASK NEEDS TO BE UNCOMMENTED WHEN 5.2.3 IS RELEASED.
//COMMENTING IT OUT SO THAT CURRENT APPL. IS NOT AFFECTED
addTask(new ACX_306_AlterTableTenderResponse()); // 12
addTask(new ACX_260_RegisterImportDocs5_2_0()); // 13
//ANYONE ADDING A NEW TASK, PLEASE START FROM STEP NO 13.
addTask(new ACX367_RemoveStuckTask5_2_0()); // 14
addTask(new ACX_375_UnShareWembleyDocs()); // 15
addTask(new ACX_381_FixMailApprovals()); // 16
addTask(new WhiteCity_AddDocStatus()); //17
addTask(new ACX_390_RegisterImportDocs5_2_0()); // 19
addTask(new ACX_295_MaccasUKImport_1()); //20
addTask(new ACX_295_MaccasUKImport_2()); //21
addTask(new ACX_295_MaccasUKImport_3()); //22
addTask(new ACX_312_UnconflateCDStreams_2()); // 23
addTask(new ACX_396_AddDocType5_2_0()); // 24
addTask(new ACX_396_CorrectDocsValue5_2_0()); // 25
addTask(new ACX_424_ReverseShareToAllWembleyDocs()); // 26
addTask(new ACX_422_FixMergedUser()); // 27
addTask(new ACX_446_ResetMailNumbering()); // 28
addTask(new ACX_312_UnconflateCDStreams_3()); // 29
addTask(new ACX450_RemoveAutoTextPref5_2_0()); //30
addTask(new ACX454_UnshareDocs5_2_0()); //31
addTask(new ACX_477_ResetMailNumbering()); // 32
addTask(new ACX464_RejectApprovals5_2_0()); // 33
addTask(new ACX450_RemoveBadAutoText5_2_0()); // 34
//addTask(new ACX_490_RemoveWemblyDuplicateDocs5_2_0()); // 34
addTask(new ACX448_RemoveObsoleteTask5_2_0()); // 35
addTask(new ACX_295_MaccasUKImport_4()); //36
addTask(new ACX_538AddBobUserToDraftMails()); //37
addTask(new ACX_493_CompleteTerminatedWorkflowTasks5_2_0()); // 38
addTask(new ACX_520_RemoveWorkflow5_2_0()); // 39
//////////////////////////////////////////////////////////////////
// Release 5_2_3
//////////////////////////////////////////////////////////////////
// ACX_343 is awaiting customer approval, leave it commented out until then
// addTask(new ACX_343_MandatoryFax()); //1
addTask(new ACX_340_FixTransmittalTasks()); //2
addTask(new ACX_312_UnconflateCDStreams_4()); //3
addTask(new ACX_492_FixTask()); //4
addTask(new ACX_501_RemoveTemplate()); //5
addTask(new ACX_600_DeleteDocForESGeneral5_2_3()); //6
//////////////////////////////////////////////////////////////////
// Release 5_3_0
//////////////////////////////////////////////////////////////////
addTask(new ACX_39_AddNewFieldsToCurrentTemplates()); //1
addTask(new ACX_624_TermimateWorkflow5_3_0()); //2
addTask(new ACX_652_RemoveMidlandGateTemplates()); //3
addTask(new ACX_616_RemoveMailFromTask5_3_0()); //4
addTask(new ACX_624_RemoveTaskForWF10815_3_0());
addTask(new ACX_694_MailNumbering()); //6
addTask(new ACX_673_FixSupersedeCandidates()); //7
addTask(new ACX_383_RemoveStuckDrafts5_3_0()); // 8
addTask(new ACX_687_ApproveTask5_3_0()); // 9
addTask(new ACX_705_RemoveBadPreferenceEntries5_3_0()); // 10
addTask(new ACX_708_WhitecityChangeCDocVersion5_3_2()); // 11
addTask(new ACX_721_AddFolders()); // 12
addTask(new ACX_569_FixBadTasks()); // 13
addTask(new ACX_727_Remove209Duplicate5_3_2()); // 14
addTask(new ACX_726_WhitecityRemoveDuplicates5_3_2()); // 15
addTask(new ACX_569_FixMoreBadTasks()); // 16
addTask(new ACX_756_RemoveTasks()); // 17
addTask(new ACX_749_AddStatus5_3_2()); // 18
addTask(new ACX_749_McDonaldsQLDPhotoImport5_3_2()); // 19
addTask(new ACX_749_McDonaldsRegisterDoc5_3_0()); // 20
addTask(new ACX_790_MaccasUKImport_1()); // 21
addTask(new ACX_790_MaccasUKImport_2()); // 22
//////////////////////////////////////////////////////////////////
// Release 5_4_0
//////////////////////////////////////////////////////////////////
addTask(new ACX_151_InsertDefaultPreferencesforCorrTypes()); //1
addTask(new ACX_151_InsertDefaultPreferencesforDisciplines()); //2
addTask(new ACX_151_InsertModifyPreferencesforDocTypes()); //3
addTask(new ACX_261_InsertAdminToolsSecuredAsset()); //4
addTask(new ACX_489_IncreaseDocumentNo()); //5
addTask(new ACX_536_AddIndexesToTableForUserMerge()); //6
addTask(new ACX_792_AddAllMaccasUsersToAllProjects5_4_0()); // 7
addTask(new ACX_882_AddMcDonaldsDisciplinesForAll5_4_0()); //11
//////////////////////////////////////////////////////////////////
// Release 5_4_1
//////////////////////////////////////////////////////////////////
addTask(new ACX_861_InsertFolderData()); //1
addTask(new ACX_885_FixDraftMailsUK()); //2
//////////////////////////////////////////////////////////////////
// Release 5_4_2
//////////////////////////////////////////////////////////////////
addTask(new ACX_852_ModifyStyleSheetForLHR_5_4_2()); //1
addTask(new ACX_866_RemoveOldTasks()); //3
addTask(new ACX_845_ChangeJ2FaxProviderFilter5_4_2()); //4
addTask(new ACX_837_UpdatePrintShopName5_4_2()); //5
// addTask(new ACX_867_CreateCurrentCDVersions()); //6 deprecated by change made by PSMITH, do not uncomment
//Temperaraly removed, otherwise this add preferences to 1900 temp projectes created via import
//addTask(new ACX_961_AddNewDisiplines5_4_2() ); //6
//addTask(new ACX_961_AddNewAttributes5_4_2()); //7
addTask(new ACX_960_RegisterMacUKImportDoc5_4_2()); //8 //Indu: I need some import data to complete this
addTask(new ACX_984_RemoveProjectFromUser5_4_2()); //9
addTask(new ACX_961_RemoveIncorrectAttribute5_4_2()); //10
//////////////////////////////////////////////////////////////////
// RELEASE_5_4_3
//////////////////////////////////////////////////////////////////
addTask(new ACX_808_AlterWorkflowRequest5_4_3()); //1
addTask(new ACX_900_ChangeCountryMacaoToMacau()); //2
addTask(new ACX_863_MailNumbering()); //3
addTask(new ACX_399_UnconflateCDStreams()); //4
addTask(new ACX_399_SynchroniseCDLog()); //5
addTask(new ACX_919_DeleteUnwantedCorrType()); //6
// addTask(new ACX_264_CorrectFilexTableAgainPartA5_4_3()); //7
// addTask(new ACX_264_CorrectFilexTableAgainPartB5_4_3()); //8
addTask(new ACX_767_RemoveBadTask()); //9
addTask(new ACX_731_FixWorkflow()); //10
addTask(new ACX_925_FixApproval()); //11
addTask(new ACX_981_FixWorkflow()); //12
addTask(new ACX_968_FixUserMergeForMarble5_4_3()); //13
addTask(new ACX_989_MoveProject()); //14
addTask(new ACX_1019_ConfidentialMail()); //15
//Indu: I will uncomment this as when necessary, this should run as part of macuk
// import and need to synchronized with the other events
addTask(new ACX_960_RegisterImportedDocs5_4_3()); //16
addTask(new CopyToCorrectStoreNo5_4_3()); //17
addTask(new ACX_1018_FixApproval()); //18
//Indu: I will uncomment this as when necessary, this should run as part of macuk
addTask(new ACX_960_ChangeProjectNameCase5_4_3()); //19
addTask(new ACX_960_DeleteImport1Data5_4_3()); //20
addTask(new ACX_1041_ChangeApprovalRequestStatus5_4_3()); //21
addTask(new ACX_1053_ChangeApprovalClassPackage5_4_3()); //22
//////////////////////////////////////////////////////////////////
// RELEASE_5_5_0
//////////////////////////////////////////////////////////////////
addTask(new ACX_784_AddWorkFlowNotesTable()); //1
addTask(new ACX_605_AddIndexesToTaskTable5_5_0()); //2
addTask(new ACX_106_PrefTypeForTimeZone()); //3
addTask(new ACX_947_CreateFastSearchTables()); //4
addTask(new ACX_738_AddDocStatus()); //5
addTask(new ACX_1086_MailNumbering()); //6
addTask(new ACX_1099_FixApproval()); //7
addTask(new ACX_1131_RemovePCProjectTemplates()); //8
addTask(new ACX_1115_ChangeAttributeNames()); //9
//////////////////////////////////////////////////////////////////
// RELEASE_5_5_1
//////////////////////////////////////////////////////////////////
addTask(new ACX_1036_CreateCorrNoteTable5_5_1()); // 1
addTask(new ACX_1036_AddIndexToCorrNoteTable5_5_1()); // 2
addTask(new ACX_1104_Copy_MultiplexNZ_SI_To_Oz()); // 3
addTask(new ACX_1104_Copy_MultiplexNZ_SI_To_Oz_2()); // 4
addTask(new ACX_1183_AddDocumentTypes5_5_1()); // 5
addTask(new ACX_1183_ExcludeDocTypeByDefault5_1_1()); // 6
addTask(new ACX_1186_RemoveAttributeFromProject5_5_1()); // 7
addTask(new ACX_1018_FixApprovals()); // 8
addTask(new ACX_1179_MailNumbering()); // 9
addTask(new ACX_1126_RemoveBadDistribution5_5_1()); // 10
addTask(new ACX_1219_UnshareDocuments()); // 11
addTask(new ACX_1219_InsertFolderData()); // 12
addTask(new ACX_1251_RetireDocuments()); // 13
addTask(new ACX_1242_ReinstateMissingReadMailTasks5_5_1()); // 14
//addTask(new ACX_1170_UnlockControlledDocs()); // 15
addTask(new ACX_1268_WidenReferenceField5_5_1()); // 16
addTask(new ACX_1268_SetIsRegisteredForImportedDocs5_5_1()); // 17
addTask(new ACX_1158_CompleteDocRegisterSetup()); // 18
addTask(new ACX_1158_CompleteDocRegister()); // 19
addTask(new ACX_1308_FixMailToMergedUsers()); // 20
addTask(new AddCorrTypeGroupElementToKeytable()); // 21
addTask(new ACX_1104_TurnMultiplexTemplatesOn()); // 22
addTask(new ACX_1104_PostProcessing()); // 23
addTask(new ACX_1104_AddNewMultiplexScheme()); // 24
// addTask(new ACX_1352_FixSiteInstructionSchemes5_5_1()); // 26
addTask(new ACX_1365_FixApprovalTable()); //27
addTask(new ACX_1354_ChangeCorrespondenceViewIDs()); //28
addTask(new ACX_1018_FixApprovalsMay()); // 29
addTask(new ACX_1355_ReactivateApproveMailTasks()); // 30
//////////////////////////////////////////////////////////////////
// RELEASE_5_5_2
//////////////////////////////////////////////////////////////////
addTask(new ACX_1065_CreatePreferencesForFeatures5_5_2()); // 1
addTask(new ACX_1065_CreateVisiblePreferenceForFeatures5_5_2()); // 2
addTask(new ACX_1362_RemoveOrg()); // 3
addTask(new ACX_1422_UnshareDocs5_5_2()); // 4
addTask(new ACX_1416_NewSchemesTassoTest()); // 5
addTask(new ACX_1334_AddDocStatus()); // 6
addTask(new ACX_1437_MailNumbering()); // 7
addTask(new ACX_1420_FixApprovalTasks()); // 8
//////////////////////////////////////////////////////////////////
// RELEASE_5_6
//////////////////////////////////////////////////////////////////
addTask(new ACX_1182_AddSecurityRule5_6_0()); // 1
addTask(new ACX_1129_CreateTermsOfServiceTable5_6_0()); // 2
addTask(new ACX_1129_CreateTermsOfServiceLogTable5_6_0()); // 3
addTask(new ACX_1129_AddTermsOfService5_6_0()); // 4
addTask(new ACX_1129_AddTermsOfServiceUK5_6_0()); // 5
addTask(new ACX_1129_AddTermsOfServiceMcD5_6_0()); // 6
addTask(new ACX_1129_AddTermsOfServiceMcDUK5_6_0()); // 7
addTask(new ACX_1443_AcceptTermsOfService5_6_0()); // 8
addTask(new ACX_1448_AddIndexesToTOSLogTable5_6_0()); // 9
addTask(new ACX_1059_RemoveMultiplexNZTemplates()); // 10
addTask(new ACX_1458_TurnOffPrintPDFPref()); // 11
addTask(new ACX_1457_ConfidentialMail()); // 12
addTask(new ACX_1467_AddDocStatus()); // 13
addTask(new ACX_1242_ChangeMailtoReadForWembley()) ; // 14
addTask(new ACX_1459_UnlockDocuments()) ; // 15
addTask(new ACX_1469_ConfidentialMail()) ; // 16
addTask(new ACX_1466_MailNumbering()); // 17
addTask(new ACX_1475_ChangePasswordRuleForMultiplex()); // 18
addTask(new ACX_1475_ChangePasswordRuleForMultiplexUK()); // 19
addTask(new ACX_1345_AddPreferences()); // 20
addTask(new ACX_925_RemoveApprovalTask()); // 21
addTask(new ACX_1464_AddPrintShopUsersToNotify()); // 22
addTask(new ACX_1355_ResetMailApprovalTasks()); // 23
addTask(new ACX_1355_ReactivateApproveMailTasks2()); // 24
addTask(new ACX_1446_FixOrg4327()); // 25
addTask(new ACX_1679_FixApprovalTable()); // 26
//////////////////////////////////////////////////////////////////
// RELEASE_5_6_2
//////////////////////////////////////////////////////////////////
addTask(new ACX_1598_RemoveBadDistribution5_6_2()); // 1
addTask(new ACX_1622_MarkMailConfidential5_6_2()); // 2
addTask(new ACX_1592_AddDocStatus5_6_2()); // 3
addTask(new ACX_1590_AlterNextDocNo5_6_2()); // 4
addTask(new ACX_1665_AlterTdrAttachmentTable5_6_2()); // 5
addTask(new ACX_1773_AddDocStatuses()); // 6
addTask(new ACX_1629_DeleteDuplicateMailTypePrefs5_6_2()); // 7
addTask(new ACX_1718_UpdatePrintShopUserToNotify()); // 8
//////////////////////////////////////////////////////////////////
// RELEASE_5_7
//////////////////////////////////////////////////////////////////
addTask(new CreateCAOptionTable_CA()); // 1
addTask(new CreateCATerminologyTable_CA()); // 2
addTask(new ModifyContractAdminSecuredAsset_CA()); // 3
addTask(new AlterCATerminologyTable_CA()); // 4
addTask(new AlterCAOptionTable_CA()); // 5
addTask(new AlterCAOptionTable_CAb()); // 6
addTask(new CreateBudgetTable_CA()); // 7
addTask(new CreateContractTable_CA()); // 8
addTask(new CreateBudgetItemTable_CA()); // 9
addTask(new CreateBudgetItemEventLogTable_CA()); // 10
addTask(new AlterBudgetItemTable_CA()); // 12
addTask(new AlterCATerminologyColumnSize_CA()); // 13
addTask(new AlterBudgetItemTableColumnSize_CA()); // 14
addTask(new AlterContractTable_CA()); // 15
addTask(new AlterContractTable2ndTime_CA()); // 16
addTask(new AlterBudgetItemEventLogTable_CA()); // 17
addTask(new CreateContractEventLogTable_CA()); // 18
addTask(new AlterContractTable3rdTime_CA()); // 19
addTask(new AlterContractTable4thTime_CA()); // 20
addTask(new CreateVariationTable_CA()); // 21
addTask(new CreateVariationEventLogTable_CA()); // 22
addTask(new CreateVariationCorrTable_CA()); // 23
addTask(new CreateVariationLinkTable_CA()); // 24
addTask(new CreateVariationBudgetItemTable_CA()); // 25
addTask(new AlterVariationTable_CA()); // 26
addTask(new AlterCATablesSettingNotNull_CA()); // 27
addTask(new AlterContractTable5thTime_CA()); // 28
addTask(new AddToContractAdminRoles_CA()); // 29
addTask(new CreateContractGroupTable_CA()); // 30
addTask(new AlterVariationTable2ndTime_CA()); // 31
addTask(new AlterContractEventLogTable_CA()); // 32
addTask(new AlterVariationEventLogTable_CA()); // 33
addTask(new AlterVariationBudgetItemTable_CA()); // 34
addTask(new AlterVariationEventLogTable2ndTime_CA()); // 35
addTask(new AlterVariationBudgetItemTable2ndTime_CA()); // 36
//addTask(new ACX_1461_SetMailNumbering()); // 1 - needs renumbering when activated
addTask(new ACX_1695_RemoveTaskForMissingMail()); // 37
//Script moved to 5_6_2 ACX-1718 // 38
addTask(new ACX_1741_UpdatePrintShopUserToNotify()); // 39
addTask(new ACX_1820_MailNumbering()); // 40
addTask(new ACX_1774_SetTaskDone()); // 41
addTask(new ACX_1833_RemoveBadCorrespondence5_7_0()); // 42
//////////////////////////////////////////////////////////////////
// RELEASE_5_7_1
//////////////////////////////////////////////////////////////////
// addTask(new ETN_AddMembershipRequestToKeypool_5_7_1()); // 1
// addTask(new ETN_AddPhoneticColumnsToOrganizationTable5_7_1()); // 2
// addTask(new ETN_AddPhoneticColumnsToUserTable5_7_1()); // 3
// addTask(new ETN_PopulateOrganizationPhoneticFields5_7_1()); // 4
// addTask(new ETN_PopulateUserPhoneticFields5_7_1()); // 5
addTask(new ACX_1761_AddIndexToShareTable5_7_1()); // 6
addTask(new ACX_1761_AddIndexToPreferenceTable5_7_1()); // 7
addTask(new ACX_1471_AddDocSharePreferenceType5_7_1()); // 8
addTask(new ACX_1471_AddDocSharePreferences5_7_1()); // 9
addTask(new ACX_1761_AddIndexToRoleTable5_7_1()); // 10
addTask(new ACX_1862_InsertMultiplexFooters()); // 11
addTask(new ACX_1899_AddUserToTdrResponseTable_5_7_1()); // 12
addTask(new ACX_1910_RemoveTaskForMisplacedMail()); // 13
addTask(new ACX_1925_RemoveUKMultiplexTemplates()); // 14
addTask(new ACX_1882_RemoveTaskForUnsentMail()); // 15
addTask(new ACX_1919_SetTasksToApproved()); // 16
addTask(new ACX_1920_AddIndexToFileTable()); // 17
addTask(new ACX_1402_ChangeContractorsAdviceCode5_7_1()); // 18
addTask(new ACX_1896_MailNumbering()); // 19
addTask(new ACX_1964_AddPrintShopUsersToNotify()); // 20
addTask(new ACX_1928_AddTransmittalReasons()); // 21
addTask(new ACX_1971_ActivateDocumentType()); // 22
//////////////////////////////////////////////////////////////////
// RELEASE_5_7_2
//////////////////////////////////////////////////////////////////
addTask(new ACX_1849_AddIndexToProjectUserTable()); // 1
addTask(new ACX_1847_AlterIndexesForProjectOrganizationTable()); // 2
addTask(new ACX_1835_AddCorrespondexIndexes()); // 3
addTask(new ACX_1880_RemoveTransactionData()); // 4
addTask(new ACX_1941_AddIndexesToFolderTable()); // 5
addTask(new ACX_1917_AlterCorrAttributeIndexes()); // 6
addTask(new ACX_1961_AddUserxIndex()); // 7
addTask(new ACX_2003_5_7_2_Add_Missing_UserIDs_To_tender()); // 8
addTask(new ACX_2024_MailNumbering()); // 9
addTask(new MaccasUKImport_5_7_2()); // 10
addTask(new ACX_2015_DeleteUnusedOrgs()); // 11
addTask(new ACX_2050_MailNumbering()); // 12
addTask(new ACX_2048_ResetDrafts()); // 13
addTask(new MaccasUKAddAttributes_5_7_2()) ; //14
//////////////////////////////////////////////////////////////////
// Release 6_0_0 Contract Admin
//////////////////////////////////////////////////////////////////
addTask(new CAL_4_AlterContractAdminRole()); // 1
addTask(new AddContractAdminMailType6_0_0()); // 2
addTask(new AlterCAdemoTables6_0_0()); // 3
addTask(new ACX_2025_DisableCAMailTypeByDefault()); // 4
addTask(new ACX_2030_AddMailApprovalForMPXShowground()) ; //5
//////////////////////////////////////////////////////////////////
// Release 6_1_0
//////////////////////////////////////////////////////////////////
addTask(new ACX_1916_DeleteOldCompletedTasks()); // 1
addTask(new ACX_2070_IncreaseMailNumberFieldLength()) ; // 2
addTask(new ACX_2102_MakeMailConfidential()); // 3
addTask(new ACX_2060_NewDocumentStatus()); // 4
addTask(new ACX_2081_ChangeMultiplexEmails()); // 5
addTask(new ACX_2102_MakeMailMoreConfidential()); // 6
addTask(new ACX_2042_ChangePrintShopName()); // 7
addTask(new ACX_2126_MakeAnotherMailConfidential()); // 8
addTask(new ACX_2156_MailNumbering()); // 9
//////////////////////////////////////////////////////////////////
// Release 6_2_0 Login Screens and Maintenance Stuff
//////////////////////////////////////////////////////////////////
addTask(new ACX_1387_AlterUserx6_2_0()); // 1
addTask(new WR_3_AddFlagsToWebcams6_2_0()); // 2
addTask(new WR_8_MoveExistingWebcamArchives_6_2_0()); // 3
addTask(new ACX_2084_IncreasePrintNoteFieldSize()); // 4
addTask(new ACX_2063_DROPCLUSTER_TRANSMITTALHIST()); // 5
addTask(new ACX_2063_RECLUSTER_TRANSMITTALHIST()); // 6
addTask(new ACX_2063_InstallStoredProc_TransmittalHistoryByDoc()); // 7
addTask(new ACX_2105_SetProjectImageToWebcamMEL()); //8
addTask(new ACX_2117_SetProjectImageToWebcamLHR()); //9
addTask(new ACX_2148_ResetRegentPlcWebcamATStatus()); //10
addTask(new WR_8_MoveExistingWebcamArchivesLHR()); // 11
addTask(new ACX_2239_ChangePrintShopName()); // 12
addTask(new ACX_2157_RemoveOldMailApprovals()); // 13
addTask(new ACX_2156_SetMailNumber()); // 14
addTask(new ACX_2229_ChangeMailTypes()); //15
addTask(new ACX_2251_UpdateResetPasswordFieldForAllPrintShopUsers());// 16
//////////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////////////////
// RELEASE_6_3_0
//////////////////////////////////////////////////////////////////
addTask(new ETN_AddMembershipRequestToKeypool()); // 1
addTask(new ETN_AddPhoneticColumnsToOrganizationTable()); // 2
addTask(new ETN_AddPhoneticColumnsToUserTable()); // 3
addTask(new ETN_PopulateOrganizationPhoneticFields()); // 4
addTask(new ETN_PopulateUserPhoneticFields()); // 5
addTask(new ACX_2263_AddCompositeIndexToTaskTable()) ; //6
addTask(new ACX_2278_ChangeMailTypes()); //7
addTask(new ACX_2307_RemoveOldMailApprovals()); //8
addTask(new ACX_1389_RemoveDocApprovalTasks()); //9
addTask(new ACX_2284_RemoveOldMailApprovals()) ; //10
addTask(new ACX_2370_ChangeProjectOwner()); //11
//29Jun05 EBaillie: These scripts all moved to 5.7
//////////////////////////////////////////////////////////////////
// RELEASE_6_3_1
//////////////////////////////////////////////////////////////////
addTask(new ACX_2283_MailNumbering()); // 1
addTask(new ACX_2274_RemoveDraftMail()); // 2
addTask(new ACX_2377_YetAnotherMailConfidential()); // 3
addTask(new ACX_2378_FixDocsInWorkFlow()); // 4
//////////////////////////////////////////////////////////////////
// RELEASE_6_3_2
//////////////////////////////////////////////////////////////////
addTask(new ACX_2409_EnableWorkflowsAndTendersMPX_UK()); //1
addTask(new ACX_2409_EnableWorkflowsAndTendersMPX_AU()); //2
addTask(new ACX_2512_MailNumbering()); //3
addTask(new ACX_2513_RemoveDocApprovalTask()); //4
//////////////////////////////////////////////////////////////////
// RELEASE_6_4_0
//////////////////////////////////////////////////////////////////
addTask(new ACX_2244_CreateDMSLookupTable()); //1
addTask(new ACX_2252_AddDocFileToKeyPool()); //2
addTask(new ACX_2343_AddPrefTypePreloadJVM()); //3
addTask(new ACX_2493_MakeMailConfidential()) ; //4
addTask(new ACX_2230_MailNumberingMerge_Contractors()); // 5
addTask(new ACX_2230_MailNumberingMerge_Emtech()); // 6
addTask(new ACX_2448_ChangeProjectOwnerIkea()); // 8
addTask(new ACX_2521_MarkCorrConfidential()); // 9
// Commented out until it can be tested properly
// addTask(new ACX_2444_DuplicateMailTypes()); // 10
//////////////////////////////////////////////////////////////////
// RELEASE_6_4_1
//////////////////////////////////////////////////////////////////
addTask(new ACX_2450_MarkCorrConfidential()); // 1
addTask(new ACX_2569_MakeMailConfidential()); // 2
//////////////////////////////////////////////////////////////////
// RELEASE_6_5_0
//////////////////////////////////////////////////////////////////
addTask(new ACX_1763_ApprovableItemCommandClass()); // 1
addTask(new ACX_1659_UpdateFaxPrefOptionsLhr()); // 2
addTask(new ACX_1659_UpdateFaxPrefOptionsMel()); // 3
addTask(new ACX_1678_RemoveMailTemplatePrefType()); // 4
addTask(new ACX_2396_ReInstallStoredProc_TransmittalHistoryByDoc());// 5
//////////////////////////////////////////////////////////////////
// RELEASE_6_5_2
//////////////////////////////////////////////////////////////////
addTask(new ACX_2609_MailNumberChange()); // 1
addTask(new ACX_2637_CompleteUnregDocTasks()); // 2
addTask(new ACX_1568_AddIndexToControlledDocTable()); // 3
addTask(new ACX_2592_ActivateMailType()); // 4
addTask(new ACX_2645_ActivateMailType()); // 5
//////////////////////////////////////////////////////////////////
// RELEASE_6_5_3
//////////////////////////////////////////////////////////////////
addTask(new ACX_2656_ChangeMailFromOrgId()); // 1
addTask(new ACX_2639_RemoveUnreadMailTasks()); // 2
addTask(new ACX_2696_AddNewDocumentStatus()); // 3
addTask(new ACX_2602_RemoveMailType()); // 4
//////////////////////////////////////////////////////////////////
// RELEASE_6_5_4
//////////////////////////////////////////////////////////////////
addTask(new ACX_2686_RemoveTask()); // 1
addTask(new ACX_2599_UpdateAndDeleteMailAttributes()); // 2
//////////////////////////////////////////////////////////////////
// RELEASE_6_5_5
//////////////////////////////////////////////////////////////////
addTask(new ACX_2761_DeleteMailTypeAddedToAllProjects()); // 1
// addTask(new ACX_2715_RemoveMailTypeFromProject()); // 2
addTask(new ACX_2686_RemoveOverdueMailTask()); // 3
addTask(new ACX_2298_RemoveInvalidMailTask_RTRFI()); // 4
addTask(new ACX_2298_RemoveInvalidMailTask_RFI()); // 5
addTask(new ACX_2786_RemoveCorruptedAutoTextEntry()); //6
addTask(new ACX_LOTS_RemoveSwagOfDodgyTasks()); //7
addTask(new ACX_2891_PrintShopSecurityCheckIndex()); //8
//////////////////////////////////////////////////////////////////
// RELEASE_6_5_6
//////////////////////////////////////////////////////////////////
addTask(new ACX_2946_RemoveStuckTasks()); // 1
//////////////////////////////////////////////////////////////////
// RELEASE_7_0_0
//////////////////////////////////////////////////////////////////
addTask(new ACX_2362_IncreaseMailNumberFieldLength()); // 1
addTask(new PDF_105_AddPDFSecuredAsset()); // 2
addTask(new ACX_2983_Index_on_ReferenceId_Task()); // 3
//////////////////////////////////////////////////////////////////
// RELEASE_7_0_1
//////////////////////////////////////////////////////////////////
addTask(new MDF_21_DefinitiveAttributes()); // 1
//addTask(new MDF_21_DefinitiveDisciplines()); // 2
addTask(new MDF_39_DefinitiveDocTypes()); // 3
addTask(new MDF_39_DefinitiveStatuses()); // 4
addTask(new MDF_25_AU_RemapDisciplines()); // 5
addTask(new MDF_33_AU_DefinitiveAttributes()); // 6
addTask(new MDF_43_AU_DefinitiveDisciplinesDecorFix()); // 7
addTask(new MDF_34_AU_RemapWhyallaOrgID()); // 8
addTask(new MDF_25_AU_RemapDecorDiscipline()); //9
//////////////////////////////////////////////////////////////////
// RELEASE_7_0_4
//////////////////////////////////////////////////////////////////
addTask(new ACX_3025_DocFileUniqueIndex()); // 1
addTask(new ACX_3033_CleanUpDisciplinesOnGeneral()); // 2
addTask(new ACX_3026_FixDocsInWorkFlow()); // 3
//////////////////////////////////////////////////////////////////
// RELEASE_7_0_5
//////////////////////////////////////////////////////////////////
addTask(new ACX_2232_CleanUpDisciplinesLHR()); // 1
addTask(new ACX_3396_FixWorkflowStatusLHR()); // 2
//////////////////////////////////////////////////////////////////
// RELEASE_7_0_6
//////////////////////////////////////////////////////////////////
addTask(new ACX_2560_CleanUpDisciplinesMPX_LongBayProject()); //1
addTask(new ACX_3062_FixFooBarredDateInProject()); //2
addTask(new ACX_3089_ResetFaxAccountForOldOrg()); //3
//////////////////////////////////////////////////////////////////
// RELEASE_7_1_0
//////////////////////////////////////////////////////////////////
// addTask(new ACX_1276_AddQuartzTables()); // 1
addTask(new ACX_2054_AddPrefMailSecondaryAttribute7_1_0()); // 2
addTask(new ACX_2054_AddPrefCompulsoryMailSecondaryAttrib7_1_0()); // 3
addTask(new ACX_2054_AlterCorrAttributeTable7_1_0()); // 4
addTask(new ACX_2703_UpdateDocStatusPrefType7_1_0()); // 5
addTask(new ACX_2678_AddSecurityPreference()) ; // 6
addTask(new ACX_2260_CreateSavedSearchTable7_1_0()); // 7
addTask(new ACX_3107_AlterNotificationExtraDataColumn()); // 8
addTask(new ACX_3215_AddSuperSearchSecuredAsset()); // 9
addTask(new ACX_3148_CreateUserxMergeTable7_1_0()); // 10
//////////////////////////////////////////////////////////////////
// RELEASE_8_0_0 Internationalization
//////////////////////////////////////////////////////////////////
addTask(new InsertLanguagePreference8_0_0()); // 1
addTask(new ModifyDatabaseVarchar8_0_0()); // 2
addTask(new IN_26_RemovePayloadXml8_0_0()); // 3
addTask(new IN_22_ModifyDatabaseText8_0_0()); // 4
addTask(new IN_50_CreateCorrTypeLiteralTable8_0_0()); // 5
addTask(new IN_56_CreateDocTypeLiteralTable8_0_0()); // 6
//////////////////////////////////////////////////////////////////
// Hack Release
//////////////////////////////////////////////////////////////////
addTask(new SynchronizeKeyTable()); //1
addTask(new ImportUserandOrgForWembley()); //2
addTask(new ImportMailForWembly()); //3
addTask(new RegisterWembleyCDocs()); //4
addTask(new UpdateMailNumbersForWembley()); //5
addTask(new ACX_396_DetachedFiles1000001_1_1()); //6
addTask(new ACX_396_AttachNewFiles1000001_1_1()); //7
addTask(new ACX_517_WembleyAttachMoreFiles1000001_1_1()); //8
addTask(new ACX_812_McImportAttachmentFix1000001_1_1()); //9
addTask(new ACX_264_CorrectFilexTableAgainPartA1000001_1_1()); //10
addTask(new ACX_264_CorrectFilexTableAgainPartB1000001_1_1()); //11
addTask(new IN_67_FixSupportedLocales()); // 12
}
public static void main(String args[]) {
Install start = new Install();
int retval = -1;
try {
//PropertyConfigurator.configure();
start.configLog4j();
//start.welcomeMessage();
start.setupCommandLine(start.getArgumentSet());
if (!start.parseCommandLine(args)) {
start.usage();
retval = 3;
} else {
retval = start.run();
}
} catch (Exception e) {
e.printStackTrace();
} finally {
start.cleanup();
}
System.exit(retval);
}
}