alter table formas add if not exists TEF_PAYGO_Modalidade integer;
alter table formas add if not exists TEF_PAYGO_Tipocartao integer;
alter table formas add if not exists TEF_PAYGO_ModFinanciamento integer;
alter table formas add if not exists TEF_PAYGO_Autorizador varchar(20);

alter table anfe add if not exists enviada_contingencia boolean;


alter table cupom2 add if not exists e2e varchar(40);

CREATE TABLE IF NOT EXISTS "pix"
(
   "numero" AUTOINC,
   "dh" TIMESTAMP,
   "NSU" VARCHAR(40),
   "valor" FLOAT,
   "Rede_Adquirente" VARCHAR(30),
   "operacao" INTEGER,
   "E2E" VARCHAR(70),
PRIMARY KEY ("RecordID") COMPRESS NONE
DESCRIPTION 'Registro de transação PIX'
LOCALE CODE 0
USER MAJOR VERSION 4
USER MINOR VERSION 5
);

CREATE INDEX IF NOT EXISTS "numero" ON "pix" ("numero");
CREATE INDEX IF NOT EXISTS "nsu" ON "pix" ("NSU");

alter table os10 add if not exists NSU varchar(40);
alter table os10 add if not exists rede varchar(30);
alter table os10 add if not exists Nome_do_Produto varchar(30);
alter table os10 add if not exists cAut varchar(10);
alter table os10 add if not exists bandeira_cartao integer;
alter table os10 add if not exists cnpj_integradora varchar(20);
alter table os10 add if not exists tipo_integracao Integer;
alter table os10 add if not exists E2E varchar(40);

alter table nfe1 add if not exists FCP_Aliq float;

update confignf set NFCE_sem_ST_Cst='102';
update confignf set NFCE_sem_ST_Cfop='102';
update confignf set NFCE_ST_Cst='500';
update confignf set NFCE_ST_Cfop='405';

alter table operacao add if not exists ignoracfopcstnocadastro Boolean;

alter table operacao add if not exists produtos_diferimento float;
alter table nfe1 add if not exists pdif float;

alter table os add if not exists locacao boolean;
alter table os add if not exists nro_locacao integer;
alter table os add if not exists datainicio_locacao date;
alter table os add if not exists horainicio_locacao time;
alter table os add if not exists datafim_locacao date;
alter table os add if not exists horafim_locacao time;

alter table sistema add if not exists Locacao_Numero_sequencial integer;

update sistema set Locacao_Numero_sequencial=0 where Locacao_Numero_sequencial=null;

alter table os add if not exists marcacao boolean;

alter table nfe1 add if not exists nitemped varchar(20);    

alter table nfe add if not exists incluir_frete_na_bcicms boolean;
alter table nfe add if not exists incluir_frete_na_bcicmsst boolean;

alter table nfe1 add if not exists cstis varchar(3);
alter table nfe1 add if not exists cclasstribis varchar(6);
alter table nfe1 add if not exists aliqis Float;
alter table nfe1 add if not exists aliqisespec Float;
alter table nfe1 add if not exists cstcbs varchar(3);
alter table nfe1 add if not exists cclasstribcbs varchar(6);
alter table nfe1 add if not exists aliqibsuf Float;
alter table nfe1 add if not exists aliqdifibsuf Float;
alter table nfe1 add if not exists vldevtribibsuf Float;
alter table nfe1 add if not exists aliqredibsuf Float;
alter table nfe1 add if not exists aliqefetibsuf Float;
alter table nfe1 add if not exists aliqibsmun Float;
alter table nfe1 add if not exists aliqdifibsmun Float;
alter table nfe1 add if not exists vldevtribibsmun Float;
alter table nfe1 add if not exists aliqredibsmun Float;
alter table nfe1 add if not exists aliefetibsmun Float;
alter table nfe1 add if not exists aliqcbs Float;
alter table nfe1 add if not exists aliqdifcbs Float;
alter table nfe1 add if not exists aliqefetcbs Float;
alter table nfe1 add if not exists vldevtribcbs Float;
alter table nfe1 add if not exists aliqredcbs Float;
alter table nfe1 add if not exists transfcredvibs Float;
alter table nfe1 add if not exists transfcredvcbs Float;
alter table nfe1 add if not exists aliqefetibsmun Float;

alter table anfe1 add if not exists cstis varchar(3);
alter table anfe1 add if not exists cclasstribis varchar(6);
alter table anfe1 add if not exists aliqis Float;
alter table anfe1 add if not exists aliqisespec Float;
alter table anfe1 add if not exists cstcbs varchar(3);
alter table anfe1 add if not exists cclasstribcbs varchar(6);
alter table anfe1 add if not exists aliqibsuf Float;
alter table anfe1 add if not exists aliqdifibsuf Float;
alter table anfe1 add if not exists vldevtribibsuf Float;
alter table anfe1 add if not exists aliqredibsuf Float;
alter table anfe1 add if not exists aliqefetibsuf Float;
alter table anfe1 add if not exists aliqibsmun Float;
alter table anfe1 add if not exists aliqdifibsmun Float;
alter table anfe1 add if not exists vldevtribibsmun Float;
alter table anfe1 add if not exists aliqredibsmun Float;
alter table anfe1 add if not exists aliefetibsmun Float;
alter table anfe1 add if not exists aliqcbs Float;
alter table anfe1 add if not exists aliqdifcbs Float;
alter table anfe1 add if not exists aliqefetcbs Float;
alter table anfe1 add if not exists vldevtribcbs Float;
alter table anfe1 add if not exists aliqredcbs Float;
alter table anfe1 add if not exists transfcredvibs Float;
alter table anfe1 add if not exists transfcredvcbs Float;
alter table anfe1 add if not exists aliqefetibsmun Float;

alter table confignf add if not exists aliqfixasreformatrib2026 Boolean;
update confignf set aliqfixasreformatrib2026=true;

CREATE TABLE IF NOT EXISTS "prod9"
(
   "codigo" integer,
   "cstis" varchar(3),
   "cclasstribis" varchar(6),
   "aliqis" Float,
   "aliqisespec" Float,
   "cstcbs" varchar(3),
   "cclasstribcbs" varchar(6),
   "aliqibsuf" Float,
   "aliqdifibsuf" Float,
   "vldevtribibsuf" Float,
   "aliqredibsuf" Float,
   "aliqefetibsuf" Float,
   "aliqibsmun" Float,
   "aliqdifibsmun" Float,
   "vldevtribibsmun" Float,
   "aliqredibsmun" Float,
   "aliefetibsmun" Float,
   "aliqcbs" Float,
   "aliqdifcbs" Float,
   "aliqefetcbs" Float,
   "vldevtribcbs" Float,
   "aliqredcbs" Float,
   "aliqefetibsmun" Float,
   "qtde_trib" Float,
PRIMARY KEY ("RecordID") COMPRESS NONE
DESCRIPTION 'Infos Tributarias a partir da reforma tributaria'
LOCALE CODE 0
USER MAJOR VERSION 3
USER MINOR VERSION 5
);

CREATE INDEX IF NOT EXISTS "codigo" ON "prod9" ("codigo");

insert into acesso (codigo, descricao) values (2100,'EXPORTAR ARQUIVOS CSV PRODUTOS E CLIENTES');
insert into acesso (codigo, descricao) values (2200,'EXPORTAR LISTAGENS DE PRODUTOS E CLIENTES');