/** 首页配置 **/
DELETE FROM T_BAS_CARDCONFIG_L WHERE FID IN (SELECT FID FROM T_BAS_CARDCONFIG WHERE FMAINPAGEID = 1196349179459298304);	
DELETE FROM T_BAS_CARDCONFIG WHERE FMAINPAGEID = 1196349179459298304;	
DELETE FROM T_BAS_MAINPAGELAYOUT_L WHERE FID = 1196349179459298304;	
DELETE FROM T_BAS_MAINPAGELAYOUT_L WHERE FID = 1196349179459298304;	
DELETE FROM T_BAS_MAINPAGELAYOUT WHERE FID = 1196349179459298304;	
DELETE FROM t_bas_cardconfig_l WHERE fpkid = '1QYKP+UTJNFK';
--INSERT INTO t_bas_cardconfig_l(fid,fpkid,flocaleid,fcustomname,fcardtitle) VALUES (1196349179534795776,'1QYKP+UTJNFK','zh_TW',' ','快速發起'); 
DELETE FROM t_bas_cardconfig_l WHERE fpkid = '1QYKP+UTJNFL';
INSERT INTO t_bas_cardconfig_l(fid,fpkid,flocaleid,fcustomname,fcardtitle) VALUES (1196349179534795776,'1QYKP+UTJNFL','zh_CN',' ','快速发起'); 
DELETE FROM t_bas_cardconfig WHERE fid = 1196349179534795776;
INSERT INTO t_bas_cardconfig(fid,ftype,fcardid,fmainpageid,fuserid,fconfig) VALUES (1196349179534795776,'bos_card_quicklaunch',1196344057358480384,1196349179459298304,0,'{"cardType":"bos_card_quicklaunch","config":{"1185484204381593600":{"cache_sel_appId":"1NQE0WQWLLZ=","cache_sel_menuId":"1185484204381593600","launchType":"launchType_menu"},"1195456226180225024":{"cache_sel_appId":"1NQE0WQWLLZ=","cache_sel_menuId":"1195456226180225024","launchType":"launchType_menu"},"1195456600496696320":{"cache_sel_appId":"1NQE0WQWLLZ=","cache_sel_menuId":"1195456600496696320","launchType":"launchType_menu"},"1190428642505659392":{"cache_sel_appId":"1NQE0WQWLLZ=","cache_sel_menuId":"1190428642505659392","launchType":"launchType_menu"},"1185485207080297472":{"cache_sel_appId":"1NQE0WQWLLZ=","cache_sel_menuId":"1185485207080297472","launchType":"launchType_menu"}}}');
DELETE FROM t_bas_mainpagelayout_l WHERE fpkid = '1QYKP+TZXXPZ';
INSERT INTO t_bas_mainpagelayout_l(fid,fpkid,flocaleid,fname) VALUES (1196349179459298304,'1QYKP+TZXXPZ','zh_CN','招聘基础数据应用首页默认方案'); 
DELETE FROM t_bas_mainpagelayout WHERE fid = 1196349179459298304;
INSERT INTO t_bas_mainpagelayout(fid,fcustomable,ftype,fformnum,fnumber,fdisabletime,flayout,fcreatetime,fismultiorg,fenable,fmodifierid,fispreset,fbizappid,fmodifytime,fschemetype,fcreatorid,fuserid,fdisablerid) VALUES (1196349179459298304,'1','app',' ','HP-000014',NULL,'[{"w":12,"h":1,"x":0,"y":0,"i":"1196344057358480384","moved":false,"static":false}]',{ts'2021-07-09  00:00:00'},'1','1',0,'0','1NQE0WQWLLZ=',NULL,'1',1165011567415139328,0,0); 


