

#2020-09-21 资格证数据所有小写x，统一更新为大写X，后续生成的新证书信息也都只记录大写X
update security_person set id_number= UPPER(id_number);
update security_certificate set idnum= UPPER(idnum);
update security_certificate_snapshot set idnum= UPPER(idnum);
update sb_personcertificate set Cardnumber= UPPER(Cardnumber);

#2020-09-24 课程学习记录旧数据修复
update cer_learn_record t1,sb_personcertificate t2
set t1.trainId= t2.trainOrgID,t1.trainName = t2.trainOrgName
where t1.idNum = t2.Cardnumber and t1.recordType='01'
and t1.trainId is null;

update cer_learn_record t1,sb_person_grade t2
set t1.trainId= t2.trainId,t1.trainName = t2.trainName
where t1.idNum = t2.idNum and t1.recordType='03'
and t1.trainId is null;