
/******消息平台预置数据***********/

DELETE FROM T_MSG_TPLSCENE WHERE FID = 1692819436425650176;
INSERT INTO T_MSG_TPLSCENE(FID,FMODIFYDATE,FISPREINSDATA,FCREATEDATE,FENTITYNUMBER,FNUMBER,FNAME) VALUES (1692819436425650176,{ts'2008-08-08  00:00:00'},'0',{ts'2008-08-08  00:00:00'},'er_contractbill','er_contact_pay','合同台账单');

DELETE FROM T_MSG_TPLSCENE_L WHERE FPKID = '3=Y409LDRYZ4';
INSERT INTO T_MSG_TPLSCENE_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1692819436425650176,'3=Y409LDRYZ4','zh_CN','合同台账单');
DELETE FROM T_MSG_TPLSCENE_L WHERE FPKID = '3=Y409LDRYZ5';
INSERT INTO T_MSG_TPLSCENE_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1692819436425650176,'3=Y409LDRYZ5','zh_TW','合同台賬單');



DELETE FROM T_MSG_TEMPLATE WHERE FID = 1692818732495609856;
INSERT INTO T_MSG_TEMPLATE(FID,FMODIFYDATE,FMSGSCENENAME,FCREATEDATE,FCOMMONLANG,FMSGENTITY,FNAME,FNUMBER,FMSGTYPE,FMSGCHANNEL,FBIZPLUGIN,FMSGTEMPLATE,FMSGSCENE) VALUES (1692818732495609856,{ts'2008-08-08  00:00:00'},'合同台账单',{ts'2008-08-08  00:00:00'},'{"content":"合同台账存在超期未付单据{billno}来自消息平台。"}','er_contractbill','合同付款云之家预警','contactCloud','message','yunzhijia',' ',NULL,'er_contact_pay');

DELETE FROM T_MSG_TEMPLATE_L WHERE FPKID = '3=Y3X4JDDSVT';
INSERT INTO T_MSG_TEMPLATE_L(FID,FMSGSCENENAME,FPKID,FLOCALEID,FMSGTEMPLATE,FNAME) VALUES (1692818732495609856,'合同台账单','3=Y3X4JDDSVT','zh_CN','{"content":"合同台账存在超期未付单据{billno}来自消息平台。"}','合同付款云之家预警');
DELETE FROM T_MSG_TEMPLATE_L WHERE FPKID = '3=Y3X4JDDSVU';
INSERT INTO T_MSG_TEMPLATE_L(FID,FMSGSCENENAME,FPKID,FLOCALEID,FMSGTEMPLATE,FNAME) VALUES (1692818732495609856,'合同台賬單','3=Y3X4JDDSVU','zh_TW',' ','合同付款雲之家預警');


DELETE FROM t_msg_template WHERE FID = 1697040572696835072;
INSERT INTO t_msg_template(FID,FMODIFYDATE,FMSGSCENENAME,FCREATEDATE,FCOMMONLANG,FMSGENTITY,FNAME,FNUMBER,FMSGTYPE,FMSGCHANNEL,FBIZPLUGIN,FMSGTEMPLATE,FMSGSCENE) VALUES (1697040572696835072,{ts'2023-06-07  00:00:00'},'合同台账单',{ts'2023-05-31  00:00:00'},'{"content":"{billstatus}"}','er_contractbill','合同付短信款预警','contractMsg','message','sms',' ',NULL,'er_contact_pay');


DELETE FROM T_MSG_TEMPLATE_L WHERE FPKID = '3AFBQM5HBAZG';
INSERT INTO T_MSG_TEMPLATE_L(FID,FMSGSCENENAME,FPKID,FLOCALEID,FMSGTEMPLATE,FNAME) VALUES (1697040572696835072,'合同台账单','3AFBQM5HBAZG','zh_CN','{"content":"{billstatus}"}','合同付短信款预警');
DELETE FROM T_MSG_TEMPLATE_L WHERE FPKID = '3AFBQM5HBAZH';
INSERT INTO T_MSG_TEMPLATE_L(FID,FMSGSCENENAME,FPKID,FLOCALEID,FMSGTEMPLATE,FNAME) VALUES (1697040572696835072,'合同台賬單','3AFBQM5HBAZH','zh_TW',' ','合同付短信款預警');




DELETE FROM T_MSG_SELECTSCENE WHERE FPKID = 1697040572696834048;
INSERT INTO T_MSG_SELECTSCENE(FID,FBASEDATAID,FPKID) VALUES (1697040572696835072,1692819436425650176,1697040572696834048);

DELETE FROM T_MSG_SELECTSCENE WHERE FPKID = 1692819578360773632;
INSERT INTO T_MSG_SELECTSCENE(FID,FBASEDATAID,FPKID) VALUES (1692818732495609856,1692819436425650176,1692819578360773632);