DELETE FROM T_CR_CODERULE WHERE FID='1J=53C=SY7ST';
 INSERT INTO T_CR_CODERULE(FID,FNUMBER,FRULETYPE,FBIZOBJECTID,FSPLITSIGN,FCTRLMODE,FAPPMODE,FEXAMPLE,FEXAMPLELENGTH,FENABLE,FSTATUS,FCREATORID,FCREATETIME,FMODIFIERID,FMODIFYTIME,FDISABLERID,FDISABLEDATE,FMASTERID,FISUPDATERECOVER,FISNONBREAK,FISCHECKCODE,FISAPPCONDITION,FISAPPORG,FISLOG,FISSERIALNUMBER,FISUNIQUE,FISMODIFIABLE,FISADDVIEW,FISFAST)
 VALUES('1J=53C=SY7ST','1J=4YHNUZVYR',null,'tsrbd_cfgmail','-','1','2',' ',' ','1','C',1,{ts'2021-04-14 16:53:34'},1,{ts'2021-04-14 16:53:34'},0,null,'1J=53C=SY7ST','0','1','0','0','0','0','1','0','0','1','0');
 DELETE FROM T_CR_CODERULE_L WHERE FPKID='1J=53C=SY8G1';
 INSERT INTO T_CR_CODERULE_L(FPKID,FID,FLOCALEID,FNAME)
 VALUES('1J=53C=SY8G1','1J=53C=SY7ST','zh_CN','收取简历邮箱');
 DELETE FROM T_CR_CODERULEENTRY WHERE FENTRYID='1J=53CB6AFOH';
 INSERT INTO T_CR_CODERULEENTRY(FENTRYID,FID,FSEQ,FATTRIBUTETYPE,FATTUSINGMODE,FVALUEATRIBUTE,FFORMAT,FSETTINGVALUE,FLENGTH,FINITIAL,FSTEP,FADDCHAR,FISSPLITSIGN,FADDSTYLE,FCUTSTYLE,FISSORTITEM,FSPLITSIGN,FISVISABLE)
 VALUES('1J=53CB6AFOH','1J=53C=SY7ST',0,'16',' ',' ',' ',' ',4,1001,1,' ','0','1','1','0',' ','1');
 
 DELETE FROM T_CR_CODERULE WHERE fid = '1Q4J+KWP7/XN';
INSERT INTO T_CR_CODERULE(fexample,fappmode,fisaddview,fisappcondition,fmasterid,fisunique,fruletype,fismodifiable,fcreatetime,fbizobjectid,fenable,fisupdaterecover,fisapporg,fisserialnumber,fdisablerid,fischeckcode,fid,fsplitsign,fctrlmode,fdisabledate,fislog,fstatus,fnumber,fexamplelength,fisfast,fmodifierid,fisnonbreak,fmodifytime,fcreatorid) VALUES (' ','2','1','0','1Q4J+KWP7/XN','0',NULL,'0',{ts'2021-06-30  00:00:00'},'tsrbd_cfgresurule','1','0','0','0',NULL,'0','1Q4J+KWP7/XN','-','1',NULL,'0','C','1Q4J+8D9M6WA',' ','0',0,'0',{ts'2021-06-30  00:00:00'},0); 
DELETE FROM T_CR_CODERULE_L WHERE fpkid = '1Q4J+KWP70KX';
INSERT INTO T_CR_CODERULE_L(fid,fpkid,flocaleid,fname) VALUES ('1Q4J+KWP7/XN','1Q4J+KWP70KX','zh_CN','初筛淘汰规则'); 
DELETE FROM t_cr_coderuleentry WHERE fentryid = '1Q4J+KXIURN9';
INSERT INTO t_cr_coderuleentry(fid,finitial,fattributetype,fsplitsign,fissortitem,fentryid,fstep,fcutstyle,fattusingmode,fseq,flength,fisvisable,fformat,fsettingvalue,faddstyle,fvalueatribute,fissplitsign,faddchar) VALUES ('1Q4J+KWP7/XN',1,'10',' ','0','1Q4J+KXIURN9',1,'1',' ',0,8,'1',' ',' ','1',' ','0',' '); 

