-- 基础资料出厂字段对比,设置出厂状态字段
UPDATE T_HAOS_ADMINORGTYPE SET FORISTATUS = '1' WHERE FID IN (1010, 1020, 1030, 1040) AND (FNAME != FORINAME OR FNUMBER != FORINUMBER);
UPDATE T_HAOS_ADMINORGTYPESTD SET FORISTATUS = '1' WHERE FID IN (1010, 1020, 1030, 1040) AND (FNAME != FORINAME OR FNUMBER != FORINUMBER);
UPDATE T_HAOS_PROJCHANGETYPE SET FORISTATUS = '1' WHERE FID IN (1010, 1020, 1030, 1040, 1050) AND (FNAME != FORINAME OR FNUMBER != FORINUMBER);
UPDATE T_HAOS_PROJCHANGESCENE SET FORISTATUS = '1' WHERE FID IN (1010, 1020, 1030, 1040, 1050) AND (FNAME != FORINAME OR FNUMBER != FORINUMBER);
UPDATE T_HAOS_PROJCHANGEOPERATE SET FORISTATUS = '1' WHERE FID IN (1010, 1020, 1030, 1040, 1050) AND (FNAME != FORINAME OR FNUMBER != FORINUMBER);
UPDATE T_HAOS_ORGCHANGETYPE SET FORISTATUS = '1' WHERE FID IN (1010, 1020, 1030, 1040, 1050, 1060, 1070, 1080, 1090) AND (FNAME != FORINAME OR FNUMBER != FORINUMBER);
UPDATE T_HAOS_ORGCHANGEREASON SET FORISTATUS = '1' WHERE FID = 1010 AND (FNAME != FORINAME OR FNUMBER != FORINUMBER);
UPDATE T_HAOS_OTCLASSIFY SET FORISTATUS = '1' WHERE FID IN (1010, 1020, 1030, 1040) AND (FNAME != FORINAME OR FNUMBER != FORINUMBER);
UPDATE T_HAOS_TEAMCOOPRELTYPE SET FORISTATUS = '1' WHERE FID = 1010 AND (FNAME != FORINAME OR FNUMBER != FORINUMBER);
UPDATE T_HAOS_ORGCHANGETYPE SET FORISTATUS = '1' WHERE FID IN (1010, 1020, 1030, 1040, 1050, 1060, 1070, 1080, 1090, 1110) AND (FNAME != FORINAME OR FNUMBER != FORINUMBER);
UPDATE T_HAOS_CHANGEOPERAT SET FORISTATUS = '1' WHERE FID IN (1010, 1020, 1030, 1040, 1050) AND (FNAME != FORINAME OR FNUMBER != FORINUMBER);
UPDATE T_HAOS_CHANGESCENESUB SET FORISTATUS = '1' WHERE FID IN (1010, 1020, 1030, 1040, 1050, 1060, 1070, 1080, 1090, 1100, 1110, 1120, 1130, 1140, 1150) AND (FNAME != FORINAME OR FNUMBER != FORINUMBER);
