--调度作业
DELETE FROM t_sch_job WHERE FID = '1V30SHB2GL5G';
INSERT INTO t_sch_job(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNMODE,FRUNBYUSERID,FJOBTYPE,FSTATUS,FNUMBER,FCONCURRENT,FSTRATEGY,FTIMEOUT,FRETRYTIME,FRUNBYLANG,FCANSTOP,FPARAMS,FRUNBYORGID) VALUES ('1V30SHB2GL5G','kd.tsc.tsrbd.formplugin.web.seclevel.task.SecuserLevelTask','1WF/NG3R9IHU','0',1200562912884720640,'BIZ','1','tsrbd_bos_tsrbd_sec_task_SKDJ_S','1','1',0,0,' ','0','{}',0);

DELETE FROM t_sch_job_l WHERE FPKID = '1V30SHB2GLUQ';
INSERT INTO t_sch_job_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('1V30SHB2GL5G','1V30SHB2GLUQ','zh_CN','用户分级状态监测作业');
DELETE FROM t_sch_job_l WHERE FPKID = '1V30SHB2GLUR';
--INSERT INTO t_sch_job_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('1V30SHB2GL5G','1V30SHB2GLUR','zh_TW','用戶分級狀態監測作業');

DELETE FROM t_sch_job_n WHERE FID = '1V30SHB2GL5G';
INSERT INTO t_sch_job_n(FID,FJOBPRINCIPAL,FOVERTIME,FSUCCESSNOTIFY,FJOBMSGRECEIVER,FMSGCONTENT,FFAILNOTIFY,FNOTIFYTYPE,FCAPTION) VALUES ('1V30SHB2GL5G',0,'0','0',0,' ','1',' ','调度作业通知');

