DELETE FROM t_warn_schedule WHERE FNUMBER like 'src_%' or FNUMBER like 'tnd_%';
DELETE FROM t_warn_schedule_l WHERE FID IN (select fid from t_warn_schedule WHERE FNUMBER like 'src_%' or FNUMBER like 'tnd_%');

DELETE FROM t_warn_schedule WHERE FID = '1271756336308426752';
INSERT INTO t_warn_schedule(FMODIFYDATE,FTYPE,FEARLYWARNID,FISV,FDATA,FINHERITPATH,FMASTERID,FMONITORFREQUENCY,FPLANID,FMONITORRANGE,FENABLE,FJOBID,FMODELTYPE,FID,FVERSION,FISTEMPLATE,FSTARTDATE,FCREATEDATE,FLASTSYNCTIME,FPARENTID,FNUMBER,FPLANNUMBER,FMODIFIERID,FBIZAPPID,FENDDATE,FCREATORID) VALUES ({ts'2021-10-21  00:00:00'},'0','1271756115268605952','kingdee',' ','1271756336308426752','1271756336308426752','每天-00:00:00','1271757265136833536','从2021-10-21开始','1','1271757264130200576','WarnScheduleModel','1271756336308426752',1634805280102,'0',{ts'2021-10-21  00:00:00'},{ts'2021-10-21  00:00:00'},{ts'2021-10-21  00:00:00'},' ','src_negotiate_tender',' ',13466739,'0DUM2+6E41IA',{ts'2021-10-21  00:00:00'},13466739); 
DELETE FROM t_warn_schedule WHERE FID = '1271761772931717120';
INSERT INTO t_warn_schedule(FMODIFYDATE,FTYPE,FEARLYWARNID,FISV,FDATA,FINHERITPATH,FMASTERID,FMONITORFREQUENCY,FPLANID,FMONITORRANGE,FENABLE,FJOBID,FMODELTYPE,FID,FVERSION,FISTEMPLATE,FSTARTDATE,FCREATEDATE,FLASTSYNCTIME,FPARENTID,FNUMBER,FPLANNUMBER,FMODIFIERID,FBIZAPPID,FENDDATE,FCREATORID) VALUES ({ts'2021-10-21  00:00:00'},'0','1271761682955507712','kingdee',' ','1271761772931717120','1271761772931717120','每天-00:00:00','1271763028362187776','从2021-10-21开始','1','1271763028295078912','WarnScheduleModel','1271761772931717120',1634805967098,'0',{ts'2021-10-21  00:00:00'},{ts'2021-10-21  00:00:00'},{ts'2021-10-21  00:00:00'},' ','src_tender_supplier',' ',13466739,'0DUM2+6E41IA',{ts'2021-10-21  00:00:00'},13466739); 
DELETE FROM t_warn_schedule WHERE FID = '1271769256794789888';
INSERT INTO t_warn_schedule(FMODIFYDATE,FTYPE,FEARLYWARNID,FISV,FDATA,FINHERITPATH,FMASTERID,FMONITORFREQUENCY,FPLANID,FMONITORRANGE,FENABLE,FJOBID,FMODELTYPE,FID,FVERSION,FISTEMPLATE,FSTARTDATE,FCREATEDATE,FLASTSYNCTIME,FPARENTID,FNUMBER,FPLANNUMBER,FMODIFIERID,FBIZAPPID,FENDDATE,FCREATORID) VALUES ({ts'2021-10-21  00:00:00'},'0','1271769009917842432','kingdee',' ','1271769256794789888','1271769256794789888','每天-00:00:00','1271769836950705152','从2021-10-21开始','1','1271769836900373504','WarnScheduleModel','1271769256794789888',1634806778746,'0',{ts'2021-10-21  00:00:00'},{ts'2021-10-21  00:00:00'},{ts'2021-10-21  00:00:00'},' ','tnd_tender_stoptime',' ',13466739,'0DUMFA=HL9S1',{ts'2021-10-21  00:00:00'},13466739); 
DELETE FROM t_warn_schedule WHERE FID = '1271771640484647936';
INSERT INTO t_warn_schedule(FMODIFYDATE,FTYPE,FEARLYWARNID,FISV,FDATA,FINHERITPATH,FMASTERID,FMONITORFREQUENCY,FPLANID,FMONITORRANGE,FENABLE,FJOBID,FMODELTYPE,FID,FVERSION,FISTEMPLATE,FSTARTDATE,FCREATEDATE,FLASTSYNCTIME,FPARENTID,FNUMBER,FPLANNUMBER,FMODIFIERID,FBIZAPPID,FENDDATE,FCREATORID) VALUES ({ts'2021-10-21  00:00:00'},'0','1271771594280195072','kingdee',' ','1271771640484647936','1271771640484647936','每天-00:00:00','1271772121814800384','从2021-10-21开始','1','1271772121764468736','WarnScheduleModel','1271771640484647936',1634807051121,'0',{ts'2021-10-21  00:00:00'},{ts'2021-10-21  00:00:00'},{ts'2021-10-21  00:00:00'},' ','tnd_quote_stoptime',' ',13466739,'0DUMFA=HL9S1',{ts'2021-10-21  00:00:00'},13466739); 

