DELETE FROM T_MSG_TPLSCENE WHERE FID = 1982569222873673728;
DELETE FROM T_MSG_TPLSCENE WHERE FID = 1982570167900696576;
INSERT INTO T_MSG_TPLSCENE
(FNUMBER, FID, FENTITYNUMBER, FNAME, FISPREINSDATA, FCREATEDATE, FMODIFYDATE)
VALUES('bei_bankpaybill_refund', 1982569222873673728, 'bei_bankpaybill', '银行付款单退票', '0', {ts'2018-08-08  00:00:00'}, {ts'2018-08-08  00:00:00'});
INSERT INTO T_MSG_TPLSCENE
(FNUMBER, FID, FENTITYNUMBER, FNAME, FISPREINSDATA, FCREATEDATE, FMODIFYDATE)
VALUES('bei_bankagentpay_refund', 1982570167900696576, 'bei_bankagentpay', '银行代发单分录退票', '0', {ts'2018-08-08  00:00:00'}, {ts'2018-08-08  00:00:00'});

DELETE FROM T_MSG_TPLSCENE_L WHERE FPKID = '47I=J/HRWT+X';
DELETE FROM T_MSG_TPLSCENE_L WHERE FPKID = '47I=J/HRWT+Y';
DELETE FROM T_MSG_TPLSCENE_L WHERE FPKID = '47I=PX2+/2N7';
DELETE FROM T_MSG_TPLSCENE_L WHERE FPKID = '47I=PX2+/2N8';
INSERT INTO T_MSG_TPLSCENE_L (FPKID, FID, FLOCALEID, FNAME) VALUES('47I=J/HRWT+X', 1982569222873673728, 'zh_CN', '银行付款单退票');
INSERT INTO T_MSG_TPLSCENE_L (FPKID, FID, FLOCALEID, FNAME) VALUES('47I=PX2+/2N7', 1982570167900696576, 'zh_CN', '银行代发单分录退票');


DELETE FROM T_MSG_TEMPLATE WHERE FID = 1982579486939541504;
DELETE FROM T_MSG_TEMPLATE WHERE FID = 1982586735258890240;
INSERT INTO T_MSG_TEMPLATE
(FID, FMSGTYPE, FMSGCHANNEL, FMSGSCENE, FMSGTEMPLATE, FMSGENTITY, FCREATEDATE, FMODIFYDATE, FMSGSCENENAME, FNUMBER, FNAME, FBIZPLUGIN, FCOMMONLANG)
VALUES(1982579486939541504, 'message', 'mcenter', 'bei_bankpaybill_refund', NULL, 'bei_bankpaybill', {ts'2018-08-08  00:00:00'}, {ts'2018-08-08  00:00:00'}, '银行付款单退票', 'bei_bankpaybill_refund_notice', '银行付款单退票通知', ' ', '{"title":"银行付款单退票通知","content":"银行付款单：{billno}已被退票，请及时查看和处理。"}');
INSERT INTO T_MSG_TEMPLATE
(FID, FMSGTYPE, FMSGCHANNEL, FMSGSCENE, FMSGTEMPLATE, FMSGENTITY, FCREATEDATE, FMODIFYDATE, FMSGSCENENAME, FNUMBER, FNAME, FBIZPLUGIN, FCOMMONLANG)
VALUES(1982586735258890240, 'message', 'mcenter', 'bei_bankagentpay_refund', NULL, 'bei_bankagentpay', {ts'2018-08-08  00:00:00'}, {ts'2018-08-08  00:00:00'}, '银行代发单分录退票', 'bei_bankagentpay_refund_notice', '银行代发单分录退票通知', ' ', '{"title":"银行代发单分录退票通知","content":"银行代发单：{billno}已被退票，请及时查看和处理。"}');


DELETE FROM T_MSG_TEMPLATE_L WHERE FPKID = '47IBFTGJCKLP';
DELETE FROM T_MSG_TEMPLATE_L WHERE FPKID = '47IBFTGJCKLQ';
DELETE FROM T_MSG_TEMPLATE_L WHERE FPKID = '47ICTMD=TKD+';
DELETE FROM T_MSG_TEMPLATE_L WHERE FPKID = '47ICTMD=TKD/';
INSERT INTO T_MSG_TEMPLATE_L
(FPKID, FID, FLOCALEID, FMSGSCENENAME, FMSGTEMPLATE, FNAME)
VALUES('47IBFTGJCKLP', 1982579486939541504, 'zh_CN', '银行付款单退票', '{"title":"银行付款单退票通知","content":"银行付款单：{billno}已被退票，请及时查看和处理。"}', '银行付款单退票通知');
INSERT INTO T_MSG_TEMPLATE_L
(FPKID, FID, FLOCALEID, FMSGSCENENAME, FMSGTEMPLATE, FNAME)
VALUES('47ICTMD=TKD+', 1982586735258890240, 'zh_CN', '银行代发单分录退票', '{"title":"银行代发单分录退票通知","content":"银行代发单：{billno}已被退票，请及时查看和处理。"}', '银行代发单分录退票通知');
