-- hmx add start ---
alter table finsih_limit_list drop column pro_version;
alter table finsih_limit
drop column pro_version,
drop column recheck_user,
drop column recheck_time;

-- hmx add end ---


-- yyk add start ---

alter table rec_credit_detail_tmp drop column rate_upper_limit;
alter table rec_credit_detail_tmp drop column rate_lower_limit;
alter table rec_credit_detail_his drop column rate_upper_limit;
alter table rec_credit_detail_his drop column rate_lower_limit;

alter table fac_loan_duebill drop column contract_type;
alter table ctr_loan_cont drop column contract_type;
alter table pay_payout_app drop column contract_type;
alter table pay_credit_app drop column contract_type;
alter table pls_repay_result drop column contract_type;

-- yyk add end ---
-- ycq add start--
ALTER TABLE `rec_loan`.`lmt_first_audit`
DROP COLUMN `cust_verify_type`,
DROP COLUMN `cust_verify_result`,
DROP COLUMN `cust_verify_time`,
DROP COLUMN `contracts`;

ALTER TABLE `rec_loan`.`lmt_last_audit`
DROP COLUMN `platform_admit_limit`,
DROP COLUMN `platform_rate_limit`,
DROP COLUMN `platform_rate_bottom`,
DROP COLUMN `credit_rate_limit`,
DROP COLUMN `credit_rate_bottom`;

ALTER TABLE `rec_loan`.`lmt_last_audit`
MODIFY COLUMN `platfrom_admit` int(11) DEFAULT NULL COMMENT '授信建议额度 分' AFTER `platform_access`;

-- 修改字段长度
ALTER TABLE `rec_loan`.`biz_dxm_request_info`
MODIFY COLUMN `request` varchar(10240) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '合作方请求数据' AFTER `business_key`;

ALTER TABLE `rec_loan`.`lmt_crdt_app`
DROP COLUMN `business_model`;
-- ycq add end--

-- 字段相关

-- 数据字典
delete from `rec_loan`.sys_select where select_key in('PRDCODE_TYPE','WSD_PRO_VERSION_TYPE','WSD_RATE_TYPE','WSD_REPAY_MODE','WSD_LOAN_MODE','WSD_LOAN_USE','WSD_CUST_VERIFY_TYPE','WSD_ISDIRECT','WSD2_BUSINESS_MODEL','PUSH_REASON','COMPANY_INFO_COMPANY_TYPE','TRUE_FALSE_FLAG','COMPANY_INFO_STATUS_ID','COMPANY_INFO_FUND_CURRENCY','CUST_VERIFY_RESULT','WSD_GRADE_01_02','WSD_GRADE_01_05','WSD_GRADE_01_10','WSD_GRADE_01_04','WSD_GRADE_01_08','WSD_GRADE_1_6','WSD_SEG_A_D','WSD_CUST_SEG_SMF_FINAL','SMF_REPAYMENT_SEG','RISK_SMF_FINAL','WSD_GRADE_1_5')
delete from `rec_loan`.sys_option where select_id in('20606866586644520960','20629620871161446400','20629693738360242176','20629694522795753472','20629695786078175232','20629696766186356736','20629704733367468032','20635519908511219712','20636147928146116608','20633015993672663040','20633609080459493376','20633017648409477120','20633029497733513216','20633690619016904704','20633714998618619904','20633784410520420352','20633784771780018176','20633783736822923264','20633785258734518272','20633785772327043072','20633786210237546496','20633783342961000448','20633786703563194368','20633787173031641088','20633788251974402048','20633788731446263808')


-- 交易配置
delete from biz_tran_config where tran_code in('TRANWSD007','ONLINEWSD010','ONLINEWSD011','TRANWSD008','TRANWSD005','TRANWSD006','ONLINEWSD0009');

