drop table biz_dxm_request_info;
drop table biz_account_bdcollate;
drop table rec_bdfile_loan_tmp;
drop table rec_bdfile_repay_plan_tmp;
drop table rec_bdfile_open_tmp;
drop table rec_bdfile_repay_tmp;
drop table rec_bdfile_repay_item_tmp;
drop table rec_bdfile_reduce_tmp;
drop table rec_bdfile_loan_rate_tmp;
drop table rec_bdfile_ledger_tmp;
drop table rec_bdfile_flow_tmp;
drop table rec_bdfile_transfertxt_tmp;
drop table rec_bdfile_transfermoney_tmp;
drop table rec_bdfile_loan_his;
drop table rec_bdfile_repay_plan_his;
drop table rec_bdfile_open_his;
drop table rec_bdfile_repay_his;
drop table rec_bdfile_repay_item_his;
drop table rec_bdfile_reduce_his;
drop table rec_bdfile_loan_rate_his;
drop table rec_bdfile_ledger_his;
drop table rec_bdfile_flow_his;
drop table rec_bdfile_transfertxt_his;
drop table rec_bdfile_transfermoney_his;
drop table lmt_dxm_ext_used_lmt;
drop table lmt_dxm_ext_used_lmt_his;
drop table lmt_dxm_ext_used_biz_rel;
drop table biz_accounting_config;
drop table biz_accounting_record;
drop table biz_accounting_detail;
drop table biz_dxm_benefit_config;
drop table biz_dxm_benefit_record;
drop table biz_dxm_benefit_detail;
drop table lmt_recovery_notice;

alter table cus_indiv  drop column `localization`;
alter table cus_indiv  drop column `revenue_level`;
alter table cus_indiv  drop column `total_loan_cnt`;
alter table cus_indiv  drop column `days_of_loan`;
alter table cus_indiv  drop column `if_car_flag`;
alter table cus_indiv  drop column `if_house_flag`;


alter table lmt_cus_indiv  drop column  `revenue_level`;
alter table lmt_cus_indiv  drop column  `total_loan_cnt`;
alter table lmt_cus_indiv  drop column  `days_of_loan`;
alter table lmt_cus_indiv  drop column  `if_car_flag`;
alter table lmt_cus_indiv  drop column  `if_house_flag`;
alter table lmt_cus_indiv  drop column  `localization`;
alter table lmt_cus_indiv  drop column  `finally_int`;
alter table lmt_cus_indiv  drop column  `json_address`;

alter table lmt_crdt_app  drop column  `cert_type`;
alter table lmt_crdt_app  drop column  `cert_no`;
alter table lmt_crdt_app  drop column  `float_rate`;



alter table ctr_loan_cont  drop column  `cont_content`;


alter table pay_credit_app modify column ext_app_no varchar(50) default null comment '外部申请编号';
alter table lmt_crdt_risk modify column ext_app_no varchar(50) default null comment '外部申请编号';
alter table lmt_crdt_app modify column ext_app_no varchar(50) default null comment '外部申请编号';
alter table lmt_crdt_apply_report modify column ext_app_no varchar(50) default null comment '外部申请编号';
alter table lmt_crdt_agr modify column ext_app_no varchar(50) default null comment '外部申请编号';
alter table biz_tran_record modify column ext_app_no varchar(50) default null comment '外部申请编号';
alter table biz_tran_record modify column tran_no varchar(50) default null comment '交易流水号';
alter table cus_ind_work modify column com_name varchar(200) not null comment '工作单位名称';
alter table pay_payout_app modify column ext_app_no varchar(50) default null comment '外部申请编号';
alter table ctr_loan_cont modify column cont_no varchar(64) default null comment '贷款合同编号';
alter table bam_file_store modify column biz_key varchar(32) default null comment '业务主键';
alter table pay_credit_app modify column cont_no varchar(40) default null comment '贷款合同编号';
alter table finsih_limit MODIFY COLUMN `reason` varchar(200) NOT NULL COMMENT '调整原因' AFTER `prd_name`;
alter table finsih_limit_list MODIFY COLUMN `reason` varchar(200) NOT NULL COMMENT '调整原因' AFTER `prd_name`;

ALTER TABLE biz_open_tran_log drop index `index_tran_code`;
ALTER TABLE biz_open_tran_log drop index `index_is_success`;

alter table biz_open_tran_log  drop column `consume_time`;
alter table biz_open_tran_log  drop column `ret_code`;
alter table biz_open_tran_log  drop column `ret_msg`;
alter table biz_open_tran_log  drop column `is_success`;
alter table biz_open_tran_log  drop column `glob_seq_num`;

