
--将第三方应用im的密码设置为空，让用户预设密码
UPDATE T_OPEN_3RDAPPS SET FSYSPWD = ' ' WHERE FID = 895525922394945536 AND FSYSPWD = 'jx5lwOsWJCC8omQf+ORsDQ==';

--修改授权全部api为否
UPDATE T_OPEN_3RDAPPS SET FALLOWALLAPI = '0' WHERE FID = 895525922394945536;

--添加授权api分录
DELETE FROM t_open_3rdappsapis WHERE FENTRYID = 1708611459262461952;
INSERT INTO t_open_3rdappsapis(FID,FAPISERVICEID,FENTRYID,FSEQ) VALUES (895525922394945536,1460207046883334144,1708611459262461952,1); 
DELETE FROM t_open_3rdappsapis WHERE FENTRYID = 1708611459262461953;
INSERT INTO t_open_3rdappsapis(FID,FAPISERVICEID,FENTRYID,FSEQ) VALUES (895525922394945536,1459459750155709440,1708611459262461953,2); 
DELETE FROM t_open_3rdappsapis WHERE FENTRYID = 1708611459262461954;
INSERT INTO t_open_3rdappsapis(FID,FAPISERVICEID,FENTRYID,FSEQ) VALUES (895525922394945536,1457242002889592832,1708611459262461954,3); 
DELETE FROM t_open_3rdappsapis WHERE FENTRYID = 1708611459262461955;
INSERT INTO t_open_3rdappsapis(FID,FAPISERVICEID,FENTRYID,FSEQ) VALUES (895525922394945536,1449987739767333888,1708611459262461955,4); 
DELETE FROM t_open_3rdappsapis WHERE FENTRYID = 1708611459262461956;
INSERT INTO t_open_3rdappsapis(FID,FAPISERVICEID,FENTRYID,FSEQ) VALUES (895525922394945536,1462302314038614016,1708611459262461956,5); 
DELETE FROM t_open_3rdappsapis WHERE FENTRYID = 1708611459262461957;
INSERT INTO t_open_3rdappsapis(FID,FAPISERVICEID,FENTRYID,FSEQ) VALUES (895525922394945536,1458000776935857152,1708611459262461957,6); 
DELETE FROM t_open_3rdappsapis WHERE FENTRYID = 1708611459262461958;
INSERT INTO t_open_3rdappsapis(FID,FAPISERVICEID,FENTRYID,FSEQ) VALUES (895525922394945536,1462352049734735872,1708611459262461958,7); 
DELETE FROM t_open_3rdappsapis WHERE FENTRYID = 1708611459262461959;
INSERT INTO t_open_3rdappsapis(FID,FAPISERVICEID,FENTRYID,FSEQ) VALUES (895525922394945536,1458708209060632576,1708611459262461959,8); 
DELETE FROM t_open_3rdappsapis WHERE FENTRYID = 1708611459262461960;
INSERT INTO t_open_3rdappsapis(FID,FAPISERVICEID,FENTRYID,FSEQ) VALUES (895525922394945536,1462354202830362624,1708611459262461960,9); 
DELETE FROM t_open_3rdappsapis WHERE FENTRYID = 1708611459262461961;
INSERT INTO t_open_3rdappsapis(FID,FAPISERVICEID,FENTRYID,FSEQ) VALUES (895525922394945536,1463651245012080640,1708611459262461961,10); 
DELETE FROM t_open_3rdappsapis WHERE FENTRYID = 1708611459262461962;
INSERT INTO t_open_3rdappsapis(FID,FAPISERVICEID,FENTRYID,FSEQ) VALUES (895525922394945536,1458709032234735616,1708611459262461962,11); 
DELETE FROM t_open_3rdappsapis WHERE FENTRYID = 1708611459262461963;
INSERT INTO t_open_3rdappsapis(FID,FAPISERVICEID,FENTRYID,FSEQ) VALUES (895525922394945536,1459487312042977280,1708611459262461963,12); 
DELETE FROM t_open_3rdappsapis WHERE FENTRYID = 1708611459262461964;
INSERT INTO t_open_3rdappsapis(FID,FAPISERVICEID,FENTRYID,FSEQ) VALUES (895525922394945536,1459488340704422912,1708611459262461964,13); 
DELETE FROM t_open_3rdappsapis WHERE FENTRYID = 1708611459262461965;
INSERT INTO t_open_3rdappsapis(FID,FAPISERVICEID,FENTRYID,FSEQ) VALUES (895525922394945536,1459490869894899712,1708611459262461965,14); 
DELETE FROM t_open_3rdappsapis WHERE FENTRYID = 1708611459262461966;
INSERT INTO t_open_3rdappsapis(FID,FAPISERVICEID,FENTRYID,FSEQ) VALUES (895525922394945536,1463650572388328448,1708611459262461966,15); 
DELETE FROM t_open_3rdappsapis WHERE FENTRYID = 1708611459262461967;
INSERT INTO t_open_3rdappsapis(FID,FAPISERVICEID,FENTRYID,FSEQ) VALUES (895525922394945536,1459491399635495936,1708611459262461967,16); 
DELETE FROM t_open_3rdappsapis WHERE FENTRYID = 1708611459262461968;
INSERT INTO t_open_3rdappsapis(FID,FAPISERVICEID,FENTRYID,FSEQ) VALUES (895525922394945536,1463649822497104896,1708611459262461968,17); 
DELETE FROM t_open_3rdappsapis WHERE FENTRYID = 1708611459262461969;
INSERT INTO t_open_3rdappsapis(FID,FAPISERVICEID,FENTRYID,FSEQ) VALUES (895525922394945536,1463650184012552192,1708611459262461969,18); 
DELETE FROM t_open_3rdappsapis WHERE FENTRYID = 1708611459262461970;
INSERT INTO t_open_3rdappsapis(FID,FAPISERVICEID,FENTRYID,FSEQ) VALUES (895525922394945536,1460241801246988288,1708611459262461970,19); 
DELETE FROM t_open_3rdappsapis WHERE FENTRYID = 1708611459262461971;
INSERT INTO t_open_3rdappsapis(FID,FAPISERVICEID,FENTRYID,FSEQ) VALUES (895525922394945536,1462298526246560768,1708611459262461971,20); 
DELETE FROM t_open_3rdappsapis WHERE FENTRYID = 1708611459262461972;
INSERT INTO t_open_3rdappsapis(FID,FAPISERVICEID,FENTRYID,FSEQ) VALUES (895525922394945536,1462303063502021632,1708611459262461972,21); 
DELETE FROM t_open_3rdappsapis WHERE FENTRYID = 1708611459262461973;
INSERT INTO t_open_3rdappsapis(FID,FAPISERVICEID,FENTRYID,FSEQ) VALUES (895525922394945536,1462316535438694400,1708611459262461973,22); 
DELETE FROM t_open_3rdappsapis WHERE FENTRYID = 1708611459262461974;
INSERT INTO t_open_3rdappsapis(FID,FAPISERVICEID,FENTRYID,FSEQ) VALUES (895525922394945536,1462323044268696576,1708611459262461974,23); 
DELETE FROM t_open_3rdappsapis WHERE FENTRYID = 1708611459262461975;
INSERT INTO t_open_3rdappsapis(FID,FAPISERVICEID,FENTRYID,FSEQ) VALUES (895525922394945536,1462311697434862592,1708611459262461975,24); 
DELETE FROM t_open_3rdappsapis WHERE FENTRYID = 1708611459262461976;
INSERT INTO t_open_3rdappsapis(FID,FAPISERVICEID,FENTRYID,FSEQ) VALUES (895525922394945536,1462323627629271040,1708611459262461976,25); 
DELETE FROM t_open_3rdappsapis WHERE FENTRYID = 1708611459262461977;
INSERT INTO t_open_3rdappsapis(FID,FAPISERVICEID,FENTRYID,FSEQ) VALUES (895525922394945536,1462324050851321856,1708611459262461977,26); 
DELETE FROM t_open_3rdappsapis WHERE FENTRYID = 1708611459262461978;
INSERT INTO t_open_3rdappsapis(FID,FAPISERVICEID,FENTRYID,FSEQ) VALUES (895525922394945536,1462353383783454720,1708611459262461978,27); 
DELETE FROM t_open_3rdappsapis WHERE FENTRYID = 1708611459262461979;
INSERT INTO t_open_3rdappsapis(FID,FAPISERVICEID,FENTRYID,FSEQ) VALUES (895525922394945536,1462312064092526592,1708611459262461979,28); 
DELETE FROM t_open_3rdappsapis WHERE FENTRYID = 1708611459262461980;
INSERT INTO t_open_3rdappsapis(FID,FAPISERVICEID,FENTRYID,FSEQ) VALUES (895525922394945536,1462312423728931840,1708611459262461980,29); 
DELETE FROM t_open_3rdappsapis WHERE FENTRYID = 1708611459262461981;
INSERT INTO t_open_3rdappsapis(FID,FAPISERVICEID,FENTRYID,FSEQ) VALUES (895525922394945536,1458005183991733248,1708611459262461981,30); 
DELETE FROM t_open_3rdappsapis WHERE FENTRYID = 1708611459262461982;
INSERT INTO t_open_3rdappsapis(FID,FAPISERVICEID,FENTRYID,FSEQ) VALUES (895525922394945536,1462312755305437184,1708611459262461982,31); 
DELETE FROM t_open_3rdappsapis WHERE FENTRYID = 1708611459262461983;
INSERT INTO t_open_3rdappsapis(FID,FAPISERVICEID,FENTRYID,FSEQ) VALUES (895525922394945536,1458001499815761920,1708611459262461983,32); 
DELETE FROM t_open_3rdappsapis WHERE FENTRYID = 1708611459262461984;
INSERT INTO t_open_3rdappsapis(FID,FAPISERVICEID,FENTRYID,FSEQ) VALUES (895525922394945536,1458002071876884480,1708611459262461984,33); 
DELETE FROM t_open_3rdappsapis WHERE FENTRYID = 1708611459262461985;
INSERT INTO t_open_3rdappsapis(FID,FAPISERVICEID,FENTRYID,FSEQ) VALUES (895525922394945536,1458003289483336704,1708611459262461985,34); 
DELETE FROM t_open_3rdappsapis WHERE FENTRYID = 1708611459262461986;
INSERT INTO t_open_3rdappsapis(FID,FAPISERVICEID,FENTRYID,FSEQ) VALUES (895525922394945536,1458706286802720768,1708611459262461986,35); 
DELETE FROM t_open_3rdappsapis WHERE FENTRYID = 1708611459262461987;
INSERT INTO t_open_3rdappsapis(FID,FAPISERVICEID,FENTRYID,FSEQ) VALUES (895525922394945536,1462314315896903680,1708611459262461987,36); 
DELETE FROM t_open_3rdappsapis WHERE FENTRYID = 1708611459262461988;
INSERT INTO t_open_3rdappsapis(FID,FAPISERVICEID,FENTRYID,FSEQ) VALUES (895525922394945536,1462360033550459904,1708611459262461988,37); 
DELETE FROM t_open_3rdappsapis WHERE FENTRYID = 1708611459262461989;
INSERT INTO t_open_3rdappsapis(FID,FAPISERVICEID,FENTRYID,FSEQ) VALUES (895525922394945536,1462308599706474496,1708611459262461989,38); 
DELETE FROM t_open_3rdappsapis WHERE FENTRYID = 1708611459262461990;
INSERT INTO t_open_3rdappsapis(FID,FAPISERVICEID,FENTRYID,FSEQ) VALUES (895525922394945536,1450004301807150080,1708611459262461990,39); 
DELETE FROM t_open_3rdappsapis WHERE FENTRYID = 1708611459262461991;
INSERT INTO t_open_3rdappsapis(FID,FAPISERVICEID,FENTRYID,FSEQ) VALUES (895525922394945536,1462353810780382208,1708611459262461991,40); 
DELETE FROM t_open_3rdappsapis WHERE FENTRYID = 1708611459262461992;
INSERT INTO t_open_3rdappsapis(FID,FAPISERVICEID,FENTRYID,FSEQ) VALUES (895525922394945536,1458707776250403840,1708611459262461992,41); 
DELETE FROM t_open_3rdappsapis WHERE FENTRYID = 1708611459262461993;
INSERT INTO t_open_3rdappsapis(FID,FAPISERVICEID,FENTRYID,FSEQ) VALUES (895525922394945536,1462333055602579456,1708611459262461993,42); 
DELETE FROM t_open_3rdappsapis WHERE FENTRYID = 1708611459262461994;
INSERT INTO t_open_3rdappsapis(FID,FAPISERVICEID,FENTRYID,FSEQ) VALUES (895525922394945536,1457233357472747520,1708611459262461994,43); 
DELETE FROM t_open_3rdappsapis WHERE FENTRYID = 1708611459262461995;
INSERT INTO t_open_3rdappsapis(FID,FAPISERVICEID,FENTRYID,FSEQ) VALUES (895525922394945536,1457237800348102656,1708611459262461995,44); 
DELETE FROM t_open_3rdappsapis WHERE FENTRYID = 1708611459262461996;
INSERT INTO t_open_3rdappsapis(FID,FAPISERVICEID,FENTRYID,FSEQ) VALUES (895525922394945536,1457238298094424064,1708611459262461996,45); 
