/* 组织引入模板 */
DELETE FROM T_BAS_IMPORTTEMPLATE WHERE FID = 678158543513261056;
INSERT INTO T_BAS_IMPORTTEMPLATE(FID,FSTATUS,FBIZOBJECT,FMODIFYTIME,FNAME,FENABLE,FCOMMENT,FNUMBER,FENABLEIMPORT,FCREATORID,FTEMPLATETYPE,FMASTERID,FMODIFIERID,FCREATETIME) VALUES (678158543513261056,'C','bos_adminorg_structure',{ts'2019-07-29  00:00:00'},' ','1',' ','bos_adminorg_structure_IMPT','1',1,'IMPT',678158543513261056,1,{ts'2019-07-29  00:00:00'}); 

DELETE FROM T_BAS_IMPORTTEMPLATE_l WHERE FID = 678158543513261056;
DELETE FROM T_BAS_IMPORTTEMPLATE_l WHERE FPKID = '03=++OVFMD87';
INSERT INTO T_BAS_IMPORTTEMPLATE_l(FPKID,FNAME,FCOMMENT,FLOCALEID,FID) VALUES ('03=++OVFMD87','行政组织','出厂预置模板','zh_CN',678158543513261056); 
DELETE FROM T_BAS_IMPORTTEMPLATE_l WHERE FPKID = '03=++OVFMD88';
INSERT INTO T_BAS_IMPORTTEMPLATE_l(FPKID,FNAME,FCOMMENT,FLOCALEID,FID) VALUES ('03=++OVFMD88','行政組織','出廠預置模板','zh_TW',678158543513261056); 

DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FID = 678158543513261056;
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 678661489996894208;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FFIELDKEY,FISIMPORT,FFIELDNAME,FENTRYID,FPARENTENTRYID,FDESCRIPTION,FISFIELD,FIMPORTPROP,FMUSTINPUT,FEXPORTPROP,FSEQ) VALUES (678158543513261056,'bos_adminorg_structure','1','行政组织结构',678661489996894208,0,'引入数据按照组织架构层级排序，上级组织在前','0',' ','0',' ',1); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 678661490105944064;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FFIELDKEY,FISIMPORT,FFIELDNAME,FENTRYID,FPARENTENTRYID,FDESCRIPTION,FISFIELD,FIMPORTPROP,FMUSTINPUT,FEXPORTPROP,FSEQ) VALUES (678158543513261056,'billhead','1','单据头',678661490105944064,678661489996894208,' ','0',' ','0',' ',2); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 678661490105944065;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FFIELDKEY,FISIMPORT,FFIELDNAME,FENTRYID,FPARENTENTRYID,FDESCRIPTION,FISFIELD,FIMPORTPROP,FMUSTINPUT,FEXPORTPROP,FSEQ) VALUES (678158543513261056,'fullname','1','长名称*',678661490105944065,678661490105944064,'包含本组织名称以及所有上级的名称，组织层级间用下横线"_"隔开：如，某某公司_某某事业部_某某部门','1',' ','1',' ',4); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 678661490105944066;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FFIELDKEY,FISIMPORT,FFIELDNAME,FENTRYID,FPARENTENTRYID,FDESCRIPTION,FISFIELD,FIMPORTPROP,FMUSTINPUT,FEXPORTPROP,FSEQ) VALUES (678158543513261056,'comment','1','描述',678661490105944066,678661490105944064,' ','1',' ','0',' ',6); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 678661490105946112;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FFIELDKEY,FISIMPORT,FFIELDNAME,FENTRYID,FPARENTENTRYID,FDESCRIPTION,FISFIELD,FIMPORTPROP,FMUSTINPUT,FEXPORTPROP,FSEQ) VALUES (678158543513261056,'org','1','组织',678661490105946112,678661490105944064,'填写组织的编码。为空时，根据编码规则自动填写','1','number','0','name',3); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 678661490105946113;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FFIELDKEY,FISIMPORT,FFIELDNAME,FENTRYID,FPARENTENTRYID,FDESCRIPTION,FISFIELD,FIMPORTPROP,FMUSTINPUT,FEXPORTPROP,FSEQ) VALUES (678158543513261056,'orgpattern','1','形态',678661490105946113,678661490105944064,'填写组织形态的编码，默认为“部门”的编码','1','number','0','name',5); 

/* 人员引入模板 */
DELETE FROM T_BAS_IMPORTTEMPLATE WHERE FID = 678191414810548224;
INSERT INTO T_BAS_IMPORTTEMPLATE(FID,FSTATUS,FBIZOBJECT,FMODIFYTIME,FNAME,FENABLE,FCOMMENT,FNUMBER,FENABLEIMPORT,FCREATORID,FTEMPLATETYPE,FMASTERID,FMODIFIERID,FCREATETIME) VALUES (678191414810548224,'C','bos_user',{ts'2019-07-29  00:00:00'},' ','1',' ','bos_user_IMPT','1',1,'IMPT',678191414810548224,1,{ts'2019-07-29  00:00:00'}); 

