-- 翻译平台预置第三方应用

-- 更新API服务数据状态
IF EXISTS (SELECT 1 FROM t_open_apiservice WHERE fid = 492464089864353792)
update t_open_apiservice set fstatus = 'C' where fid = 492464089864353792;
IF EXISTS (SELECT 1 FROM t_open_apiservice WHERE fid = 455561143209971712)
update t_open_apiservice set fstatus = 'C' where fid = 455561143209971712;
IF EXISTS (SELECT 1 FROM t_open_apiservice WHERE fid = 455610870970470400)
update t_open_apiservice set fstatus = 'C' where fid = 455610870970470400;
IF EXISTS (SELECT 1 FROM t_open_apiservice WHERE fid = 461466183325998080)
update t_open_apiservice set fstatus = 'C' where fid = 461466183325998080;
IF EXISTS (SELECT 1 FROM t_open_apiservice WHERE fid = 468471415696332800)
update t_open_apiservice set fstatus = 'C' where fid = 468471415696332800;
IF EXISTS (SELECT 1 FROM t_open_apiservice WHERE fid = 468472169303713792)
update t_open_apiservice set fstatus = 'C' where fid = 468472169303713792;
IF EXISTS (SELECT 1 FROM t_open_apiservice WHERE fid = 468472837053683712)
update t_open_apiservice set fstatus = 'C' where fid = 468472837053683712;
IF EXISTS (SELECT 1 FROM t_open_apiservice WHERE fid = 492463224285837312)
update t_open_apiservice set fstatus = 'C' where fid = 492463224285837312;
IF EXISTS (SELECT 1 FROM t_open_apiservice WHERE fid = 492463350920263680)
update t_open_apiservice set fstatus = 'C' where fid = 492463350920263680;
IF EXISTS (SELECT 1 FROM t_open_apiservice WHERE fid = 503473057168360448)
update t_open_apiservice set fstatus = 'C' where fid = 503473057168360448;
IF EXISTS (SELECT 1 FROM t_open_apiservice WHERE fid = 503475005347070976)
update t_open_apiservice set fstatus = 'C' where fid = 503475005347070976;
IF EXISTS (SELECT 1 FROM t_open_apiservice WHERE fid = 503496455110076416)
update t_open_apiservice set fstatus = 'C' where fid = 503496455110076416;
IF EXISTS (SELECT 1 FROM t_open_apiservice WHERE fid = 510724207722640384)
update t_open_apiservice set fstatus = 'C' where fid = 510724207722640384;
IF EXISTS (SELECT 1 FROM t_open_apiservice WHERE fid = 504772694642788352)
update t_open_apiservice set fstatus = 'C' where fid = 504772694642788352;

DELETE FROM t_open_3rdapps WHERE fid = 1184690318432297984;
INSERT INTO t_open_3rdapps(fid,fjwtasymmetic,flastenabletime,fallowallapi,fdisabledate,fmasterid,fstatus,fnumber,fcreatetime,fsecuritypublickey,fmodifierid,fsyspwd,fenable,fwhitelist,fmodifytime,fpwdlength,fpublickey,flaststoptime,fsecurityprivatekey,fcreatorid,fdisablerid) VALUES (1184690318432297984,'0',NULL,'0',NULL,1184690318432297984,'A','trans-tc',{ts'2021-06-23  00:00:00'},' ',1,'78d6d40f6dab3b3a78d5912131a332e592f49cf868359dd3adaf74f6f007e4a61cc559ab42f0b168fbd643da823fa0eea86533a9340bb424377469182a02c995de43533ff1e0ee4711d8e088a3730ca5','1',' ',{ts'2021-06-23  00:00:00'},NULL,' ',NULL,' ',1,NULL); 

DELETE FROM t_open_3rdapps_l WHERE fpkid = '1PHQ=1X=51TG';
INSERT INTO t_open_3rdapps_l(fid,fpkid,flocaleid,fname) VALUES (1184690318432297984,'1PHQ=1X=51TG','zh_CN','翻译平台'); 
DELETE FROM t_open_3rdapps_l WHERE fpkid = '1PHQ=1X=51TH';
INSERT INTO t_open_3rdapps_l(fid,fpkid,flocaleid,fname) VALUES (1184690318432297984,'1PHQ=1X=51TH','zh_TW','翻譯平台'); 

