Table of Contents
1. Migración a versión 4 (3.3.4.5.17)
Desde versión 2 (3.2.2.25.43)
- Se contempla la migración desde la versión 3.2.2.25.43
- Realizar la actualización de personalizaciones, cualquier cambio en los SQL debe implmentarse en los archivos correspondientes de la nueva versión.
- Por los cambios en la estructura de tablas relacionadas con el DRobot.exe, verificar la configuración de cuentas de correo e ingresar nuevamente contraseña para su encripción.
- Para migración desde versión 3, pueden ejecutarse menos actualizaciones y cambios en la base de datos.
Después de actualizar los archivos de Software y los sitios, realizar las siguientes actualizaciones de base de datos con el SetupBox1).
Nuevo!
Función para verificación en un solo paso de archivos cfg2), tablas y actualizaciones de versión.
Función para verificación en un solo paso de archivos cfg2), tablas y actualizaciones de versión.
- En SetupBox > Módulos > Común
Para la versión 3.2.2.17 se deben instalar las siguientes actualizaciones:
- Dar clic en Check Upgrade
- Para actualizar la versión en base de datos:
Dar clic en Apply Upgrade.
- Habilitar la casilla Full Update para incluir los pasos de verificación de archivos .cfg y tablas/campos
- En caso de no activar la casilla Full Update se van a realizar unicamente las actualizaciones de versión pendientes
Se generará resultado de las operaciones y se indicará si fue correcta o no la actualización:
Resumen de verificación y actualización de los service pack
-------------------- Build BDD Basic----------------------- Generate:Common Generate:SetupBox Generate:DataLink Generate:CMDB Generate:Atis Generate:DRobot Generate:Demo -------------------- Verify BDD Basic----------------------- Create BDD:Common Create BDD:SetupBox Create BDD:DataLink Create BDD:CMDB Create BDD:Atis Create BDD:DRobot Create BDD:Demo -- Interno Service Prefix[Common] BDD[mdf] -- YES NEW_TABLE TABLE:ITHCLOG FIELD:IDITHCLOG SQL:CREATE TABLE ITHCLOG ([IDITHCLOG]INTEGER IDENTITY(1,1), CONSTRAINT IDITHCLOG1 UNIQUE ([IDITHCLOG])) YES NEW_COLUMN TABLE:ITHCLOG FIELD:IDLOGCODE SQL:ALTER TABLE ITHCLOG ADD [IDLOGCODE]VARCHAR(50) YES NEW_COLUMN TABLE:ITHCLOG FIELD:LOG_DATECHANGE SQL:ALTER TABLE ITHCLOG ADD [LOG_DATECHANGE]DATETIME YES NEW_COLUMN TABLE:ITHCLOG FIELD:LOG_IDCMDBCIUSER SQL:ALTER TABLE ITHCLOG ADD [LOG_IDCMDBCIUSER]INTEGER YES NEW_COLUMN TABLE:ITHCLOG FIELD:LOG_DESCRIPTION SQL:ALTER TABLE ITHCLOG ADD [LOG_DESCRIPTION]VARCHAR(100) YES NEW_COLUMN TABLE:ITHCLOG FIELD:LOG_TABLE SQL:ALTER TABLE ITHCLOG ADD [LOG_TABLE]VARCHAR(50) YES NEW_COLUMN TABLE:ITHCLOG FIELD:LOG_TYPECHANGE SQL:ALTER TABLE ITHCLOG ADD [LOG_TYPECHANGE]INTEGER YES NEW_COLUMN TABLE:ITHCLOG FIELD:LOG_DATA SQL:ALTER TABLE ITHCLOG ADD [LOG_DATA]TEXT -- Interno Service Prefix[SetupBox] BDD[mdf] -- changes were not in the database. -- Interno Service Prefix[DataLink] BDD[mdf] -- changes were not in the database. -- Interno Service Prefix[CMDB] BDD[mdf] -- YES NEW_COLUMN TABLE:CMDBCIDEFINEEXTRAFIELDS FIELD:EXTRAFIELDS_FILESRVTYPE SQL:ALTER TABLE CMDBCIDEFINEEXTRAFIELDS ADD [EXTRAFIELDS_FILESRVTYPE]INTEGER YES NEW_COLUMN TABLE:CMDBCIDEFINEEXTRAFIELDS FIELD:EXTRAFIELDS_FILESRVSTYLETYPE1 SQL:ALTER TABLE CMDBCIDEFINEEXTRAFIELDS ADD [EXTRAFIELDS_FILESRVSTYLETYPE1]INTEGER -- Interno Service Prefix[Atis] BDD[mdf] -- YES NEW_COLUMN TABLE:MDSERVICEEXTRAFIELDS FIELD:EXTRAFIELDS_FILESRVTYPE SQL:ALTER TABLE MDSERVICEEXTRAFIELDS ADD [EXTRAFIELDS_FILESRVTYPE]INTEGER YES NEW_COLUMN TABLE:MDSERVICEEXTRAFIELDS FIELD:EXTRAFIELDS_FILESRVSTYLETYPE1 SQL:ALTER TABLE MDSERVICEEXTRAFIELDS ADD [EXTRAFIELDS_FILESRVSTYLETYPE1]INTEGER YES NEW_COLUMN TABLE:GPEDIT_COLUMN FIELD:EXTRAFIELDS_FILESRVTYPE SQL:ALTER TABLE GPEDIT_COLUMN ADD [EXTRAFIELDS_FILESRVTYPE]INTEGER YES NEW_COLUMN TABLE:GPEDIT_COLUMN FIELD:EXTRAFIELDS_FILESRVSTYLETYPE1 SQL:ALTER TABLE GPEDIT_COLUMN ADD [EXTRAFIELDS_FILESRVSTYLETYPE1]INTEGER YES NEW_COLUMN TABLE:GPDETAIL FIELD:GPDETAIL_INDEX SQL:ALTER TABLE GPDETAIL ADD [GPDETAIL_INDEX]INTEGER YES NEW_COLUMN TABLE:SDNOTIFY FIELD:ISSENDWHATSAPP SQL:ALTER TABLE SDNOTIFY ADD [ISSENDWHATSAPP]BIT YES NEW_TABLE TABLE:EV_EXTRA_SDCASE FIELD:IDEV_EXTRA_SDCASE SQL:CREATE TABLE EV_EXTRA_SDCASE ([IDEV_EXTRA_SDCASE]INTEGER IDENTITY(1,1), CONSTRAINT IDEV_EXTRA_SDCASE1 UNIQUE ([IDEV_EXTRA_SDCASE])) YES NEW_COLUMN TABLE:EV_EXTRA_SDCASE FIELD:IDEV_EXCEPTION_CASE SQL:ALTER TABLE EV_EXTRA_SDCASE ADD [IDEV_EXCEPTION_CASE]INTEGER, CONSTRAINT IDEV_EXTRA_SDCASE2 FOREIGN KEY ([IDEV_EXCEPTION_CASE]) REFERENCES EV_EXCEPTION_CASE([IDEV_EXCEPTION_CASE]) YES NEW_COLUMN TABLE:EV_EXTRA_SDCASE FIELD:DREXTRATYPE SQL:ALTER TABLE EV_EXTRA_SDCASE ADD [DREXTRATYPE]INTEGER YES NEW_COLUMN TABLE:EV_EXTRA_SDCASE FIELD:EXTRA_EDITVALUES SQL:ALTER TABLE EV_EXTRA_SDCASE ADD [EXTRA_EDITVALUES]TEXT YES NEW_COLUMN TABLE:EV_EXTRA_SDCASE FIELD:EXTRA_BODYTEXT SQL:ALTER TABLE EV_EXTRA_SDCASE ADD [EXTRA_BODYTEXT]TEXT YES NEW_COLUMN TABLE:EV_EXTRA_SDCASE FIELD:EXTRA_BODYTEXT_BA SQL:ALTER TABLE EV_EXTRA_SDCASE ADD [EXTRA_BODYTEXT_BA]VARBINARY(MAX) YES NEW_COLUMN TABLE:EV_EXTRA_SDCASE FIELD:EXTRA_SUBJECT SQL:ALTER TABLE EV_EXTRA_SDCASE ADD [EXTRA_SUBJECT]TEXT YES NEW_COLUMN TABLE:EV_EXTRA_SDCASE FIELD:EXTRA_ATTACH SQL:ALTER TABLE EV_EXTRA_SDCASE ADD [EXTRA_ATTACH]TEXT YES NEW_COLUMN TABLE:EV_EXTRA_SDCASE FIELD:EXTRA_SDCASE_DATE_CREATE SQL:ALTER TABLE EV_EXTRA_SDCASE ADD [EXTRA_SDCASE_DATE_CREATE]DATETIME YES NEW_COLUMN TABLE:EV_EXTRA_SDCASE FIELD:EXTRA_SDCASE_DATE_ASIGNED SQL:ALTER TABLE EV_EXTRA_SDCASE ADD [EXTRA_SDCASE_DATE_ASIGNED]DATETIME YES NEW_COLUMN TABLE:EV_EXTRA_SDCASE FIELD:EXTRA_SDCASE_STATUS SQL:ALTER TABLE EV_EXTRA_SDCASE ADD [EXTRA_SDCASE_STATUS]INTEGER YES NEW_COLUMN TABLE:EV_EXTRA_SDCASE FIELD:IDSDCASE SQL:ALTER TABLE EV_EXTRA_SDCASE ADD [IDSDCASE]INTEGER YES NEW_TABLE TABLE:EV_VOIP_SDCASE FIELD:IDEV_VOIP_SDCASE SQL:CREATE TABLE EV_VOIP_SDCASE ([IDEV_VOIP_SDCASE]INTEGER IDENTITY(1,1), CONSTRAINT IDEV_VOIP_SDCASE1 UNIQUE ([IDEV_VOIP_SDCASE])) YES NEW_COLUMN TABLE:EV_VOIP_SDCASE FIELD:IDEV_EXCEPTION_CASE SQL:ALTER TABLE EV_VOIP_SDCASE ADD [IDEV_EXCEPTION_CASE]INTEGER, CONSTRAINT IDEV_VOIP_SDCASE2 FOREIGN KEY ([IDEV_EXCEPTION_CASE]) REFERENCES EV_EXCEPTION_CASE([IDEV_EXCEPTION_CASE]) YES NEW_COLUMN TABLE:EV_VOIP_SDCASE FIELD:CONTACTDEFINE1 SQL:ALTER TABLE EV_VOIP_SDCASE ADD [CONTACTDEFINE1]VARCHAR(150) YES NEW_COLUMN TABLE:EV_VOIP_SDCASE FIELD:IDCMDBCONTACTTYPE1 SQL:ALTER TABLE EV_VOIP_SDCASE ADD [IDCMDBCONTACTTYPE1]INTEGER YES NEW_COLUMN TABLE:EV_VOIP_SDCASE FIELD:CONTACTDEFINE2 SQL:ALTER TABLE EV_VOIP_SDCASE ADD [CONTACTDEFINE2]VARCHAR(150) YES NEW_COLUMN TABLE:EV_VOIP_SDCASE FIELD:IDCMDBCONTACTTYPE2 SQL:ALTER TABLE EV_VOIP_SDCASE ADD [IDCMDBCONTACTTYPE2]INTEGER YES NEW_COLUMN TABLE:EV_VOIP_SDCASE FIELD:VOIP_BODYTEXT SQL:ALTER TABLE EV_VOIP_SDCASE ADD [VOIP_BODYTEXT]TEXT YES NEW_COLUMN TABLE:EV_VOIP_SDCASE FIELD:VOIP_BODYTEXT_BA SQL:ALTER TABLE EV_VOIP_SDCASE ADD [VOIP_BODYTEXT_BA]VARBINARY(MAX) YES NEW_COLUMN TABLE:EV_VOIP_SDCASE FIELD:VOIP_SUBJECT SQL:ALTER TABLE EV_VOIP_SDCASE ADD [VOIP_SUBJECT]TEXT YES NEW_COLUMN TABLE:EV_VOIP_SDCASE FIELD:VOIP_ATTACH SQL:ALTER TABLE EV_VOIP_SDCASE ADD [VOIP_ATTACH]TEXT YES NEW_COLUMN TABLE:EV_VOIP_SDCASE FIELD:VOIP_SDCASE_DATE_CREATE SQL:ALTER TABLE EV_VOIP_SDCASE ADD [VOIP_SDCASE_DATE_CREATE]DATETIME YES NEW_COLUMN TABLE:EV_VOIP_SDCASE FIELD:VOIP_SDCASE_DATE_ASIGNED SQL:ALTER TABLE EV_VOIP_SDCASE ADD [VOIP_SDCASE_DATE_ASIGNED]DATETIME YES NEW_COLUMN TABLE:EV_VOIP_SDCASE FIELD:VOIP_SDCASE_STATUS SQL:ALTER TABLE EV_VOIP_SDCASE ADD [VOIP_SDCASE_STATUS]INTEGER YES NEW_COLUMN TABLE:EV_VOIP_SDCASE FIELD:IDSDCASE SQL:ALTER TABLE EV_VOIP_SDCASE ADD [IDSDCASE]INTEGER YES NEW_TABLE TABLE:TE_TESTIGOSATTACH FIELD:IDEV_VOIP_SDCASE SQL:CREATE TABLE TE_TESTIGOSATTACH ([IDEV_VOIP_SDCASE]INTEGER IDENTITY(1,1), CONSTRAINT IDTE_TESTIGOSATTACH1 UNIQUE ([IDEV_VOIP_SDCASE])) YES NEW_COLUMN TABLE:TE_TESTIGOSATTACH FIELD:CEDULA SQL:ALTER TABLE TE_TESTIGOSATTACH ADD [CEDULA]VARCHAR(15) YES NEW_COLUMN TABLE:TE_TESTIGOSATTACH FIELD:URL SQL:ALTER TABLE TE_TESTIGOSATTACH ADD [URL]TEXT YES NEW_COLUMN TABLE:TE_TESTIGOSATTACH FIELD:PATH SQL:ALTER TABLE TE_TESTIGOSATTACH ADD [PATH]TEXT YES NEW_COLUMN TABLE:TE_TESTIGOSATTACH FIELD:EXTRA_ATTACH SQL:ALTER TABLE TE_TESTIGOSATTACH ADD [EXTRA_ATTACH]TEXT YES NEW_TABLE TABLE:DR_TRIGGER_SQLCONDITION FIELD:IDDR_TRIGGER_SQLCONDITION SQL:CREATE TABLE DR_TRIGGER_SQLCONDITION ([IDDR_TRIGGER_SQLCONDITION]INTEGER IDENTITY(1,1), CONSTRAINT IDDR_TRIGGER_SQLCONDITION1 UNIQUE ([IDDR_TRIGGER_SQLCONDITION])) YES NEW_COLUMN TABLE:DR_TRIGGER_SQLCONDITION FIELD:DRT_SQLCONDITION_NAME SQL:ALTER TABLE DR_TRIGGER_SQLCONDITION ADD [DRT_SQLCONDITION_NAME]VARCHAR(100) YES NEW_COLUMN TABLE:DR_TRIGGER_SQLCONDITION FIELD:DRT_SQLCONDITION_DESCRIPTION SQL:ALTER TABLE DR_TRIGGER_SQLCONDITION ADD [DRT_SQLCONDITION_DESCRIPTION]TEXT YES NEW_COLUMN TABLE:DR_TRIGGER_SQLCONDITION FIELD:DRT_SQLCONDITION_SQL SQL:ALTER TABLE DR_TRIGGER_SQLCONDITION ADD [DRT_SQLCONDITION_SQL]TEXT YES NEW_TABLE TABLE:DR_TRIGGER_ACTIONCASE FIELD:IDDR_TRIGGER_ACTIONCASE SQL:CREATE TABLE DR_TRIGGER_ACTIONCASE ([IDDR_TRIGGER_ACTIONCASE]INTEGER IDENTITY(1,1), CONSTRAINT IDDR_TRIGGER_ACTIONCASE1 UNIQUE ([IDDR_TRIGGER_ACTIONCASE])) YES NEW_COLUMN TABLE:DR_TRIGGER_ACTIONCASE FIELD:IDEV_EXCEPTION_CASE SQL:ALTER TABLE DR_TRIGGER_ACTIONCASE ADD [IDEV_EXCEPTION_CASE]INTEGER, CONSTRAINT IDDR_TRIGGER_ACTIONCASE2 FOREIGN KEY ([IDEV_EXCEPTION_CASE]) REFERENCES EV_EXCEPTION_CASE([IDEV_EXCEPTION_CASE]) YES NEW_COLUMN TABLE:DR_TRIGGER_ACTIONCASE FIELD:IDDR_TRIGGER_SQLCONDITION SQL:ALTER TABLE DR_TRIGGER_ACTIONCASE ADD [IDDR_TRIGGER_SQLCONDITION]INTEGER, CONSTRAINT IDDR_TRIGGER_ACTIONCASE3 FOREIGN KEY ([IDDR_TRIGGER_SQLCONDITION]) REFERENCES DR_TRIGGER_SQLCONDITION([IDDR_TRIGGER_SQLCONDITION]) YES NEW_COLUMN TABLE:DR_TRIGGER_ACTIONCASE FIELD:DRT_ACTIONCASE_NAME SQL:ALTER TABLE DR_TRIGGER_ACTIONCASE ADD [DRT_ACTIONCASE_NAME]VARCHAR(100) YES NEW_COLUMN TABLE:DR_TRIGGER_ACTIONCASE FIELD:DRT_ACTIONCASE_DESCRIPTION SQL:ALTER TABLE DR_TRIGGER_ACTIONCASE ADD [DRT_ACTIONCASE_DESCRIPTION]TEXT YES NEW_COLUMN TABLE:TOPICSRESPONSE FIELD:IMAGECODEDISPLAYSCREEN SQL:ALTER TABLE TOPICSRESPONSE ADD [IMAGECODEDISPLAYSCREEN]TEXT -- Interno Service Prefix[DRobot] BDD[mdf] -- YES NEW_COLUMN TABLE:DREMAILACCOUNTSDETAIL FIELD:SSL SQL:ALTER TABLE DREMAILACCOUNTSDETAIL ADD [SSL]BIT YES NEW_COLUMN TABLE:DREMAILACCOUNTSDETAIL FIELD:AUTHTYPE SQL:ALTER TABLE DREMAILACCOUNTSDETAIL ADD [AUTHTYPE]INTEGER YES NEW_COLUMN TABLE:DREMAILACCOUNTSDETAIL FIELD:USEHTTPLISTENEROAUTH SQL:ALTER TABLE DREMAILACCOUNTSDETAIL ADD [USEHTTPLISTENEROAUTH]BIT YES NEW_COLUMN TABLE:DREMAILACCOUNTSDETAIL FIELD:USEDEFAULTBROWSEROAUTH SQL:ALTER TABLE DREMAILACCOUNTSDETAIL ADD [USEDEFAULTBROWSEROAUTH]BIT YES NEW_COLUMN TABLE:DREMAILACCOUNTSDETAIL FIELD:PROTOCOL SQL:ALTER TABLE DREMAILACCOUNTSDETAIL ADD [PROTOCOL]INTEGER YES NEW_COLUMN TABLE:DREMAILACCOUNTSDETAIL FIELD:LEAVECOPYMESSAGESERVER SQL:ALTER TABLE DREMAILACCOUNTSDETAIL ADD [LEAVECOPYMESSAGESERVER]BIT YES NEW_COLUMN TABLE:DREMAILACCOUNTSDETAIL FIELD:CLIENTID SQL:ALTER TABLE DREMAILACCOUNTSDETAIL ADD [CLIENTID]VARCHAR(100) YES NEW_COLUMN TABLE:DREMAILACCOUNTSDETAIL FIELD:SECRETID SQL:ALTER TABLE DREMAILACCOUNTSDETAIL ADD [SECRETID]VARCHAR(100) YES NEW_COLUMN TABLE:DREMAILACCOUNTSDETAIL FIELD:TENANTID SQL:ALTER TABLE DREMAILACCOUNTSDETAIL ADD [TENANTID]VARCHAR(100) YES NEW_COLUMN TABLE:DREMAILACCOUNTSDETAIL FIELD:SERVERREQUIRESUSERAUTHENTICATION SQL:ALTER TABLE DREMAILACCOUNTSDETAIL ADD [SERVERREQUIRESUSERAUTHENTICATION]BIT YES NEW_COLUMN TABLE:DREMAILACCOUNTSDETAIL FIELD:CONNECTIONTYPET SQL:ALTER TABLE DREMAILACCOUNTSDETAIL ADD [CONNECTIONTYPET]INTEGER YES NEW_COLUMN TABLE:DREMAILACCOUNTSDETAIL FIELD:TOKEN SQL:ALTER TABLE DREMAILACCOUNTSDETAIL ADD [TOKEN]VARBINARY(MAX) YES NEW_COLUMN TABLE:DREMAILACCOUNTSDETAIL FIELD:TOKENREFRESH SQL:ALTER TABLE DREMAILACCOUNTSDETAIL ADD [TOKENREFRESH]VARBINARY(MAX) YES NEW_TABLE TABLE:DRVOIP_ACCOUNT FIELD:IDDRVOIP_ACCOUNT SQL:CREATE TABLE DRVOIP_ACCOUNT ([IDDRVOIP_ACCOUNT]INTEGER IDENTITY(1,1), CONSTRAINT IDDRVOIP_ACCOUNT1 UNIQUE ([IDDRVOIP_ACCOUNT])) YES NEW_COLUMN TABLE:DRVOIP_ACCOUNT FIELD:DRVIA_NAME SQL:ALTER TABLE DRVOIP_ACCOUNT ADD [DRVIA_NAME]VARCHAR(100) YES NEW_TABLE TABLE:DRVOIP_ACCOUNTDETAIL FIELD:IDDRVOIP_ACCOUNTDETAIL SQL:CREATE TABLE DRVOIP_ACCOUNTDETAIL ([IDDRVOIP_ACCOUNTDETAIL]INTEGER IDENTITY(1,1), CONSTRAINT IDDRVOIP_ACCOUNTDETAIL1 UNIQUE ([IDDRVOIP_ACCOUNTDETAIL])) YES NEW_TABLE TABLE:DRVOIP_PROVIDER FIELD:IDDRVOIP_PROVIDER SQL:CREATE TABLE DRVOIP_PROVIDER ([IDDRVOIP_PROVIDER]INTEGER IDENTITY(1,1), CONSTRAINT IDDRVOIP_PROVIDER1 UNIQUE ([IDDRVOIP_PROVIDER])) YES NEW_COLUMN TABLE:DRVOIP_ACCOUNTDETAIL FIELD:IDDRVOIP_PROVIDER SQL:ALTER TABLE DRVOIP_ACCOUNTDETAIL ADD [IDDRVOIP_PROVIDER]INTEGER, CONSTRAINT IDDRVOIP_ACCOUNTDETAIL2 FOREIGN KEY ([IDDRVOIP_PROVIDER]) REFERENCES DRVOIP_PROVIDER([IDDRVOIP_PROVIDER]) YES NEW_COLUMN TABLE:DRVOIP_ACCOUNTDETAIL FIELD:IDDRVOIP_ACCOUNT SQL:ALTER TABLE DRVOIP_ACCOUNTDETAIL ADD [IDDRVOIP_ACCOUNT]INTEGER, CONSTRAINT IDDRVOIP_ACCOUNTDETAIL3 FOREIGN KEY ([IDDRVOIP_ACCOUNT]) REFERENCES DRVOIP_ACCOUNT([IDDRVOIP_ACCOUNT]) YES NEW_COLUMN TABLE:DRVOIP_ACCOUNTDETAIL FIELD:URLBASE SQL:ALTER TABLE DRVOIP_ACCOUNTDETAIL ADD [URLBASE]VARCHAR(255) YES NEW_COLUMN TABLE:DRVOIP_ACCOUNTDETAIL FIELD:USERNAME SQL:ALTER TABLE DRVOIP_ACCOUNTDETAIL ADD [USERNAME]VARCHAR(150) YES NEW_COLUMN TABLE:DRVOIP_ACCOUNTDETAIL FIELD:PASSWORD SQL:ALTER TABLE DRVOIP_ACCOUNTDETAIL ADD [PASSWORD]VARCHAR(255) YES NEW_COLUMN TABLE:DRVOIP_ACCOUNTDETAIL FIELD:VERSION SQL:ALTER TABLE DRVOIP_ACCOUNTDETAIL ADD [VERSION]VARCHAR(50) YES NEW_COLUMN TABLE:DRVOIP_ACCOUNTDETAIL FIELD:PORT SQL:ALTER TABLE DRVOIP_ACCOUNTDETAIL ADD [PORT]VARCHAR(50) YES NEW_TABLE TABLE:DRVOIP_NEWCASE FIELD:IDDRVOIP_NEWCASE SQL:CREATE TABLE DRVOIP_NEWCASE ([IDDRVOIP_NEWCASE]INTEGER IDENTITY(1,1), CONSTRAINT IDDRVOIP_NEWCASE1 UNIQUE ([IDDRVOIP_NEWCASE])) YES NEW_COLUMN TABLE:DRVOIP_NEWCASE FIELD:NEWCASENAME SQL:ALTER TABLE DRVOIP_NEWCASE ADD [NEWCASENAME]VARCHAR(50) YES NEW_COLUMN TABLE:DRVOIP_NEWCASE FIELD:NEWCASESTATUS SQL:ALTER TABLE DRVOIP_NEWCASE ADD [NEWCASESTATUS]BIT YES NEW_TABLE TABLE:DRVOIP_NEWCASEDETAIL FIELD:IDDRVOIP_NEWCASEDETAIL SQL:CREATE TABLE DRVOIP_NEWCASEDETAIL ([IDDRVOIP_NEWCASEDETAIL]INTEGER IDENTITY(1,1), CONSTRAINT IDDRVOIP_NEWCASEDETAIL1 UNIQUE ([IDDRVOIP_NEWCASEDETAIL])) YES NEW_COLUMN TABLE:DRVOIP_NEWCASEDETAIL FIELD:IDDRVOIP_NEWCASE SQL:ALTER TABLE DRVOIP_NEWCASEDETAIL ADD [IDDRVOIP_NEWCASE]INTEGER, CONSTRAINT IDDRVOIP_NEWCASEDETAIL2 FOREIGN KEY ([IDDRVOIP_NEWCASE]) REFERENCES DRVOIP_NEWCASE([IDDRVOIP_NEWCASE]) YES NEW_COLUMN TABLE:DRVOIP_NEWCASEDETAIL FIELD:IDEV_EXCEPTION_CASE SQL:ALTER TABLE DRVOIP_NEWCASEDETAIL ADD [IDEV_EXCEPTION_CASE]INTEGER, CONSTRAINT IDDRVOIP_NEWCASEDETAIL3 FOREIGN KEY ([IDEV_EXCEPTION_CASE]) REFERENCES EV_EXCEPTION_CASE([IDEV_EXCEPTION_CASE]) YES NEW_COLUMN TABLE:DRVOIP_NEWCASEDETAIL FIELD:IDDRVOIP_ACCOUNT SQL:ALTER TABLE DRVOIP_NEWCASEDETAIL ADD [IDDRVOIP_ACCOUNT]INTEGER YES NEW_COLUMN TABLE:DRVOIP_NEWCASEDETAIL FIELD:IDDREMAILACCOUNTSDETAILOUTPUT SQL:ALTER TABLE DRVOIP_NEWCASEDETAIL ADD [IDDREMAILACCOUNTSDETAILOUTPUT]INTEGER YES NEW_COLUMN TABLE:DRVOIP_NEWCASEDETAIL FIELD:DELETECALL SQL:ALTER TABLE DRVOIP_NEWCASEDETAIL ADD [DELETECALL]BIT YES NEW_COLUMN TABLE:DRVOIP_NEWCASEDETAIL FIELD:SENDEMAIL SQL:ALTER TABLE DRVOIP_NEWCASEDETAIL ADD [SENDEMAIL]BIT YES NEW_COLUMN TABLE:DRVOIP_NEWCASEDETAIL FIELD:ACCOUNTNUMBER SQL:ALTER TABLE DRVOIP_NEWCASEDETAIL ADD [ACCOUNTNUMBER]TEXT YES NEW_COLUMN TABLE:DRVOIP_NEWCASEDETAIL FIELD:VOIP_BODYTEXT SQL:ALTER TABLE DRVOIP_NEWCASEDETAIL ADD [VOIP_BODYTEXT]TEXT YES NEW_COLUMN TABLE:DRVOIP_NEWCASEDETAIL FIELD:VOIP_SUBJECT SQL:ALTER TABLE DRVOIP_NEWCASEDETAIL ADD [VOIP_SUBJECT]VARCHAR(255) YES NEW_COLUMN TABLE:DRVOIP_NEWCASEDETAIL FIELD:IDDREMAILGENERATORDETAIL SQL:ALTER TABLE DRVOIP_NEWCASEDETAIL ADD [IDDREMAILGENERATORDETAIL]INTEGER YES NEW_COLUMN TABLE:DRVOIP_NEWCASEDETAIL FIELD:IDDRVOIP_NEWCASE_SERVERMODE SQL:ALTER TABLE DRVOIP_NEWCASEDETAIL ADD [IDDRVOIP_NEWCASE_SERVERMODE]INTEGER YES NEW_TABLE TABLE:DRVOIP_INCOMINGCALL FIELD:IDDRVOIP_INCOMINGCALL SQL:CREATE TABLE DRVOIP_INCOMINGCALL ([IDDRVOIP_INCOMINGCALL]INTEGER IDENTITY(1,1), CONSTRAINT IDDRVOIP_INCOMINGCALL1 UNIQUE ([IDDRVOIP_INCOMINGCALL])) YES NEW_COLUMN TABLE:DRVOIP_INCOMINGCALL FIELD:INCOMINGCALL_EXTENCION SQL:ALTER TABLE DRVOIP_INCOMINGCALL ADD [INCOMINGCALL_EXTENCION]VARCHAR(50) YES NEW_COLUMN TABLE:DRVOIP_INCOMINGCALL FIELD:INCOMINGCALL_EMAIL SQL:ALTER TABLE DRVOIP_INCOMINGCALL ADD [INCOMINGCALL_EMAIL]VARCHAR(50) YES NEW_COLUMN TABLE:DRVOIP_INCOMINGCALL FIELD:INCOMINGCALL_DURATION SQL:ALTER TABLE DRVOIP_INCOMINGCALL ADD [INCOMINGCALL_DURATION]INTEGER YES NEW_COLUMN TABLE:DRVOIP_INCOMINGCALL FIELD:IDDRVOIP_PBXCALLSTATUS_IN SQL:ALTER TABLE DRVOIP_INCOMINGCALL ADD [IDDRVOIP_PBXCALLSTATUS_IN]INTEGER YES NEW_COLUMN TABLE:DRVOIP_INCOMINGCALL FIELD:IDDRVOIP_PBXCALLSTATUS_OUT SQL:ALTER TABLE DRVOIP_INCOMINGCALL ADD [IDDRVOIP_PBXCALLSTATUS_OUT]INTEGER YES NEW_COLUMN TABLE:DRVOIP_INCOMINGCALL FIELD:IDDRVOIP_INCOMINGCALL_STATUS SQL:ALTER TABLE DRVOIP_INCOMINGCALL ADD [IDDRVOIP_INCOMINGCALL_STATUS]INTEGER YES NEW_TABLE TABLE:DRVOIP_EXTENSIONQUERYCALL FIELD:IDDRVOIP_EXTENSIONQUERYCALL SQL:CREATE TABLE DRVOIP_EXTENSIONQUERYCALL ([IDDRVOIP_EXTENSIONQUERYCALL]INTEGER IDENTITY(1,1), CONSTRAINT IDDRVOIP_EXTENSIONQUERYCALL1 UNIQUE ([IDDRVOIP_EXTENSIONQUERYCALL])) YES NEW_COLUMN TABLE:DRVOIP_EXTENSIONQUERYCALL FIELD:EXTENSIONQUERYCALL_SERVEREXT SQL:ALTER TABLE DRVOIP_EXTENSIONQUERYCALL ADD [EXTENSIONQUERYCALL_SERVEREXT]VARCHAR(50) YES NEW_COLUMN TABLE:DRVOIP_EXTENSIONQUERYCALL FIELD:EXTENSIONQUERYCALL_CALLID SQL:ALTER TABLE DRVOIP_EXTENSIONQUERYCALL ADD [EXTENSIONQUERYCALL_CALLID]FLOAT YES NEW_COLUMN TABLE:DRVOIP_EXTENSIONQUERYCALL FIELD:EXTENSIONQUERYCALL_STARTDATE SQL:ALTER TABLE DRVOIP_EXTENSIONQUERYCALL ADD [EXTENSIONQUERYCALL_STARTDATE]DATETIME YES NEW_COLUMN TABLE:DRVOIP_EXTENSIONQUERYCALL FIELD:EXTENSIONQUERYCALL_ENDDATE SQL:ALTER TABLE DRVOIP_EXTENSIONQUERYCALL ADD [EXTENSIONQUERYCALL_ENDDATE]DATETIME YES NEW_COLUMN TABLE:DRVOIP_EXTENSIONQUERYCALL FIELD:EXTENSIONQUERYCALL_STATUS SQL:ALTER TABLE DRVOIP_EXTENSIONQUERYCALL ADD [EXTENSIONQUERYCALL_STATUS]INTEGER YES NEW_COLUMN TABLE:DRVOIP_EXTENSIONQUERYCALL FIELD:EXTENSIONQUERYCALL_ACTIVE SQL:ALTER TABLE DRVOIP_EXTENSIONQUERYCALL ADD [EXTENSIONQUERYCALL_ACTIVE]INTEGER YES NEW_COLUMN TABLE:DRVOIP_EXTENSIONQUERYCALL FIELD:IDEV_VOIP_SDCASE SQL:ALTER TABLE DRVOIP_EXTENSIONQUERYCALL ADD [IDEV_VOIP_SDCASE]INTEGER YES NEW_TABLE TABLE:DRVOIP_EXTENSIONQUERYMEMBER FIELD:IDDRVOIP_EXTENSIONQUERYMEMBER SQL:CREATE TABLE DRVOIP_EXTENSIONQUERYMEMBER ([IDDRVOIP_EXTENSIONQUERYMEMBER]INTEGER IDENTITY(1,1), CONSTRAINT IDDRVOIP_EXTENSIONQUERYMEMBER1 UNIQUE ([IDDRVOIP_EXTENSIONQUERYMEMBER])) YES NEW_COLUMN TABLE:DRVOIP_EXTENSIONQUERYMEMBER FIELD:IDDRVOIP_EXTENSIONQUERYCALL SQL:ALTER TABLE DRVOIP_EXTENSIONQUERYMEMBER ADD [IDDRVOIP_EXTENSIONQUERYCALL]INTEGER, CONSTRAINT IDDRVOIP_EXTENSIONQUERYMEMBER2 FOREIGN KEY ([IDDRVOIP_EXTENSIONQUERYCALL]) REFERENCES DRVOIP_EXTENSIONQUERYCALL([IDDRVOIP_EXTENSIONQUERYCALL]) YES NEW_COLUMN TABLE:DRVOIP_EXTENSIONQUERYMEMBER FIELD:EXTENSIONQUERYMEMBER_EXT SQL:ALTER TABLE DRVOIP_EXTENSIONQUERYMEMBER ADD [EXTENSIONQUERYMEMBER_EXT]VARCHAR(50) YES NEW_COLUMN TABLE:DRVOIP_EXTENSIONQUERYMEMBER FIELD:EXTENSIONQUERYMEMBER_CHANNELID SQL:ALTER TABLE DRVOIP_EXTENSIONQUERYMEMBER ADD [EXTENSIONQUERYMEMBER_CHANNELID]VARCHAR(100) YES NEW_COLUMN TABLE:DRVOIP_EXTENSIONQUERYMEMBER FIELD:IDEXTENSIONQUERYMEMBER_STATUS SQL:ALTER TABLE DRVOIP_EXTENSIONQUERYMEMBER ADD [IDEXTENSIONQUERYMEMBER_STATUS]VARCHAR(20) YES NEW_COLUMN TABLE:DRVOIP_EXTENSIONQUERYMEMBER FIELD:EXTENSIONQUERYMEMBER_ACTIVE SQL:ALTER TABLE DRVOIP_EXTENSIONQUERYMEMBER ADD [EXTENSIONQUERYMEMBER_ACTIVE]INTEGER YES NEW_COLUMN TABLE:DRVOIP_EXTENSIONQUERYMEMBER FIELD:EXTENSIONQUERYMEMBER_STARTDATE SQL:ALTER TABLE DRVOIP_EXTENSIONQUERYMEMBER ADD [EXTENSIONQUERYMEMBER_STARTDATE]DATETIME YES NEW_COLUMN TABLE:DRVOIP_EXTENSIONQUERYMEMBER FIELD:EXTENSIONQUERYMEMBER_ENDDATE SQL:ALTER TABLE DRVOIP_EXTENSIONQUERYMEMBER ADD [EXTENSIONQUERYMEMBER_ENDDATE]DATETIME YES NEW_COLUMN TABLE:DRVOIP_PROVIDER FIELD:DRVIP_NAME SQL:ALTER TABLE DRVOIP_PROVIDER ADD [DRVIP_NAME]VARCHAR(100) YES NEW_COLUMN TABLE:DRVOIP_PROVIDER FIELD:DRVIP_DESCRIPTION SQL:ALTER TABLE DRVOIP_PROVIDER ADD [DRVIP_DESCRIPTION]VARCHAR(250) -- Interno Service Prefix[Demo] BDD[mdf] -- changes were not in the database. -------------------- Build BDD Extra----------------------- Generate:CIExtraTable Generate:ServiceExtraTable Generate:BaseLine -------------------- Verify BDD Extra----------------------- Create:CIExtraTable Create:ServiceExtraTable Create:BaseLine -- Interno Service Prefix[CMDB_EF] BDD[mdf] -- changes were not in the database. -- Interno Service Prefix[ST] BDD[mdf] -- changes were not in the database. -- Interno Service Prefix[BL] BDD[mdf] -- changes were not in the database. -------------------- apply service pack ----------------------- Persistence.ITHC.Properties+TITHCVERSION_Persistence.ITHC.Properties+TITHCVERSIONBUILD OK Persistence.ITHC.Properties+TITHCVERSION_Persistence.ITHC.Properties+TITHCVERSIONBUILD OK UpGrade Service pack completed Service OK: 2 Service Error: 0 -------------------- Upgrade Model ----------------------- Result ModuleCode Update 1 : True Result ModuleCode Update 2 : True Result ModuleCode Update 3 : True Result ModuleCode Update 4 : True Result ModuleCode Update 5 : True Result ModuleCode Update 6 : True Result ModuleCode Update 7 : True Result Model 7, Step 1 : True Result Model 7, Step 2 : True
Verificación de actualización en base de datos
Cambios en la base de datos después de actualizaciones:
1- Nuevos tipos de SDCASESOURCETYPE INSERT INTO SDCASESOURCETYPE(IDSDCASESOURCETYPE,SOURCETYPENAME) Values (3,'PERSON_USER') INSERT INTO SDCASESOURCETYPE(IDSDCASESOURCETYPE,SOURCETYPENAME) Values (4,'PERSON_MANAGER') INSERT INTO SDCASESOURCETYPE(IDSDCASESOURCETYPE,SOURCETYPENAME) Values (5,'EVENT_EXCEPTION') INSERT INTO SDCASESOURCETYPE(IDSDCASESOURCETYPE,SOURCETYPENAME) Values (6,'EVENT_EMAIL') INSERT INTO SDCASESOURCETYPE(IDSDCASESOURCETYPE,SOURCETYPENAME) Values (7,'EVENT_VOIP') INSERT INTO SDCASESOURCETYPE(IDSDCASESOURCETYPE,SOURCETYPENAME) Values (8,'EVENT_SQL') INSERT INTO SDCASESOURCETYPE(IDSDCASESOURCETYPE,SOURCETYPENAME) Values (9,'EVENT_EXTRA') 2- Actualización de versión del sistema INSERT INTO ITHCVERSION(IDITHCVERSION, VERSIONCOMERCIAL, VERSIONCERTIFICATION) Values (3, '2021 Q2', '3.2') INSERT INTO ITHCVERSIONBUILD(IDITHCVERSIONBUILD, IDITHCVERSION, BUILDRELEASE, BUILDDATE, BUILDDETAIL) Values (5, 3, -1, '12:00:00 AM 08/31/2021', 'Upgrade SDCASESOURCETYPE') INSERT INTO ITHCVERSION(IDITHCVERSION, VERSIONCOMERCIAL, VERSIONCERTIFICATION) Values (4, '2022 Q2', '3.2') INSERT INTO ITHCVERSIONBUILD(IDITHCVERSIONBUILD, IDITHCVERSION, BUILDRELEASE, BUILDDATE, BUILDDETAIL) Values (4, 4, -1, '12:00:00 AM 04/21/2022', 'Upgrade DRPROVIDER, DREMAILACCOUNTSDETAIL') 3- Nuevos tipos de componentes en DRobot UPDATE DRPROVIDER SET PROVIDERNAME='ComponentPro' WHERE IDDRPROVIDER = 1 UPDATE DRPROVIDER SET PROVIDERNAME='MailKit' WHERE IDDRPROVIDER = 2 UPDATE DRPROVIDER SET PROVIDERNAME='EmailArchitect' WHERE IDDRPROVIDER = 3 UPDATE DREMAILACCOUNTSDETAIL SET IDDRPROVIDER=1