DELETE FROM T_BAS_IMPORTTEMPLATE_l WHERE FID = 678191414810548224;
DELETE FROM T_BAS_IMPORTTEMPLATE_l WHERE FPKID = '03=447ME6JKE';
INSERT INTO T_BAS_IMPORTTEMPLATE_l(FPKID,FNAME,FCOMMENT,FLOCALEID,FID) VALUES ('03=447ME6JKE','人员','出厂预置模板','zh_CN',678191414810548224); 
DELETE FROM T_BAS_IMPORTTEMPLATE_l WHERE FPKID = '03=447ME6JKF';
INSERT INTO T_BAS_IMPORTTEMPLATE_l(FPKID,FNAME,FCOMMENT,FLOCALEID,FID) VALUES ('03=447ME6JKF','人員','出廠預置模板','zh_TW',678191414810548224); 

DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FID = 678191414810548224;
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 678667457459685376;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FFIELDKEY,FISIMPORT,FFIELDNAME,FENTRYID,FPARENTENTRYID,FDESCRIPTION,FISFIELD,FIMPORTPROP,FMUSTINPUT,FEXPORTPROP,FSEQ) VALUES (678191414810548224,'ispartjob','0','兼职',678667457459685376,0,' ','1',' ','0',' ',7); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 678667457484851200;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FFIELDKEY,FISIMPORT,FFIELDNAME,FENTRYID,FPARENTENTRYID,FDESCRIPTION,FISFIELD,FIMPORTPROP,FMUSTINPUT,FEXPORTPROP,FSEQ) VALUES (678191414810548224,'picturefield','0','人员头像',678667457484851200,678667457484853248,' ','1',' ','0',' ',9); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 678667457484851201;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FFIELDKEY,FISIMPORT,FFIELDNAME,FENTRYID,FPARENTENTRYID,FDESCRIPTION,FISFIELD,FIMPORTPROP,FMUSTINPUT,FEXPORTPROP,FSEQ) VALUES (678191414810548224,'simplepinyin','0','姓名简拼',678667457484851201,678667457484853248,' ','1',' ','0',' ',11); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 678667457484851202;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FFIELDKEY,FISIMPORT,FFIELDNAME,FENTRYID,FPARENTENTRYID,FDESCRIPTION,FISFIELD,FIMPORTPROP,FMUSTINPUT,FEXPORTPROP,FSEQ) VALUES (678191414810548224,'username','1','用户名',678667457484851202,678667457484853248,' ','1',' ','0',' ',13); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 678667457484851203;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FFIELDKEY,FISIMPORT,FFIELDNAME,FENTRYID,FPARENTENTRYID,FDESCRIPTION,FISFIELD,FIMPORTPROP,FMUSTINPUT,FEXPORTPROP,FSEQ) VALUES (678191414810548224,'number','1','工号*',678667457484851203,678667457484853248,' ','1',' ','1',' ',15); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 678667457484851204;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FFIELDKEY,FISIMPORT,FFIELDNAME,FENTRYID,FPARENTENTRYID,FDESCRIPTION,FISFIELD,FIMPORTPROP,FMUSTINPUT,FEXPORTPROP,FSEQ) VALUES (678191414810548224,'email','1','邮箱',678667457484851204,678667457484853248,' ','1',' ','0',' ',17); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 678667457484851205;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FFIELDKEY,FISIMPORT,FFIELDNAME,FENTRYID,FPARENTENTRYID,FDESCRIPTION,FISFIELD,FIMPORTPROP,FMUSTINPUT,FEXPORTPROP,FSEQ) VALUES (678191414810548224,'birthday','1','生日',678667457484851205,678667457484853248,' ','1',' ','0',' ',19); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 678667457484853248;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FFIELDKEY,FISIMPORT,FFIELDNAME,FENTRYID,FPARENTENTRYID,FDESCRIPTION,FISFIELD,FIMPORTPROP,FMUSTINPUT,FEXPORTPROP,FSEQ) VALUES (678191414810548224,'superior','0','直接上级',678667457484853248,678667457459685376,' ','1','number','0','name',8); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 678667457484853249;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FFIELDKEY,FISIMPORT,FFIELDNAME,FENTRYID,FPARENTENTRYID,FDESCRIPTION,FISFIELD,FIMPORTPROP,FMUSTINPUT,FEXPORTPROP,FSEQ) VALUES (678191414810548224,'name','1','姓名*',678667457484853249,678667457484853248,' ','1',' ','1',' ',10); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 678667457484853250;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FFIELDKEY,FISIMPORT,FFIELDNAME,FENTRYID,FPARENTENTRYID,FDESCRIPTION,FISFIELD,FIMPORTPROP,FMUSTINPUT,FEXPORTPROP,FSEQ) VALUES (678191414810548224,'fullpinyin','0','姓名全拼',678667457484853250,678667457484853248,' ','1',' ','0',' ',12); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 678667457484853251;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FFIELDKEY,FISIMPORT,FFIELDNAME,FENTRYID,FPARENTENTRYID,FDESCRIPTION,FISFIELD,FIMPORTPROP,FMUSTINPUT,FEXPORTPROP,FSEQ) VALUES (678191414810548224,'usertype','1','类型*',678667457484853251,678667457484853248,'固定为职员类型，请填写“1”','1',' ','1',' ',14); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 678667457484853252;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FFIELDKEY,FISIMPORT,FFIELDNAME,FENTRYID,FPARENTENTRYID,FDESCRIPTION,FISFIELD,FIMPORTPROP,FMUSTINPUT,FEXPORTPROP,FSEQ) VALUES (678191414810548224,'phone','1','手机',678667457484853252,678667457484853248,'手机和邮箱必须选择其中一项录入','1',' ','0',' ',16); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 678667457484853253;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FFIELDKEY,FISIMPORT,FFIELDNAME,FENTRYID,FPARENTENTRYID,FDESCRIPTION,FISFIELD,FIMPORTPROP,FMUSTINPUT,FEXPORTPROP,FSEQ) VALUES (678191414810548224,'idcard','1','身份证号',678667457484853253,678667457484853248,' ','1',' ','0',' ',18); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 678667457484853254;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FFIELDKEY,FISIMPORT,FFIELDNAME,FENTRYID,FPARENTENTRYID,FDESCRIPTION,FISFIELD,FIMPORTPROP,FMUSTINPUT,FEXPORTPROP,FSEQ) VALUES (678191414810548224,'gender','1','性别',678667457484853254,678667457484853248,' ','1',' ','0',' ',20); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 678667457493239808;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FFIELDKEY,FISIMPORT,FFIELDNAME,FENTRYID,FPARENTENTRYID,FDESCRIPTION,FISFIELD,FIMPORTPROP,FMUSTINPUT,FEXPORTPROP,FSEQ) VALUES (678191414810548224,'isincharge','0','负责人',678667457493239808,678667457459685376,' ','1',' ','0',' ',6); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 678667457493239809;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FFIELDKEY,FISIMPORT,FFIELDNAME,FENTRYID,FPARENTENTRYID,FDESCRIPTION,FISFIELD,FIMPORTPROP,FMUSTINPUT,FEXPORTPROP,FSEQ) VALUES (678191414810548224,'dpt','1','部门*',678667457493239809,678667457484853248,'职位分录不为空时，必录','1','number','1','name',4); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 678667457493239810;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FFIELDKEY,FISIMPORT,FFIELDNAME,FENTRYID,FPARENTENTRYID,FDESCRIPTION,FISFIELD,FIMPORTPROP,FMUSTINPUT,FEXPORTPROP,FSEQ) VALUES (678191414810548224,' ','0',' ',678667457493239810,678667457484853248,' ','0',' ','0',' ',2); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 678667457493241856;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FFIELDKEY,FISIMPORT,FFIELDNAME,FENTRYID,FPARENTENTRYID,FDESCRIPTION,FISFIELD,FIMPORTPROP,FMUSTINPUT,FEXPORTPROP,FSEQ) VALUES (678191414810548224,'position','1','职位*',678667457493241856,678667457484853248,'职位分录不为空时，必录','1',' ','1',' ',5); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 678667457493241857;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FFIELDKEY,FISIMPORT,FFIELDNAME,FENTRYID,FPARENTENTRYID,FDESCRIPTION,FISFIELD,FIMPORTPROP,FMUSTINPUT,FEXPORTPROP,FSEQ) VALUES (678191414810548224,'entryentity','0','单据体',678667457493241857,678667457484853248,' ','0',' ','0',' ',3); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 678667457493241858;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FFIELDKEY,FISIMPORT,FFIELDNAME,FENTRYID,FPARENTENTRYID,FDESCRIPTION,FISFIELD,FIMPORTPROP,FMUSTINPUT,FEXPORTPROP,FSEQ) VALUES (678191414810548224,' ','0',' ',678667457493241858,678667457484853248,' ','0',' ','0',' ',1); 
