--预置用餐订单确认-消息场景及模板
--消息场景
DELETE FROM T_MSG_TPLSCENE WHERE FID = 1559472080830026752;
DELETE FROM t_msg_tplscene_l WHERE FPKID = '2WJ9NCG26/P/';
DELETE FROM t_msg_tplscene_l WHERE FPKID = '2WJ9NCG26/P0';
INSERT INTO T_MSG_TPLSCENE(FID,FMODIFYDATE,FISPREINSDATA,FCREATEDATE,FENTITYNUMBER,FNUMBER,FNAME) VALUES (1559472080830026752,{ts'2018-08-08 18:08:08'},'1',{ts'2018-08-08 18:08:08'},'er_mealbill','trip_order_notice_confrim_meal','商旅订单确认通知_用餐');
INSERT INTO t_msg_tplscene_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1559472080830026752,'2WJ9NCG26/P/','zh_CN','商旅订单确认通知_用餐');
INSERT INTO t_msg_tplscene_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1559472080830026752,'2WJ9NCG26/P0','zh_TW','商旅訂單確認通知_用餐');

--消息模板
DELETE FROM t_msg_template WHERE FID = 1559473501533066240;
DELETE FROM t_msg_template_l WHERE FPKID = '2WJ9XQ7F8TVS';
DELETE FROM t_msg_template_l WHERE FPKID = '2WJ9XQ7F8TVT';
INSERT INTO t_msg_template(FID,FMODIFYDATE,FMSGSCENENAME,FCREATEDATE,FCOMMONLANG,FMSGENTITY,FNUMBER,FNAME,FMSGTYPE,FMSGCHANNEL,FBIZPLUGIN,FMSGTEMPLATE,FMSGSCENE) VALUES (1559473501533066240,{ts'2018-08-08 18:08:08'},'商旅订单确认通知_用餐',{ts'2018-08-08 18:08:08'},'{"title":"用餐订单需要进行确认，请尽快处理。","content":"订单号：{ordernum}"}','er_mealbill','er_trip_order_notice_meal_yzj','商旅订单确认通知模版_用餐','message','yunzhijia',' ',NULL,'trip_order_notice_confrim_meal');
INSERT INTO t_msg_template_l(FID,FMSGSCENENAME,FPKID,FLOCALEID,FMSGTEMPLATE,FNAME) VALUES (1559473501533066240,'商旅订单确认通知_用餐','2WJ9XQ7F8TVS','zh_CN','{"title":"用餐订单需要进行确认，请尽快处理。","content":"订单号：{ordernum}"}','商旅订单确认通知模版_用餐');
INSERT INTO t_msg_template_l(FID,FMSGSCENENAME,FPKID,FLOCALEID,FMSGTEMPLATE,FNAME) VALUES (1559473501533066240,'商旅訂單確認通知_用餐','2WJ9XQ7F8TVT','zh_TW',' ','商旅訂單確認通知模版_用餐');