UPDATE `rec_loan`.`biz_tran_config` SET `tran_code` = 'ONLINEWSD0006', `tran_name` = '额度反欺诈调用', `tran_sts` = '1', `tran_lock` = '1', `rec_save_flag` = '1', `retry_times` = 1, `retry_space` = 1, `wait_end` = '1', `bank_code` = '007', `create_user` = '007001', `create_org` = '007', `create_date` = '2022-02-28', `create_time` = '2022-03-22 20:02:20', `update_user` = '007001', `update_org` = '007', `update_date` = '2022-02-25', `update_time` = '2022-03-23 23:56:50', `cur_vers` = 4, `json_res` = '{\"lines\":[{\"target\":\"1647955683376\",\"source\":\"1647955685318\",\"text\":\"\",\"condition\":\"\"},{\"target\":\"1647955686774\",\"source\":\"1647955683376\",\"text\":\"\",\"condition\":\"\"}],\"nodes\":[{\"id\":1647955683376,\"nodeName\":\"网商额度变更反欺诈发送\",\"left\":\"291px\",\"top\":\"128px\",\"type\":\"tranConfigScheduleExecutor\",\"code\":\"fqzSendServiceService\"},{\"id\":1647955685318,\"nodeName\":\"开始\",\"left\":\"113px\",\"top\":\"125px\",\"type\":\"start\",\"code\":\"\"},{\"id\":1647955686774,\"nodeName\":\"结束节点\",\"left\":\"524px\",\"top\":\"129px\",\"type\":\"end\",\"code\":\"\"}]}', `validate_res` = NULL, `business_open_date` = NULL, `business_close_date` = NULL, `retry` = '1' WHERE `id` = 604403148139790336;
UPDATE `rec_loan`.`biz_tran_config` SET `tran_code` = 'ONLINEWSD0001', `tran_name` = '网商初审处理', `tran_sts` = '1', `tran_lock` = '1', `rec_save_flag` = '1', `retry_times` = 3, `retry_space` = 1, `wait_end` = '1', `bank_code` = '007', `create_user` = '007001', `create_org` = '007', `create_date` = '2038-12-13', `create_time` = '2022-02-25 13:45:06', `update_user` = '007001', `update_org` = '007', `update_date` = '2042-07-22', `update_time` = '2022-05-28 11:39:25', `cur_vers` = 8, `json_res` = '{\"lines\":[{\"target\":\"1653709825913\",\"source\":\"1645768962404\",\"text\":\"\",\"condition\":\"\"},{\"target\":\"1645768997216\",\"source\":\"1653709825913\",\"text\":\"\",\"condition\":\"\"}],\"nodes\":[{\"id\":1645768962404,\"nodeName\":\"开始\",\"left\":\"96px\",\"top\":\"49px\",\"type\":\"start\",\"code\":\"\"},{\"id\":1645768997216,\"nodeName\":\"结束节点\",\"left\":\"541px\",\"top\":\"49px\",\"type\":\"end\",\"code\":\"\"},{\"id\":1646137135172,\"nodeName\":\"初审用户中心开户\",\"left\":\"351px\",\"top\":\"239px\",\"type\":\"tranConfigScheduleExecutor\",\"code\":\"cusAccountTranService\"},{\"id\":1653709825913,\"nodeName\":\"初审虚节点\",\"left\":\"330px\",\"top\":\"49px\",\"type\":\"tranConfigScheduleExecutor\",\"code\":\"WSDFirstCreditVirtual\"}]}', `validate_res` = NULL, `business_open_date` = '00:00:00', `business_close_date` = '23:59:59', `retry` = '1' WHERE `id` = 595248518260588544;
UPDATE `rec_loan`.`biz_tran_config` SET `tran_code` = 'ONLINEWSD0002', `tran_name` = '网商终审处理', `tran_sts` = '1', `tran_lock` = '1', `rec_save_flag` = '1', `retry_times` = 6, `retry_space` = 1, `wait_end` = '1', `bank_code` = '007', `create_user` = '007001', `create_org` = '007', `create_date` = '2038-12-13', `create_time` = '2022-02-25 13:47:24', `update_user` = '007001', `update_org` = '007', `update_date` = '2041-12-22', `update_time` = '2022-05-17 15:11:52', `cur_vers` = 97, `json_res` = '{\"lines\":[{\"target\":\"1652066908399\",\"source\":\"1647177665611\",\"text\":\"\",\"condition\":\"\"},{\"target\":\"1652166695119\",\"source\":\"1652066908399\",\"text\":\"\",\"condition\":\"\"},{\"target\":\"1647177665611\",\"source\":\"1647177668658\",\"text\":\"\",\"condition\":\"\"},{\"target\":\"1652240079224\",\"source\":\"1652166695119\",\"text\":\"\",\"condition\":\"\"},{\"target\":\"1652771354299\",\"source\":\"1645769217269\",\"text\":\"\",\"condition\":\"\"},{\"target\":\"1652771833780\",\"source\":\"1652771354299\",\"text\":\"\",\"condition\":\"\"},{\"target\":\"1647177668658\",\"source\":\"1652771833780\",\"text\":\"\",\"condition\":\"\"}],\"nodes\":[{\"id\":1645769217269,\"nodeName\":\"开始\",\"left\":\"78px\",\"top\":\"56px\",\"type\":\"start\",\"code\":\"\"},{\"id\":1647177665611,\"nodeName\":\"终审四要素鉴权\",\"left\":\"677px\",\"top\":\"440px\",\"type\":\"tranConfigScheduleExecutor\",\"code\":\"creditApplyAuthService\"},{\"id\":1647177668658,\"nodeName\":\"联网核查\",\"left\":\"694px\",\"top\":\"7px\",\"type\":\"tranConfigScheduleExecutor\",\"code\":\"creditApplyInspectService\"},{\"id\":1652066908399,\"nodeName\":\"终审三要素鉴权\",\"left\":\"452px\",\"top\":\"446px\",\"type\":\"tranConfigScheduleExecutor\",\"code\":\"creditThreeApplyAuthService\"},{\"id\":1652166695119,\"nodeName\":\"网商授信反欺诈复审发送mq\",\"left\":\"232px\",\"top\":\"456px\",\"type\":\"tranConfigScheduleExecutor\",\"code\":\"testService\"},{\"id\":1652240079224,\"nodeName\":\"结束节点\",\"left\":\"16px\",\"top\":\"470px\",\"type\":\"end\",\"code\":\"creditThreeApplyAuthService\"},{\"id\":1652771354299,\"nodeName\":\"本地化标签\",\"left\":\"284px\",\"top\":\"40px\",\"type\":\"tranConfigScheduleExecutor\",\"code\":\"cusLocalFlagTranService\"},{\"id\":1652771833780,\"nodeName\":\"检查身份证影像文件是否上传\",\"left\":\"444px\",\"top\":\"16px\",\"type\":\"tranConfigScheduleExecutor\",\"code\":\"checkCreditApplyImageService\"}]}', `validate_res` = NULL, `business_open_date` = '00:00:00', `business_close_date` = '23:59:59', `retry` = '1' WHERE `id` = 595249096646721536;
UPDATE `rec_loan`.`biz_tran_config` SET `tran_code` = 'TRANWSD001', `tran_name` = '网商初审 ', `tran_sts` = '1', `tran_lock` = '1', `rec_save_flag` = '1', `retry_times` = 5, `retry_space` = 1, `wait_end` = '1', `bank_code` = '007', `create_user` = '007001', `create_org` = '007', `create_date` = '2038-12-13', `create_time` = '2022-02-25 13:46:08', `update_user` = '007001', `update_org` = '007', `update_date` = '2041-04-11', `update_time` = '2022-04-22 15:30:20', `cur_vers` = 19, `json_res` = '{\"lines\":[{\"target\":\"1646211854423\",\"source\":\"1646211830474\",\"text\":\"\",\"condition\":\"\"},{\"target\":\"1646211830474\",\"source\":\"1646210318207\",\"text\":\"\",\"condition\":\"\"},{\"target\":\"1646210316645\",\"source\":\"1645768718818\",\"text\":\"\",\"condition\":\"\"},{\"target\":\"1646210318207\",\"source\":\"1646210316645\",\"text\":\"\",\"condition\":\"\"}],\"nodes\":[{\"id\":1645768718818,\"nodeName\":\"开始\",\"left\":\"33px\",\"top\":\"79px\",\"type\":\"start\",\"code\":\"\"},{\"id\":1646210316645,\"nodeName\":\"保存授信初审\",\"left\":\"263px\",\"top\":\"138px\",\"type\":\"tranConfigScheduleExecutor\",\"code\":\"saveLmtFirstAudit\"},{\"id\":1646210318207,\"nodeName\":\"网商授信入参校验服务\",\"left\":\"320px\",\"top\":\"263px\",\"type\":\"tranConfigScheduleExecutor\",\"code\":\"WsdcreditInputCheckService\"},{\"id\":1646211830474,\"nodeName\":\"流程发起\",\"left\":\"498px\",\"top\":\"224px\",\"type\":\"tranConfigScheduleExecutor\",\"code\":\"publishFlowService\"},{\"id\":1646211854423,\"nodeName\":\"结束节点\",\"left\":\"502px\",\"top\":\"308px\",\"type\":\"end\",\"code\":\"\"}]}', `validate_res` = NULL, `business_open_date` = '00:00:00', `business_close_date` = '23:59:59', `retry` = '1' WHERE `id` = 595248780396199936;