DELETE FROM t_warn_schedule_l WHERE FPKID = '2+6VCESLMQTG';
INSERT INTO t_warn_schedule_l(FID,FPKID,FLOCALEID,FDATA,FNAME) VALUES ('1271756336308426752','2+6VCESLMQTG','zh_CN','<?xml version="1.0" encoding="UTF-8"?>

<WarnScheduleMetadata/>
','议价回标情况提醒'); 
DELETE FROM t_warn_schedule_l WHERE FPKID = '2+6VCESPBRPK';
INSERT INTO t_warn_schedule_l(FID,FPKID,FLOCALEID,FDATA,FNAME) VALUES ('1271756336308426752','2+6VCESPBRPK','en_US','<?xml version="1.0" encoding="UTF-8"?>

<WarnScheduleMetadata/>
',' '); 
DELETE FROM t_warn_schedule_l WHERE FPKID = '2+6VCET+4DKI';
INSERT INTO t_warn_schedule_l(FID,FPKID,FLOCALEID,FDATA,FNAME) VALUES ('1271756336308426752','2+6VCET+4DKI','zh_TW','<?xml version="1.0" encoding="UTF-8"?>

<WarnScheduleMetadata>
  <WarnSchedule>
    <WarnSchedule>
      <Name>議價回標情況提醒</Name>
    </WarnSchedule>
  </WarnSchedule>
</WarnScheduleMetadata>
','議價回標情況提醒'); 
DELETE FROM t_warn_schedule_l WHERE FPKID = '2+6WFEJZYRW2';
INSERT INTO t_warn_schedule_l(FID,FPKID,FLOCALEID,FDATA,FNAME) VALUES ('1271761772931717120','2+6WFEJZYRW2','zh_CN','<?xml version="1.0" encoding="UTF-8"?>

<WarnScheduleMetadata/>
','项目回标情况提醒'); 
DELETE FROM t_warn_schedule_l WHERE FPKID = '2+6WFEK+0CKO';
INSERT INTO t_warn_schedule_l(FID,FPKID,FLOCALEID,FDATA,FNAME) VALUES ('1271761772931717120','2+6WFEK+0CKO','en_US','<?xml version="1.0" encoding="UTF-8"?>

<WarnScheduleMetadata/>
',' '); 
DELETE FROM t_warn_schedule_l WHERE FPKID = '2+6WFEK56L93';
INSERT INTO t_warn_schedule_l(FID,FPKID,FLOCALEID,FDATA,FNAME) VALUES ('1271761772931717120','2+6WFEK56L93','zh_TW','<?xml version="1.0" encoding="UTF-8"?>

<WarnScheduleMetadata>
  <WarnSchedule>
    <WarnSchedule>
      <Name>項目回標情況提醒</Name>
    </WarnSchedule>
  </WarnSchedule>
</WarnScheduleMetadata>
','項目回標情況提醒'); 
DELETE FROM t_warn_schedule_l WHERE FPKID = '2+6XQ0I5300B';
INSERT INTO t_warn_schedule_l(FID,FPKID,FLOCALEID,FDATA,FNAME) VALUES ('1271769256794789888','2+6XQ0I5300B','zh_CN','<?xml version="1.0" encoding="UTF-8"?>

<WarnScheduleMetadata/>
','投标截止时间即将到期提醒'); 
DELETE FROM t_warn_schedule_l WHERE FPKID = '2+6XQ0I8U0YF';
INSERT INTO t_warn_schedule_l(FID,FPKID,FLOCALEID,FDATA,FNAME) VALUES ('1271769256794789888','2+6XQ0I8U0YF','en_US','<?xml version="1.0" encoding="UTF-8"?>

<WarnScheduleMetadata/>
',' '); 
DELETE FROM t_warn_schedule_l WHERE FPKID = '2+6XQ0I8QF7V';
INSERT INTO t_warn_schedule_l(FID,FPKID,FLOCALEID,FDATA,FNAME) VALUES ('1271769256794789888','2+6XQ0I8QF7V','zh_TW','<?xml version="1.0" encoding="UTF-8"?>

<WarnScheduleMetadata>
  <WarnSchedule>
    <WarnSchedule>
      <Name>投標截止時間即將到期提醒</Name>
    </WarnSchedule>
  </WarnSchedule>
</WarnScheduleMetadata>
','投標截止時間即將到期提醒'); 
DELETE FROM t_warn_schedule_l WHERE FPKID = '2+6Y4OV9=L2E';
INSERT INTO t_warn_schedule_l(FID,FPKID,FLOCALEID,FDATA,FNAME) VALUES ('1271771640484647936','2+6Y4OV9=L2E','zh_CN','<?xml version="1.0" encoding="UTF-8"?>

<WarnScheduleMetadata/>
','报价截止时间即将到期提醒'); 
DELETE FROM t_warn_schedule_l WHERE FPKID = '2+6Y4OV97+CU';
INSERT INTO t_warn_schedule_l(FID,FPKID,FLOCALEID,FDATA,FNAME) VALUES ('1271771640484647936','2+6Y4OV97+CU','en_US','<?xml version="1.0" encoding="UTF-8"?>

<WarnScheduleMetadata/>
',' '); 
DELETE FROM t_warn_schedule_l WHERE FPKID = '2+6Y4OV9=L2F';
INSERT INTO t_warn_schedule_l(FID,FPKID,FLOCALEID,FDATA,FNAME) VALUES ('1271771640484647936','2+6Y4OV9=L2F','zh_TW','<?xml version="1.0" encoding="UTF-8"?>

<WarnScheduleMetadata>
  <WarnSchedule>
    <WarnSchedule>
      <Name>報價截止時間即將到期提醒</Name>
    </WarnSchedule>
  </WarnSchedule>
</WarnScheduleMetadata>
','報價截止時間即將到期提醒'); 