ALTER TABLE finsih_limit DROP COLUMN `before_lmt_rate`;
ALTER TABLE finsih_limit DROP COLUMN `after_lmt_rate` ;
ALTER TABLE finsih_limit DROP COLUMN `before_repay_mode`;
ALTER TABLE finsih_limit DROP COLUMN `after_repay_mode`;
ALTER TABLE finsih_limit DROP COLUMN `repay_periods`;
ALTER TABLE finsih_limit DROP COLUMN `reason_org`;
ALTER TABLE finsih_limit DROP COLUMN `occur_time`;
ALTER TABLE finsih_limit DROP COLUMN `dxm_b_score_org`;
ALTER TABLE finsih_limit DROP COLUMN `dxm_b_score_cur_org`;


ALTER TABLE finsih_limit_list DROP COLUMN `before_lmt_rate`;
ALTER TABLE finsih_limit_list DROP COLUMN `after_lmt_rate` ;
ALTER TABLE finsih_limit_list DROP COLUMN `before_repay_mode`;
ALTER TABLE finsih_limit_list DROP COLUMN `after_repay_mode`;
ALTER TABLE finsih_limit_list DROP COLUMN `repay_periods`;
ALTER TABLE finsih_limit_list DROP COLUMN `reason_org`;
ALTER TABLE finsih_limit_list DROP COLUMN `occur_time`;
ALTER TABLE finsih_limit_list DROP COLUMN `dxm_b_score_org`;
ALTER TABLE finsih_limit_list DROP COLUMN `dxm_b_score_cur_org`;

ALTER TABLE lmt_crdt_lmt DROP COLUMN `lmt_rate`;



DELETE FROM BIZ_TRAN_CONFIG WHERE  ID='600712063760728064';
DELETE FROM BIZ_TRAN_CONFIG WHERE  ID='600712367566749696';
DELETE FROM BIZ_TRAN_CONFIG WHERE  ID='600712664942903296';
DELETE FROM BIZ_TRAN_CONFIG WHERE  ID='600712774561038336';
DELETE FROM BIZ_TRAN_CONFIG WHERE  ID='600712850326945792';
DELETE FROM BIZ_TRAN_CONFIG WHERE  ID='600712917129625600';
DELETE FROM BIZ_TRAN_CONFIG WHERE  ID='600769981558292480';
DELETE FROM BIZ_TRAN_CONFIG WHERE  ID='601786897747935232';
DELETE FROM BIZ_TRAN_CONFIG WHERE  ID='609813082360774656';
DELETE FROM BIZ_TRAN_CONFIG WHERE  ID='607145376406831104';

