create table lmt_crdt_agr_20220424_tmp select app_no from lmt_crdt_agr where ccy = '';
create table lmt_crdt_lmt_20220424_tmp select lmt_no from lmt_crdt_lmt where ccy = '';
create table lmt_crdt_app_20220424_tmp select app_no from lmt_crdt_app where ccy = '';
create table lmt_cus_crdt_lmt_20220424_tmp select cus_lmt_no from lmt_cus_crdt_lmt where ccy = '';



alter table lmt_crdt_agr add index `ccy`(`ccy`) using  BTREE;
alter table lmt_crdt_lmt add index `ccy`(`ccy`)  using BTREE;
alter table lmt_crdt_app add index  `ccy`(`ccy`) using  BTREE;
alter table lmt_cus_crdt_lmt add index `ccy`(`ccy`) using  BTREE;

drop index `ccy` on lmt_crdt_agr;
drop index `ccy` on lmt_crdt_lmt;
drop index `ccy` on lmt_crdt_app;
drop index `ccy` on lmt_cus_crdt_lmt;