/**

   t_bas_importtemplate  t_bas_importtemplateentry
		用户角色关系引入模板
*/


DELETE FROM T_BAS_IMPORTTEMPLATE WHERE FID = 1018887444088493056;
INSERT INTO T_BAS_IMPORTTEMPLATE(FID,FENABLEIMPORT,FMASTERID,FSTATUS,FNAME,FNUMBER,FTEMPLATETYPE,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (1018887444088493056,'1',1018887444088493056,'C','用户角色关系引入模板','perm_userrole_IMPT_S','IMPT',{ts'2020-11-06  19:05:16'},13466739,'1',{ts'2020-11-06  19:07:29'},' ',13466739,'perm_userrole'); 

DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1018886336330863616;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (1018887444088493056,'0','0',' ',0,1018886336330863616,'perm_userrole','0',1,' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1018886336347657216;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (1018887444088493056,'0','0',' ',1018886336330863616,1018886336347657216,'billhead','0',2,' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1018886336347640832;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (1018887444088493056,'0','1',' ',1018886336347657216,1018886336347640832,'id','0',3,' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1018886336347657217;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (1018887444088493056,'1','1','number',1018886336347657216,1018886336347657217,'user','1',4,'name',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1018886336347640833;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (1018887444088493056,'1','1','number',1018886336347657216,1018886336347640833,'org','1',5,'name',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1018886336347657218;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (1018887444088493056,'1','1','number',1018886336347657216,1018886336347657218,'role','1',6,'name',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1018886336347640834;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (1018887444088493056,'1','1',' ',1018886336347657216,1018886336347640834,'includesuborg','1',7,' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1018886336347657219;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (1018887444088493056,'1','1',' ',1018886336347657216,1018886336347657219,'source','1',8,' ','请选择通用角色,业务角色请使用另一模板',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1018886336347640835;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (1018887444088493056,'0','1','number',1018886336347657216,1018886336347640835,'bizroleid','0',9,'name',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1018886336347657220;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (1018887444088493056,'1','1',' ',1018886336347657216,1018886336347657220,'dimtype','1',10,' ','请填入bos_org',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1018886336347640836;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (1018887444088493056,'1','1',' ',1018886336347657216,1018886336347640836,'starttime','0',11,' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1018886336347657221;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (1018887444088493056,'1','1',' ',1018886336347657216,1018886336347657221,'endtime','0',12,' ',' ',NULL); 


/**

   t_bas_importtemplate  t_bas_importtemplateentry
		用户角色关系引入模板-多类别基础资料
*/

DELETE FROM T_BAS_IMPORTTEMPLATE WHERE FID = 1033156624614693888;
INSERT INTO T_BAS_IMPORTTEMPLATE(FID,FENABLEIMPORT,FMASTERID,FSTATUS,FNAME,FNUMBER,FTEMPLATETYPE,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (1033156624614693888,'1',1033156624614693888,'C','用户角色关系-多类别引入模板','perm_userrole_multype_IMPT_S','IMPT',{ts'2020-11-27  11:24:10'},13466739,'1',{ts'2020-11-27  15:33:57'},' ',13466739,'perm_userrole_multype'); 

DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1033149778000616448;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (1033156624614693888,'0','0',' ',0,1033149778000616448,'perm_userrole_multype','0',1,' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1033149778017394688;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (1033156624614693888,'0','0',' ',1033149778000616448,1033149778017394688,'billhead','0',2,' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1033149778017393664;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (1033156624614693888,'0','1',' ',1033149778017394688,1033149778017393664,'id','0',3,' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1033149778017394689;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (1033156624614693888,'1','1','number',1033149778017394688,1033149778017394689,'user','1',4,'name',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1033149778017393665;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (1033156624614693888,'1','1',' ',1033149778017394688,1033149778017393665,'itemclasstypefield','1',5,' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1033149778017393666;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (1033156624614693888,'1','1','number',1033149778017394688,1033149778017393666,'role','1',7,'name',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1033149778017394691;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (1033156624614693888,'1','1',' ',1033149778017394688,1033149778017394691,'includesuborg','1',8,' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1033149778017393667;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (1033156624614693888,'1','1',' ',1033149778017394688,1033149778017393667,'source','1',9,' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1033149778017394692;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (1033156624614693888,'0','1','number',1033149778017394688,1033149778017394692,'bizroleid','0',10,'name',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1033149778017393668;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (1033156624614693888,'1','1',' ',1033149778017394688,1033149778017393668,'starttime','0',11,' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1033149778017394693;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (1033156624614693888,'1','1',' ',1033149778017394688,1033149778017394693,'endtime','0',12,' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1033261977041925125;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (1033156624614693888,'1','1','number',1033149778017394688,1033261977041925125,'itemclass','1',6,'name',' ',NULL); 



/**

   t_bas_importtemplate  t_bas_importtemplateentry
		用户业务角色关系引入模板
*/

DELETE FROM T_BAS_IMPORTTEMPLATE WHERE FID = 1016651197299308544;
INSERT INTO T_BAS_IMPORTTEMPLATE(FID,FNAME,FENABLEIMPORT,FMASTERID,FSTATUS,FNUMBER,FTEMPLATETYPE,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCREATORID,FBIZOBJECT,FCOMMENT) VALUES (1016651197299308544,'用户业务角色关系引入模板','1',1016651197299308544,'C','perm_userbizrole_IMPT_S','IMPT',{ts'2020-12-01  17:02:40'},13466739,'1',{ts'2020-12-01  17:11:08'},13466739,'perm_userbizrole',' '); 


DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1016650305934211072;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FPARENTENTRYID,FEXPORTPROP,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FIMPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (1016651197299308544,'0','0',0,' ',1016650305934211072,'perm_userbizrole','0',1,' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1016650305934212096;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FPARENTENTRYID,FEXPORTPROP,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FIMPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (1016651197299308544,'0','0',1016650305934211072,' ',1016650305934212096,'billhead','0',2,' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1016650305934211073;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FPARENTENTRYID,FEXPORTPROP,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FIMPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (1016651197299308544,'0','1',1016650305934212096,' ',1016650305934211073,'id','0',3,' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1016650305934212097;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FPARENTENTRYID,FEXPORTPROP,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FIMPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (1016651197299308544,'1','1',1016650305934212096,'name',1016650305934212097,'user','1',4,'number',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1016650305934211074;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FPARENTENTRYID,FEXPORTPROP,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FIMPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (1016651197299308544,'1','1',1016650305934212096,'name',1016650305934211074,'bizrole','1',5,'number',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1016650305934212098;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FPARENTENTRYID,FEXPORTPROP,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FIMPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (1016651197299308544,'1','1',1016650305934212096,' ',1016650305934212098,'starttime','0',6,' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1016650305934211075;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FPARENTENTRYID,FEXPORTPROP,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FIMPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (1016651197299308544,'1','1',1016650305934212096,' ',1016650305934211075,'endtime','0',7,' ',' ',NULL); 
