
-- 同步银行接收状态-权限项名字修改
DELETE FROM T_PERM_PERMITEM WHERE FID = '3HDK2=WZ964+';
INSERT INTO T_PERM_PERMITEM(FID,FPREPERMITEMID,FINHERITMODE,FBIZAPPID,FORDER,FDESCRIPTION,FGROUP,FBIZDOMAINID,FNUMBER) VALUES ('3HDK2=WZ964+','47150e89000000ac','10','/LSWHQ7US+Q6',0,' ','20',0,'QXBEI0044');

DELETE FROM T_PERM_PERMITEM_L WHERE FPKID = '3HDK2=WZ95FQ';
INSERT INTO T_PERM_PERMITEM_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3HDK2=WZ964+','3HDK2=WZ95FQ','zh_CN','同步银行接收状态');
DELETE FROM T_PERM_PERMITEM_L WHERE FPKID = '3HDK2=WZ95FR';
INSERT INTO T_PERM_PERMITEM_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3HDK2=WZ964+','3HDK2=WZ95FR','zh_TW','同步銀行接收狀態');


-- 同步银行接收状态-调度执行程序名字修改
DELETE FROM t_sch_taskdefine WHERE FID = '3HDR=3OS=+M1';
INSERT INTO t_sch_taskdefine(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('3HDR=3OS=+M1','kd.tmc.bei.business.task.ElecBalanceAccSyncTask','bei','bei_elecbalancestate_accSyncTask');

DELETE FROM t_sch_taskdefine_l WHERE FPKID = '3HDR=3OS=/=A';
INSERT INTO t_sch_taskdefine_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3HDR=3OS=+M1','3HDR=3OS=/=A','zh_CN','同步银行接收状态');
DELETE FROM t_sch_taskdefine_l WHERE FPKID = '3HDR=3OS=/=B';
INSERT INTO t_sch_taskdefine_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3HDR=3OS=+M1','3HDR=3OS=/=B','zh_TW','同步銀行接收狀態');

-- 同步银行接收状态-调度作业名字修改
DELETE FROM T_SCH_JOB WHERE FID = '3HDRK0IY=Y1V';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNBYUSERID,FJOBTYPE,FTIMEOUT,FRUNBYLANG,FSTATUS,FPARAMS,FRUNBYORGID,FNUMBER,FCONCURRENT) VALUES ('3HDRK0IY=Y1V','kd.tmc.bei.business.task.ElecBalanceAccSyncTask','3HDR=3OS=+M1',1,'BIZ',0,' ','1','{}',0,'bei_elecbalancestate_accSyncJob_SKDJ_S','0');

DELETE FROM T_SCH_JOB_L WHERE FPKID = '3HDRK0IYC+6C';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3HDRK0IY=Y1V','3HDRK0IYC+6C','zh_CN','同步银行接收状态');
DELETE FROM T_SCH_JOB_L WHERE FPKID = '3HDRK0IYC+6D';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3HDRK0IY=Y1V','3HDRK0IYC+6D','zh_TW','同步銀行接收狀態');


