
DELETE FROM t_open_apiservice WHERE fid=1492758669568295936;
INSERT INTO t_open_apiservice (fapiservicetype, fcustommethod, fisfailcontinue, faddedinfo, foperation, fisksql, fmasterid, forder_by_hide, fmustparam, fselectparam, fcontenttype, fcreatetime, fenable, isfailcontinue, freqtype, fisvid, fdisablerid, fbizobject, fallowguest, fid, fversion, faddedinfo_tag, furl, fdisabledate, fsaveoperation, fstatus, ffilterparam, fcu_limit_tac, freptype, fnumber, fcustomsort, fmessagetype, fisdyobjresult, fmodifierid, fplugin, fmodifytime, fappid, furlformat, fhttpmethod, fcreatorid) VALUES('0', ' ', '0', ' ', 'query', '0', 1492758669568295936, ' ', ' ', 'name,createorg,modifytime', '0', {ts'2022-08-22 14:34:59'}, '1', '1', NULL, 'kingdee', NULL, 'bos_user', '0', 1492758669568295936, '2', ' ', NULL, NULL, ' ', 'C', ' ', 0, NULL, 'queryByNumber', 0, NULL, '0', 1, ' ', {ts'2022-08-22 14:46:48'}, '83bfebc8000037ac', '/v2/base/bos_user/queryByNumber', '0', 1);


DELETE FROM t_open_apiservice_l WHERE fpkid='2OBNIWFM7SJL';
DELETE FROM t_open_apiservice_l WHERE fpkid='2OBNIWFM7SJM';

INSERT INTO t_open_apiservice_l (fdiscription, fid, fpkid, flocaleid, fname) VALUES(' ', 1492758669568295936, '2OBNIWFM7SJL', 'zh_CN', '工号查询人员信息');
INSERT INTO t_open_apiservice_l (fdiscription, fid, fpkid, flocaleid, fname) VALUES(' ', 1492758669568295936, '2OBNIWFM7SJM', 'zh_TW', '工號查詢人員信息');

DELETE FROM t_open_apibodyentry WHERE fentryid=1492757980695806976;
INSERT INTO t_open_apibodyentry (fid, fexample, fentryid, fbody_data_model, fis_unique_key, fobjpropname, fis_body_custom, fbody_level, fmust, fparamtype, fparententryid, fbodyparamdes, fseq, fparamname) VALUES(1492758669568295936, '["6pdBs","fZe4f"]', 1492757980695806976, 'TextProp', '0', 'number', '0', '1', '1', 'Array<String>', 0, '工号', 1, 'number');

DELETE FROM t_open_apiqueryfilter WHERE fentryid=1492758669576684544;
INSERT INTO t_open_apiqueryfilter (fid, ffiltercompare, ffilterlink, ffilterleftbracket, ffilter_type, ffiltervalue, ffiltercolumn, fentryid, fseq, ffilterrightbracket, ffilterlabel) VALUES(1492758669568295936, 'IN', '0', ' ', 'String', 'number', 'number', 1492758669576684544, 1, ' ', '工号');


DELETE FROM t_open_apirespentry WHERE fentryid=1492758470624067584;
DELETE FROM t_open_apirespentry WHERE fentryid=1492758470640845824;
DELETE FROM t_open_apirespentry WHERE fentryid=1492758470657623040;
DELETE FROM t_open_apirespentry WHERE fentryid=1492758470649233408;
DELETE FROM t_open_apirespentry WHERE fentryid=1492758470649234432;
DELETE FROM t_open_apirespentry WHERE fentryid=1492758470657622016;

INSERT INTO t_open_apirespentry (fid, frespparamtype, fentryid, fis_resp_custom, frespexample, frespparamname, frespparammust, fparententryid, fseq, fresp_level, frespdes, fresp_data_model, frespobjpropname) VALUES(1492758669568295936, 'Long', 1492758470624067584, '0', '16', 'id', '1', 0, 1, '1', 'id', 'LongProp', 'id');
INSERT INTO t_open_apirespentry (fid, frespparamtype, fentryid, fis_resp_custom, frespexample, frespparamname, frespparammust, fparententryid, fseq, fresp_level, frespdes, fresp_data_model, frespobjpropname) VALUES(1492758669568295936, 'String', 1492758470640845824, '0', '"X91FH"', 'number', '1', 0, 2, '1', '工号', 'TextProp', 'number');
INSERT INTO t_open_apirespentry (fid, frespparamtype, fentryid, fis_resp_custom, frespexample, frespparamname, frespparammust, fparententryid, fseq, fresp_level, frespdes, fresp_data_model, frespobjpropname) VALUES(1492758669568295936, 'String', 1492758470657623040, '0', '"sQXFc"', 'name', '1', 0, 3, '1', '姓名', 'MuliLangTextProp', 'name');
INSERT INTO t_open_apirespentry (fid, frespparamtype, fentryid, fis_resp_custom, frespexample, frespparamname, frespparammust, fparententryid, fseq, fresp_level, frespdes, fresp_data_model, frespobjpropname) VALUES(1492758669568295936, 'String', 1492758470649233408, '0', '"HWwXW"', 'phone', '1', 0, 4, '1', '手机', 'TextProp', 'phone');
INSERT INTO t_open_apirespentry (fid, frespparamtype, fentryid, fis_resp_custom, frespexample, frespparamname, frespparammust, fparententryid, fseq, fresp_level, frespdes, fresp_data_model, frespobjpropname) VALUES(1492758669568295936, 'String', 1492758470649234432, '0', '"W6HD1"', 'email', '1', 0, 5, '1', '邮箱', 'TextProp', 'email');
INSERT INTO t_open_apirespentry (fid, frespparamtype, fentryid, fis_resp_custom, frespexample, frespparamname, frespparammust, fparententryid, fseq, fresp_level, frespdes, fresp_data_model, frespobjpropname) VALUES(1492758669568295936, 'String', 1492758470657622016, '0', '"1"', 'gender', '1', 0, 6, '1', '性别', 'ComboProp', 'gender');
