ALTER TABLE t_outlineinfo ADD COLUMN REQ_TYPE INT(1) DEFAULT 0 ;
ALTER TABLE t_outlineinfo ADD COLUMN QUOTIETY DOUBLE(7,2) DEFAULT 1 ;
ALTER TABLE t_outlineinfo ADD COLUMN CASE_COUNT INT(7) DEFAULT 3 ;
ALTER TABLE t_outlineinfo ADD COLUMN SCRP_COUNT INT(7) DEFAULT 0 ;
ALTER TABLE t_outlineinfo ADD COLUMN SCENE_COUNT INT(7) DEFAULT 0 ;
ALTER TABLE T_TESTRESULT ADD COLUMN PLANT_FORM_ID INT(15) ;
ALTER TABLE T_OUTLINEINFO ADD COLUMN SEQ INT(8) ;
ALTER TABLE t_user MODIFY COLUMN PASSWORD VARCHAR(255);
ALTER TABLE t_function MODIFY COLUMN URL VARCHAR(300) ;
ALTER TABLE  t_exe_history MODIFY COLUMN TESTVER TINYINT(15) DEFAULT NULL;
ALTER TABLE t_exe_history MODIFY COLUMN RESULTID TINYINT(15) NOT NULL DEFAULT NULL AUTO_INCREMENT;
ALTER TABLE t_exe_history MODIFY COLUMN INSDATE DATETIME DEFAULT NULL,
 MODIFY COLUMN UPDDATE DATETIME DEFAULT NULL;

