-- 刷原始预置数据给新增的字段：foriname、forinumber（我是去基线环境找到的fname、fnumber，因为这个在用户环境可能已经修改过，基线不出意外还是原厂的。我没遇到出意外的），同时还要升级对应多语言表中zh_CN对应的foriname
update t_hdm_regcategory set foriname='提前转正',forinumber ='101020_S' where fid =1020;
update t_hdm_regcategory set foriname='不予转正',forinumber ='102020_S' where fid =2020;
update t_hdm_regcategory set foriname='延期转正',forinumber ='101090_S' where fid =1080;
update t_hdm_regcategory set foriname='按期转正',forinumber ='101010_S' where fid =1010;
update t_hdm_regcategory_l set foriname='提前转正' where fid =1020 and flocaleid = 'zh_CN';
update t_hdm_regcategory_l set foriname='不予转正' where fid =2020 and flocaleid = 'zh_CN';
update t_hdm_regcategory_l set foriname='延期转正' where fid =1080 and flocaleid = 'zh_CN';
update t_hdm_regcategory_l set foriname='按期转正' where fid =1010 and flocaleid = 'zh_CN';

update t_hdm_regcomment set foriname='同意转正',forinumber ='1010_S' where fid =1010;
update t_hdm_regcomment set foriname='不同意转正',forinumber ='1020_S' where fid =1020;
update t_hdm_regcomment_l set foriname='同意转正' where fid =1010 and flocaleid = 'zh_CN';
update t_hdm_regcomment_l set foriname='不同意转正' where fid =1020 and flocaleid = 'zh_CN';


update t_hdm_regexamitem set foriname='激情',forinumber ='101010_S' where fid =1378222755853505536;
update t_hdm_regexamitem set foriname='责任感',forinumber ='101020_S' where fid =1371026398319299584;
update t_hdm_regexamitem set foriname='创新能力',forinumber ='101030_S' where fid =1371026606398747648;
update t_hdm_regexamitem set foriname='团队合作',forinumber ='101040_S' where fid =1371026800712463360;
update t_hdm_regexamitem set foriname='客户导向',forinumber ='101050_S' where fid =1371026941381030912;
update t_hdm_regexamitem set foriname='学习能力',forinumber ='101060_S' where fid =1371027081839883264;
update t_hdm_regexamitem set foriname='工作效率',forinumber ='101070_S' where fid =1371027205966115840;
update t_hdm_regexamitem set foriname='发展潜力',forinumber ='101080_S' where fid =1371027385322943488;
update t_hdm_regexamitem set foriname='基础知识',forinumber ='101090_S' where fid =1371027552767947776;
update t_hdm_regexamitem set foriname='专业技能',forinumber ='102010_S' where fid =1371027683571512320;
update t_hdm_regexamitem set foriname='践行核心价值观',forinumber ='102020_S' where fid =1371027921807952896;

update t_hdm_regexamitem_l set foriname='激情' where fid =1378222755853505536 and flocaleid = 'zh_CN';
update t_hdm_regexamitem_l set foriname='责任感' where fid =1371026398319299584 and flocaleid = 'zh_CN';
update t_hdm_regexamitem_l set foriname='创新能力' where fid =1371026606398747648 and flocaleid = 'zh_CN';
update t_hdm_regexamitem_l set foriname='团队合作' where fid =1371026800712463360 and flocaleid = 'zh_CN';
update t_hdm_regexamitem_l set foriname='客户导向' where fid =1371026941381030912 and flocaleid = 'zh_CN';
update t_hdm_regexamitem_l set foriname='学习能力' where fid =1371027081839883264 and flocaleid = 'zh_CN';
update t_hdm_regexamitem_l set foriname='工作效率' where fid =1371027205966115840 and flocaleid = 'zh_CN';
update t_hdm_regexamitem_l set foriname='发展潜力' where fid =1371027385322943488 and flocaleid = 'zh_CN';
update t_hdm_regexamitem_l set foriname='基础知识' where fid =1371027552767947776 and flocaleid = 'zh_CN';
update t_hdm_regexamitem_l set foriname='专业技能' where fid =1371027683571512320 and flocaleid = 'zh_CN';
update t_hdm_regexamitem_l set foriname='践行核心价值观' where fid =1371027921807952896 and flocaleid = 'zh_CN';



update t_hdm_regexamtype set foriname='核心能力素质',forinumber ='1010_S' where fid =1371024520009305088;
update t_hdm_regexamtype set foriname='专业能力',forinumber ='1020_S' where fid =1371024680852474880;
update t_hdm_regexamtype set foriname='组织认同',forinumber ='1030_S' where fid =1371024811949640704;

update t_hdm_regexamtype_l set foriname='核心能力素质' where fid =1371024520009305088 and flocaleid = 'zh_CN';
update t_hdm_regexamtype_l set foriname='专业能力' where fid =1371024680852474880 and flocaleid = 'zh_CN';
update t_hdm_regexamtype_l set foriname='组织认同' where fid =1371024811949640704 and flocaleid = 'zh_CN';


update t_hdm_parttimereason set foriname='业务分管',forinumber ='1010_S' where fid =1387719114973366272;
update t_hdm_parttimereason_l set foriname='业务分管' where fid =1387719114973366272 and flocaleid = 'zh_CN';



-- 对比fname与foriname或fnumber与forinumber是否一致，不一致则证明被修改过，进行赋值foristatus='1'
update t_hdm_regcategory set foristatus = '1' where fissyspreset = '1' and (fnumber != forinumber or fname != foriname or fdescription != '预置数据');
update t_hdm_regcomment set foristatus = '1' where fissyspreset = '1' and (fnumber != forinumber or fname != foriname or fdescription != '预置数据');
update t_hdm_regexamitem set foristatus = '1' where fissyspreset = '1' and (fnumber != forinumber or fname != foriname or fdescription != ' ');
update t_hdm_regexamtype set foristatus = '1' where fissyspreset = '1' and (fnumber != forinumber or fname != foriname or fdescription != '预置数据');
update t_hdm_regtestmodel set foristatus = '1' where fissyspreset = '1' and (fnumber != forinumber or fname != foriname);
update t_hdm_parttimereason set foristatus = '1' where fissyspreset = '1' and (fnumber != forinumber or fname != foriname or fdescription != '业务分管');


