
update sb_personcertificate set censor_status='001' where censor_status is null or censor_status ='';
update sb_personcertificate set card_state='0' where card_state is null or card_state ='';
update sb_personcertificate set test_state='0' where test_state is null or test_state ='';
update sb_personcertificate set exam_state='0' where exam_state is null or exam_state ='';
update sb_personcertificate set fee_state='0' where fee_state is null or fee_state ='';
update sb_personcertificate set fingercard_state='0' where fingercard_state is null or fingercard_state ='';