CREATE TABLE T_EXE_HISTORY (TASKID  VARCHAR(32) ,TEST_PHASE  TINYINT(1)  ,MODULEID   TINYINT(15)   NOT NULL ,TESTCASEID  TINYINT(15)   NOT NULL ,TESTVER   TINYINT(15)   NOT NULL ,TESTRESULT   TINYINT(1)    ,TESTACTOR   VARCHAR(32)   ,INSDATE DATE ,UPDDATE    DATE   ,RESULTID     TINYINT(15)      ,TESTCONFIGID   TINYINT(15) ,REMARK  VARCHAR(200) ,SEQ   TINYINT(3) ,PLANT_FORM_ID   TINYINT(15)  ,OPERA_TYPE   TINYINT(1)    )ENGINE=INNODB DEFAULT CHARSET=UTF8;
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('70','查看预估测试成本',70,'68',2,1,'','cost_prediction','0');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','70');
ALTER TABLE T_EXE_HISTORY ADD PRIMARY KEY T_EXE_HISTORY_PK (RESULTID);
update t_user t set t.my_home = '/bugManager/bugManagerAction!loadAllMyBug.action?dto.allTestTask=true' where t.my_home = '/project/projectAction!listProjects.action';
update  t_function t set t.url='/outLineManager/outLineAction!index.action' where t.url='/outLineManager/outLineAction!initList.action';
update  t_user t set t.rela_doc_user_id=10420 where loginname ='admin'; 
delete  FROM t_function  WHERE functionid in (121,122,123,124,126,127);
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('121','消息管理',121,'-1',1,0,'/msgManager/commonMsgAction!loadMsg.action','','0');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','121');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('122','消息维护',122,'121',2,0,'/msgManager/commonMsgAction!loadMsg.action','','0');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','122');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('123','发布',123,'122',3,1,'','commonMsgAction!publish;loadMsg','0');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','123');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('124','修改',124,'122',3,1,'','commonMsgAction!upinit;loadMsg','0');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','124');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('125','删除',125,'122',3,1,'','commonMsgAction!delBroMsg;loadMsg','0');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','125');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('126','接收消息',126,'121',2,0,'/msgManager/commonMsgAction!loadRecevMsg.action','','0');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','126');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('127','查看',127,'126',3,1,'','commonMsgAction!loadRecevMsg','0');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','127');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('128','发布消息',128,'121',2,0,'/msgManager/commonMsgAction!loadSendMsg.action','','0');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','128');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('129','查看',129,'128',3,1,'','commonMsgAction!loadSendMsg','0');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','129');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('140','发布',140,'128',3,1,'','commonMsgAction!sendBroMsg;loadSendMsg','0');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','140');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('141','修改',141,'128',3,1,'','commonMsgAction!sendMsgUpInit;loadSendMsg','0');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','141');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('142','删除',142,'128',3,1,'','commonMsgAction!sendBroMsgDel;loadSendMsg','0');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','142');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('143','分析度量',143,'-1',1,0,'/analysis/analysisAction!goAnalysisMain.action','','0');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','143');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('144','趋势分析',144,'143',2,0,'bl','','1');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','144');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('145','日编写用例趋势',145,'144',3,0,'/singleTestTask/singleTestTaskAction!swTestTask4Report.action?dto.repTemplet=writeCaseDayTrend_750_540_wrCaseDate','','1');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','145');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('146','查看',146,'145',4,1,'','writeCaseDayTrend','1');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','146');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('147','提交|打开|待处理|修改|关闭BUG趋势',147,'144',3,0,'/singleTestTask/singleTestTaskAction!swTestTask4Report.action?dto.repTemplet=reptFixCloseDayTrend_750_540_bugDate','','1');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','147');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('148','查看',148,'147',4,1,'','reptFixCloseDayTrend','1');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','148');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('149','开发人员日修改BUG趋势',149,'144',3,0,'/singleTestTask/singleTestTaskAction!swTestTask4Report.action?dto.repTemplet=devDayFixTrend_750_540_bugDate','','1');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','149');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('160','查看',160,'149',4,1,'','devDayFixTrend','1');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','160');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('161','日提交BUG趋势',161,'144',3,0,'/singleTestTask/singleTestTaskAction!swTestTask4Report.action?dto.repTemplet=testerDayCommitTrend_750_540_bugDate','','1');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','161');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('162','查看',162,'161',4,1,'','testerDayCommitTrend','1');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','162');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('163','日提交及BUG总数趋势',163,'144',3,0,'/singleTestTask/singleTestTaskAction!swTestTask4Report.action?dto.repTemplet=commitExistBugDayStat_750_540_bugDate','','1');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','163');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('164','查看',164,'163',4,1,'','commitExistBugDayStat','1');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','164');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('165','版本间提交及BUG总数趋势',165,'144',3,0,'/singleTestTask/singleTestTaskAction!swTestTask4Report.action?dto.repTemplet=commitExistBugBuildStat_750_540','','1');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','165');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('166','查看',166,'165',4,1,'','commitExistBugBuildStat','1');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','166');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('167','日执行用例趋势',167,'144',3,0,'/singleTestTask/singleTestTaskAction!swTestTask4Report.action?dto.repTemplet=testerExeCaseDayTrend_750_540_exeCaseDate','','1');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','167');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('168','查看',168,'167',4,1,'','testerExeCaseDayTrend','1');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','168');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('169','开发人员待改BUG统计',169,'143',2,0,'/singleTestTask/singleTestTaskAction!swTestTask4Report.action?dto.repTemplet=bugFixPersonStat_750_540','','1');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','169');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('180','查看',180,'169',3,1,'','bugFixPersonStat','1');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','180');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('181','测试人员提交BUG统计',181,'143',2,0,'/singleTestTask/singleTestTaskAction!swTestTask4Report.action?dto.repTemplet=testerBugStat_750_540','','1');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','181');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('182','查看',182,'181',3,1,'','testerBugStat','1');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','182');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('183','己关闭BUG按天龄期统计',183,'143',2,0,'/singleTestTask/singleTestTaskAction!swTestTask4Report.action?dto.repTemplet=bugExistDayStat_750_540','','1');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','183');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('184','查看',184,'183',3,1,'','bugExistDayStat','1');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','184');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('185','己关闭BUG按周龄期统计',185,'143',2,0,'/singleTestTask/singleTestTaskAction!swTestTask4Report.action?dto.repTemplet=bugExistWeekStat_750_540','','1');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','185');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('186','查看',186,'185',3,1,'','bugExistWeekStat','1');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','186');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('187','待处理BUG按天龄期统计',187,'143',2,0,'/singleTestTask/singleTestTaskAction!swTestTask4Report.action?dto.repTemplet=bugExistDay4NoFixStat_750_540','','1');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','187');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('188','查看',188,'187',3,1,'','bugExistDay4NoFixStat','1');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','188');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('189','待处理BUG按周龄期统计',189,'143',2,0,'/singleTestTask/singleTestTaskAction!swTestTask4Report.action?dto.repTemplet=bugExistWeek4NoFixStat_750_540','','1');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','189');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('200','查看',200,'189',3,1,'','bugExistWeek4NoFixStat','1');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','200');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('201','BUG类型统计',201,'143',2,0,'/singleTestTask/singleTestTaskAction!swTestTask4Report.action?dto.repTemplet=bugTypeStat_750_540','','1');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','201');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('202','查看',202,'201',3,1,'','bugTypeStat','1');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','202');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('203','BUG等级统计',203,'143',2,0,'/singleTestTask/singleTestTaskAction!swTestTask4Report.action?dto.repTemplet=bugGradeStat_750_540','','1');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','203');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('204','查看',204,'203',3,1,'','bugGradeStat','1');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','204');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('205','BUG引入阶段分析',205,'143',2,0,'/singleTestTask/singleTestTaskAction!swTestTask4Report.action?dto.repTemplet=bugImpPhaseStat_750_540','','1');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','205');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('206','查看',206,'205',3,1,'','bugImpPhaseStat','1');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','206');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('207','遗留BUG分析',207,'143',2,0,'/singleTestTask/singleTestTaskAction!swTestTask4Report.action?dto.repTemplet=bugBequeathStat_750_540','','1');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','207');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('208','查看',208,'207',3,1,'','bugBequeathStat','1');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','208');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('209','测试人员BUG质量分析',209,'143',2,0,'/singleTestTask/singleTestTaskAction!swTestTask4Report.action?dto.repTemplet=testerBugQuality_750_540','','1');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','209');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('220','查看',220,'209',3,1,'','testerBugQuality','1');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','220');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('221','BUG密度分析',221,'143',2,0,'/singleTestTask/singleTestTaskAction!swTestTask4Report.action?dto.repTemplet=bugDensityStat_750_540','','1');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','221');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('222','查看',222,'221',3,1,'','bugDensityStat','1');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','222');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('223','BUG模块分布统计',223,'143',2,0,'/singleTestTask/singleTestTaskAction!swTestTask4Report.action?dto.repTemplet=bugModuleDistbuStat_750_540','','1');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','223');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('224','查看',224,'223',3,1,'','bugModuleDistbuStat','1');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','224');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('225','BUG状态分布统计',225,'143',2,0,'/singleTestTask/singleTestTaskAction!swTestTask4Report.action?dto.repTemplet=bugStatusDistbuStat_750_540','','1');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','225');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('226','查看',226,'225',3,1,'','bugStatusDistbuStat','1');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','226');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('50','修改个人信息',50,'1',2,0,'/userManager/userManagerAction!setMyInfoInit.action,','','0');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','50');
insert into  T_FUNCTION(FUNCTIONID,FUNCTIONNAME,SEQ,PARENTID,LEVELNUM,ISLEAF,URL,SECURITY_URL,PAGE) values('51','允许修改',51,'50',3,1,'userManagerAction!setMyInfoInit,','','0');
insert into T_ROLE_FUNCTION_REAL(ROLEID,FUNCTIONID)  values('402880ea25b62b6a0125b66873290012','51');



FilterDispatcher
AnalysisBlh 

HibernateGenericController


ViewerServletContextListener

CommonMessageListener

ViewerFilter

SecurityFilter