Scripts de execução manual em patch's da versão 4.8.9.0

--SQL Server:
--Connector
ALTER TABLE TBINTEGRATORPROCESSOR DROP CONSTRAINT IX_TBIntegratorProcessor
ALTER TABLE TBINTEGRATORPROCESSOR ALTER COLUMN IDFILA varchar(50) not null
ALTER TABLE TBINTEGRATORPROCESSOR ADD CONSTRAINT IX_TBIntegratorProcessor UNIQUE NONCLUSTERED (IDFILA)
ALTER TABLE TBINTEGRATORPROCESSOR ALTER COLUMN NSU varchar(50)

--Cold
ALTER TABLE NOMETABELASATCOLD_INTEGRATOR ALTER COLUMN IDFILA varchar(50) not null
ALTER TABLE NOMETABELASATCOLD_INTEGRATOR ALTER COLUMN NSU varchar(50)

--Oracle:
--Connector
ALTER TABLE TBINTEGRATORPROCESSOR ADD IDFILA2 VARCHAR2(50)
update TBINTEGRATORPROCESSOR set IDFILA2 = IDFILA
ALTER TABLE TBINTEGRATORPROCESSOR DROP COLUMN IDFILA
ALTER TABLE TBINTEGRATORPROCESSOR RENAME COLUMN IDFILA2 to IDFILA
ALTER TABLE TBINTEGRATORPROCESSOR ADD CONSTRAINT UQ_IDFILA UNIQUE (IDFILA)
ALTER TABLE TBINTEGRATORPROCESSOR ADD NSU2 VARCHAR2(50)
update TBINTEGRATORPROCESSOR set NSU2 = NSU
ALTER TABLE TBINTEGRATORPROCESSOR DROP COLUMN NSU
ALTER TABLE TBINTEGRATORPROCESSOR RENAME COLUMN NSU2 to NSU

--Cold
ALTER TABLE NOMETABELASATCOLD_INTEGRATOR ADD IDFILA2 VARCHAR2(50)
update NOMETABELASATCOLD_INTEGRATOR set IDFILA2 = IDFILA
ALTER TABLE NOMETABELASATCOLD_INTEGRATOR OR DROP COLUMN IDFILA
ALTER TABLE NOMETABELASATCOLD_INTEGRATOR RENAME COLUMN IDFILA2 to IDFILA
ALTER TABLE NOMETABELASATCOLD_INTEGRATOR ADD NSU2 VARCHAR2(50)
update NOMETABELASATCOLD_INTEGRATOR set NSU2 = NSU
ALTER TABLE NOMETABELASATCOLD_INTEGRATOR DROP COLUMN NSU
ALTER TABLE NOMETABELASATCOLD_INTEGRATOR RENAME COLUMN NSU2 to NSU

--SQL Server:
ALTER TABLE TBNDDJOB ADD TIMETORETRIVERETRECEPTION INT NOT NULL DEFAULT 0

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TBINPROCESSSCHEDULING]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[TBINPROCESSSCHEDULING](
[ID] [bigint] IDENTITY(1,1) NOT NULL,
[LOGDOCID] [bigint] NULL,
[DOCUMENTDATE] [datetime] NULL,
[JOBID] [bigint] NULL,
[PROCESSID] [bigint] NOT NULL,
[PROCESSDATAID] [bigint] NOT NULL,
[KIND] [smallint] NOT NULL,
[EXECUTORID] [bigint] NULL,
[XMLPARAMS] [varchar](max) NULL, 
[INSERTDATE] [datetime] NOT NULL,
[EXECUTEDATE] [datetime] NOT NULL,
[TIMESEXECUTED] [int] NOT NULL,
CONSTRAINT [PK_TBINPROCESSSCHEDULING] PRIMARY KEY CLUSTERED 
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END

IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[TBINPROCESSSCHEDULING]') AND name = N'IX_TBINPROCESSSCHEDULING_1')
CREATE NONCLUSTERED INDEX [IX_TBINPROCESSSCHEDULING_1] ON [dbo].[TBINPROCESSSCHEDULING]
(
[ID] ASC,
[EXECUTEDATE] ASC,
[EXECUTORID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]
GO

--Oracle:
ALTER TABLE TBNDDJOB ADD TIMETORETRIVERETRECEPTION Number(10,0) DEFAULT 0 NOT NULL

Create Table "TBINPROCESSSCHEDULING"(
"ID" Numeric(20,0) Not Null Enable,
"LOGDOCID" Numeric(20,0),
"DOCUMENTDATE" Timestamp(3),
"JOBID" Numeric(20,0),
"PROCESSID" Numeric(20,0) Not Null Enable,
"PROCESSDATAID" Numeric(20,0) Not Null Enable,
"KIND" Smallint Not Null Enable,
"EXECUTORID" NUMERIC(20,0),
"XMLPARAMS" CLOB,
"INSERTDATE" TIMESTAMP (3) NOT NULL ENABLE, 
"EXECUTEDATE" TIMESTAMP (3) NOT NULL ENABLE, 
"TIMESEXECUTED" Numeric(10,0) Not Null Enable,
Constraint "PK_TBINPROCESSSCHEDULING" Primary Key (ID)
)

CREATE INDEX "IX_TBINPROCESSSCHEDULING_1" ON "TBINPROCESSSCHEDULING" ("ID", "EXECUTEDATE", "EXECUTORID")

CREATE SEQUENCE "TBINPROCESSSCHEDULING_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1

CREATE OR REPLACE TRIGGER "BI_TBINPROCESSSCHEDULING" BEFORE INSERT ON TBINPROCESSSCHEDULING
FOR EACH ROW
WHEN (new.ID IS NULL) BEGIN
SELECT "TBINPROCESSSCHEDULING_SEQ".NEXTVAL INTO :new.ID FROM dual;
End;

ALTER TRIGGER "BI_TBINPROCESSSCHEDULING" ENABLE;

--SQL Server:
ALTER TABLE TBCERTIFICATE ADD CHAINCERTIFICATE varchar(max)

--Oracle:
ALTER TABLE TBCERTIFICATE ADD CHAINCERTIFICATE CLOB

--SQL Server:
ALTER TABLE TBENTERPRISE ADD QRCODEVERSION smallint not null DEFAULT 1
ALTER TABLE TBSTORE ADD USEQRCODEVERSIONDEFAULT BIT NOT NULL DEFAULT 1
ALTER TABLE TBSTORE ADD QRCODEVERSION smallint not null DEFAULT 1

--Oracle:
ALTER TABLE TBENTERPRISE ADD QRCODEVERSION Smallint DEFAULT 1 NOT NULL
ALTER TABLE TBSTORE ADD USEQRCODEVERSIONDEFAULT Number(1,0) DEFAULT 1 NOT NULL
ALTER TABLE TBSTORE ADD QRCODEVERSION Smallint DEFAULT 1 NOT NULL

--SQL Server Particionado:
ALTER TABLE XP_TBLOGDOCUMENTACTION ADD STORENAME varchar(50) NULL
ALTER TABLE XP_TBLOGDOCUMENTACTION ADD SERIE int NOT NULL DEFAULT 0
ALTER TABLE XP_TBLOGDOCUMENTACTION ADD DOCUMENTNUMBER int NOT NULL DEFAULT 0
ALTER TABLE XP_TBLOGDOCUMENTACTION ADD CNPJEMIT bigint NOT NULL DEFAULT 0