alter table path add if not exists beep_maior boolean;
alter table path add if not exists imprimir_guia_producao_pedido boolean;
alter table movprod add if not exists apagado boolean;
alter table movprod1 add if not exists apagado boolean;
alter table gerencial add if not exists apagado boolean;
alter table estoque add if not exists apagado boolean;
alter table comprar add if not exists apagado boolean;
alter table prodabc add if not exists apagado boolean;
alter table path add if not exists perguntar_segunda_via_payer boolean;

alter table path add if not exists paygotef boolean;
alter table path add if not exists paygoqrcode integer;
alter table path add if not exists paygo_codEmpresa varchar(20);
alter table path add if not exists paygo_codFilial varchar(20);
alter table path add if not exists paygo_codTerminal varchar(20);
alter table path add if not exists paygo_enderecoServidor varchar(60);
alter table path add if not exists paygo_Operador varchar(20);
alter table path add if not exists paygo_portaPinPad varchar(20);
alter table path add if not exists paygo_comprovante_reduzido boolean;

alter table path add if not exists pix_psp_atual integer;
alter table path add if not exists pix_TimeOut integer;
alter table path add if not exists pix_nomerecebedor varchar(100);
alter table path add if not exists pix_cep varchar(9);
alter table path add if not exists pix_cidade varchar(30);
alter table path add if not exists pix_uf varchar(2);
alter table path add if not exists pix_timeout_cobranca integer;
alter table path add if not exists pix_autenticacaomanual Boolean;
alter table path add if not exists pix_proxy_host varchar(60);
alter table path add if not exists pix_proxy_porta integer;
alter table path add if not exists pix_proxy_usuario varchar(20);
alter table path add if not exists pix_proxy_senha varchar(20);
alter table path add if not exists pix_TipoChave integer;

alter table path add if not exists pix_PSPShipay_ClienteID Memo;
alter table path add if not exists pix_PSPShipay_SecretKey Memo;
alter table path add if not exists pix_PSPShipay_AccessKey Memo;

alter table path add if not exists pix_PSPBB_Chave varchar(40);
alter table path add if not exists pix_PSPBB_ClienteID Memo;
alter table path add if not exists pix_PSPBB_ClientSecret Memo;
alter table path add if not exists pix_PSPBB_DevKey Memo;
alter table path add if not exists pix_PSPBB_Arq_PFX varchar(100);
alter table path add if not exists pix_PSPBB_Senha varchar(20);

alter table path add if not exists Pix_PSPItau_chave varchar(40);
alter table path add if not exists pix_PSPItau_ClientId Memo;
alter table path add if not exists pix_PSPItau_ClientSecret Memo;
alter table path add if not exists pix_PSPItau_arqCert varchar(100);

alter table path add if not exists Pix_PSPSantander_chave varchar(40);
alter table path add if not exists pix_PSPSantander_ConsumerKey Memo;
alter table path add if not exists pix_PSPSantander_ConsumerSecret Memo;
alter table path add if not exists pix_PSPSantander_arqPFX varchar(100);
alter table path add if not exists pix_PSPSantander_senhaPFX varchar(20);

alter table path add if not exists Pix_PSPSicredi_chave varchar(40);
alter table path add if not exists Pix_PSPSicredi_ClienteID Memo;
alter table path add if not exists Pix_PSPSicredi_ClientSecret Memo;
alter table path add if not exists Pix_PSPSicredi_arqchavePriv varchar(100);
alter table path add if not exists Pix_PSPSicredi_arqcert varchar(100);

alter table path add if not exists Pix_PSPSicoob_chave varchar(40);
alter table path add if not exists Pix_PSPSicoob_ClienteID Memo;
alter table path add if not exists Pix_PSPSicoob_arqchavePriv varchar(100);
alter table path add if not exists Pix_PSPSicoob_arqcert varchar(100);

