
/*筛选方案*/
DELETE FROM T_BAS_FILTERSCHEME WHERE FSCHEMEID = '1Q0OQZ==PAJ7';
DELETE FROM T_BAS_FILTERSCHEME WHERE FSCHEMEID = '1Q0OV65CBWEW';
DELETE FROM T_BAS_FILTERSCHEME WHERE FSCHEMEID = '1Q0OXYF539W=';

DELETE FROM T_BAS_FILTERSCHEME_L WHERE FPKID = '1Q0OQZAE7B6W';
DELETE FROM T_BAS_FILTERSCHEME_L WHERE FPKID = '1Q0OQZAE7=VC';
DELETE FROM T_BAS_FILTERSCHEME_L WHERE FPKID = '1Q0OQZAE7B6X';
DELETE FROM T_BAS_FILTERSCHEME_L WHERE FPKID = '1Q0OV65CBV2C';
DELETE FROM T_BAS_FILTERSCHEME_L WHERE FPKID = '1Q0OV65CBWEX';
DELETE FROM T_BAS_FILTERSCHEME_L WHERE FPKID = '1Q0OV65CBV2D';
DELETE FROM T_BAS_FILTERSCHEME_L WHERE FPKID = '1Q0OXYF538IS';
DELETE FROM T_BAS_FILTERSCHEME_L WHERE FPKID = '1Q0OXYF539WA';
DELETE FROM T_BAS_FILTERSCHEME_L WHERE FPKID = '1Q0OXYF538IT';




/*首页方案-面试官*/
DELETE FROM T_BAS_CARDCONFIG WHERE FMAINPAGEID = 1327614344942323712;
DELETE FROM T_BAS_MAINPAGELAYOUT_L WHERE FID = 1327614344942323712;
DELETE FROM T_BAS_MAINPAGELAYOUT_L WHERE FID = 1327614344942323712;
DELETE FROM T_BAS_MAINPAGELAYOUT WHERE FID = 1327614344942323712;

DELETE FROM T_BAS_CARDCONFIG_L WHERE FPKID = '251G0/IS612A';
DELETE FROM T_BAS_CARDCONFIG_L WHERE FPKID = '251G0/IS612B';
DELETE FROM T_BAS_CARDCONFIG_L WHERE FPKID = '251G0/IS612C';
DELETE FROM T_BAS_CARDCONFIG_L WHERE FPKID = '251G0/IS612D';
DELETE FROM T_BAS_CARDCONFIG_L WHERE FPKID = '251G0/IS612E';
DELETE FROM T_BAS_CARDCONFIG_L WHERE FPKID = '251G0/IS612F';
DELETE FROM T_BAS_CARDCONFIG_L WHERE FPKID = '251G0/IS612G';
DELETE FROM T_BAS_CARDCONFIG_L WHERE FPKID = '251G0/IS612H';
DELETE FROM T_BAS_CARDCONFIG_L WHERE FPKID = '251G0/IS612I';
DELETE FROM T_BAS_CARDCONFIG_L WHERE FPKID = '251G0/IS612J';
DELETE FROM T_BAS_CARDCONFIG WHERE FID = 1327614345093318656;
DELETE FROM T_BAS_CARDCONFIG WHERE FID = 1327614345093318657;
DELETE FROM T_BAS_CARDCONFIG WHERE FID = 1327614345093318658;
DELETE FROM T_BAS_CARDCONFIG WHERE FID = 1327614345093318659;
DELETE FROM T_BAS_CARDCONFIG WHERE FID = 1327614345093318660;
DELETE FROM T_BAS_MAINPAGELAYOUT_L WHERE FPKID = '251G0/H2XKM2';
DELETE FROM T_BAS_MAINPAGELAYOUT WHERE FID = 1327614344942323712;
DELETE FROM T_BAS_USERMAINPAGE WHERE FID = 1291316612741229787;

