/* 在系统云--API服务 插入预置数据 */

DELETE FROM t_open_apiservice WHERE FID = 697543714616295424;
INSERT INTO t_open_apiservice(FID,FAPISERVICETYPE,FCUSTOMMETHOD,FOPERATION,FDISABLEDATE,FURL,FMASTERID,FSTATUS,FCONTENTTYPE,FNUMBER,FREPTYPE,FMESSAGETYPE,FCREATETIME,FMODIFIERID,FENABLE,FPLUGIN,FMODIFYTIME,FAPPID,FURLFORMAT,FHTTPMETHOD,FCREATORID,FREQTYPE,FDISABLERID,FBIZOBJECT) VALUES (697543714616295424,'2',' ',' ',null,' ',697543714616295424,'C','0','bidwebapi',0,null,{ts'2019-08-21  10:14:02'},2744157,'1','[{"Type":0,"_Type_":"Plugin","RowKey":1,"ClassName":"kd.scm.common.webApi.PurWebApi","Enabled":true,"rowKey":null}]',{ts'2019-08-21  10:14:50'},'101/HIPCXLPU','/app/bid/bidwebapi','1',2744157,0,null,' '); 
DELETE FROM t_open_apiservice WHERE FID = 696276269817617408;
INSERT INTO t_open_apiservice(FID,FAPISERVICETYPE,FCUSTOMMETHOD,FOPERATION,FDISABLEDATE,FURL,FMASTERID,FSTATUS,FCONTENTTYPE,FNUMBER,FREPTYPE,FMESSAGETYPE,FCREATETIME,FMODIFIERID,FENABLE,FPLUGIN,FMODIFYTIME,FAPPID,FURLFORMAT,FHTTPMETHOD,FCREATORID,FREQTYPE,FDISABLERID,FBIZOBJECT) VALUES (696276269817617408,'2',' ',' ',null,' ',696276269817617408,'C','0','malwebapi',0,null,{ts'2019-08-19  16:14:06'},1,'1','[{"Type":0,"_Type_":"Plugin","RowKey":1,"ClassName":"kd.scm.common.webApi.PurWebApi","Enabled":true,"rowKey":null}]',{ts'2019-08-19  16:16:39'},'UUPIH+47DAK','/app/mal/malwebapi','1',1,0,null,' '); 
DELETE FROM t_open_apiservice WHERE FID = 696125732312800256;
INSERT INTO t_open_apiservice(FID,FAPISERVICETYPE,FCUSTOMMETHOD,FOPERATION,FDISABLEDATE,FURL,FMASTERID,FSTATUS,FCONTENTTYPE,FNUMBER,FREPTYPE,FMESSAGETYPE,FCREATETIME,FMODIFIERID,FENABLE,FPLUGIN,FMODIFYTIME,FAPPID,FURLFORMAT,FHTTPMETHOD,FCREATORID,FREQTYPE,FDISABLERID,FBIZOBJECT) VALUES (696125732312800256,'2',' ',' ',null,' ',696125732312800256,'C','0','purwebapi',0,null,{ts'2019-08-19  11:15:47'},2744157,'1','[{"Type":0,"_Type_":"Plugin","RowKey":1,"ClassName":"kd.scm.common.webApi.PurWebApi","Enabled":true,"rowKey":null}]',{ts'2019-08-21  10:11:57'},'eae607fb000143ac','/app/pur/purwebapi','1',1,0,null,' '); 
DELETE FROM t_open_apiservice WHERE FID = 697542981124800512;
INSERT INTO t_open_apiservice(FID,FAPISERVICETYPE,FCUSTOMMETHOD,FOPERATION,FDISABLEDATE,FURL,FMASTERID,FSTATUS,FCONTENTTYPE,FNUMBER,FREPTYPE,FMESSAGETYPE,FCREATETIME,FMODIFIERID,FENABLE,FPLUGIN,FMODIFYTIME,FAPPID,FURLFORMAT,FHTTPMETHOD,FCREATORID,FREQTYPE,FDISABLERID,FBIZOBJECT) VALUES (697542981124800512,'2',' ',' ',null,' ',697542981124800512,'C','0','souwebapi',0,null,{ts'2019-08-21  10:12:19'},2744157,'1','[{"Type":0,"_Type_":"Plugin","RowKey":1,"ClassName":"kd.scm.common.webApi.PurWebApi","Enabled":true,"rowKey":null}]',{ts'2019-08-21  10:13:43'},'SE7SAP7HR2N','/app/sou/souwebapi','1',2744157,0,null,' '); 
DELETE FROM t_open_apiservice WHERE FID = 696274386768164864;
INSERT INTO t_open_apiservice(FID,FAPISERVICETYPE,FCUSTOMMETHOD,FOPERATION,FDISABLEDATE,FURL,FMASTERID,FSTATUS,FCONTENTTYPE,FNUMBER,FREPTYPE,FMESSAGETYPE,FCREATETIME,FMODIFIERID,FENABLE,FPLUGIN,FMODIFYTIME,FAPPID,FURLFORMAT,FHTTPMETHOD,FCREATORID,FREQTYPE,FDISABLERID,FBIZOBJECT) VALUES (696274386768164864,'2',' ',' ',null,' ',696274386768164864,'C','0','srmwebapi',0,null,{ts'2019-08-19  16:09:09'},2744157,'1','[{"ClassName":"kd.scm.common.webApi.PurWebApi","Enabled":true,"RowKey":1}]',{ts'2019-08-19  21:44:32'},'XV1IC150UR4','/app/srm/srmwebapi','1',1,0,null,' '); 

