

update company_certificate t1,security_company t2
set t1.areaCode = t2.areacode,t1.orgId=t2.orgid
where t1.companyId = t2.id and t1.areaCode is null;

update company_certificate t1,sb_sponsorlicense t2
set t1.areaCode = t2.district,t1.orgId=t2.orgid
where t1.sponsorlicenseid = t2.id and t1.areaCode is null;


UPDATE company_certificate t1,config t2 SET t1.areaCode = concat(t2.`value`,'0000')
where t1.areaCode is null and t2.`key`='current_native';

update module_menu t1,config t2
set t1.`rankAuth`='0'
where parentIds like '%732604919269294080%'
and t2.`key`='current_native'
and t2.`value` not in ('11','45');


update module_menu t1,config t2
set t1.`rankAuth`='1'
where parentIds like '%732604919269294080%'
and t2.`key`='current_native'
and t2.`value` not in ('11','45');

#2020-12-21
update bank_account set initial=0;
update grade_Certificate set cerDate = appraisalTime;