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

--SQL Server:
ALTER TABLE TBINTEGRATIONNFCE ADD MODEL SMALLINT NULL;
ALTER TABLE TBINTEGRATIONNFCE ADD DOCUMENTNUMBER INT NULL;
ALTER TABLE TBINTEGRATIONNFCE ADD SERIE INT NULL;
ALTER TABLE TBINTEGRATIONNFCE ADD INSERTDATE DATETIME NULL;

--Oracle:
ALTER TABLE TBINTEGRATIONNFCE ADD MODEL NUMBER(3,0);
ALTER TABLE TBINTEGRATIONNFCE ADD DOCUMENTNUMBER NUMBER(9,0);
ALTER TABLE TBINTEGRATIONNFCE ADD SERIE NUMBER(9,0);
ALTER TABLE TBINTEGRATIONNFCE ADD INSERTDATE TIMESTAMP(3);

--SQL Server:
ALTER TABLE TBSATSERVER ADD ISSUERUF SMALLINT NOT NULL DEFAULT 35

--Oracle:
ALTER TABLE TBSATSERVER ADD ISSUERUF NUMBER(5,0) default 35 NOT NULL

--SQL Server:
CREATE TABLE [TBDOCUMENTNUMBERCONTROL](
[ID] [bigint] IDENTITY(1,1) NOT NULL,
[CNPJ] [bigint] NOT NULL,
[SERIE] [smallint] NOT NULL,
[DOCUMENTNUMBER] [int] NOT NULL,
CONSTRAINT [PK_TBDOCUMENTNUMBERCONTROL] 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],
CONSTRAINT [UQ_CNPJ_SERIE] UNIQUE NONCLUSTERED
(
[CNPJ] ASC,
[SERIE] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,
ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

--Oracle:
CREATE TABLE TBDOCUMENTNUMBERCONTROL(
ID number(20,0) NOT NULL ENABLE,
CNPJ number(20,0) NOT NULL ENABLE,
SERIE number(5,0) NOT NULL ENABLE,
DOCUMENTNUMBER number(10,0) NOT NULL ENABLE,
CONSTRAINT "PK_TBDOCUMENTNUMBERCONTROL" PRIMARY KEY("ID") ENABLE,
CONSTRAINT "UQ_CNPJ_SERIE" UNIQUE (CNPJ,SERIE)
)

--SQL Server:
CREATE TABLE [TBSATCONFIGURATION](
[ID] [bigint] IDENTITY(1,1) NOT NULL,
[STOREID] [bigint] NOT NULL CONSTRAINT [FK_TBSATCONFIGURATION_TBSTORE] FOREIGN KEY
REFERENCES TBSTORE(ID),
[ISDEFAULT] [bit] NOT NULL,
[IDENTIFIER] [varchar](50) NOT NULL,
[ISSUERCNPJ] [bigint] NOT NULL,
[ISSUERIE] [bigint] NOT NULL,
[ISSUERUF] [varchar](2) NOT NULL,
[SOFTWAREHOUSECNPJ] [bigint] NOT NULL,
[ACTIVATIONCODE] [varchar](32) NOT NULL,
[ACSIGNATURE] [varchar](344) NOT NULL,
[DLLPATH] [varchar](max) NOT NULL,
[ATTEMPTSNUMBER] [int] NOT NULL,
[ATTEMPTSDELAY] [int] NOT NULL,
CONSTRAINT [PK__TBSATCONFIGURATION] 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]
ALTER TABLE TBDOCUMENTNUMBERCONTROL ADD LASTCHANGE DATETIME NOT NULL DEFAULT
GETDATE();
ALTER TABLE TBDOCUMENTNUMBERCONTROL ADD USERDOMAIN varchar(255) NOT NULL DEFAULT 'Local';
ALTER TABLE TBDOCUMENTNUMBERCONTROL ADD USERNAME varchar(100) NOT NULL DEFAULT 'ndd';

--Oracle:
CREATE TABLE "TBSATCONFIGURATION"
(
"ID" NUMBER(20,0) NOT NULL ENABLE,
"STOREID" NUMBER(20,0) NOT NULL ENABLE,
"ISDEFAULT" NUMBER(1,0) NOT NULL ENABLE,
"IDENTIFIER" VARCHAR2(50) NOT NULL ENABLE,
"ISSUERCNPJ" NUMBER(20,0) NOT NULL ENABLE,
"ISSUERIE" NUMBER(20,0) NOT NULL ENABLE,
"ISSUERUF" VARCHAR2(2) NOT NULL ENABLE,
"SOFTWAREHOUSECNPJ" NUMBER(20,0) NOT NULL ENABLE,
"ACTIVATIONCODE" VARCHAR2(32) NOT NULL ENABLE,
"ACSIGNATURE" VARCHAR2(344) NOT NULL ENABLE,
"DLLPATH" VARCHAR(4000) NOT NULL ENABLE,
"ATTEMPTSNUMBER" NUMBER(10,0) NOT NULL ENABLE,
"ATTEMPTSDELAY" NUMBER(10,0) NOT NULL ENABLE,
CONSTRAINT "PK_TBSATCONFIGURATION" PRIMARY KEY ("ID") ENABLE,
CONSTRAINT "FK_TBSATCONFIGURATION_TBSTORE" FOREIGN KEY ("STOREID") REFERENCES
"TBSTORE" ("ID") ENABLE
)
/
create or replace TRIGGER "TBSATCONFIGURATION_BI" BEFORE INSERT ON TBSATCONFIGURATION
FOR EACH ROW
WHEN(new.ID IS NULL) BEGIN
SELECT TBSATCONFIGURATION_SEQ.NEXTVAL INTO :new.ID FROM dual;
END;
/
CREATE SEQUENCE "TBSATCONFIGURATION_SEQ" MINVALUE 1 MAXVALUE
999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE;
ALTER TABLE TBDOCUMENTNUMBERCONTROL ADD LASTCHANGE Timestamp(3) default sysdate NOT
NULL;
ALTER TABLE TBDOCUMENTNUMBERCONTROL ADD USERDOMAIN VARCHAR2(255 Byte) default 'Local' NOT NULL;
ALTER TABLE TBDOCUMENTNUMBERCONTROL ADD USERNAME VARCHAR2(100 Byte) default 'ndd' NOT NULL;

--Sql Server:
CREATE TABLE [TBINTEGRATORPROCESSOR](
[ID] [bigint] IDENTITY(1,1) NOT NULL,
[IDFILA] [bigint] NOT NULL,
[INSERTDATE] [datetime] NOT NULL,
[AGENTKEY] [varchar](20) NULL,
[CHAVEACESSOVALIDADOR] [varchar](50) NULL,
[CNPJ] [bigint] NULL,
[CHAVEACESSO] [varchar](44) NULL,
[NSU] [int] NULL,
[NUMERODEAPROVACAO] [int] NULL,
[BANDEIRA] [varchar](50) NULL,
[ADQUIRINTE] [varchar](50) NULL,
[CODIGORETORNO] [bigint] NULL,
[VERIFSTATUSVALIDADORSENDDATA] [varchar](max) NULL,
[RESPOSTAFISCALSENDDATA] [varchar](max) NULL,
[CONTENTTYPE] [tinyint] NULL,
CONSTRAINT [PK_TBINTEGRATORPROCESSOR] 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],
CONSTRAINT [IX_TBIntegratorProcessor] UNIQUE NONCLUSTERED
(
[IDFILA] 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]

--Oracle:
CREATE TABLE "TBINTEGRATORPROCESSOR"
(
"ID" NUMBER(20,0) NOT NULL ENABLE,
"IDFILA" NUMBER(20,0) NOT NULL ENABLE,
"INSERTDATE" TIMESTAMP(6) NOT NULL ENABLE,
"AGENTKEY" VARCHAR2(20),
"CHAVEACESSOVALIDADOR" VARCHAR2(50),
"CNPJ" NUMBER(20,0),
"CHAVEACESSO" VARCHAR2(44),
"NSU" NUMBER(12,0),
"NUMERODEAPROVACAO" NUMBER(12,0),
"BANDEIRA" VARCHAR2(50),
"ADQUIRINTE" VARCHAR2(50),
"CODIGORETORNO" NUMBER(20,0),
"VERIFSTATUSVALIDADORSENDDATA" CLOB,
"RESPOSTAFISCALSENDDATA" CLOB,
"CONTENTTYPE" NUMBER(3,0),
CONSTRAINT "PK_TBINTEGRATORPROCESSOR" PRIMARY KEY ("ID") ENABLE,
CONSTRAINT "UQ_IDFILA" UNIQUE ("IDFILA")
);
/
CREATE SEQUENCE "TBINTEGRATORPROCESSOR_SEQ" MINVALUE 1 MAXVALUE
999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE;
/
create or replace TRIGGER "TBINTEGRATORPROCESSOR_BI" BEFORE INSERT ON
TBINTEGRATORPROCESSOR
FOR EACH ROW
WHEN(new.ID IS NULL) BEGIN
SELECT TBINTEGRATORPROCESSOR_SEQ.NEXTVAL INTO :new.ID FROM dual;
END;

--Sql Server:
ALTER TABLE TBCONCENTRATOR ADD CONTINGENCYDATEEXIT DATETIME;
ALTER TABLE TBLOGDOCUMENTACTION ADD OBSERVATION VARCHAR(255);
ALTER TABLE TBLOGDOCUMENTACTION ALTER COLUMN LOGDOCID BIGINT NULL;
ALTER TABLE TBSTORE ADD CNPJ BIGINT NOT NULL DEFAULT 0;
--Apenas para Sql Server Particionado:
ALTER TABLE XP_TBLOGDOCUMENTACTION ALTER COLUMN LOGDOCID BIGINT NULL;
ALTER TABLE XP_TBLOGDOCUMENTACTION ADD OBSERVATION VARCHAR(255);

--Oracle:
ALTER TABLE TBCONCENTRATOR ADD CONTINGENCYDATEEXIT Timestamp(3);
ALTER TABLE TBLOGDOCUMENTACTION ADD OBSERVATION Varchar2(255);
ALTER TABLE TBLOGDOCUMENTACTION MODIFY LOGDOCID NULL;
ALTER TABLE TBSTORE ADD CNPJ NUMBER(20,0) DEFAULT 0 NOT NULL;

--Sql Server:
ALTER TABLE TBSATSERVER ADD COMPRESSEDLOG BIT NOT NULL DEFAULT 0;
IF NOT EXISTS(SELECT * FROM sys.columns WHERE Name = N'USERDOMAIN' and Object_ID = 
Object_ID(N'TBLOGDOCUMENTADJUSTMENTS'))
BEGIN
ALTER TABLE TBLOGDOCUMENTADJUSTMENTS ADD USERDOMAIN VARCHAR(255) NOT NULL DEFAULT 'Local'
END

--Oracle:
ALTER TABLE TBSATSERVER ADD COMPRESSEDLOG NUMBER(1,0) default 0 NOT NULL;
declare v_column_exists number := 0; 
begin 
Select count(*) into v_column_exists from user_tab_cols where column_name = 'USERDOMAIN' and table_name = 'TBLOGDOCUMENTADJUSTMENTS'; 
if (v_column_exists = 0) then execute immediate 'ALTER TABLE TBLOGDOCUMENTADJUSTMENTS ADD USERDOMAIN 
Varchar2(255) default ''Local'' NOT NULL'; 
END IF; 
end;

--Sql Server:
ALTER TABLE TBENTERPRISE ADD ADDITIONALDATAAUTOMATICFIELDS varchar(max) NOT NULL DEFAULT '<?xml version="1.0" encoding="utf-8"?>
<additionaldataautomaticfields xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<fields total="0" />
</additionaldataautomaticfields>';

ALTER TABLE TBSTORE ADD ADDITIONALDATAAUTOMATICFIELDS varchar(max) NOT NULL DEFAULT '<?xml version="1.0" encoding="utf-8"?>
<additionaldataautomaticfields xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<fields total="0" />
</additionaldataautomaticfields>'

--Oracle:
ALTER TABLE TBENTERPRISE ADD ADDITIONALDATAAUTOMATICFIELDS CLOB DEFAULT '<?xml version="1.0" encoding="utf-8"?>
<additionaldataautomaticfields xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<fields total="0" />
</additionaldataautomaticfields>' NOT NULL;
ALTER TABLE TBSTORE ADD ADDITIONALDATAAUTOMATICFIELDS CLOB DEFAULT '<?xml version="1.0" encoding="utf-8"?>
<additionaldataautomaticfields xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<fields total="0" />
</additionaldataautomaticfields>' NOT NULL

--SQL Server:
ALTER TABLE TBCONCENTRATOR ADD CONTINGENCYACTIVATIONDATE DATETIME NULL

--Oracle:
ALTER TABLE TBCONCENTRATOR ADD CONTINGENCYACTIVATIONDATE Timestamp(3)