DELETE FROM t_open_apiservice_l WHERE FID = 697543714616295424;
DELETE FROM t_open_apiservice_l WHERE FID = 696276269817617408;
DELETE FROM t_open_apiservice_l WHERE FID = 696125732312800256;
DELETE FROM t_open_apiservice_l WHERE FID = 697542981124800512;
DELETE FROM t_open_apiservice_l WHERE FID = 696274386768164864;

INSERT INTO t_open_apiservice_l(FID,FDISCRIPTION,FPKID,FLOCALEID,FNAME) VALUES (697542981124800512,'询报价webApi','05NUWREE9+15','zh_CN','询报价webApi'); 
INSERT INTO t_open_apiservice_l(FID,FDISCRIPTION,FPKID,FLOCALEID,FNAME) VALUES (697542981124800512,'詢報價webApi','05NUWREE9+16','zh_TW','詢報價webApi'); 
INSERT INTO t_open_apiservice_l(FID,FDISCRIPTION,FPKID,FLOCALEID,FNAME) VALUES (696125732312800256,'采购协同webApi','05H12=5HZ2VW','zh_CN','采购协同webApi'); 
INSERT INTO t_open_apiservice_l(FID,FDISCRIPTION,FPKID,FLOCALEID,FNAME) VALUES (696125732312800256,'采購協同webApi','05H12=5HZ2VX','zh_TW','采購協同webApi'); 
INSERT INTO t_open_apiservice_l(FID,FDISCRIPTION,FPKID,FLOCALEID,FNAME) VALUES (696274386768164864,'供应商管理webApi','05HRVIQ7JA47','zh_CN','供应商管理webApi'); 
INSERT INTO t_open_apiservice_l(FID,FDISCRIPTION,FPKID,FLOCALEID,FNAME) VALUES (696274386768164864,'供應商管理webApi','05HRVIQ7JA48','zh_TW','供應商管理webApi'); 
INSERT INTO t_open_apiservice_l(FID,FDISCRIPTION,FPKID,FLOCALEID,FNAME) VALUES (696276269817617408,'购物商城webApi','05HS78VIYXZG','zh_CN','购物商城webApi'); 
INSERT INTO t_open_apiservice_l(FID,FDISCRIPTION,FPKID,FLOCALEID,FNAME) VALUES (696276269817617408,'購物商城webApi','05HS78VIYXZH','zh_TW','購物商城webApi'); 
INSERT INTO t_open_apiservice_l(FID,FDISCRIPTION,FPKID,FLOCALEID,FNAME) VALUES (697543714616295424,'招投标webApi','05NV02WBMIK7','zh_CN','招投标webApi'); 
INSERT INTO t_open_apiservice_l(FID,FDISCRIPTION,FPKID,FLOCALEID,FNAME) VALUES (697543714616295424,'招投標webApi','05NV02WBMIK8','zh_TW','招投標webApi'); 


