alter table lmt_crdt_app  drop column `three_ele_auth_sign`;
alter table lmt_crdt_app  drop column `three_ele_auth_fail_reason`;
alter table lmt_crdt_app  drop column `ocr_reco_sign`;
alter table lmt_crdt_app  drop column `ocr_reco_fail_reason`;


delete from biz_coop_sftp_config where id = '9';
delete from bam_file_group where id = '628164642547433472';
delete from bam_file_grp_detail where id in (628165320317599744,628165320325988352,628165320338571264,628165320351154176,628165320359542784,628165320376320000);
delete from biz_tran_config where id in (627899772220473344,627901023465242624);

delete from sys_option where id = '20630408757272117248';
delete from sys_option where id in (20630409175532306432,20630409408450396160,20630409584573415424,20630410047301615616,20630410427523661824,20630410595945938944);
delete from sys_option where id = '20630415264059490304';

delete from biz_coop_config where id = '628269218256650240';
-- 删除表
DROP TABLE cfg_ip;


-- 回滚自动代偿信息表新增字段：代偿类型
ALTER TABLE `rec_loan`.`rec_ln_acct_automatic_compensation` DROP COLUMN `compensatory_method`;

-- 回滚贷款还款历史表新增字段：登记日期
ALTER TABLE `rec_loan`.`rec_ln_acct_repayment_mmdd_add` DROP COLUMN `create_date`;
-- 回滚贷款还款历史表新增字段：登记时间戳
ALTER TABLE `rec_loan`.`rec_ln_acct_repayment_mmdd_add` DROP COLUMN `create_time`;

-- 回滚贷款还款计划表新增字段：登记日期
ALTER TABLE `rec_loan`.`rec_ln_acct_repay_plan_add` DROP COLUMN `create_date`;
-- 回滚贷款还款计划表新增字段：登记时间戳
ALTER TABLE `rec_loan`.`rec_ln_acct_repay_plan_add` DROP COLUMN `create_time`;

-- 删除款还款计划变更信息表
DROP TABLE `rec_loan`.`rec_ln_acct_repay_plan_amend`;

-- 回滚还款计划表表新增字段：应还总额
ALTER TABLE `rec_loan`.`fac_loan_repay_plan` DROP COLUMN `curr_total_amt`;


-- 影像平台根节点映射
delete from `rec_loan`.`sys_option` where id = '20632535682379677696';
-- 影像平台子节点映射
delete from `rec_loan`.`sys_option` where id = '20632536829622484992';
-- 影像平台上传配置
delete from `rec_loan`.`sys_option` where id = '20632537364559822848';
-- 影像配置
delete from `rec_loan`.`bam_file_group` where id = '632533329295441920';
delete from `rec_loan`.`bam_file_grp_detail` where id = '632533543163002880';
-- 组件配置
delete from `rec_loan`.`biz_tran_config` where id = '629280659965214720';
delete from `rec_loan`.`biz_tran_config` where id = '628656396199526400';
delete from `rec_loan`.`biz_tran_config` where id = '628655883370364928';