alter table path add if not exists Pix_PSPPagSeguro_chave varchar(40);
alter table path add if not exists Pix_PSPPagSeguro_ClientID Memo;
alter table path add if not exists Pix_PSPPagSeguro_ClientSecret Memo;
alter table path add if not exists Pix_PSPPagSeguro_arqchavePriv varchar(100);
alter table path add if not exists Pix_PSPPagSeguro_arqcert varchar(100);

alter table path add if not exists Pix_PSPGerencia_chave varchar(40);
alter table path add if not exists Pix_PSPGerencia_ClientID Memo;
alter table path add if not exists Pix_PSPGerencia_ClientSecret Memo;
alter table path add if not exists Pix_PSPGerencia_arqPFX varchar(100);

alter table path add if not exists Pix_PSPBradesco_chave varchar(40);
alter table path add if not exists Pix_PSPBradesco_ClientID Memo;
alter table path add if not exists Pix_PSPBradesco_ClientSecret Memo;
alter table path add if not exists Pix_PSPBradesco_arqPFX varchar(100);
alter table path add if not exists Pix_PSPBradesco_senhaPFX varchar(20);

alter table path add if not exists Pix_PSPPixPdv_cnpj varchar(20);
alter table path add if not exists Pix_PSPPixPdv_Token Memo;
alter table path add if not exists Pix_PSPPixPdv_SecretKey Memo;

alter table path add if not exists Pix_PSPInter_chave varchar(40);
alter table path add if not exists Pix_PSPInter_ClientId Memo;
alter table path add if not exists Pix_PSPInter_ClientSecret Memo;
alter table path add if not exists Pix_PSPInter_ChavePriv varchar(100);
alter table path add if not exists Pix_PSPInter_Cert varchar(100);

alter table path add if not exists Pix_PSPAilos_chave varchar(40);
alter table path add if not exists Pix_PSPAilos_ClientId Memo;
alter table path add if not exists Pix_PSPAilos_ClientSecret Memo;
alter table path add if not exists Pix_PSPAilos_ChavePriv varchar(100);
alter table path add if not exists Pix_PSPAilos_Cert varchar(100);
alter table path add if not exists Pix_PSPAilos_CertRoot varchar(100);

alter table path add if not exists Pix_PSPMatera_chave varchar(40);
alter table path add if not exists Pix_PSPMatera_ClientId Memo;
alter table path add if not exists Pix_PSPMatera_ClientSecret Memo;
alter table path add if not exists Pix_PSPMatera_SecretKey Memo;
alter table path add if not exists Pix_PSPMatera_AccountId Memo;
alter table path add if not exists Pix_PSPMatera_MediatorFee Float;
alter table path add if not exists Pix_PSPMatera_arqChavePriv varchar(100);
alter table path add if not exists Pix_PSPMatera_arqCert varchar(100);

alter table path add if not exists Pix_PSPCielo_chave varchar(40);
alter table path add if not exists Pix_PSPCielo_ClientId Memo;
alter table path add if not exists Pix_PSPCielo_ClientSecret memo;

alter table path add if not exists Pix_PSPMp_chave varchar(40);
alter table path add if not exists Pix_PSPMp_Token Memo;

alter table path add if not exists Pix_PSPGate_Api Memo;
alter table path add if not exists Pix_PSPGate_Key Memo;

alter table path add if not exists PINPAD_Porta varchar(10);
alter table path add if not exists PINPAD_Baud integer;
alter table path add if not exists PINPAD_DataBits integer;
alter table path add if not exists PINPAD_Paridade integer;
alter table path add if not exists PINPAD_Stop_bits integer;
alter table path add if not exists PINPAD_HardFlow Boolean;
alter table path add if not exists PINPAD_SoftFlow Boolean;
alter table path add if not exists PINPAD_HandShake integer;
alter table path add if not exists pix_QRCode integer;
alter table path drop if exists PINPAD_QRCode;

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

