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 venda1 add if not exists e2e varchar(40);