/*首页方案-非面试官*/
DELETE FROM T_BAS_CARDCONFIG_L WHERE FID=1328373986974763008;
DELETE FROM T_BAS_CARDCONFIG_L WHERE FID=1328373986974763009;
DELETE FROM T_BAS_CARDCONFIG_L WHERE FID=1328373986974763010;
DELETE FROM T_BAS_CARDCONFIG_L WHERE FID=1328373986974763011;
DELETE FROM T_BAS_CARDCONFIG WHERE FMAINPAGEID = 1328367063319708672;
DELETE FROM T_BAS_MAINPAGELAYOUT_L WHERE FID = 1328367063319708672;
DELETE FROM T_BAS_MAINPAGELAYOUT_L WHERE FID = 1328367063319708672;
DELETE FROM T_BAS_MAINPAGELAYOUT WHERE FID = 1328367063319708672;
DELETE FROM T_BAS_CARDCONFIG_L WHERE FPKID = '2552ZHYASN3X';
DELETE FROM T_BAS_CARDCONFIG_L WHERE FPKID = '2552ZHYASN3Y';
DELETE FROM T_BAS_CARDCONFIG_L WHERE FPKID = '2552ZHYASN3Z';
DELETE FROM T_BAS_CARDCONFIG_L WHERE FPKID = '2552ZHYASN4+';
DELETE FROM T_BAS_CARDCONFIG_L WHERE FPKID = '2552ZHYASN4/';
DELETE FROM T_BAS_CARDCONFIG_L WHERE FPKID = '2552ZHYASN40';
DELETE FROM T_BAS_CARDCONFIG_L WHERE FPKID = '2552ZHYASN41';
DELETE FROM T_BAS_CARDCONFIG_L WHERE FPKID = '2552ZHYASN42';
DELETE FROM T_BAS_CARDCONFIG WHERE FID = 1328373986974763008;
DELETE FROM T_BAS_CARDCONFIG WHERE FID = 1328373986974763009;
DELETE FROM T_BAS_CARDCONFIG WHERE FID = 1328373986974763010;
DELETE FROM T_BAS_CARDCONFIG WHERE FID = 1328373986974763011;
DELETE FROM T_BAS_MAINPAGELAYOUT_L WHERE FPKID = '2551O1=+M+MK';
DELETE FROM T_BAS_MAINPAGELAYOUT WHERE FID = 1328367063319708672;
DELETE FROM T_BAS_USERMAINPAGE WHERE FID = 1288816612741229568;

/**新预制数据**/
DELETE FROM T_BAS_CARDCONFIG WHERE FID = 1814723062139181058;
INSERT INTO T_BAS_CARDCONFIG(FID,FTYPE,FCARDID,FMAINPAGEID,FUSERID,FCONFIG) VALUES (1814723062139181058,'bos_card_custom',1814721527342684160,1814703844106522624,0,'{"cardformnum":"tsrbd_avronerecurt","cardType":"bos_card_custom","cardformname":"人人招聘"}');
DELETE FROM T_BAS_CARDCONFIG WHERE FID = 1814723062139181056;
INSERT INTO T_BAS_CARDCONFIG(FID,FTYPE,FCARDID,FMAINPAGEID,FUSERID,FCONFIG) VALUES (1814723062139181056,'bos_card_custom',1814718223497811968,1814703844106522624,0,'{"cardformnum":"tsrbd_interviewer","cardType":"bos_card_custom","cardformname":"面试官"}');
DELETE FROM T_BAS_CARDCONFIG WHERE FID = 1814723062139181060;
INSERT INTO T_BAS_CARDCONFIG(FID,FTYPE,FCARDID,FMAINPAGEID,FUSERID,FCONFIG) VALUES (1814723062139181060,'bos_card_custom',1814722010308399104,1814703844106522624,0,'{"cardformnum":"tsrbd_intvcaled","cardType":"bos_card_custom","cardformname":"面试日历"}');
DELETE FROM T_BAS_CARDCONFIG WHERE FID = 1814723062139181059;
INSERT INTO T_BAS_CARDCONFIG(FID,FTYPE,FCARDID,FMAINPAGEID,FUSERID,FCONFIG) VALUES (1814723062139181059,'bos_card_custom',1814721810349150208,1814703844106522624,0,'{"cardformnum":"tsrbd_overviewdata","cardType":"bos_card_custom","cardformname":"概览数据"}');
DELETE FROM T_BAS_CARDCONFIG WHERE FID = 1814723062139181057;
INSERT INTO T_BAS_CARDCONFIG(FID,FTYPE,FCARDID,FMAINPAGEID,FUSERID,FCONFIG) VALUES (1814723062139181057,'bos_card_custom',1814721279350265856,1814703844106522624,0,'{"cardformnum":"tsrbd_todayintv","cardType":"bos_card_custom","cardformname":"今日面试"}');

