DELETE FROM t_open_apiservice WHERE FID = 962085524846152704;
DELETE FROM t_open_apiservice_L where fid=962085524846152704;
DELETE FROM T_OPEN_3RDAPPS WHERE FID = 966440543972233216;
DELETE FROM T_OPEN_3RDAPPS_L WHERE FPKID = '1/P38P8AVMAN';
DELETE FROM T_OPEN_3RDAPPS_L WHERE FPKID = '1/P38P8AVMAO';
DELETE FROM t_sec_user WHERE FID = 965949720436421632;
DELETE FROM T_SEC_USERPOSITION WHERE FENTRYID = 965949720469976064;
DELETE FROM t_sec_user_u WHERE FID = 965949720436421632;
DELETE FROM t_open_apiusers WHERE FPKID = 966437055393434624;
DELETE FROM t_open_apiauthorize WHERE FID = 966437055393435649;

DELETE FROM t_open_apiservice WHERE FID = 980403589195507712;
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 (980403589195507712,'2',' ',' ',NULL,980403589195507712,'C','0',NULL,'invoiceupload',{ts'2020-09-14  16:44:47'},975833337228726272,'1','[{"FPK":"","Type":0,"Description":"","ClassName":"kd.imc.bdm.common.moduleservice.ModuleOperationPlugin","Enabled":true,"BizAppId":"","rowKey":0}]',{ts'2020-12-08  10:45:13'},'0QHC=8NRINCF','/app/bdm/invoiceupload','1',975278083873649664,NULL,'0',' '); 
DELETE FROM t_open_apiservice_L WHERE FPKID = '11E/6=N/Q6R+';
INSERT INTO t_open_apiservice_L(FID,FDISCRIPTION,FPKID,FLOCALEID,FNAME) VALUES (980403589195507712,'第三方发票上传','11E/6=N/Q6R+','zh_CN','发票上传接口'); 



-- 删除第三方应用invoiceupload（平台安全部门的不让预置第三方应用）
DELETE FROM T_OPEN_3RDAPPS WHERE FID = 980405017691564032;
-- INSERT INTO T_OPEN_3RDAPPS(FID,FLASTENABLETIME,FDISABLEDATE,FMASTERID,FSTATUS,FNUMBER,FCREATETIME,FENABLE,FMODIFIERID,FSYSPWD,FMODIFYTIME,FWHITELIST,FLASTSTOPTIME,FPUBLICKEY,FPWDLENGTH,FCREATORID,FDISABLERID)
-- VALUES (980405017691564032,{ts'2021-09-30  16:48:47'},NULL,980405017691564032,'A','invoiceupload',{ts'2020-09-14  16:48:47'},'1',975278083873649664,'bs8SPhjG823bkQKzNeFzNA==',{ts'2020-12-15  14:26:43'},' ',{ts'2021-10-14  16:48:47'},'upload1234',NULL,975278083873649664,NULL);
DELETE FROM T_OPEN_3RDAPPS_L WHERE FPKID = '11E/FKLZZ17U';
-- INSERT INTO T_OPEN_3RDAPPS_L(FID,FPKID,FLOCALEID,FNAME) VALUES (980405017691564032,'11E/FKLZZ17U','zh_CN','第三方发票上传');
DELETE FROM T_OPEN_3RDAPPS_L WHERE FPKID = '11E/FKLZZ17V';
-- INSERT INTO T_OPEN_3RDAPPS_L(FID,FPKID,FLOCALEID,FNAME) VALUES (980405017691564032,'11E/FKLZZ17V','zh_TW','第三方發票上傳');


-- 删除第三方发票上传用户
DELETE FROM t_sec_user WHERE FID = 983955508870269952;
DELETE FROM T_SEC_USERPOSITION WHERE FENTRYID = 983955508903824384;
DELETE FROM t_sec_user_u WHERE FID = 983955508870269952;
DELETE FROM t_open_apiusers WHERE FPKID = 983955645713647616;
DELETE FROM t_open_apiauthorize WHERE FID = 983955645713632257;
