/*增加证件类型，岗位到人员预置模板，其他调整顺序*/
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1817322906753738761;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678191414810548224,'1','1','number',763608724018302976,1817322906753738761,'idtype',13,'0',' ','name','证件类型');
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1817322906873016320;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678191414810548224,'1','1','number',763608724026718212,1817322906873016320,'post',25,'0',' ','name','岗位');

UPDATE T_BAS_IMPORTTEMPLATEENTRY SET FSEQ = 14, FFIELDNAME='证件号码' WHERE FID = 678191414810548224 AND FFIELDKEY ='idcard';
UPDATE T_BAS_IMPORTTEMPLATEENTRY SET FSEQ = 15 WHERE FID = 678191414810548224 AND FFIELDKEY ='birthday';
UPDATE T_BAS_IMPORTTEMPLATEENTRY SET FSEQ = 16 WHERE FID = 678191414810548224 AND FFIELDKEY ='gender';
UPDATE T_BAS_IMPORTTEMPLATEENTRY SET FSEQ = 17 WHERE FID = 678191414810548224 AND FFIELDKEY ='externaluuid';
UPDATE T_BAS_IMPORTTEMPLATEENTRY SET FSEQ = 18 WHERE FID = 678191414810548224 AND FFIELDKEY ='entryentity';
UPDATE T_BAS_IMPORTTEMPLATEENTRY SET FSEQ = 19 WHERE FID = 678191414810548224 AND FFIELDKEY ='entryentity.id';
UPDATE T_BAS_IMPORTTEMPLATEENTRY SET FSEQ = 20 WHERE FID = 678191414810548224 AND FFIELDKEY ='dpt';
UPDATE T_BAS_IMPORTTEMPLATEENTRY SET FSEQ = 21 WHERE FID = 678191414810548224 AND FFIELDKEY ='position';
UPDATE T_BAS_IMPORTTEMPLATEENTRY SET FSEQ = 22 WHERE FID = 678191414810548224 AND FFIELDKEY ='isincharge';
UPDATE T_BAS_IMPORTTEMPLATEENTRY SET FSEQ = 23 WHERE FID = 678191414810548224 AND FFIELDKEY ='ispartjob';
UPDATE T_BAS_IMPORTTEMPLATEENTRY SET FSEQ = 24 WHERE FID = 678191414810548224 AND FFIELDKEY ='superior';
UPDATE T_BAS_IMPORTTEMPLATEENTRY SET FSEQ = 26 WHERE FID = 678191414810548224 AND FFIELDKEY ='contactentity';
UPDATE T_BAS_IMPORTTEMPLATEENTRY SET FSEQ = 27 WHERE FID = 678191414810548224 AND FFIELDKEY ='contactentity.id';
UPDATE T_BAS_IMPORTTEMPLATEENTRY SET FSEQ = 28 WHERE FID = 678191414810548224 AND FFIELDKEY ='contact';
UPDATE T_BAS_IMPORTTEMPLATEENTRY SET FSEQ = 29 WHERE FID = 678191414810548224 AND FFIELDKEY ='contacttype';
UPDATE T_BAS_IMPORTTEMPLATEENTRY SET FSEQ = 30 WHERE FID = 678191414810548224 AND FFIELDKEY ='isdefault';
