
DELETE FROM t_bcm_batchexportplan WHERE FID IN (SELECT FID FROM t_bmc_batchexportplan);
INSERT INTO t_bcm_batchexportplan (FID,FNUMBER,FMASTERID,FNAME,FAPPLICATIONSCOPE,FISDEFAULTPLAN,FDESCRIPTION,FMODIFIERID,FCREATORID,FCREATETIME,FMODIFYTIME,FSTATUS,FENABLE,FUSERID,FPLANID,FMODELID) SELECT FID,FNUMBER,FMASTERID,FNAME,FAPPLICATIONSCOPE,FISDEFAULTPLAN,FDESCRIPTION,FMODIFIERID,FCREATORID,FCREATETIME,FMODIFYTIME,FSTATUS,FENABLE,FUSERID,FPLANID,FMODELID FROM t_bmc_batchexportplan;

DELETE FROM t_bcm_batchexportplan_l WHERE FID IN (SELECT FID FROM t_bmc_batchexportplan_l);
INSERT INTO t_bcm_batchexportplan_l (FPKID,FID,FLOCALEID,FNAME) SELECT FPKID,FID,FLOCALEID,FNAME FROM t_bmc_batchexportplan_l;