/**tsrbd_workaddr coderule preinsdata export**/
DELETE FROM T_CR_CODERULE WHERE fid = '1OPN7H4G8G/V';
INSERT INTO T_CR_CODERULE(fexample,fappmode,fisaddview,fisappcondition,fmasterid,fisunique,fruletype,fismodifiable,fcreatetime,fbizobjectid,fenable,fisupdaterecover,fisapporg,fisserialnumber,fdisablerid,fischeckcode,fid,fsplitsign,fctrlmode,fdisabledate,fislog,fstatus,fnumber,fexamplelength,fisfast,fmodifierid,fisnonbreak,fmodifytime,fcreatorid) VALUES (' ','2','1','0','1OPN7H4G8G/V','0',NULL,'0',{ts'2021-06-14  00:00:00'},'tsrbd_workaddr','1','0','0','0',NULL,'0','1OPN7H4G8G/V','-','1',NULL,'0','C','1OPN4GWO5WKT',' ','0',0,'0',{ts'2021-06-14  00:00:00'},0); 
DELETE FROM T_CR_CODERULE_L WHERE fpkid = '1OPN7H4G8E/2';
INSERT INTO T_CR_CODERULE_L(fid,fpkid,flocaleid,fname) VALUES ('1OPN7H4G8G/V','1OPN7H4G8E/2','zh_CN','工作地点'); 
DELETE FROM t_cr_coderuleentry WHERE fentryid = '1OPN7H5=W6RG';
INSERT INTO t_cr_coderuleentry(fid,finitial,fattributetype,fsplitsign,fissortitem,fentryid,fstep,fcutstyle,fattusingmode,fseq,flength,fisvisable,fformat,fsettingvalue,faddstyle,fvalueatribute,fissplitsign,faddchar) VALUES ('1OPN7H4G8G/V',1,'10',' ','0','1OPN7H5=W6RG',1,'1',' ',0,8,'1',' ',' ','1',' ','0',' '); 

DELETE FROM T_CR_CODERULE WHERE fid = '1QR+ATGYMGJ9';
INSERT INTO T_CR_CODERULE(fexample,fappmode,fisaddview,fisappcondition,fmasterid,fisunique,fruletype,fismodifiable,fcreatetime,fbizobjectid,fenable,fisupdaterecover,fisapporg,fisserialnumber,fdisablerid,fischeckcode,fid,fsplitsign,fctrlmode,fdisabledate,fislog,fstatus,fnumber,fexamplelength,fisfast,fmodifierid,fisnonbreak,fmodifytime,fcreatorid) VALUES (' ','2','1','0','1QR+ATGYMGJ9','0',NULL,'0',{ts'2021-07-07  00:00:00'},'tsrbd_cfgmail','1','0','0','1',NULL,'0','1QR+ATGYMGJ9','-','1',NULL,'0','C','1QR+6FSB4RO4',' ','0',0,'1',{ts'2021-07-07  00:00:00'},0); 
DELETE FROM T_CR_CODERULE_L WHERE fpkid = '1QR+ATH08XE0';
--INSERT INTO T_CR_CODERULE_L(fid,fpkid,flocaleid,fname) VALUES ('1QR+ATGYMGJ9','1QR+ATH08XE0','zh_TW','收取郵箱'); 
DELETE FROM T_CR_CODERULE_L WHERE fpkid = '1QR+ATH08XE1';
INSERT INTO T_CR_CODERULE_L(fid,fpkid,flocaleid,fname) VALUES ('1QR+ATGYMGJ9','1QR+ATH08XE1','zh_CN','收取邮箱'); 
DELETE FROM t_cr_coderuleentry WHERE fentryid = '1QR+ATJ200+1';
INSERT INTO t_cr_coderuleentry(fid,finitial,fattributetype,fsplitsign,fissortitem,fentryid,fstep,fcutstyle,fattusingmode,fseq,flength,fisvisable,fformat,fsettingvalue,faddstyle,fvalueatribute,fissplitsign,faddchar) VALUES ('1QR+ATGYMGJ9',1001,'16',' ','0','1QR+ATJ200+1',1,'1',' ',0,4,'1',' ',' ','1',' ','0',' '); 


 
/** 面试评价表 **/
DELETE FROM T_CR_CODERULE WHERE FID = '1MDQOVV5=4IH';
INSERT INTO T_CR_CODERULE(FEXAMPLE,FAPPMODE,FISADDVIEW,FISAPPCONDITION,FMASTERID,FISUNIQUE,FRULETYPE,FISMODIFIABLE,FCREATETIME,
FBIZOBJECTID,FENABLE,FISUPDATERECOVER,FISAPPORG,FISSERIALNUMBER,FDISABLERID,FISCHECKCODE,FID,FSPLITSIGN,FCTRLMODE,FDISABLEDATE,FISLOG,FSTATUS
,FNUMBER,FEXAMPLELENGTH,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID) VALUES (' ','2','1','0','1MDQOVV5=4IH','0',NULL,'0',
{ts'2021-04-14 16:53:34'},'tsrbd_intvevlqunr','1','0','0','1',NULL,'0','1MDQOVV5=4IH','-','1',NULL,'0','C','1MDQNGR+WW3S',' ',0,'0',{ts'2021-04-14 16:53:34'},0);