delete from biz_accounting_config where id = '1';
delete from biz_accounting_config where id = '2';
delete from biz_accounting_config where id = '3';
delete from biz_accounting_config where id = '4';
delete from biz_accounting_config where id = '5';
delete from biz_accounting_config where id = '6';
delete from biz_accounting_config where id = '7';
delete from biz_accounting_config where id = '8';
delete from biz_accounting_config where id = '9';
delete from biz_accounting_config where id = '10';
delete from biz_accounting_config where id = '11';
delete from biz_accounting_config where id = '12';
delete from biz_accounting_config where id = '13';
delete from biz_accounting_config where id = '14';
delete from biz_accounting_config where id = '15';
delete from biz_accounting_config where id = '16';
delete from biz_accounting_config where id = '17';
delete from biz_accounting_config where id = '18';
delete from biz_accounting_config where id = '19';
delete from biz_accounting_config where id = '20';
delete from biz_accounting_config where id = '21';
delete from biz_accounting_config where id = '22';
delete from biz_accounting_config where id = '23';
delete from biz_accounting_config where id = '24';
delete from biz_accounting_config where id = '25';
delete from biz_accounting_config where id = '29';
delete from biz_accounting_config where id = '30';
delete from biz_accounting_config where id = '31';
delete from biz_accounting_config where id = '32';
delete from biz_accounting_config where id = '33';
delete from biz_accounting_config where id = '34';
delete from biz_accounting_config where id = '35';
delete from biz_accounting_config where id = '36';
delete from biz_accounting_config where id = '37';
delete from biz_accounting_config where id = '38';
delete from biz_accounting_config where id = '39';
delete from biz_accounting_config where id = '40';
delete from biz_accounting_config where id = '41';
delete from biz_accounting_config where id = '42';
delete from biz_accounting_config where id = '43';
delete from biz_accounting_config where id = '44';
delete from biz_accounting_config where id = '45';
delete from biz_accounting_config where id = '46';
delete from biz_accounting_config where id = '47';
delete from biz_accounting_config where id = '48';
delete from biz_accounting_config where id = '49';
delete from biz_accounting_config where id = '50';
delete from biz_accounting_config where id = '51';
delete from biz_accounting_config where id = '52';
delete from biz_accounting_config where id = '53';
delete from biz_accounting_config where id = '54';
delete from biz_accounting_config where id = '55';
delete from biz_accounting_config where id = '56';
delete from biz_accounting_config where id = '57';
delete from biz_accounting_config where id = '58';
delete from biz_accounting_config where id = '59';
delete from biz_accounting_config where id = '60';
delete from biz_accounting_config where id = '61';
delete from biz_accounting_config where id = '62';
delete from biz_accounting_config where id = '63';
delete from biz_accounting_config where id = '64';
delete from biz_accounting_config where id = '65';
delete from biz_accounting_config where id = '66';
delete from biz_accounting_config where id = '67';
delete from biz_accounting_config where id = '68';
delete from biz_accounting_config where id = '69';
delete from biz_accounting_config where id = '70';
delete from biz_accounting_config where id = '71';
delete from biz_accounting_config where id = '72';
delete from biz_accounting_config where id = '73';
delete from biz_accounting_config where id = '74';
delete from biz_accounting_config where id = '75';
delete from biz_accounting_config where id = '76';
delete from biz_accounting_config where id = '77';
delete from biz_accounting_config where id = '78';
delete from biz_accounting_config where id = '79';
delete from biz_accounting_config where id = '80';
delete from biz_accounting_config where id = '81';
delete from biz_accounting_config where id = '82';
delete from biz_accounting_config where id = '83';
delete from biz_accounting_config where id = '84';
delete from biz_accounting_config where id = '85';
delete from biz_accounting_config where id = '86';
delete from biz_accounting_config where id = '87';
delete from biz_accounting_config where id = '88';
delete from biz_accounting_config where id = '89';
delete from biz_accounting_config where id = '90';
delete from biz_accounting_config where id = '91';
delete from biz_accounting_config where id = '92';
delete from biz_accounting_config where id = '93';
delete from biz_accounting_config where id = '94';
delete from biz_accounting_config where id = '95';
delete from biz_accounting_config where id = '96';
delete from biz_accounting_config where id = '97';
delete from biz_accounting_config where id = '98';
delete from biz_accounting_config where id = '99';
delete from biz_accounting_config where id = '100';
delete from biz_accounting_config where id = '101';
delete from biz_accounting_config where id = '102';
delete from biz_accounting_config where id = '103';
delete from biz_accounting_config where id = '104';
delete from biz_accounting_config where id = '105';
delete from biz_accounting_config where id = '106';
delete from biz_accounting_config where id = '107';
delete from biz_accounting_config where id = '108';
delete from biz_accounting_config where id = '109';
delete from biz_accounting_config where id = '110';
delete from biz_accounting_config where id = '111';
delete from biz_accounting_config where id = '112';
delete from biz_accounting_config where id = '113';
delete from biz_accounting_config where id = '114';
delete from biz_accounting_config where id = '115';
delete from biz_accounting_config where id = '116';
delete from biz_accounting_config where id = '117';
delete from biz_accounting_config where id = '118';
delete from biz_accounting_config where id = '119';
delete from biz_accounting_config where id = '120';
delete from biz_accounting_config where id = '121';
delete from biz_accounting_config where id = '122';
delete from biz_accounting_config where id = '123';
delete from biz_accounting_config where id = '124';
delete from biz_accounting_config where id = '125';
delete from biz_accounting_config where id = '126';
delete from biz_accounting_config where id = '127';
delete from biz_accounting_config where id = '128';
delete from biz_accounting_config where id = '129';
delete from biz_accounting_config where id = '130';
delete from biz_accounting_config where id = '131';
delete from biz_accounting_config where id = '132';


DELETE FROM biz_cont_tmpl_app WHERE  ID='606560514046164992';
DELETE FROM biz_cont_tmpl WHERE  ID='606560514046164993';
DELETE FROM biz_cont_signer_config WHERE  ID='606560845677203456';
DELETE FROM prd_agr_tmpl_ref WHERE  ID='609051007220973568';



delete from bam_file_group where id in (
    606561981637328896,
    606562352581574656
    );

delete from bam_file_grp_detail where id in (
     606561981645717504,
     606561981662494720,
     606561981675077632,
     606561981687660544,
     606562352594157568
    );

delete from sys_option where id in (
    '20606562939482144768',
    '20606563034940309504',
    '20606563924346667008',
    '20606563603562102784',
    '20606563728904683520',
    '20606563829513453568',
    '20606564133894094848',
    '20606802016336871424',
    '20606626320704602112',
    '20606556279250354176',
    '20607618876766683136',
    '20607618585824591872',
    '20607618801697030144'
    '20606900929182048256',
    '20606900969157959680',
    '20606901035813838848',
    '20606901067468251136',
    '20606905650013806592',
    '20606905704875302912',
    '20606905768528060416',
    '20606905830993829888',
    '20606905913667756032'

    );

delete from sys_select where id in (
    '20606556186694647808',
    '20606626246939377664',
    '20606801761113473024',
    '20606900819874291712',
    '20606904983606009856'
);

delete from biz_coop_config where coop_no = '602431367094996992';

delete from biz_coop_prd_config where coop_no = '602431367094996992';

delete from biz_coop_sftp_config where coop_no = '602431367094996992';

delete from biz_return_code_map where id in (
    '31',
    '32',
    '33',
    '34',
    '35',
    '36',
    '37'
    );