CREATE TABLE IF NOT EXISTS "rmovprod"
(
   "codigo" INTEGER,
   "ref" VARCHAR(20),
   "descricao" VARCHAR(60),
   "un" VARCHAR(2),
   "classe" VARCHAR(30),
   "linha" VARCHAR(40),
   "qtde" FLOAT,
   "custo" FLOAT,
   "venda" FLOAT,
   "desconto" FLOAT,
   "liquido" FLOAT,
   "lucro" FLOAT,
   "margeml" FLOAT,
   "cstpis" VARCHAR(3),
   "apis" FLOAT,
   "vlpis" FLOAT,
   "cstcofins" VARCHAR(3),
   "acofins" FLOAT,
   "vlcofins" FLOAT,
   "cstipi" VARCHAR(3),
   "aipi" FLOAT,
   "vlipi" FLOAT,
   "csticms" VARCHAR(3),
   "aicms" FLOAT,
   "vlicms" FLOAT,
   "estoque" FLOAT,
   "NFCE_NFE_TLS_Protocolo" INTEGER,
   "apagado" BOOLEAN,
PRIMARY KEY ("codigo") COMPRESS NONE
DESCRIPTION 'Temporário para resumo de produtos vendidos'
LOCALE CODE 0
USER MAJOR VERSION 3
);

CREATE INDEX IF NOT EXISTS "ref" ON "rmovprod" ("ref");
CREATE INDEX IF NOT EXISTS "descricao" ON "rmovprod" ("descricao");
CREATE INDEX IF NOT EXISTS "classe" ON "rmovprod" ("classe","descricao");
CREATE INDEX IF NOT EXISTS "qtde" ON "rmovprod" ("qtde");
CREATE INDEX IF NOT EXISTS "qtdemenos" ON "rmovprod" ("qtde" DESC,"descricao","ref");
CREATE INDEX IF NOT EXISTS "marca" ON "rmovprod" ("classe","linha","descricao");
CREATE INDEX IF NOT EXISTS "linha" ON "rmovprod" ("linha","classe","descricao");
CREATE INDEX IF NOT EXISTS "lucro" ON "rmovprod" ("lucro" DESC,"descricao");
CREATE INDEX IF NOT EXISTS "venda" ON "rmovprod" ("venda" DESC,"descricao");
CREATE INDEX IF NOT EXISTS "margem" ON "rmovprod" ("margeml" DESC,"lucro" DESC,"descricao");
CREATE INDEX IF NOT EXISTS "menoslucro" ON "rmovprod" ("lucro","descricao");
CREATE INDEX IF NOT EXISTS "menosvenda" ON "rmovprod" ("venda","descricao");
CREATE INDEX IF NOT EXISTS "menosmargem" ON "rmovprod" ("margeml","descricao");

CREATE TABLE IF NOT EXISTS "movabc"
(
   "codigo" INTEGER,
   "ref" VARCHAR(20),
   "barra" VARCHAR(20),
   "descricao" VARCHAR(80),
   "un" VARCHAR(2),
   "fabrica" VARCHAR(30),
   "grupo_codigo" INTEGER,
   "grupo_descricao" VARCHAR(40),
   "similar" VARCHAR(10),
   "custo" FLOAT,
   "margem" FLOAT,
   "venda" FLOAT,
   "vendas_qtde" FLOAT,
   "vendas_valor" FLOAT,
   "vendas_custo" FLOAT,
   "vendas_lucro" FLOAT,
   "vendas_total_geral" FLOAT,
   "vendas_percentual_individual" FLOAT,
   "vendas_percentual_acumulado" FLOAT,
   "curva" VARCHAR(1),
   "NFCE_NFE_TLS_Protocolo" INTEGER,
PRIMARY KEY ("RecordID") COMPRESS NONE
DESCRIPTION 'Temporário - Relatorio da Curva ABC'
LOCALE CODE 0
USER MAJOR VERSION 3
);

CREATE INDEX IF NOT EXISTS "codigo" ON "movabc" ("codigo");
CREATE INDEX IF NOT EXISTS "vendas_qtde" ON "movabc" ("vendas_qtde" DESC,"vendas_valor" DESC);

alter table path add if not exists Balanca_auto_codProd integer;