delete from t_msg_tplscene where fid in (1287610544727025664,1287610210365499392,1287609875433547776,1287609468535728128);

INSERT INTO t_msg_tplscene
(fid, fnumber, fentitynumber, fname, fispreinsdata, fcreatedate, fmodifydate)
VALUES(1287610544727025664, 'trip_order_notice_confrim_vehicle', 'er_vehiclebill', '商旅订单确认通知_用车', '0', {ts'2021-11-12 13:31:40'}, {ts'2021-11-12 17:27:39'});
INSERT INTO t_msg_tplscene
(fid, fnumber, fentitynumber, fname, fispreinsdata, fcreatedate, fmodifydate)
VALUES(1287610210365499392, 'trip_order_notice_confrim_hotel', 'er_hotelbill', '商旅订单确认通知_酒店', '0', {ts'2021-11-12 13:31:02'}, {ts'2021-11-12 13:31:38'});
INSERT INTO t_msg_tplscene
(fid, fnumber, fentitynumber, fname, fispreinsdata, fcreatedate, fmodifydate)
VALUES(1287609875433547776, 'trip_order_notice_confrim_plane', 'er_planebill', '商旅订单确认通知_飞机', '0', {ts'2021-11-12 13:30:12'}, {ts'2021-11-12 13:30:58'});
INSERT INTO t_msg_tplscene
(fid, fnumber, fentitynumber, fname, fispreinsdata, fcreatedate, fmodifydate)
VALUES(1287609468535728128, 'trip_order_notice_confrim_train', 'er_trainbill', '商旅订单确认通知_火车', '0', {ts'2021-11-12 13:29:09'}, {ts'2021-11-12 13:30:09'});


delete from t_msg_tplscene_l where fid in (1287610544727025664,1287610210365499392,1287609875433547776,1287609468535728128);
INSERT INTO t_msg_tplscene_l
(fpkid, fid, flocaleid, fname)
VALUES('204T=5ACIUXG', 1287609468535728128, 'zh_CN', '商旅订单确认通知_火车');
INSERT INTO t_msg_tplscene_l
(fpkid, fid, flocaleid, fname)
VALUES('204T=5ACIUXH', 1287609468535728128, 'zh_TW', '商旅訂單確認通知_火車');
INSERT INTO t_msg_tplscene_l
(fpkid, fid, flocaleid, fname)
VALUES('204TC3Z7SAYB', 1287609875433547776, 'zh_CN', '商旅订单确认通知_飞机');
INSERT INTO t_msg_tplscene_l
(fpkid, fid, flocaleid, fname)
VALUES('204TC3Z7SAYC', 1287609875433547776, 'zh_TW', '商旅訂單確認通知_飛機');
INSERT INTO t_msg_tplscene_l
(fpkid, fid, flocaleid, fname)
VALUES('204TEK4F=VAQ', 1287610210365499392, 'zh_CN', '商旅订单确认通知_酒店');
INSERT INTO t_msg_tplscene_l
(fpkid, fid, flocaleid, fname)
VALUES('204TEK4F=VAR', 1287610210365499392, 'zh_TW', '商旅訂單確認通知_酒店');
INSERT INTO t_msg_tplscene_l
(fpkid, fid, flocaleid, fname)
VALUES('204TH/5B94M8', 1287610544727025664, 'zh_CN', '商旅订单确认通知_用车');
INSERT INTO t_msg_tplscene_l
(fpkid, fid, flocaleid, fname)
VALUES('204TH/5B94M9', 1287610544727025664, 'zh_TW', '商旅訂單確認通知_用車');





delete from t_msg_template where fid in (1287618800920848384,1287615318121801728,1287613085351208960,  1287612044266203136 );
INSERT INTO t_msg_template
(fid, fmsgtype, fmsgchannel, fmsgscene, fmsgtemplate, fmsgentity, fcreatedate, fmodifydate, fmsgscenename, fnumber, fname, fbizplugin)
VALUES(1287618800920848384, 'message', 'yunzhijia', 'trip_order_notice_confrim_hotel', NULL, 'er_hotelbill', {ts'2021-11-12 13:47:29'}, {ts'2021-11-15 09:21:04'}, '商旅订单确认通知_酒店', 'er_trip_order_notice_hotel_yzj ', '商旅订单确认通知模版_酒店', ' ');
INSERT INTO t_msg_template
(fid, fmsgtype, fmsgchannel, fmsgscene, fmsgtemplate, fmsgentity, fcreatedate, fmodifydate, fmsgscenename, fnumber, fname, fbizplugin)
VALUES(1287615318121801728, 'message', 'yunzhijia', 'trip_order_notice_confrim_plane', NULL, 'er_planebill', {ts'2021-11-12 13:37:32'}, {ts'2021-11-12 18:42:11'}, '商旅订单确认通知_飞机', 'er_trip_order_notice_plane_yzj ', '商旅订单确认通知模版_飞机', ' ');
INSERT INTO t_msg_template
(fid, fmsgtype, fmsgchannel, fmsgscene, fmsgtemplate, fmsgentity, fcreatedate, fmodifydate, fmsgscenename, fnumber, fname, fbizplugin)
VALUES(1287613085351208960, 'message', 'yunzhijia', 'trip_order_notice_confrim_train', NULL, 'er_trainbill', {ts'2021-11-12 13:35:56'}, {ts'2021-11-15 09:21:18'}, '商旅订单确认通知_火车', 'er_trip_order_notice_train_yzj ', '商旅订单确认通知模版_火车', ' ');
INSERT INTO t_msg_template
(fid, fmsgtype, fmsgchannel, fmsgscene, fmsgtemplate, fmsgentity, fcreatedate, fmodifydate, fmsgscenename, fnumber, fname, fbizplugin)
VALUES(1287612044266203136, 'message', 'yunzhijia', 'trip_order_notice_confrim_vehicle', NULL, 'er_vehiclebill', {ts'2021-11-12 13:32:40'}, {ts'2021-11-15 09:21:34'}, '商旅订单确认通知_用车', 'er_trip_order_notice_vehicle_yzj', '商旅订单确认通知模版_用车', ' ');

