-- 删除open_api接口用户
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;

-- 删除第三方发票上传对应用户
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;


-- 新建机器人标准业务接口授权用户
DELETE FROM t_sec_user WHERE FID = 1064346091820281856;
INSERT INTO t_sec_user(FBILLSSATUSFIELD,FUSERTYPE,FFULLPINYIN,FTID,FPOSITIONID,FGENDER,FDPTID,FUID,FMASTERID,FTRUENAME,FSIMPLEPINYIN,FIDCARD,FCREATETIME,FHEADSCULPTURE,FENABLE,FEMAIL,FBIRTHDAY,FDISABLERID,FID,FSORTCODE,FOPENID,FSTARTDATE,FHIREDATE,FAVATAR,FNICKNAME,FDISABLEDATE,FSTATUS,FNUMBER,FPHONE,FMODIFIERID,FSOURCE,FMAINTAIN,FMODIFYTIME,FEID,FENDDATE,FCREATORID)
VALUES (NULL,'6','fapiaoyunbiaozhunyewujiekoushouquanzhanghu',0,0,' ',NULL,0,1064346091820281856,'发票云标准业务接口授权账户','fpybzywjksqzh',' ',{ts'2021-01-08  12:21:38'},' ','1',' ',NULL,0,1064346091820281856,NULL,' ',{ts'2021-01-08  00:00:00'},NULL,' ',NULL,NULL,'C','ID-FPY',' ',1,' ',NULL,{ts'2021-01-08  12:25:49'},0,{ts'2999-12-31  00:00:00'},1);

-- 新建机器人标准业务接口授权用户
DELETE FROM t_sec_user_u WHERE FID = 1064346091820281856;
INSERT INTO t_sec_user_u(FID,FISLOCKED,FTYPE,FPSWEFFECTIVEDATE,FPASSWORD,FLOCKEDTIME,FISACTIVED,FISREGISTED,FAUTHORSTATUS,FPSWHISSTR,FERRCOUNT,FUSERNAME,FISFORBIDDEN,FPSWSTRATEGYID)
VALUES (1064346091820281856,'0',' ',{ts'2021-01-08  00:00:00'},'2486f1d1627882b29c9acb9e88d02861973f7ec3c969ebfcadff8250a955f97c4cf1a21bd1fd589e2308cd38a34e9a05385e24357eb35bcc8771a82502d08185b449685317cb69a23763321549f1982f',NULL,'1','1',' ',' ',0,'disanfangfapiaoshangchuan','0',338333884850648064);

-- 第三方发票上传接口
DELETE FROM t_open_apiusers WHERE FPKID = 1064347002671964160;
INSERT INTO t_open_apiusers(FID,FBASEDATAID,FPKID) VALUES (1064347002671840257,1064346091820281856,1064347002671964160);

DELETE FROM t_open_apiauthorize WHERE FID = 1064347002671840257;
INSERT INTO t_open_apiauthorize(FID,FAPINUMBER) VALUES (1064347002671840257,'invoiceupload');