DELETE FROM T_CR_CODERULEENTRY WHERE FENTRYID = '1MDQOVVME7H1';
INSERT INTO T_CR_CODERULEENTRY(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1MDQOVV5=4IH',1,'1',' ','0','1MDQOVVME7H1',1,'1','1',0,8,'1','S',' ','1',' ','0',' '); 
DELETE FROM T_CR_CODERULEENTRY WHERE FENTRYID = '1MDQOVVME7H2';
INSERT INTO T_CR_CODERULEENTRY(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1MDQOVV5=4IH',6,'16',' ','0','1MDQOVVME7H2',1,'1',' ',1,4,'1',' ',' ','1',' ','0',' '); 

DELETE FROM T_CR_CODERULE_L WHERE FPKID = '1MDQOVV5=56R';
INSERT INTO T_CR_CODERULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('1MDQOVV5=4IH','1MDQOVV5=56R','zh_CN','面试评价表'); 

DELETE FROM T_PERM_PERMITEM WHERE FID = '1M0SJPZYPM94';
INSERT INTO T_PERM_PERMITEM (FID, FNUMBER, FINHERITMODE, FGROUP, FPREPERMITEMID, FDESCRIPTION, FBIZAPPID) VALUES ('1M0SJPZYPM94', 'TSRBS-SETDEFAULT', '10', '20', '47150e89000000ac', ' ', '15DWX09GISE8');
DELETE FROM T_PERM_PERMITEM_L WHERE FID = '1M0SJPZYPM94';
INSERT INTO T_PERM_PERMITEM_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('1MG4794LX6AP', '1M0SJPZYPM94', 'zh_CN', '设置默认');

/**招聘渠道tsrbd_recruchnlnm coderule preinsdata export**/
DELETE FROM T_CR_CODERULE WHERE FID = '1U=XJUEEHQEC';
INSERT INTO T_CR_CODERULE(FEXAMPLE,FAPPMODE,FISADDVIEW,FISAPPCONDITION,FMASTERID,FISUNIQUE,FRULETYPE,FISMODIFIABLE,FCREATETIME,FBIZOBJECTID,FENABLE,FISUPDATERECOVER,FISAPPORG,FISSERIALNUMBER,FDISABLERID,FISCHECKCODE,FID,FSPLITSIGN,FCTRLMODE,FDISABLEDATE,FISLOG,FSTATUS,FNUMBER,FEXAMPLELENGTH,FISFAST,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID) VALUES (' ','2','1','0','1U=XJUEEHQEC','0',NULL,'0',{ts'2021-08-16  00:00:00'},'tsrbd_recruchnlnm','1','0','0','1',NULL,'0','1U=XJUEEHQEC','-','1',NULL,'0','C','1U=XB+754ACN',' ','0',0,'0',{ts'2021-08-16  00:00:00'},1168029223173006336); 
DELETE FROM T_CR_CODERULE_L WHERE FPKID = '1U=XJUEEHR2M';
INSERT INTO T_CR_CODERULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('1U=XJUEEHQEC','1U=XJUEEHR2M','zh_CN','招聘渠道'); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1U=XJUFQ9J3J';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1U=XJUEEHQEC',2000,'16',' ','0','1U=XJUFQ9J3J',1,'1',' ',0,4,'1',' ',' ','1',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1U=XJUFQ9J3K';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1U=XJUEEHQEC',1,'1','_','0','1U=XJUFQ9J3K',1,'1','1',1,8,'1','S',' ','1',' ','1',' '); 
DELETE FROM t_cr_maxserial WHERE FID = '1U=XK9Z1POJD';
INSERT INTO t_cr_maxserial(FID,FINITSERIAL,FSEQSEGMENTENTRYID,FMAXSERIAL,FCREATETIME,FMODIFIERID,FCODERULEID,FMODIFYTIME,FSORTITEMVALUE,FCREATORID) VALUES ('1U=XK9Z1POJD',0,' ',0,{ts'2021-08-16  00:00:00'},0,'1U=XJUEEHQEC',{ts'2021-08-16  00:00:00'},' ',1168029223173006336); 

/**tsrbd_recruchnlnm_add coderule preinsdata export**/
DELETE FROM T_CR_CODERULE WHERE FID = '1V4C69X+IX/W';
INSERT INTO T_CR_CODERULE(FEXAMPLE,FAPPMODE,FISADDVIEW,FISAPPCONDITION,FMASTERID,FISUNIQUE,FRULETYPE,FISMODIFIABLE,FCREATETIME,FBIZOBJECTID,FENABLE,FISUPDATERECOVER,FISAPPORG,FISSERIALNUMBER,FDISABLERID,FISCHECKCODE,FID,FSPLITSIGN,FCTRLMODE,FDISABLEDATE,FISLOG,FSTATUS,FNUMBER,FEXAMPLELENGTH,FISFAST,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID) VALUES (' ','2','1','0','1V4C69X+IX/W','0',NULL,'0',{ts'2021-08-25  00:00:00'},'tsrbd_recruchnlnm_add','1','0','0','1',NULL,'0','1V4C69X+IX/W','-','1',NULL,'0','C','1V4BTLYKGFHP',' ','0',0,'0',{ts'2021-08-25  00:00:00'},1168029223173006336); 
DELETE FROM T_CR_CODERULE_L WHERE FPKID = '1V4C69X+HDFK';
INSERT INTO T_CR_CODERULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('1V4C69X+IX/W','1V4C69X+HDFK','zh_CN','新增招聘渠道'); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1V4C69YNTCH3';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1V4C69X+IX/W',2000,'16',' ','0','1V4C69YNTCH3',1,'1',' ',0,4,'1',' ',' ','1',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1V4C69YNTCH4';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1V4C69X+IX/W',1,'1','_','0','1V4C69YNTCH4',1,'1','1',1,8,'1','S',' ','1',' ','1',' '); 
DELETE FROM t_cr_maxserial WHERE FID = '1V4CRD8I1I12';
INSERT INTO t_cr_maxserial(FID,FINITSERIAL,FSEQSEGMENTENTRYID,FMAXSERIAL,FCREATETIME,FMODIFIERID,FCODERULEID,FMODIFYTIME,FSORTITEMVALUE,FCREATORID) VALUES ('1V4CRD8I1I12',0,' ',0,{ts'2021-08-25  00:00:00'},0,'1V4C69X+IX/W',{ts'2021-08-25  00:00:00'},' ',1168029223173006336); 