delete from t_msg_template_l where fid in (1287618800920848384,1287615318121801728,1287613085351208960,  1287612044266203136 );

INSERT INTO t_msg_template_l
(fpkid, fid, flocaleid, fmsgscenename, fmsgtemplate, fname)
VALUES('204TRYAGVKKC', 1287612044266203136, 'zh_TW', '商旅訂單確認通知_用車', ' ', '商旅訂單確認通知模版_用車');
INSERT INTO t_msg_template_l
(fpkid, fid, flocaleid, fmsgscenename, fmsgtemplate, fname)
VALUES('204TZI6BNUN6', 1287613085351208960, 'zh_TW', '商旅訂單確認通知_火車', ' ', '商旅訂單確認通知模版_火車');
INSERT INTO t_msg_template_l
(fpkid, fid, flocaleid, fmsgscenename, fmsgtemplate, fname)
VALUES('204UCSQC+3RC', 1287615318121801728, 'zh_TW', '商旅訂單確認通知_飛機', ' ', '商旅訂單確認通知模版_飛機');
INSERT INTO t_msg_template_l
(fpkid, fid, flocaleid, fmsgscenename, fmsgtemplate, fname)
VALUES('204V05HW/IQQ', 1287618800920848384, 'zh_TW', '商旅訂單確認通知_酒店', ' ', '商旅訂單確認通知模版_酒店');
INSERT INTO t_msg_template_l
(fpkid, fid, flocaleid, fmsgscenename, fmsgtemplate, fname)
VALUES('204UCSQC+3RB', 1287615318121801728, 'zh_CN', '商旅订单确认通知_飞机', '{"title":"机票订单需要进行确认，请尽快处理。","content":"订单号：{ordernum}"}', '商旅订单确认通知模版_飞机');
INSERT INTO t_msg_template_l
(fpkid, fid, flocaleid, fmsgscenename, fmsgtemplate, fname)
VALUES('204V05HW/IQP', 1287618800920848384, 'zh_CN', '商旅订单确认通知_酒店', '{"title":"酒店订单需要进行确认，请尽快处理。","content":"订单号：{ordernum}"}', '商旅订单确认通知模版_酒店');
INSERT INTO t_msg_template_l
(fpkid, fid, flocaleid, fmsgscenename, fmsgtemplate, fname)
VALUES('204TZI6BNUN5', 1287613085351208960, 'zh_CN', '商旅订单确认通知_火车', '{"title":"火车订单需要进行确认，请尽快处理。","content":"订单号：{ordernum}"}', '商旅订单确认通知模版_火车');
INSERT INTO t_msg_template_l
(fpkid, fid, flocaleid, fmsgscenename, fmsgtemplate, fname)
VALUES('204TRYAGVKKB', 1287612044266203136, 'zh_CN', '商旅订单确认通知_用车', '{"title":"用车订单需要进行确认，请尽快处理。","content":"订单号：{ordernum}"}', '商旅订单确认通知模版_用车');


delete from t_msg_selectscene where fid in (1287618800920848384,1287615318121801728,1287613085351208960,  1287612044266203136 );
INSERT INTO t_msg_selectscene
(fpkid, fid, fbasedataid)
VALUES(1287612044266235904, 1287612044266203136, 1287610544727025664);
INSERT INTO t_msg_selectscene
(fpkid, fid, fbasedataid)
VALUES(1287613085351176192, 1287613085351208960, 1287609468535728128);
INSERT INTO t_msg_selectscene
(fpkid, fid, fbasedataid)
VALUES(1287615318121834496, 1287615318121801728, 1287609875433547776);
INSERT INTO t_msg_selectscene
(fpkid, fid, fbasedataid)
VALUES(1287618800920881152, 1287618800920848384, 1287610210365499392);