DELETE FROM t_open_3rdappsapis WHERE fentryid = '1184691409723089920';
INSERT INTO t_open_3rdappsapis (fentryid,fid,fseq,fapiserviceid) VALUES('1184691409723089920',1184690318432297984,1,'455610870970470400');
DELETE FROM t_open_3rdappsapis WHERE fentryid = '1184691409723089921';
INSERT INTO t_open_3rdappsapis (fentryid,fid,fseq,fapiserviceid) VALUES('1184691409723089921',1184690318432297984,2,'455561143209971712');
DELETE FROM t_open_3rdappsapis WHERE fentryid = '1184691409723089922';
INSERT INTO t_open_3rdappsapis (fentryid,fid,fseq,fapiserviceid) VALUES('1184691409723089922',1184690318432297984,3,'1061382064189744128');
DELETE FROM t_open_3rdappsapis WHERE fentryid = '1184691409723089923';
INSERT INTO t_open_3rdappsapis (fentryid,fid,fseq,fapiserviceid) VALUES('1184691409723089923',1184690318432297984,4,'503496455110076416');
DELETE FROM t_open_3rdappsapis WHERE fentryid = '1184691409723089924';
INSERT INTO t_open_3rdappsapis (fentryid,fid,fseq,fapiserviceid) VALUES('1184691409723089924',1184690318432297984,5,'718575302510438400');
DELETE FROM t_open_3rdappsapis WHERE fentryid = '1184691409723089925';
INSERT INTO t_open_3rdappsapis (fentryid,fid,fseq,fapiserviceid) VALUES('1184691409723089925',1184690318432297984,6,'475762519630176256');
DELETE FROM t_open_3rdappsapis WHERE fentryid = '1184691409723089926';
INSERT INTO t_open_3rdappsapis (fentryid,fid,fseq,fapiserviceid) VALUES('1184691409723089926',1184690318432297984,7,'480276853009956864');
DELETE FROM t_open_3rdappsapis WHERE fentryid = '1184691409723089927';
INSERT INTO t_open_3rdappsapis (fentryid,fid,fseq,fapiserviceid) VALUES('1184691409723089927',1184690318432297984,8,'480272605186699264');
DELETE FROM t_open_3rdappsapis WHERE fentryid = '1184691409723089928';
INSERT INTO t_open_3rdappsapis (fentryid,fid,fseq,fapiserviceid) VALUES('1184691409723089928',1184690318432297984,9,'461466183325998080');
DELETE FROM t_open_3rdappsapis WHERE fentryid = '1184691409723089929';
INSERT INTO t_open_3rdappsapis (fentryid,fid,fseq,fapiserviceid) VALUES('1184691409723089929',1184690318432297984,10,'468471415696332800');
DELETE FROM t_open_3rdappsapis WHERE fentryid = '1184691409723089930';
INSERT INTO t_open_3rdappsapis (fentryid,fid,fseq,fapiserviceid) VALUES('1184691409723089930',1184690318432297984,11,'468472837053683712');
DELETE FROM t_open_3rdappsapis WHERE fentryid = '1184691409723089931';
INSERT INTO t_open_3rdappsapis (fentryid,fid,fseq,fapiserviceid) VALUES('1184691409723089931',1184690318432297984,12,'468472169303713792');
DELETE FROM t_open_3rdappsapis WHERE fentryid = '1184691409723089932';
INSERT INTO t_open_3rdappsapis (fentryid,fid,fseq,fapiserviceid) VALUES('1184691409723089932',1184690318432297984,13,'1066658538291876864');
DELETE FROM t_open_3rdappsapis WHERE fentryid = '1184691409723089933';
INSERT INTO t_open_3rdappsapis (fentryid,fid,fseq,fapiserviceid) VALUES('1184691409723089933',1184690318432297984,14,'1066659228565263360');
DELETE FROM t_open_3rdappsapis WHERE fentryid = '1184691409723089934';
INSERT INTO t_open_3rdappsapis (fentryid,fid,fseq,fapiserviceid) VALUES('1184691409723089934',1184690318432297984,15,'820304087462461440');
DELETE FROM t_open_3rdappsapis WHERE fentryid = '1184691409723089935';
INSERT INTO t_open_3rdappsapis (fentryid,fid,fseq,fapiserviceid) VALUES('1184691409723089935',1184690318432297984,16,'820303251923550208');
DELETE FROM t_open_3rdappsapis WHERE fentryid = '1184691409723089936';
INSERT INTO t_open_3rdappsapis (fentryid,fid,fseq,fapiserviceid) VALUES('1184691409723089936',1184690318432297984,17,'804325358982706176');
DELETE FROM t_open_3rdappsapis WHERE fentryid = '1184691409723089937';
INSERT INTO t_open_3rdappsapis (fentryid,fid,fseq,fapiserviceid) VALUES('1184691409723089937',1184690318432297984,18,'804327120280015872');
DELETE FROM t_open_3rdappsapis WHERE fentryid = '1184691409723089938';
INSERT INTO t_open_3rdappsapis (fentryid,fid,fseq,fapiserviceid) VALUES('1184691409723089938',1184690318432297984,19,'804329710380169216');
DELETE FROM t_open_3rdappsapis WHERE fentryid = '1184691409723089939';
INSERT INTO t_open_3rdappsapis (fentryid,fid,fseq,fapiserviceid) VALUES('1184691409723089939',1184690318432297984,20,'503473057168360448');	 
DELETE FROM t_open_3rdappsapis WHERE fentryid = '1184691409723089940';
INSERT INTO t_open_3rdappsapis (fentryid,fid,fseq,fapiserviceid) VALUES('1184691409723089940',1184690318432297984,21,'503475005347070976');
DELETE FROM t_open_3rdappsapis WHERE fentryid = '1184691409723089941';
INSERT INTO t_open_3rdappsapis (fentryid,fid,fseq,fapiserviceid) VALUES('1184691409723089941',1184690318432297984,22,'504772694642788352');
DELETE FROM t_open_3rdappsapis WHERE fentryid = '1184691409723089942';
INSERT INTO t_open_3rdappsapis (fentryid,fid,fseq,fapiserviceid) VALUES('1184691409723089942',1184690318432297984,23,'510724207722640384');
DELETE FROM t_open_3rdappsapis WHERE fentryid = '1184691409723089943';
INSERT INTO t_open_3rdappsapis (fentryid,fid,fseq,fapiserviceid) VALUES('1184691409723089943',1184690318432297984,24,'492463350920263680');
DELETE FROM t_open_3rdappsapis WHERE fentryid = '1184691409723089944';
INSERT INTO t_open_3rdappsapis (fentryid,fid,fseq,fapiserviceid) VALUES('1184691409723089944',1184690318432297984,25,'492463224285837312');
DELETE FROM t_open_3rdappsapis WHERE fentryid = '1184691409723089945';
INSERT INTO t_open_3rdappsapis (fentryid,fid,fseq,fapiserviceid) VALUES('1184691409723089945',1184690318432297984,26,'492464089864353792');
DELETE FROM t_open_3rdappsapis WHERE fentryid = '1184691409723089946';
INSERT INTO t_open_3rdappsapis (fentryid,fid,fseq,fapiserviceid) VALUES('1184691409723089946',1184690318432297984,27,'579503084166712320');
DELETE FROM t_open_3rdappsapis WHERE fentryid = '1184691409723089947';
INSERT INTO t_open_3rdappsapis (fentryid,fid,fseq,fapiserviceid) VALUES('1184691409723089947',1184690318432297984,28,'580147825531172864');
DELETE FROM t_open_3rdappsapis WHERE fentryid = '1184691409723089948';
INSERT INTO t_open_3rdappsapis (fentryid,fid,fseq,fapiserviceid) VALUES('1184691409723089948',1184690318432297984,29,'580127653755893760');
DELETE FROM t_open_3rdappsapis WHERE fentryid = '1184691409723089949';
INSERT INTO t_open_3rdappsapis (fentryid,fid,fseq,fapiserviceid) VALUES('1184691409723089949',1184690318432297984,30,'1186152046756106240');