/**tsrbd_channelaccount coderule preinsdata export**/
DELETE FROM T_CR_CODERULE WHERE FID = '1UHFM5EJEVYQ';
INSERT INTO T_CR_CODERULE(FEXAMPLE,FAPPMODE,FISADDVIEW,FISAPPCONDITION,FMASTERID,FISUNIQUE,FRULETYPE,FISMODIFIABLE,FCREATETIME,FBIZOBJECTID,FENABLE,FISUPDATERECOVER,FISAPPORG,FISSERIALNUMBER,FDISABLERID,FISCHECKCODE,FID,FSPLITSIGN,FCTRLMODE,FDISABLEDATE,FISLOG,FSTATUS,FNUMBER,FEXAMPLELENGTH,FISFAST,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID) VALUES (' ','2','1','0','1UHFM5EJEVYQ','0',NULL,'0',{ts'2021-08-18  00:00:00'},'tsrbd_channelaccount','1','0','0','1',NULL,'0','1UHFM5EJEVYQ','-','1',NULL,'0','C','1UHFA0XL9TU5',' ','0',1168029223173006336,'0',{ts'2021-08-30  00:00:00'},1168029223173006336); 
DELETE FROM T_CR_CODERULE_L WHERE FPKID = '1UHFM5EJF1BJ';
INSERT INTO T_CR_CODERULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('1UHFM5EJEVYQ','1UHFM5EJF1BJ','zh_CN','渠道账号'); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1VJBOA8P7Q9P';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1UHFM5EJEVYQ',10000001,'16',' ','0','1VJBOA8P7Q9P',1,'1',' ',0,8,'1',' ',' ','1',' ','0',' '); 
DELETE FROM t_cr_maxserial WHERE FID = '1UHFMDF62AX0';
INSERT INTO t_cr_maxserial(FID,FINITSERIAL,FSEQSEGMENTENTRYID,FMAXSERIAL,FCREATETIME,FMODIFIERID,FCODERULEID,FMODIFYTIME,FSORTITEMVALUE,FCREATORID) VALUES ('1UHFMDF62AX0',0,' ',0,{ts'2021-08-18  00:00:00'},0,'1UHFM5EJEVYQ',{ts'2021-08-18  00:00:00'},' ',1168029223173006336); 

