rcs-sys/loan-parent/db/rec_loan/03-逐笔核算/004-rollback_rec_loan_yyyymmdd.sql
2025-03-07 16:23:56 +08:00

16 lines
580 B
SQL

drop table rec_transation_record;
drop table rec_data_check;
drop table rec_transation_record_err;
ALTER TABLE rec_charge_detail_tmp drop index `contract_no`;
ALTER TABLE REC_AR_STATUS_CHANGE_TMP drop index `contract_no`;
ALTER TABLE REC_REPAY_LOAN_DETAIL_TMP drop index `contract_no`;
ALTER TABLE rec_loan_detail_tmp drop index `contract_no`;
ALTER TABLE rec_loan_int_calc_tmp drop index `contract_no`;
ALTER TABLE rec_exempt_loan_detail_tmp drop index `contract_no`;
ALTER TABLE biz_cus_acct drop index `acct_attr`;
ALTER TABLE biz_cus_acct drop index `duebill_no`;