DELETE FROM T_BRM_SCENE_L WHERE fid in (select fid from T_BRM_SCENE where  FNUMBER in ('SCENE_COLLECT_TEMPLATE','COLLECT_APPROVE_FAIL','COLLECT_APPROVE_REJECT', 'COLLECT_APPROVE_PASS','COLLECT_TASK_NOTICE_MESSAGE','COLLECT_NOTICE_MESSAGE'));
DELETE FROM T_BRM_SCENEINPUT_L WHERE fentryid  in (select fentryid from T_BRM_SCENEINPUT where  fid in (select fid from T_BRM_SCENE where  FNUMBER in ('SCENE_COLLECT_TEMPLATE','COLLECT_APPROVE_FAIL','COLLECT_APPROVE_REJECT', 'COLLECT_APPROVE_PASS','COLLECT_TASK_NOTICE_MESSAGE','COLLECT_NOTICE_MESSAGE')));
DELETE FROM T_BRM_SCENEOUTPUT_L WHERE fentryid  in (select fentryid from T_BRM_SCENEOUTPUT where  fid in (select fid from T_BRM_SCENE where  FNUMBER in ('SCENE_COLLECT_TEMPLATE','COLLECT_APPROVE_FAIL','COLLECT_APPROVE_REJECT', 'COLLECT_APPROVE_PASS','COLLECT_TASK_NOTICE_MESSAGE','COLLECT_NOTICE_MESSAGE')));
DELETE FROM T_BRM_SCENEINPUT WHERE fid in (select fid from T_BRM_SCENE where  FNUMBER in ('SCENE_COLLECT_TEMPLATE','COLLECT_APPROVE_FAIL','COLLECT_APPROVE_REJECT', 'COLLECT_APPROVE_PASS','COLLECT_TASK_NOTICE_MESSAGE','COLLECT_NOTICE_MESSAGE'));
DELETE FROM T_BRM_SCENEOUTPUT WHERE fid in (select fid from T_BRM_SCENE where  FNUMBER in ('SCENE_COLLECT_TEMPLATE','COLLECT_APPROVE_FAIL','COLLECT_APPROVE_REJECT', 'COLLECT_APPROVE_PASS','COLLECT_TASK_NOTICE_MESSAGE','COLLECT_NOTICE_MESSAGE'));

DELETE FROM T_BRM_SCENE WHERE fid in (select fid from T_BRM_SCENE where  FNUMBER in ('SCENE_COLLECT_TEMPLATE','COLLECT_APPROVE_FAIL','COLLECT_APPROVE_REJECT', 'COLLECT_APPROVE_PASS','COLLECT_TASK_NOTICE_MESSAGE','COLLECT_NOTICE_MESSAGE'));

DELETE FROM T_BRM_SCENE WHERE FID = 1312140694491515904;
INSERT INTO T_BRM_SCENE(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FBIZAPPID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1312140694491515904,'0',NULL,' ','活动采集模板匹配',1312140694491515904,'C','SCENE_COLLECT_TEMPLATE','采集模板匹配',0,{ts'2021-12-16  00:00:00'},13466739,'1','1WXB5G9/BL46',{ts'2022-03-09  00:00:00'},13466739,0);
DELETE FROM T_BRM_SCENE WHERE FID = 1340032928045875200;
INSERT INTO T_BRM_SCENE(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FBIZAPPID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1340032928045875200,'0',NULL,' ','信息审核通过消息模板',1340032928045875200,'C','COLLECT_APPROVE_PASS','信息审核通过消息模板',0,{ts'2022-01-23  00:00:00'},13466739,'1','1WXB5G9/BL46',{ts'2022-01-23  00:00:00'},13466739,0);
DELETE FROM T_BRM_SCENE WHERE FID = 1315956853858896896;
INSERT INTO T_BRM_SCENE(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FBIZAPPID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1315956853858896896,'0',NULL,' ','采集活动一键提醒',1315956853858896896,'C','COLLECT_NOTICE_MESSAGE','采集活动一键提醒',0,{ts'2021-12-21  00:00:00'},13466739,'1','1WXB5G9/BL46',{ts'2021-12-21  00:00:00'},13466739,0);
DELETE FROM T_BRM_SCENE WHERE FID = 1315957168213594112;
INSERT INTO T_BRM_SCENE(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FBIZAPPID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1315957168213594112,'0',NULL,' ','采集活动定时任务提醒获取消息模板信息',1315957168213594112,'C','COLLECT_TASK_NOTICE_MESSAGE','采集活动定时任务提醒',0,{ts'2021-12-21  00:00:00'},13466739,'1','1WXB5G9/BL46',{ts'2021-12-21  00:00:00'},13466739,0);
DELETE FROM T_BRM_SCENE WHERE FID = 1340033326152432640;
INSERT INTO T_BRM_SCENE(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FBIZAPPID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1340033326152432640,'0',NULL,' ','信息审核审核驳回消息模板',1340033326152432640,'C','COLLECT_APPROVE_REJECT','信息审核审核驳回消息模板',0,{ts'2022-01-23  00:00:00'},13466739,'1','1WXB5G9/BL46',{ts'2022-01-23  00:00:00'},13466739,0);
DELETE FROM T_BRM_SCENE WHERE FID = 1340437281768487936;
INSERT INTO T_BRM_SCENE(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FBIZAPPID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1340437281768487936,'0',NULL,' ',' ',1340437281768487936,'C','COLLECT_APPROVE_FAIL','信息审核失败消息模板',0,{ts'2022-01-24  00:00:00'},13466739,'1','1WXB5G9/BL46',{ts'2022-01-24  00:00:00'},13466739,0);