-- 申报参数
delete from `rec_loan`.`prd_declaration_parameters` where id in ('629707564409421824','632883358304567296');

delete from `rec_loan`.`prd_tree` p where p.pid='629680216939167744';
delete from `rec_loan`.`prd_tree` p where p.pid='629687537895473152';

delete from `rec_loan`.`prd_tree` where id='596716345882574848';
delete from `rec_loan`.`prd_tree` where id='596720610277588992';

-- 客群区分标识
delete from `rec_loan`.`prd_tree`  where id ='632988041568321536';

-- 是否存有效⼯商信息
delete from `rec_loan`.`prd_tree`  where id ='633014808861474816';

-- 经营状态
delete from `rec_loan`.`prd_tree`  where id ='633015128345804800';

-- 公司类型
delete from `rec_loan`.`prd_tree`  where id ='633628635932131328';

-- 币种
delete from `rec_loan`.`prd_tree`  where id ='633691179073929216';

-- 核身方式
delete from `rec_loan`.`prd_tree`  where id ='633704602474119168';

-- 核身结果
delete from `rec_loan`.`prd_tree`  where id ='633715806793891840';

delete from `rec_loan`.`prd_tree`  where id in ('633735440716926976','633735440721121280','633736066855211008','633736603294109696','633736603348635648','633743828632866816','633798822421729282','633798822421729283');

