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

-- api整改，发票云销项数据迁移接口
DELETE FROM t_open_apiservice WHERE FID = 1112942960183566336;
INSERT INTO t_open_apiservice(FID,FAPISERVICETYPE,FCUSTOMMETHOD,FOPERATION,FURL,FMASTERID,FSTATUS,FCONTENTTYPE,FREPTYPE,FNUMBER,FMODIFIERID,FENABLE,FPLUGIN,FMODIFYTIME,FAPPID,FURLFORMAT,FHTTPMETHOD,FCREATORID,FREQTYPE,FALLOWGUEST,FBIZOBJECT) VALUES (1112942960183566336,'2',' ',' ',NULL,1112942960183566336,'C','0',NULL,'sdmApi',1,'1','[{"FPK":"","Type":0,"Description":"发票云销项数据迁移接口","RowKey":0,"ClassName":"kd.imc.bdm.common.sdmservice.SDataMigrationPlugin","Enabled":true,"BizAppId":""}]',{ts'2018-08-08  18:08:08'},'0QHC=8NRINCF','/app/bdm/sdmApi','1',1,NULL,'0',' ');

-- api整改，单据API接口
DELETE FROM t_open_apiservice WHERE FID = 1041826452309323776;
INSERT INTO t_open_apiservice(FID,FAPISERVICETYPE,FCUSTOMMETHOD,FOPERATION,FURL,FMASTERID,FSTATUS,FCONTENTTYPE,FREPTYPE,FNUMBER,FMODIFIERID,FENABLE,FPLUGIN,FMODIFYTIME,FAPPID,FURLFORMAT,FHTTPMETHOD,FCREATORID,FREQTYPE,FALLOWGUEST,FBIZOBJECT) VALUES (1041826452309323776,'2',' ',' ',NULL,1041826452309323776,'C','0',NULL,'interfaceservice',1,'1','[{"FPK":"","Type":0,"Description":"","ClassName":"kd.imc.bdm.common.interfaceservice.InterfaceOperationPlugin","Enabled":true,"BizAppId":"","rowKey":0}]',{ts'2018-08-08  18:08:08'},'0QHC=8NRINCF','/app/bdm/interfaceservice','1',1,NULL,'0',' ');

-- api整改，发票上传接口
DELETE FROM t_open_apiservice WHERE FID = 980403589195507712;
INSERT INTO t_open_apiservice(FID,FAPISERVICETYPE,FCUSTOMMETHOD,FOPERATION,FURL,FMASTERID,FSTATUS,FCONTENTTYPE,FREPTYPE,FNUMBER,FMODIFIERID,FENABLE,FPLUGIN,FMODIFYTIME,FAPPID,FURLFORMAT,FHTTPMETHOD,FCREATORID,FREQTYPE,FALLOWGUEST,FBIZOBJECT) VALUES (980403589195507712,'2',' ',' ',NULL,980403589195507712,'C','0',NULL,'invoiceupload',1,'1','[{"FPK":"","Type":0,"Description":"","ClassName":"kd.imc.bdm.common.moduleservice.ModuleOperationPlugin","Enabled":true,"BizAppId":"","rowKey":0}]',{ts'2018-08-08  18:08:08'},'0QHC=8NRINCF','/app/bdm/invoiceupload','1',1,NULL,'0',' ');


-- 删除第三方应用DEV-TEST（平台安全部门的说这样预制第三方应用不规范）
DELETE FROM T_OPEN_3RDAPPS WHERE FID = 976078494541083648;
DELETE FROM T_OPEN_3RDAPPS_L WHERE FPKID = '10W=19X7/R64';
DELETE FROM T_OPEN_3RDAPPS_L WHERE FPKID = '10W=19X7/R65';

-- -- 删除第三方应用invoiceupload（平台安全部门的说这样预制第三方应用不规范）
-- DELETE FROM T_OPEN_3RDAPPS WHERE FID = 980405017691564032;
-- DELETE FROM T_OPEN_3RDAPPS_L WHERE FPKID = '11E/FKLZZ17U';
-- DELETE FROM T_OPEN_3RDAPPS_L WHERE FPKID = '11E/FKLZZ17V';

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;