DELETE FROM T_SCH_TASKDEFINE WHERE FID = '070CZCNDOQL9';
INSERT INTO T_SCH_TASKDEFINE(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('070CZCNDOQL9','kd.scm.mal.webapi.task.MalGoodsCopyToFullText','mal','malGoodsCopyToFullText'); 

DELETE FROM T_SCH_TASKDEFINE_L WHERE FPKID = '070CZCNDN8P7';
INSERT INTO T_SCH_TASKDEFINE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('070CZCNDOQL9','070CZCNDN8P7','zh_CN','同步商城商品到全文检索库'); 
DELETE FROM T_SCH_TASKDEFINE_L WHERE FPKID = '070CZCNDN8P8';
INSERT INTO T_SCH_TASKDEFINE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('070CZCNDOQL9','070CZCNDN8P8','zh_TW','同步商城商品到全文檢索庫'); 

DELETE FROM T_SCH_SCHEDULE WHERE FID = '070H53YGISST';
INSERT INTO T_SCH_SCHEDULE(FTWENTY,FFIVE,FNINE,FNO,FSUN,FEIGHT,FNOV,FPLAN,FWED,FHOST,FFOUR,FMAR,FSEP,FENDTIME,FSIX,FTWO,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,FMAY,FTWENTYTHREE,FTWELVE,FNOWEEK,FSTATUS,FNUMBER,FTWENTYTWO,FTWENTYFIVE,FELEVEN,FEIGHTEEN,FCYCLENUM,FTWENTYNINE,FJUL,FDEC,FJUN,FFEB) VALUES ('0','0','0',' ','0','0','0','0 * * * * ?','0','172.19.114.40','0','0','0',{ts'2025-12-31  20:59:58'},'0','0','h','0','d','0','0','0','0','事件将于每1小时重复','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','070D2+5ET+3N',{ts'2019-09-05  21:03:58'},'0','0','0','070H53YGISST','0','0','0','0','0','0',' ','1','mal_GoodsCopyToFullText_SKDP_S','0','0','0','0',1,'0','0','0','0','0'); 

DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '070H53YGH=WR';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('070H53YGISST','070H53YGH=WR','zh_CN','同步商城商品到全文检索库'); 
DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '070H53YGH=WS';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('070H53YGISST','070H53YGH=WS','zh_TW','同步商城商品到全文檢索庫'); 

DELETE FROM T_SCH_JOB WHERE FID = '070D2+5ET+3N';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNBYUSERID,FJOBTYPE,FTIMEOUT,FRUNBYLANG,FSTATUS,FPARAMS,FRUNBYORGID,FNUMBER) VALUES ('070D2+5ET+3N','kd.scm.mal.webapi.task.MalGoodsCopyToFullText','070CZCNDOQL9',1,'BIZ',0,' ','1',' ',0,'mal_GoodsCopyToFullText_SKDJ_S'); 

DELETE FROM T_SCH_JOB_L WHERE FPKID = '070D2+5ERH7L';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('070D2+5ET+3N','070D2+5ERH7L','zh_CN','同步商城商品到全文检索库'); 
DELETE FROM T_SCH_JOB_L WHERE FPKID = '070D2+5ERH7M';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('070D2+5ET+3N','070D2+5ERH7M','zh_TW','同步商城商品到全文檢索庫'); 
