--删除第一次配置的事件定义与事件订阅（没有则不会删除，针对第一版已经升级发布的客户使用）
DELETE FROM t_evt_event WHERE FID = 1570291697756164096;
DELETE FROM t_evt_event_l WHERE FPKID = '2XW38QN78FHD';
DELETE FROM t_evt_event_l WHERE FPKID = '2XW38QN78FHE';

DELETE FROM t_evt_subscription WHERE FID = 1570319241087833088;
DELETE FROM t_evt_subscription_l WHERE FPKID = '2XW8DF8NUN39';

--事件定义
DELETE FROM t_evt_eventconfig WHERE FENTRYID = 1576814561711886336;
INSERT INTO t_evt_eventconfig(FID,FCONFIGDESCRIPTION,FCONFIGTYPE,FISTRANSFER,FENTRYID,FSEQ,FCONFIGNUMBER,FISCUSTOM,FCONFIGNAME) VALUES (1570291697756164096,'返回结果类型为:枚举','{"description":"返回结果类型为:枚举","attribute":"例子：[{\"caption\":{\"zh_TW\":\"暫存\",\"en_US\":\"暂存\",\"zh_CN\":\"暂存\"},\"value\":\"A\"},{\"caption\":{\"zh_TW\":\"已提交\",\"en_US\":\"已提交\",\"zh_CN\":\"已提交\"},\"value\":\"B\"},{\"caption\":{\"zh_TW\":\"已審核\",\"en_US\":\"已审核\",\"zh_CN\":\"已审核\"},\"value\":\"C\"}] ","type":"enum","ismulti":false}','1',1576814561711886336,1,'outBillIds','1','补料单ID集合'); 
DELETE FROM t_evt_eventconfig WHERE FENTRYID = 1576814561711886337;
INSERT INTO t_evt_eventconfig(FID,FCONFIGDESCRIPTION,FCONFIGTYPE,FISTRANSFER,FENTRYID,FSEQ,FCONFIGNUMBER,FISCUSTOM,FCONFIGNAME) VALUES (1570291697756164096,'返回结果类型为:枚举','{"description":"返回结果类型为:枚举","attribute":"[{\"caption\":{\"zh_TW\":\"暫存\",\"en_US\":\"暂存\",\"zh_CN\":\"暂存\"},\"value\":\"A\"},{\"caption\":{\"zh_TW\":\"已提交\",\"en_US\":\"已提交\",\"zh_CN\":\"已提交\"},\"value\":\"B\"},{\"caption\":{\"zh_TW\":\"已審核\",\"en_US\":\"已审核\",\"zh_CN\":\"已审核\"},\"value\":\"C\"}] ","type":"enum","ismulti":false}','1',1576814561711886337,2,'operation','1','操作类型'); 
DELETE FROM t_evt_eventconfig WHERE FENTRYID = 1576814561711886338;
INSERT INTO t_evt_eventconfig(FID,FCONFIGDESCRIPTION,FCONFIGTYPE,FISTRANSFER,FENTRYID,FSEQ,FCONFIGNUMBER,FISCUSTOM,FCONFIGNAME) VALUES (1570291697756164096,'返回结果类型为:枚举','{"description":"返回结果类型为:枚举","attribute":"[{\"caption\":{\"zh_TW\":\"暫存\",\"en_US\":\"暂存\",\"zh_CN\":\"暂存\"},\"value\":\"A\"},{\"caption\":{\"zh_TW\":\"已提交\",\"en_US\":\"已提交\",\"zh_CN\":\"已提交\"},\"value\":\"B\"},{\"caption\":{\"zh_TW\":\"已審核\",\"en_US\":\"已审核\",\"zh_CN\":\"已审核\"},\"value\":\"C\"}] ","type":"enum","ismulti":false}','1',1576814561711886338,3,'outBillEntityType','1','补料单单据标识'); 

DELETE FROM t_evt_event WHERE FID = 1570291697756164096;
INSERT INTO t_evt_event(FID,FMODIFYDATE,FTYPE,FISPREINSDATA,FSCENE,FOPERATION,FCREATEDATE,FENTITY,FOPERNUMBER,FSTATUS,FNUMBER,FMODIFIER,FSOURCE,FNUMBERVIEW,FISMODIFIED,FCREATER) VALUES (1570291697756164096,{ts'2022-12-16  00:00:00'},'custom','0','operate',' ',{ts'2022-12-07  00:00:00'},' ',' ','1','mftstock.outupdate',1546235034439090176,' ','mftstock.outupdate','1',1546235034439090176); 

DELETE FROM t_evt_event_l WHERE FPKID = '2XW38QN78FHD';
INSERT INTO t_evt_event_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1570291697756164096,'2XW38QN78FHD','zh_CN','组件外领料更新组件清单','组件外领料更新组件清单'); 
DELETE FROM t_evt_event_l WHERE FPKID = '2XW38QN78FHE';
INSERT INTO t_evt_event_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1570291697756164096,'2XW38QN78FHE','zh_TW','組件外領料更新組件清單','組件外領料更新組件清單'); 

--事件订阅
DELETE FROM t_evt_subscription WHERE FID = 1576815001635655680;
INSERT INTO t_evt_subscription(FID,FMODIFYDATE,FISPREINSDATA,FCONDITION,FSERVICENUMBER,FCREATEDATE,FSEQUENCE,FEXECUTORVALUE,FISCONCURRENT,FSTATUS,FNOTIFYTEXT,FSERVICE,FNUMBER,FSERVICECONFIG,FEXPRESSION,FMODIFIER,FEVENT,FERRORNOTIFY,FEVENTNUMBER,FISMODIFIED,FTIMINGSTRATEGY,FEXECUTOR,FERRORSTRATEGY,FCREATER) VALUES (1576815001635655680,{ts'2022-12-16  00:00:00'},'0',' ','executePlugin',{ts'2022-12-16  00:00:00'},0,' ','1','1',' ',904236026388547584,'mftstock.outupdate.executePlugin','{"scriptid":"","type":"class","value":"{\"appid\":\"mpdm\",\"class\":\"kd.bd.mpdm.business.event.OutUpdateMftStockServiceEvent\"}"}',' ',1546235034439090176,1570291697756164096,' ','mftstock.outupdate','1',' ',' ','retry',1546235034439090176); 

DELETE FROM t_evt_subscription_l WHERE FPKID = '2YOC2YL6VINM';
INSERT INTO t_evt_subscription_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1576815001635655680,'2YOC2YL6VINM','zh_CN','组件外领料更新组件清单.执行插件'); 