/**tsrbd_channelaccount_view coderule preinsdata export**/
DELETE FROM T_CR_CODERULE WHERE FID = '1V4QV0P85/RD';
INSERT INTO T_CR_CODERULE(FEXAMPLE,FAPPMODE,FISADDVIEW,FISAPPCONDITION,FMASTERID,FISUNIQUE,FRULETYPE,FISMODIFIABLE,FCREATETIME,FBIZOBJECTID,FENABLE,FISUPDATERECOVER,FISAPPORG,FISSERIALNUMBER,FDISABLERID,FISCHECKCODE,FID,FSPLITSIGN,FCTRLMODE,FDISABLEDATE,FISLOG,FSTATUS,FNUMBER,FEXAMPLELENGTH,FISFAST,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID) VALUES (' ','2','1','0','1V4QV0P85/RD','0',NULL,'0',{ts'2021-08-25  00:00:00'},'tsrbd_channelaccount_view','1','0','0','1',NULL,'0','1V4QV0P85/RD','-','1',NULL,'0','C','1V4QSZLSD1NW',' ','0',1168029223173006336,'0',{ts'2021-08-30  00:00:00'},1168029223173006336); 
DELETE FROM T_CR_CODERULE_L WHERE FPKID = '1V4QV0P86J/+';
INSERT INTO T_CR_CODERULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('1V4QV0P85/RD','1V4QV0P86J/+','zh_CN','渠道账号新增'); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1VJBPZ9249D/';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1V4QV0P85/RD',10000001,'16',' ','0','1VJBPZ9249D/',1,'1',' ',0,8,'1',' ',' ','1',' ','0',' '); 
DELETE FROM t_cr_maxserial WHERE FID = '1V4QV87RKA4Y';
INSERT INTO t_cr_maxserial(FID,FINITSERIAL,FSEQSEGMENTENTRYID,FMAXSERIAL,FCREATETIME,FMODIFIERID,FCODERULEID,FMODIFYTIME,FSORTITEMVALUE,FCREATORID) VALUES ('1V4QV87RKA4Y',0,' ',0,{ts'2021-08-25  00:00:00'},0,'1V4QV0P85/RD',{ts'2021-08-25  00:00:00'},' ',1168029223173006336); 
