/* 在采购云基础数据--API服务对照表插入预置数据 */

DELETE FROM T_PUR_APISERVICE WHERE FID = 696985202295056384;
INSERT INTO T_PUR_APISERVICE(FID,FCREATETIME,FMODIFYTIME,FAPIOPID,FENABLE,FMODIFIERID,FAPPID,FSERVICENAME,FMASTERID,FSTATUS,FCREATORID,FNUMBER) VALUES (696985202295056384,{ts'2019-08-20  15:44:40'},{ts'2019-08-20  15:45:10'},696276269817617408,'1',1,'UUPIH+47DAK','kd.scm.mal.webapi.api.MalGetCategorys',696985202295056384,'C',1,'categorys'); 
DELETE FROM T_PUR_APISERVICE WHERE FID = 695396445339328512;
INSERT INTO T_PUR_APISERVICE(FID,FCREATETIME,FMODIFYTIME,FAPIOPID,FENABLE,FMODIFIERID,FAPPID,FSERVICENAME,FMASTERID,FSTATUS,FCREATORID,FNUMBER) VALUES (695396445339328512,{ts'2019-08-18  11:08:26'},{ts'2019-08-19  21:41:46'},696274386768164864,'1',1,'XV1IC150UR4','kd.scm.srm.webapi.api.SrmGetNotices',695396445339328512,'C',1,'notices'); 

DELETE FROM T_PUR_APISERVICE_L WHERE FPKID = '05DJU+DI2+2U';
INSERT INTO T_PUR_APISERVICE_L(FID,FPKID,FLOCALEID,FNAME) VALUES (695396445339328512,'05DJU+DI2+2U','zh_CN','获取公告管理信息'); 
DELETE FROM T_PUR_APISERVICE_L WHERE FPKID = '05DJU+DI2+2V';
INSERT INTO T_PUR_APISERVICE_L(FID,FPKID,FLOCALEID,FNAME) VALUES (695396445339328512,'05DJU+DI2+2V','zh_TW','獲取公告管理信息'); 
DELETE FROM T_PUR_APISERVICE_L WHERE FPKID = '05L5O80+MBM9';
INSERT INTO T_PUR_APISERVICE_L(FID,FPKID,FLOCALEID,FNAME) VALUES (696985202295056384,'05L5O80+MBM9','zh_CN','获取商品分类'); 
DELETE FROM T_PUR_APISERVICE_L WHERE FPKID = '05L5O80+MBM=';
INSERT INTO T_PUR_APISERVICE_L(FID,FPKID,FLOCALEID,FNAME) VALUES (696985202295056384,'05L5O80+MBM=','zh_TW','獲取商品分類'); 

DELETE FROM T_PUR_APISERVICE WHERE FID = 709179095702962176;
INSERT INTO T_PUR_APISERVICE(FID,FCREATETIME,FAPIOPID,FMODIFYTIME,FENABLE,FMODIFIERID,FAPPID,FSERVICENAME,FMASTERID,FSTATUS,FCREATORID,FNUMBER) VALUES (709179095702962176,{ts'2019-09-06  11:29:43'},696276269817617408,{ts'2019-09-06  11:35:36'},'1',2744157,'UUPIH+47DAK','kd.scm.mal.webapi.api.MalGoodsFullTextSearch',709179095702962176,'C',2744157,'goods_search'); 

DELETE FROM T_PUR_APISERVICE_L WHERE FPKID = '072L0Y1ITK0W';
INSERT INTO T_PUR_APISERVICE_L(FID,FPKID,FLOCALEID,FNAME) VALUES (709179095702962176,'072L0Y1ITK0W','zh_CN','通过全文检索库获取商品ID'); 
DELETE FROM T_PUR_APISERVICE_L WHERE FPKID = '072L0Y1ITK0X';
INSERT INTO T_PUR_APISERVICE_L(FID,FPKID,FLOCALEID,FNAME) VALUES (709179095702962176,'072L0Y1ITK0X','zh_TW','通過全文檢索庫獲取商品ID'); 


