/** 增加FAPPID字段，升级数据 **/
UPDATE T_META_MAINENTITYINFO A SET FAPPID = (SELECT FNUMBER FROM T_META_BIZAPP B WHERE FID = A.FBIZAPPID AND FTYPE <> '2') WHERE EXISTS (SELECT 1 FROM T_META_BIZAPP B WHERE FID = A.FBIZAPPID AND FTYPE <> '2');
UPDATE T_META_MAINENTITYINFO A SET FAPPID = (SELECT FNUMBER FROM T_META_BIZAPP B WHERE FID = (SELECT FMASTERID FROM T_META_BIZAPP WHERE FTYPE = '2' AND FID = A.FBIZAPPID)) WHERE EXISTS (SELECT FNUMBER FROM T_META_BIZAPP B WHERE FID = (SELECT FMASTERID FROM T_META_BIZAPP WHERE FTYPE = '2' AND FID = A.FBIZAPPID));