DELETE FROM T_BRM_SCENE_l WHERE FPKID = '2=KL490BZK9T';
INSERT INTO T_BRM_SCENE_l(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1312140694491515904,'2=KL490BZK9T','zh_CN',' ',' ','采集模板匹配');

DELETE FROM T_BRM_SCENE_l WHERE FPKID = '2=KL4RD4242W';
INSERT INTO T_BRM_SCENE_l(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1340437281768487936,'2=KL4RD4242W','zh_CN',' ',' ','信息审核失败消息模板');

DELETE FROM T_BRM_SCENE_l WHERE FPKID = '2=KL5=2B9W8F';
INSERT INTO T_BRM_SCENE_l(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1340032928045875200,'2=KL5=2B9W8F','zh_CN',' ',' ','信息审核通过消息模板');

DELETE FROM T_BRM_SCENE_l WHERE FPKID = '2=KL5PRLQRJ3';
INSERT INTO T_BRM_SCENE_l(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1340033326152432640,'2=KL5PRLQRJ3','zh_CN',' ',' ','信息审核审核驳回消息模板');

DELETE FROM T_BRM_SCENE_l WHERE FPKID = '2=KL6AC8P001';
INSERT INTO T_BRM_SCENE_l(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1315956853858896896,'2=KL6AC8P001','zh_CN',' ',' ','采集活动一键提醒');

DELETE FROM T_BRM_SCENE_l WHERE FPKID = '2=KL6T88BPYJ';
INSERT INTO T_BRM_SCENE_l(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1315957168213594112,'2=KL6T88BPYJ','zh_CN',' ',' ','采集活动定时任务提醒');


DELETE FROM T_BRM_SCENEINPUT WHERE FENTRYID = 1312140694558624768;
INSERT INTO T_BRM_SCENEINPUT(FID,FISSYSPRESET,FENTRYID,FDISABLEDATE,FPARAMSOBJECT,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FPARAMSTYPE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1312140694491515904,'0',1312140694558624768,NULL,'hom_onbrdbillbase',' ',' ',0,'C','onbrdbill','入职单',1,NULL,0,'1','dynamicObject',NULL,0,0);

