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

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

DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FID = 678191414810548224;
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 763608724001552384;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678191414810548224,'0','0',' ',0,763608724001552384,'bos_user',1,'0',' ',' ','人员');
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 763608724018302976;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678191414810548224,'0','0',' ',763608724001552384,763608724018302976,'billhead',2,'0',' ',' ','单据头');
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 763608724018329600;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678191414810548224,'0','1',' ',763608724018302976,763608724018329600,'picturefield',3,'0',' ',' ','人员头像');
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 763608724018302977;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678191414810548224,'1','1',' ',763608724018302976,763608724018302977,'name',4,'1',' ',' ','姓名*');
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 763608724018329601;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678191414810548224,'0','1',' ',763608724018302976,763608724018329601,'simplepinyin',5,'0',' ',' ','姓名简拼');
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 763608724018302978;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678191414810548224,'0','1',' ',763608724018302976,763608724018302978,'fullpinyin',6,'0',' ',' ','姓名全拼');
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 763608724026718208;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678191414810548224,'0','1',' ',763608724018302976,763608724026718208,'username',7,'0',' ',' ','用户名');
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 763608724026691584;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678191414810548224,'1','1',' ',763608724018302976,763608724026691584,'usertype',8,'1',' ',' ','类型*');
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 763608724026718209;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678191414810548224,'1','1',' ',763608724018302976,763608724026718209,'number',9,'1',' ',' ','工号*');
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 763608724026691585;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678191414810548224,'1','1',' ',763608724018302976,763608724026691585,'phone',10,'0',' ',' ','手机');
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 763608724026718210;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678191414810548224,'1','1',' ',763608724018302976,763608724026718210,'email',11,'0',' ',' ','邮箱');
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 763608724026691586;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678191414810548224,'1','1',' ',763608724018302976,763608724026691586,'idcard',12,'0',' ',' ','身份证号');
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 763608724026718211;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678191414810548224,'1','1',' ',763608724018302976,763608724026718211,'birthday',13,'0',' ',' ','生日');
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 763608724026691587;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678191414810548224,'1','1',' ',763608724018302976,763608724026691587,'gender',14,'0',' ',' ','性别');
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 763608724026718212;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678191414810548224,'0','0',' ',763608724001552384,763608724026718212,'entryentity',15,'0',' ',' ','单据体');
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 763608724035080192;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678191414810548224,'1','1','number',763608724026718212,763608724035080192,'dpt',16,'1',' ','name','部门*');
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 763608724035106816;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678191414810548224,'1','1',' ',763608724026718212,763608724035106816,'position',17,'1',' ',' ','职位*');
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 763608724035080193;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678191414810548224,'1','1',' ',763608724026718212,763608724035080193,'isincharge',18,'0',' ',' ','负责人');
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 763608724035106817;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678191414810548224,'1','1',' ',763608724026718212,763608724035106817,'ispartjob',19,'0',' ',' ','兼职');
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 763608724035080194;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678191414810548224,'0','1','number',763608724026718212,763608724035080194,'superior',20,'0',' ','name','直接上级');
