
UPDATE `sys_dict` SET `codeType`='fingercardState',`label`='已入库' WHERE `codeType`='fingercardState' and codeValue='1';
UPDATE `sys_dict` SET `codeType`='fingercardState',`label`='已采集' WHERE `codeType`='fingercardState' and codeValue='2';

update sb_grade_subsidy_batch set offApprovalState = approvalState;

update module_menu t1,config t2
set t1.active=FALSE
where parentIds like '%776400500833308672%'
and t2.`key`='current_native'
and t2.`value` not in ('11');

update sb_personcertificate t1,com_contract t2
set t1.contractStart = t2.effectStartDate,t1.contractEnd = t2.effectEndDate
where t1.comContractId is not null and t1.comContractId = t2.comContractId;

update sb_person_grade t1,com_contract t2
set t1.contractStart = t2.effectStartDate,t1.contractEnd = t2.effectEndDate
where t1.contractId is not null and t1.contractId = t2.comContractId;