53 lines
2.6 KiB
SQL
53 lines
2.6 KiB
SQL
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'; |