17 lines
758 B
SQL
17 lines
758 B
SQL
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;
|