/**首页方案修改脚本**/

DELETE from t_bas_cardconfig_l where fid in (select fid from t_bas_cardconfig where fmainpageid in(select fid from t_bas_mainpagelayout where ftype = 'app' and fbizappid = '11H66HLOX4IC' and FSCHEMETYPE = '1' and fenable = '1'));
DELETE from t_bas_cardconfig where fmainpageid in(select fid from t_bas_mainpagelayout where ftype = 'app' and fbizappid = '11H66HLOX4IC' and FSCHEMETYPE = '1' and fenable = '1');
DELETE from t_bas_mainpagelayout_l where fid in(select fid from t_bas_mainpagelayout where ftype = 'app' and fbizappid = '11H66HLOX4IC' and FSCHEMETYPE = '1' and fenable = '1');
DELETE from t_bas_mainpagelayout where ftype = 'app' and fbizappid = '11H66HLOX4IC' and FSCHEMETYPE = '1' and fenable = '1';

DELETE FROM t_bas_mainpagelayout WHERE FID = 420846703977975808;
INSERT INTO t_bas_mainpagelayout(FID,FCUSTOMABLE,FTYPE,FFORMNUM,FNUMBER,FDISABLETIME,FLAYOUT,FCREATETIME,FENABLE,FMODIFIERID,FISPRESET,FBIZAPPID,FMODIFYTIME,FSCHEMETYPE,FCREATORID,FUSERID,FDISABLERID) VALUES (420846703977975808,'1','app',' ','420846703977975808',NULL,'[{"w":12,"h":2,"x":0,"y":0,"i":"419307424172778496","moved":false,"static":false},{"w":12,"h":3,"x":0,"y":2,"i":"419308148336141312","moved":false,"static":false},{"w":12,"h":4,"x":0,"y":5,"i":"419308411956536320","moved":false,"static":false}]',NULL,'1',89559110,'1','11H66HLOX4IC',{ts'2020-05-01  14:01:16'},'1',1,1,0); 

DELETE FROM t_bas_mainpagelayout_l WHERE FPKID = '420846703977975808';
INSERT INTO t_bas_mainpagelayout_l(FID,FPKID,FLOCALEID,FNAME) VALUES (420846703977975808,'420846703977975808','zh_CN','法定合并应用首页默认方案'); 

DELETE FROM t_bas_cardconfig WHERE FID = 881750716014797824;
INSERT INTO t_bas_cardconfig(FID,FTYPE,FCARDID,FMAINPAGEID,FUSERID,FCONFIG) VALUES (881750716014797824,'bos_card_quicklaunch',419307424172778496,420846703977975808,0,'{"cardType":"bos_card_quicklaunch","config":{"16=11E7IQ2Z3":{"cache_sel_appId":"11H66HLOX4IC","cache_sel_menuId":"16=11E7IQ2Z3","launchType":"launchType_menu"},"/9+F9FHZLE9Y":{"cache_sel_appId":"11H66HLOX4IC","cache_sel_menuId":"/9+F9FHZLE9Y","launchType":"launchType_menu"},"16P2/QHGHBOK":{"cache_sel_appId":"11H66HLOX4IC","cache_sel_menuId":"16P2/QHGHBOK","launchType":"launchType_menu"},"16P311T5HE7J":{"cache_sel_appId":"11H66HLOX4IC","cache_sel_menuId":"16P311T5HE7J","launchType":"launchType_menu"},"16BY71Q9LCB7":{"cache_sel_appId":"11H66HLOX4IC","cache_sel_menuId":"16BY71Q9LCB7","launchType":"launchType_menu"},"Q+7R64EHWD4":{"cache_sel_appId":"11H66HLOX4IC","cache_sel_menuId":"Q+7R64EHWD4","launchType":"launchType_menu"},"0K9WWA/IA59B":{"cache_sel_appId":"11H66HLOX4IC","cache_sel_menuId":"0K9WWA/IA59B","launchType":"launchType_menu"}}}'); 
DELETE FROM t_bas_cardconfig WHERE FID = 881750716014797825;
INSERT INTO t_bas_cardconfig(FID,FTYPE,FCARDID,FMAINPAGEID,FUSERID,FCONFIG) VALUES (881750716014797825,'bos_card_custom',419308148336141312,420846703977975808,0,'{"cardformnum":"bcm_card_mytask","cardType":"bos_card_custom","cardformname":"我的任务卡片"}'); 
DELETE FROM t_bas_cardconfig WHERE FID = 881750716014797826;
INSERT INTO t_bas_cardconfig(FID,FTYPE,FCARDID,FMAINPAGEID,FUSERID,FCONFIG) VALUES (881750716014797826,'bos_card_custom',419308411956536320,420846703977975808,0,'{"cardformnum":"bcm_card_myvalue","cardType":"bos_card_custom","cardformname":"我的财务指标卡片"}'); 

DELETE FROM t_bas_cardconfig_l WHERE FPKID = '0R=CACE8/RDX';
INSERT INTO t_bas_cardconfig_l(FID,FPKID,FLOCALEID,FCUSTOMNAME,FCARDTITLE) VALUES (881750716014797825,'0R=CACE8/RDX','zh_CN',' ','我的报表编制任务'); 
DELETE FROM t_bas_cardconfig_l WHERE FPKID = '0R=CACE8/RDZ';
INSERT INTO t_bas_cardconfig_l(FID,FPKID,FLOCALEID,FCUSTOMNAME,FCARDTITLE) VALUES (881750716014797826,'0R=CACE8/RDZ','zh_CN',' ','我关注的财务指标'); 
DELETE FROM t_bas_cardconfig_l WHERE FPKID = '0R=CACE8/RDV';
INSERT INTO t_bas_cardconfig_l(FID,FPKID,FLOCALEID,FCUSTOMNAME,FCARDTITLE) VALUES (881750716014797824,'0R=CACE8/RDV','zh_CN',' ','快速发起');
