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); } }