-- 物料库存信息新增字段fispurchaseinspect，fisinvinspect，历史数据升级
UPDATE t_bd_materialinvinfo AS INV SET fispurchaseinspect='1', fisinvinspect='1' WHERE INV.FMASTERID IN (SELECT MS.FID FROM  T_BD_MATERIAL_S AS MS WHERE MS.FENABLEINSPECT = '1' ) AND INV.fispurchaseinspect='0' AND INV.fisinvinspect='0';