--调度计划
DELETE FROM t_sch_schedule WHERE FID = '1V314VNHL54H';
INSERT INTO t_sch_schedule(FTWENTY,FFIVE,FELEVEN,FNINE,FNO,FSUN,FTWO,FEIGHT,FNOV,FPLAN,FWED,FHOST,FTWENTYTWO,FFOUR,FMAR,FSEP,FENDTIME,FSIX,FMAY,FREPEATMODE,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',' ','0','0','0','0','0 0 0 * * ?','0','172.19.146.28','0','0','0','0',{ts'2099-12-31  00:00:00'},'0','0','d','0','d','0','0','0','0','事件将于2021-08-26 00:00:00起，
每1天0时重复。
预计最近十次执行时间：
2021-08-26 00:00:00,
2021-08-27 00:00:00,
2021-08-28 00:00:00,
2021-08-29 00:00:00,
2021-08-30 00:00:00,
2021-08-31 00:00:00,
2021-09-01 00:00:00,
2021-09-02 00:00:00,
2021-09-03 00:00:00,
2021-09-04 00:00:00','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','1V30SHB2GL5G',{ts'2021-08-26  00:00:00'},'0','0','0','1V314VNHL54H','0','0','0','0','0',' ','1','tsrbd_sec_plan_SKDP_S','0','0',1,'0','0','0','0','0');

DELETE FROM t_sch_schedule_entry WHERE FENTRYID = '1V314VNHL54I';
INSERT INTO t_sch_schedule_entry(FID,FJOBNUMBER,FENTRYID,FSEQ) VALUES ('1V314VNHL54H','1V30SHB2GL5G','1V314VNHL54I',1);

DELETE FROM t_sch_schedule_l WHERE FPKID = '1V314VNHL4G8';
INSERT INTO t_sch_schedule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('1V314VNHL54H','1V314VNHL4G8','zh_CN','用户分级状态监测计划');
DELETE FROM t_sch_schedule_l WHERE FPKID = '1V314VNHL4G9';
--INSERT INTO t_sch_schedule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('1V314VNHL54H','1V314VNHL4G9','zh_TW','用戶分級狀態監測計劃');

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

--调度任务类名
DELETE FROM t_sch_taskdefine WHERE FID = '1WF/NG3R9IHU';
INSERT INTO t_sch_taskdefine(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('1WF/NG3R9IHU','kd.tsc.tsrbd.formplugin.web.seclevel.task.SecuserLevelTask','tsrbd','tsrbd_secuserlevel_task');

DELETE FROM t_sch_taskdefine_l WHERE FPKID = '1WF/NG3R9WN7';
INSERT INTO t_sch_taskdefine_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('1WF/NG3R9IHU','1WF/NG3R9WN7','zh_CN','用户分级状态监测');
DELETE FROM t_sch_taskdefine_l WHERE FPKID = '1WF/NG3R9WN8';
--INSERT INTO t_sch_taskdefine_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('1WF/NG3R9IHU','1WF/NG3R9WN8','zh_TW','用戶分級狀態監測');

--引出模板
DELETE FROM t_bas_importtemplate WHERE FID = 1233899293253864448;
INSERT INTO t_bas_importtemplate(FID,FENABLEIMPORT,FMASTERID,FSTATUS,FNUMBER,FTEMPLATETYPE,FNAME,FCREATETIME,FMODIFIERID,FENABLE,FAPPLYSCOPE,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (1233899293253864448,'1',1233899293253864448,'C','tsrbd_secuserlevel_EXPT_S','EXPT','保密等级用户分级引出模板',{ts'2021-08-30  00:00:00'},1200562912884720640,'1','0',{ts'2021-08-30  00:00:00'},' ',1200562912884720640,'tsrbd_secuserlevel');

DELETE FROM t_bas_importtemplate_l WHERE FPKID = '1VJGS0A0IM=2';
INSERT INTO t_bas_importtemplate_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1233899293253864448,'1VJGS0A0IM=2','zh_CN',' ','保密等级用户分级引出模板');
DELETE FROM t_bas_importtemplate_l WHERE FPKID = '1VJGS0A0IM=3';
--INSERT INTO t_bas_importtemplate_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1233899293253864448,'1VJGS0A0IM=3','zh_TW',' ','保密等級用戶分級引出模板');

DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1233992746499322880;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1233899293253864448,'0','0',' ',0,1233992746499322880,'tsrbd_secuserlevel',1,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1233992746583231488;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1233899293253864448,'0','0',' ',1233992746499322880,1233992746583231488,'billhead',2,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1233992746608374784;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1233899293253864448,'1','1',' ',1233992746583231488,1233992746608374784,'effectivedate',3,'1',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1233992746625174528;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1233899293253864448,'1','1',' ',1233992746583231488,1233992746625174528,'expirationdate',4,'1',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1233992746633540608;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1233899293253864448,'0','1',' ',1233992746583231488,1233992746633540608,'creator',5,'0',' ','number,name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1233992746641951744;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1233899293253864448,'0','1',' ',1233992746583231488,1233992746641951744,'createtime',6,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1233992746658706432;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1233899293253864448,'0','1',' ',1233992746583231488,1233992746658706432,'modifier',7,'0',' ','number,name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1233992746667117568;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1233899293253864448,'0','1',' ',1233992746583231488,1233992746667117568,'modifytime',8,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1233992746683872256;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1233899293253864448,'0','1',' ',1233992746583231488,1233992746683872256,'textfield0',9,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1233992746700672000;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1233899293253864448,'0','1',' ',1233992746583231488,1233992746700672000,'textfield1',10,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1233992746709038080;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1233899293253864448,'0','1',' ',1233992746583231488,1233992746709038080,'textfield2',11,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1233992746725837824;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1233899293253864448,'0','1',' ',1233992746583231488,1233992746725837824,'textfield3',12,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1233992746750981120;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1233899293253864448,'0','1',' ',1233992746583231488,1233992746750981120,'textfield4',13,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1233992746759392256;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1233899293253864448,'0','1',' ',1233992746583231488,1233992746759392256,'textfield5',14,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1233992746784535552;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1233899293253864448,'0','1',' ',1233992746583231488,1233992746784535552,'textfield6',15,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1233992746801335296;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1233899293253864448,'0','1',' ',1233992746583231488,1233992746801335296,'textfield7',16,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1233992746809701376;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1233899293253864448,'1','1',' ',1233992746583231488,1233992746809701376,'userid',17,'1',' ','number,name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1233992746826501120;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1233899293253864448,'1','1',' ',1233992746583231488,1233992746826501120,'org',18,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1233992746834867200;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1233899293253864448,'1','1',' ',1233992746583231488,1233992746834867200,'job',19,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1233992746843278336;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1233899293253864448,'1','1',' ',1233992746583231488,1233992746843278336,'status',20,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1233992747111691264;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1233899293253864448,'1','0',' ',1233992746499322880,1233992747111691264,'tsrbd_levelentry',21,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1233992747128491008;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1233899293253864448,'1','1',' ',1233992747111691264,1233992747128491008,'functionlevel',22,'0',' ','number,name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1233992747153634304;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1233899293253864448,'1','1',' ',1233992747111691264,1233992747153634304,'userlevel',23,'0',' ','number,name',NULL);

