编辑文件 - a-846-7.sql

✏️ 正在编辑: a-846-7.sql

路径: /srv/systems_dir/yuppiecred/data/database/a-846-7.sql
提示: 您可以编辑任何文件（包括二进制文件），但请注意不当修改可能导致文件损坏。

ALTER TABLE `tb_bancos_febraban` ADD `digital` TINYINT  NULL  DEFAULT '0'  AFTER `taxa_transf`;

CREATE TABLE `tmp_bancos_digitais` (
  `codigo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `nome` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  KEY `codigo` (`codigo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

set names utf8;

INSERT INTO `tmp_bancos_digitais` (`codigo`, `nome`)
VALUES
	('69','Banco Crefisa S.A.'),
	('77','Banco Intermedium'),
	('79','Banco JBS'),
	('82','Banco Topázio S.A.'),
	('93','Polocred (Pinbank)'),
	('102','XP'),
	('121','Agibank'),
	('125','Banco Genial'),
	('140','Easyinvest'),
	('169','Olé Bonsucesso Consig S.A.'),
	('174','Pernambucanas Financ S.A.'),
	('183','Socred S.A.'),
	('197','Stone Pagamentos S.A.'),
	('212','Banco Original'),
	('218','Bonsucesso'),
	('224','Banco Fibra S.A.'),
	('243','Banco Máxima S.A.'),
	('260','Nubank'),
	('280','MeuPag!'),
	('290','PagBank'),
	('292','BS2 Títulos e Investimentos'),
	('318','BMG'),
	('323','Mercado Pago'),
	('335','Banco Digio S.A.'),
	('336','C6'),
	('340','Banco Super Digital'),
	('348','Banco XP S/A'),
	('380','PicPay Servicos S.A'),
	('396','HUB Pagamentos S.A.'),
	('401','IUGU'),
	('450','Fitbank'),
	('613','Omni Banco S.A.'),
	('626','Banco C6 Consignado S.A.'),
	('630','Banco Smartbank S.A.'),
	('637','Sofisa Direto'),
	('653','Banco Indusval'),
	('654','SouDigi+'),
	('735','Banco Neon'),
	('746','Banco Modal'),
	('748','Woop Sicredi');

update tb_bancos_febraban b
	inner join tmp_bancos_digitais tmp on(b.codigo = tmp.codigo)
set digital = 1;

insert into tb_bancos_febraban (codigo, nome, digital)
select codigo, nome, '1' as digital from tmp_bancos_digitais tmp
where codigo not in (select codigo from tb_bancos_febraban);

DROP TABLE tmp_bancos_digitais;

-- update tb_bancos_febraban
--     set codigo = LPAD(codigo, 3, "0")
-- where length(codigo) < 3;

create table tmp_bancos_excluir as 
select count(id) as qtd, codigo, nome, max(digital) as digital from tb_bancos_febraban 
group by cast(codigo as unsigned)
having count(id) > 1;

delete from tb_bancos_febraban where codigo in(select cast(codigo as unsigned) from tmp_bancos_excluir) and digital = 1;

drop table tmp_bancos_excluir;

← 返回文件管理器