es:versiones:v4:migracion_v4



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).



  1. 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 





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 





1)
Modulo para administrar conexión con motor de base de datos
2)
Archivos propios de configuración del sistema
  • es/versiones/v4/migracion_v4.txt
  • Last modified: 2022/08/22 18:42
  • by adminnancy