DELETE FROM T_BRM_SCENEOUTPUT WHERE FENTRYID = 1315956853934394368;
INSERT INTO T_BRM_SCENEOUTPUT(FID,FISSYSPRESET,FENTRYID,FDISABLEDATE,FPARAMSOBJECT,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FPARAMSTYPE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1315956853858896896,'0',1315956853934394368,NULL,' ',' ',' ',0,'C','result','结果',1,NULL,0,'1','string',NULL,0,0);
DELETE FROM T_BRM_SCENEOUTPUT WHERE FENTRYID = 1315957168230371328;
INSERT INTO T_BRM_SCENEOUTPUT(FID,FISSYSPRESET,FENTRYID,FDISABLEDATE,FPARAMSOBJECT,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FPARAMSTYPE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1315957168213594112,'0',1315957168230371328,NULL,' ',' ',' ',0,'C','result','结果',1,NULL,0,'1','string',NULL,0,0);
DELETE FROM T_BRM_SCENEOUTPUT WHERE FENTRYID = 1312140694558624769;
INSERT INTO T_BRM_SCENEOUTPUT(FID,FISSYSPRESET,FENTRYID,FDISABLEDATE,FPARAMSOBJECT,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FPARAMSTYPE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1312140694491515904,'0',1312140694558624769,NULL,'hom_infocollectconfig',' ',' ',0,'C','result','结果',1,NULL,0,'1','basedata',NULL,0,0);
DELETE FROM T_BRM_SCENEOUTPUT WHERE FENTRYID = 1340032928079429632;
INSERT INTO T_BRM_SCENEOUTPUT(FID,FISSYSPRESET,FENTRYID,FDISABLEDATE,FPARAMSOBJECT,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FPARAMSTYPE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1340032928045875200,'0',1340032928079429632,NULL,' ',' ',' ',0,'C','result','结果',1,NULL,0,'1','string',NULL,0,0);
DELETE FROM T_BRM_SCENEOUTPUT WHERE FENTRYID = 1340033326152432641;
INSERT INTO T_BRM_SCENEOUTPUT(FID,FISSYSPRESET,FENTRYID,FDISABLEDATE,FPARAMSOBJECT,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FPARAMSTYPE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1340033326152432640,'0',1340033326152432641,NULL,' ',' ',' ',0,'C','result','短信模板',1,NULL,0,'1','string',NULL,0,0);
DELETE FROM T_BRM_SCENEOUTPUT WHERE FENTRYID = 1340437281793653760;
INSERT INTO T_BRM_SCENEOUTPUT(FID,FISSYSPRESET,FENTRYID,FDISABLEDATE,FPARAMSOBJECT,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FPARAMSTYPE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1340437281768487936,'0',1340437281793653760,NULL,' ',' ',' ',0,'C','result','消息模板',1,NULL,0,'1','string',NULL,0,0);


DELETE FROM T_BRM_SCENEINPUT_L WHERE FPKID = '235AUSOK=3NO';
INSERT INTO T_BRM_SCENEINPUT_L(FPKID,FLOCALEID,FENTRYID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES ('235AUSOK=3NO','zh_CN',1312140694558624768,' ',' ','入职单');


DELETE FROM T_BRM_SCENEOUTPUT_L WHERE FPKID = '235AUSOK=3NQ';
INSERT INTO T_BRM_SCENEOUTPUT_L(FPKID,FLOCALEID,FENTRYID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES ('235AUSOK=3NQ','zh_CN',1312140694558624769,' ',' ','结果');

DELETE FROM T_BRM_SCENEOUTPUT_L WHERE FPKID = '23MLW1XULCJG';
INSERT INTO T_BRM_SCENEOUTPUT_L(FPKID,FLOCALEID,FENTRYID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES ('23MLW1XULCJG','zh_CN',1315956853934394368,' ',' ','结果');

DELETE FROM T_BRM_SCENEOUTPUT_L WHERE FPKID = '23MLYC8B2HD3';
INSERT INTO T_BRM_SCENEOUTPUT_L(FPKID,FLOCALEID,FENTRYID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES ('23MLYC8B2HD3','zh_CN',1315957168230371328,' ',' ','结果');

DELETE FROM T_BRM_SCENEOUTPUT_L WHERE FPKID = '26KZD/LQWZQP';
INSERT INTO T_BRM_SCENEOUTPUT_L(FPKID,FLOCALEID,FENTRYID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES ('26KZD/LQWZQP','zh_CN',1340032928079429632,' ',' ','结果');

DELETE FROM T_BRM_SCENEOUTPUT_L WHERE FPKID = '26KZFXQW62ZT';
INSERT INTO T_BRM_SCENEOUTPUT_L(FPKID,FLOCALEID,FENTRYID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES ('26KZFXQW62ZT','zh_CN',1340033326152432641,' ',' ','短信模板');

DELETE FROM T_BRM_SCENEOUTPUT_L WHERE FPKID = '26MWYIUIZQT0';
INSERT INTO T_BRM_SCENEOUTPUT_L(FPKID,FLOCALEID,FENTRYID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES ('26MWYIUIZQT0','zh_CN',1340437281793653760,' ',' ','消息模板');