-- 按银行账号查询电子余额对账-资金公共服务-任务调度方案
DELETE FROM t_sch_taskdefine WHERE FID = '3Q0QMWW6SJP1';
INSERT INTO t_sch_taskdefine(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('3Q0QMWW6SJP1','kd.tmc.bei.business.task.QueryElecBalanceAccTask','bei','bei_QueryElecBalanceAccTask');

DELETE FROM t_sch_taskdefine_l WHERE FPKID = '3Q0QMWW6WH6I';
INSERT INTO t_sch_taskdefine_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3Q0QMWW6SJP1','3Q0QMWW6WH6I','zh_CN','按银行账号查询电子余额对账');
DELETE FROM t_sch_taskdefine_l WHERE FPKID = '3Q0QMWW6WH6J';
INSERT INTO t_sch_taskdefine_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3Q0QMWW6SJP1','3Q0QMWW6WH6J','zh_TW','按銀行賬號查詢電子餘額對賬');

DELETE FROM t_sch_taskdefine WHERE FID = '3FBZWKR4J=Y4';
INSERT INTO t_sch_taskdefine(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('3FBZWKR4J=Y4','kd.bos.ext.tmc.task.TmcScheduleTask','bei','TmcTask-bei');

DELETE FROM t_sch_taskdefine_l WHERE FPKID = '3FBZWKR4LC0N';
INSERT INTO t_sch_taskdefine_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3FBZWKR4J=Y4','3FBZWKR4LC0N','zh_CN','TmcTask-bei');

DELETE FROM t_sch_job WHERE FID = '3Q12SLY42LIJ';
INSERT INTO t_sch_job(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNBYUSERID,FJOBTYPE,FTIMEOUT,FRUNBYLANG,FSTATUS,FPARAMS,FRUNBYORGID,FNUMBER,FCONCURRENT) VALUES ('3Q12SLY42LIJ','kd.bos.ext.tmc.task.TmcScheduleTask','3FBZWKR4J=Y4',1,'BIZ',0,' ','1','{"type":"0","intellSchemaidList":[{"Id":1824100899857912832}]}',0,'fcs_autocreate1700649772341','0');

DELETE FROM t_sch_job_l WHERE FPKID = '3Q12SLY46J0/';
INSERT INTO t_sch_job_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3Q12SLY42LIJ','3Q12SLY46J0/','zh_CN','资金任务调度作业');

DELETE FROM T_SCH_JOB_n WHERE FID = '3Q12SLY42LIJ';
INSERT INTO T_SCH_JOB_n(FID,FJOBPRINCIPAL,FOVERTIME,FSUCCESSNOTIFY,FJOBMSGRECEIVER,FMSGCONTENT,FFAILNOTIFY,FNOTIFYTYPE,FCAPTION,FABORTED) VALUES ('3Q12SLY42LIJ',0,'0','0',0,' ','1',' ',' ','0');

DELETE FROM t_sch_schedule WHERE FID = '3Q12SM0DWPD4';
INSERT INTO t_sch_schedule(FTWENTY,FFIVE,FELEVEN,FNINE,FNO,FSUN,FTWO,FEIGHT,FNOV,FPLAN,FWED,FHOST,FTWENTYTWO,FFOUR,FMAR,FSEP,FENDTIME,FSIX,FREPEATMODE,FMAY,FTHIRTYONE,FBYDAYORWEEK,FTWENTYSEVEN,FTWENTYSIX,FTHIRTEEN,FAUG,FDESC,FFIFTEEN,FTWENTYONE,FBYWEEK,FTUES,FSEVENTEEN,FSEVEN,FTWENTYFOUR,FMON,FTHIRTY,FTHREE,FFOURTEEN,FJAN,FNINETEEN,FTHUR,FTEN,FFRI,FJOBID,FSTARTTIME,FOCT,FAPR,FSIXTEEN,FID,FSAT,FONE,FTWENTYEIGHT,FTWENTYTHREE,FTWELVE,FNOWEEK,FSTATUS,FNUMBER,FTWENTYFIVE,FEIGHTEEN,FCYCLENUM,FTWENTYNINE,FJUL,FDEC,FJUN,FFEB) VALUES ('0','0','0','0',NULL,'0','0','0','0','0 42 18 22 11 ? 2023','0','172.19.79.89','0','0','0','0',{ts'2099-12-31  00:00:00'},'0','n','0','0',NULL,'0','0','0','0','事件于2023-11-22 18:42:00执行一次。','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','3Q12SLY42LIJ',{ts'2023-11-22  00:00:00'},'0','0','0','3Q12SM0DWPD4','0','0','0','0','0',NULL,'1','fcs_autocreate1700649772341_SKDP_S','0','0',1,'0','0','0','0','0');

DELETE FROM t_sch_schedule_entry WHERE FENTRYID = '3Q12SMB04LG8';
INSERT INTO t_sch_schedule_entry(FID,FJOBNUMBER,FENTRYID,FSEQ) VALUES ('3Q12SM0DWPD4','3Q12SLY42LIJ','3Q12SMB04LG8',1);

DELETE FROM t_sch_schedule_l WHERE FPKID = '3Q12SMB08IZP';
INSERT INTO t_sch_schedule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3Q12SM0DWPD4','3Q12SMB08IZP','zh_CN','资金任务调度作业');

DELETE FROM t_sch_schedule_n WHERE FID = '3Q12SM0DWPD4';
INSERT INTO t_sch_schedule_n(FID,FSNOTIFYTYPE,FMSGRECEIVER,FSMSGCONTENT,FSTIMEOUT,FSCHPRINCIPAL,FSSUCCESSNOTIFY,FSFAILNOTIFY) VALUES ('3Q12SM0DWPD4',' ',0,' ','0',0,'0','1');

DELETE FROM t_sch_schedule_m WHERE FENTRYID = '3Q13KE+K2FG8';
INSERT INTO t_sch_schedule_m(FID,FMSGTYPE,FSNOTIFYTYPE,FSMSGCONTENT,FENTRYID,FSEQ) VALUES ('3Q12SM0DWPD4','FAILED,',' ',' ','3Q13KE+K2FG8',1);

