/*预置 可归档单据范围、单据清楚规则、清楚调度计划
  用于er_datalog 定时清理*/
DELETE FROM t_cbs_archi_billset WHERE FID = 1688460151306346496;
INSERT INTO t_cbs_archi_billset(FID,FCREATETIME,FIS_STORE,FPRESET,FENTITYNUMBER,FIS_CLEAN,FNUMBER) VALUES (1688460151306346496,{ts'2023-05-19  00:00:00'},'0','0','er_datalog','1','er_datalog');
DELETE FROM t_cbs_archi_billset_l WHERE FPKID = '3=D8I86E=1K7';
INSERT INTO t_cbs_archi_billset_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1688460151306346496,'3=D8I86E=1K7','zh_CN','费用报销单据日志');

DELETE FROM t_cbs_archi_config WHERE FID = 1688461001181388800;
INSERT INTO t_cbs_archi_config(FID,FCONDITION,FMASTERID,FENTITYNUMBER,FARCHIVEPLUGIN,FSTATUS,FCONDITIONTYPE,FNUMBER,FGROUPID,FCREATETIME,FMODIFIERID,FENABLE,FSYNCBASEDATA,FREMARK,FFILTERTYPE,FMODIFYTIME,FPRESET,FMOVINGTYPE,FBILLSETID,FCREATORID,FCONDITIONDESC) VALUES (1688461001181388800,'{"bill":"{\"filterRow\":[{\"id\":\"3=D8O2XFNZ37\",\"leftBracket\":\"\",\"compareType\":\"501\",\"fieldName\":\"opdate\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3=D8O2XFQ/X+\",\"value\":\"90\"}],\"baseDataIds\":[]}],\"forList\":false}"}',1688461001181388800,'er_datalog',' ','C',' ','er_datalog',0,{ts'2023-05-19  00:00:00'},1321748923399967744,'1',' ',' ','bill',{ts'2023-05-19  00:00:00'},'0','1',1688460151306346496,1321748923399967744,'opdate < ''2023-02-18 00:00:00''');
DELETE FROM t_cbs_archi_config_l WHERE FPKID = '3=D8OER3USFR';
INSERT INTO t_cbs_archi_config_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1688461001181388800,'3=D8OER3USFR','zh_CN','费用报销单据日志');

DELETE FROM t_cbs_archi_schema WHERE FID = 1688461175538606080;
INSERT INTO t_cbs_archi_schema(FID,FSCHEDULEPLANID,FEXECUTORID,FMASTERID,FSTATUS,FNUMBER,FNAME,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FPRESET,FMOVINGTYPE,FCREATORID,FENDTIME,FEXECPLAN) VALUES (1688461175538606080,'3=D8TANO/1ZY',1321748923399967744,1688461175538606080,'A','ARCHIVE_CLN_20230519-151057170_SKDP_S','费用单据日志定时清楚',{ts'2023-05-19  00:00:00'},1321748923399967744,'1',{ts'2023-05-19  00:00:00'},'0','1',1321748923399967744,{ts'2099-12-31  00:00:00'},'事件将于2023-05-19 15:10:57起，每1天2时重复。
预计最近十次执行时间：
2023-05-20 02:10:00,
2023-05-21 02:10:00,
2023-05-22 02:10:00,
2023-05-23 02:10:00,
2023-05-24 02:...');
DELETE FROM t_cbs_archi_schema_l WHERE FPKID = '3=D8UNQ4WIZE';
INSERT INTO t_cbs_archi_schema_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1688461175538606080,'3=D8UNQ4WIZE','zh_CN','费用单据日志定时清楚');
DELETE FROM t_cbs_archi_schema_l WHERE FPKID = '3=D8UNQ4WIZF';
INSERT INTO t_cbs_archi_schema_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1688461175538606080,'3=D8UNQ4WIZF','zh_TW','費用單據日誌定時清楚');
DELETE FROM t_cbs_archi_scheduleentry WHERE FENTRYID = 1688461856248979456;
INSERT INTO t_cbs_archi_scheduleentry(FID,FENTRYID,FSEQ,FCONFIGID) VALUES (1688461175538606080,1688461856248979456,1,1688461001181388800);
