DELETE FROM t_open_apiservice WHERE FID = 1020911656395461632;
INSERT INTO t_open_apiservice(FID,FAPISERVICETYPE,FCUSTOMMETHOD,FOPERATION,FURL,FMASTERID,FSTATUS,FCONTENTTYPE,FREPTYPE,FNUMBER,FCREATETIME,FMODIFIERID,FENABLE,FPLUGIN,FMODIFYTIME,FAPPID,FURLFORMAT,FHTTPMETHOD,FCREATORID,FREQTYPE,FALLOWGUEST,FBIZOBJECT) VALUES (1020911656395461632,'2',' ',' ',NULL,1020911656395461632,'C','0',NULL,'openApi',{ts'2020-11-09  14:08:15'},985484819393818624,'1','[{"FPK":"","Type":0,"Description":"发票云销项管理对外统一接口","ClassName":"kd.imc.sim.formplugin.openapi.OpenApiPlugin","Enabled":true,"BizAppId":"","rowKey":0}]',{ts'2020-11-09  14:20:11'},'0QHC5B1PZ/Z3','/app/sim/openApi','1',985484819393818624,NULL,'0',' ');

DELETE FROM t_open_apiservice_L WHERE FPKID = '16D1YRSBN0TD';
INSERT INTO t_open_apiservice_L(FID,FDISCRIPTION,FPKID,FLOCALEID,FNAME) VALUES (1020911656395461632,'发票云销项统一对外接口','16D1YRSBN0TD','zh_CN','发票云销项对外接口');

-- 这里是第三方应用的脚本，KSQL查询条件 FNUMBER = 【第三方应用--系统编码】
DELETE FROM T_OPEN_3RDAPPS WHERE FID = 976078494541083648;
-- INSERT INTO T_OPEN_3RDAPPS(FID,FLASTENABLETIME,FDISABLEDATE,FMASTERID,FSTATUS,FNUMBER,FCREATETIME,FENABLE,
-- FMODIFIERID,FSYSPWD,FMODIFYTIME,FWHITELIST,FLASTSTOPTIME,FPUBLICKEY,FPWDLENGTH,FCREATORID,FDISABLERID) VALUES (976078494541083648,NULL,NULL,976078494541083648,
-- 'A','DEV-TEST',{ts'2020-09-08  17:32:34'},'1',13466739,'bs8SPhjG823bkQKzNeFzNA==',{ts'2020-09-08  17:33:43'},' ',NULL,' ',NULL,13466739,NULL);

DELETE FROM T_OPEN_3RDAPPS_L WHERE FPKID = '10W=19X7/R64';
-- INSERT INTO T_OPEN_3RDAPPS_L(FID,FPKID,FLOCALEID,FNAME) VALUES (976078494541083648,'10W=19X7/R64','zh_CN','开发测试');
DELETE FROM T_OPEN_3RDAPPS_L WHERE FPKID = '10W=19X7/R65';
-- INSERT INTO T_OPEN_3RDAPPS_L(FID,FPKID,FLOCALEID,FNAME) VALUES (976078494541083648,'10W=19X7/R65','zh_TW','開發測試');


DELETE FROM t_sec_user WHERE FID = 976074692236735488;
-- 删除标准对外接口用户
DELETE FROM T_SEC_USERPOSITION WHERE FENTRYID = 1022482629485964288;
DELETE FROM t_sec_user_u WHERE FID = 976074692236735488;
DELETE FROM t_open_apiusers WHERE FPKID = 976088128664433664;
DELETE FROM t_open_apiusers WHERE FPKID = 1020914515694441472;
DELETE FROM t_open_apiauthorize WHERE FID = 1020914515694696449;