DELETE FROM T_BAS_CARDCONFIG_L WHERE FPKID = '3OX56XF3P62M';
INSERT INTO T_BAS_CARDCONFIG_L(FID,FPKID,FLOCALEID,FCUSTOMNAME,FCARDTITLE) VALUES (1814723062139181056,'3OX56XF3P62M','zh_CN',' ','面试官');
DELETE FROM T_BAS_CARDCONFIG_L WHERE FPKID = '3OX56XF3P62L';
--INSERT INTO T_BAS_CARDCONFIG_L(FID,FPKID,FLOCALEID,FCUSTOMNAME,FCARDTITLE) VALUES (1814723062139181056,'3OX56XF3P62L','zh_TW',' ','麵試官');
DELETE FROM T_BAS_CARDCONFIG_L WHERE FPKID = '3OX56XF3P62O';
INSERT INTO T_BAS_CARDCONFIG_L(FID,FPKID,FLOCALEID,FCUSTOMNAME,FCARDTITLE) VALUES (1814723062139181057,'3OX56XF3P62O','zh_CN',' ','今日面试');
DELETE FROM T_BAS_CARDCONFIG_L WHERE FPKID = '3OX56XF3P62N';
--INSERT INTO T_BAS_CARDCONFIG_L(FID,FPKID,FLOCALEID,FCUSTOMNAME,FCARDTITLE) VALUES (1814723062139181057,'3OX56XF3P62N','zh_TW',' ','今日麵試');
DELETE FROM T_BAS_CARDCONFIG_L WHERE FPKID = '3OX56XF3P62Q';
INSERT INTO T_BAS_CARDCONFIG_L(FID,FPKID,FLOCALEID,FCUSTOMNAME,FCARDTITLE) VALUES (1814723062139181058,'3OX56XF3P62Q','zh_CN',' ','人人招聘');
DELETE FROM T_BAS_CARDCONFIG_L WHERE FPKID = '3OX56XF3P62P';
--INSERT INTO T_BAS_CARDCONFIG_L(FID,FPKID,FLOCALEID,FCUSTOMNAME,FCARDTITLE) VALUES (1814723062139181058,'3OX56XF3P62P','zh_TW',' ','人人招聘');
DELETE FROM T_BAS_CARDCONFIG_L WHERE FPKID = '3OX56XF3P62S';
INSERT INTO T_BAS_CARDCONFIG_L(FID,FPKID,FLOCALEID,FCUSTOMNAME,FCARDTITLE) VALUES (1814723062139181059,'3OX56XF3P62S','zh_CN',' ','我的待办');
DELETE FROM T_BAS_CARDCONFIG_L WHERE FPKID = '3OX56XF3P62R';
--INSERT INTO T_BAS_CARDCONFIG_L(FID,FPKID,FLOCALEID,FCUSTOMNAME,FCARDTITLE) VALUES (1814723062139181059,'3OX56XF3P62R','zh_TW',' ','我的待辦');
DELETE FROM T_BAS_CARDCONFIG_L WHERE FPKID = '3OX56XF3P62U';
INSERT INTO T_BAS_CARDCONFIG_L(FID,FPKID,FLOCALEID,FCUSTOMNAME,FCARDTITLE) VALUES (1814723062139181060,'3OX56XF3P62U','zh_CN',' ','面试日历');
DELETE FROM T_BAS_CARDCONFIG_L WHERE FPKID = '3OX56XF3P62T';
--INSERT INTO T_BAS_CARDCONFIG_L(FID,FPKID,FLOCALEID,FCUSTOMNAME,FCARDTITLE) VALUES (1814723062139181060,'3OX56XF3P62T','zh_TW',' ','麵試日曆');

DELETE FROM T_BAS_MAINPAGELAYOUT WHERE FID = 1814703844106522624;
INSERT INTO T_BAS_MAINPAGELAYOUT(FID,FCUSTOMABLE,FTYPE,FFORMNUM,FLAYOUT_TAG,FMASTERID,FNUMBER,FNAME,FDISABLETIME,FLAYOUT,FCREATETIME,FISMULTIORG,FENABLE,FMODIFIERID,FISPRESET,FBIZAPPID,FMODIFYTIME,FSCHEMETYPE,FCREATORID,FUSERID,FDISABLERID) VALUES (1814703844106522624,'1','app',' ',' ',0,'HP-012001','IERP的人人面试官应用首页个性方案',NULL,'[{"w":4,"h":1,"x":0,"y":0,"i":"1814718223497811968","moved":false,"static":false},{"w":4,"h":2,"x":4,"y":0,"i":"1814721279350265856","moved":false,"static":false},{"w":4,"h":2,"x":8,"y":0,"i":"1814721527342684160","moved":false,"static":false},{"w":4,"h":1,"x":0,"y":1,"i":"1814721810349150208","moved":false,"static":false},{"w":12,"h":3,"x":0,"y":2,"i":"1814722010308399104","moved":false,"static":false}]',{ts'2023-11-09  00:00:00'},'1','1',33333333333333,'0','1AMZQZV0UQGC',{ts'2023-11-09  00:00:00'},'3',33333333333333,0,0);
DELETE FROM T_BAS_MAINPAGELAYOUT_L WHERE FPKID = '3OX1LVU0E45F';
INSERT INTO T_BAS_MAINPAGELAYOUT_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1814703844106522624,'3OX1LVU0E45F','zh_CN','IERP的人人面试官应用首页个性方案');