delete from `rec_loan`.`prd_tree`  where id in ('596715801818431488','597478229808250880','596720026816348160','601359488800260096','596719595755143168');

delete from `rec_loan`.`prd_tree`  where id in ('633797720959750144','633797720959750145','633797720959750146','633797720959750147','633797720959750148','633797720959750149',
                                                                                       '633797720959750150','633797720959750151','633797720959750152','633797720959750153','633797720959750154','633797720963944448',
                                                                                       '633797720963944449','633797720963944450','633797720963944451','633797720963944452','633797720963944453','633797720963944454',
                                                                                       '633797720963944455','633797720963944456','633798822409146368','633798822417534976','633798822417534977','633798822417534978',
                                                                                       '633798822417534979','633798822421729281');

delete from `rec_loan`.`prd_tree`  where id in ('639430988610539520');

-- 产品配置
delete from `rec_loan`.`prd_tran_config` where id in ('631866950766559232','630338285058654208') ;

-- 网商2.0生产影像地址
delete from sys_option where id in ('639911642993532931','639911642993532932','639911642993532929','639911642993532928','635559706206666752','639911642993532930','639911642989338624');


-- 止付调额菜单
INSERT into `rec_loan`.`sys_app` select * from `rec_loan`.`sys_app_20220630_tmp`;

-- 产品交易场景
delete from sys_option where id in ('20630344063047958528','20630344168698281984','20637682203358134272','20637683092928069632');


-- 新增批量
delete from `rec_job`.`xxl_job_info` p where p.id in ('179','183','184','185','186','187','188');
update `rec_job`.`xxl_job_info` set `child_jobid` = '' where `id` = '92'