数据业务管理系统维护手册

共29<V拟 日审 日批 日 ThisisthepropertyofGMCC&Wstream .andcanbeneitherreproducednordisclosedtoathirdpartywithoutawrittenauthorization. 文档目 文档范 读者对 术语与缩写解 系统用 安全...........................................................................................................................总体说 硬件设 软件环 操作系 数据库服务 应用程序服务 软件环境的配置与部 操作系统与数据库的安 应用服务器的安 启动停止服 配置数据 配置数据 发布程 数据库的与配 启动停止服 数据库创建与导入数 数据库备份、恢 本文档详细介绍本项目所需的运行环境的介绍包括系统的配置部署以及等信息…力，提高产品创新效率，为公司、部门、市公司对口单位提供信息共享的平台。性：通过和网络配置机制进行保障系统运行时须有完整的日志记录；应用软件必须提供完善的工具和故障恢复项目管理以每个进展中的项目作为被关注的对象，项目作为其项目主要的管理对项目进展过程中出现的紧急情况项目通过邮件等方式实时通知相项目的其他参与者可以对项目进行评论或加以批注，将信息及时反馈给和等进行工单处理情况实时反馈以便需求提出单位和人员了解开发需求的处理情知识管理包括项目相关文档的管理和一般资料的管理。系统支持对类别的管理功能对的管理功能及服务功能等其中类别管理包括类别的添加修改删除等功能；管理包括了的上传、检入检出、版本管理及，分别对应了的开放锁定归档状态服务主要包括对的浏览检索及查找功能支持对类别标题、创建日期等的查询及的关键字检索。还有产品、新产品和创新提案的管理。IBMX255GigaEthernet,HS2.2GHz/400MHz-2MBL3CacheUpgradewithXeonProcessorMP2*512MBPC1600ECCDDRSDRAMRDIMM（一共四组）146.8GB10KrpmUltra320SCSIHotswapHDD（一共六块）ServerRaid-6MController（128MBCache）RedHatLinuxAdvancedServer4Linux费使用和自由的类Unix操作系统，这个系统是由全世界各地的成千上万的程序员设计PCUnixUnixLinuxPostgreSQL。PostgreSQLPostgreSQLPostgreSQL，Tomcat5.0。TomcatSerlvetTomcat，直接使用RLES4安装光盘启动，依提示进行安装，在定制软件包时，把分区：swap/dev/sda4GB超级用户root SSHFTP主机名IPDefaultPrimarySecondary客户：2006年2月21日下午网络配置可以生JDK 一个Linuxtform的JDK，建议RPM自解压格式（RPMinself-extractingfile,j2sdk-1_4_2_06-linux-i586-rpm.bin上载到Linux服务器上，在s下执行命令：[root@LinuxServerrpm]#od755j2sdk-1_4_2_06-linux-i586-rpm.bin[root@LinuxServerrpm]#./j2sdk-1_4_2_06-linux-i586-rpm.binSunMicrosystems,Inc.BinaryCodeLicenseAgreementfortheJAVATM2SOFTWAREDEVELOPMENTKIT(J2SDK),STANDARDEDITION,VERSION1.4.2_X…Doyouagreetotheabovelicenseterms?[yesorno]yes00UnZipSFX5.40of28November1998,byInfo-ZIP(Zip-Bugs@).inflating:j2sdk-1_4_2_06-linux-i586.rpm[root@LinuxServerrpm]#rpm–ivhj2sdk-1_4_2_06-linux-i586.rpmPreparing...###########################################1:j2sdk###########################################exportexportCLASSPATH=.:$JAVA_HOME/lib/dt.jar:$JAVA_HOME/lib/tools.jarexportPATH=$PATH:$JAVA_HOME/bin（1）从#gunzipjakarta-tomcat-5.0.30.tar.gz#tar–xvfjakarta-tomcat-5.0.30.tar然后把它拷贝到你要安装的位置export启动服务：#/opt/tomcat5/bin/停止服务点击左菜单的”Resources–UserUserDatabases选择下拉框”CreateNewUser点击左菜单的”Resources–UserUserDatabases选择下拉框”CreateNewUser点击Administrator–TomcatManager,输入刚才配置的用户名和,确定后进入管理界“.war”注Tomcatwar”的文件发布,其他的”.jar”,”ear”$createdb$psql可以用下面令备份一个独立的数据库$pg_dumpdtmis>$catdtmis.pgdump|psqlCREATESEQUENCElog_seqSTARTWITH1INCREMENTBYMINVALUE1NOCYCLENOCREATETABLETEMTEDEPENDENCY(tem INTEGERNOT INTEGERNOT INTEGERNOT ADDPRIMARYKEY(temteId,predecessor,successor);CREATETABLE MENT( INTEGERNOT VARCHAR(40)NOTNULL, TIMESTAMPNOTNULL, INTEGERNOTNULL);ALTERTABLE ADDPRIMARYKEY(demandId,commentId);CREATETABLEDEMANDFILE( INTEGERNOTNULL, INTEGERNOTNULL);ADDPRIMARYKEY(demandId,ID)；CREATETABLEDEMAND( INTEGERNOT INTEGERNOTNULL, INTEGERNOT INTEGERNOT ADDPRIMARYKEYDROPTABLEDEMANDTYPE; INTEGERNOT ADDPRIMARYKEYinsertintodemandtype(demandTypeId,name,description)values(1,'流程优化','');insertintodemandtype(demandTypeId,name,description)values(2,'新增支撑','');insertintodemandtype(demandTypeId,name,description)values(3,'新功能','');insertintodemandtype(demandTypeId,name,description)values(4,'信息化 INTEGERNOTNULL, INTEGERNOT INTEGERNOT INTEGERNOTADDPRIMARYKEY(notifyId,DROPTABLEPRODUCT_SERVICES; INTEGERNOTADDPRIMARYKEY(productId,DROPTABLEPRODSERIES_PRODUCTION; INTEGERNOT ADDPRIMARYKEY(prodSeriesId,DROPTABLEPRODCATEGORY_PRODUCT; INTEGERNOTNULL, ADDPRIMARYKEY(prodCategoryId, INTEGERNOT INTEGERNOT ADDPRIMARYKEY INTEGERNOTNULL, INTEGERNOTADDPRIMARYKEY(Id,DROPTABLEVERSION; INTEGERNOT TIMESTAMPNOTNULL, BLOB(1000M)NOT INTEGERNOTNULL ADDPRIMARYKEY Id, INTEGERNOT INTEGERNOTNULL, INTEGERNOT INTEGERNOT TABLEADDPRIMARYKEY(DROPTABLESORT; INTEGERNOT ADDPRIMARYKEY(INSERTINTOSORT(SortId,name,description)VALUES(1,'项目管理文档','');INSERTINTO SortId,name,description)VALUES(2,'需求管理文档','');INSERTINTO SortId,name,description)VALUES(3,'产品管理文档','');INSERTINTO SortId,name,description)VALUES(4,'新产品管理文档','');INSERTINTO SortId,name,description)VALUES(5,'创新提案管理文档','');INSERTINTO SortId,name,description)VALUES(17,'技术类',INSERTINTO SortId,name,description)VALUES(18,'业务类',INSERTINTO SortIdname,description)VALUES(19,业务规范','');INSERTINTOSORT(SortId,name,description)VALUES(20,'产品类',INSERTINTOSORT(SortId,name,description)VALUES(21,'其他',DROPTABLEROLE_ORGANIZATION; INTEGERNOTNULL, INTEGERNOTNULL, ADDPRIMARYKEY(organizationId, INTEGERNOTADDPRIMARYKEY(userId,INSERTINTOrole_user(userId,roleId)DROPTABLEROLE_OPERATIONSET; INTEGERNOT BIGINTNOT INTEGERNOT ADDPRIMARYKEY(roleId,realmId, INTEGERNOT INTEGERNOT organizationIdLeadedADDPRIMARYKEYINSERTINTOrole(roleId,name,type,scope,descriptionVALUES(1,'管理员',0,null,'');INSERTINTOrole(roleId,name,type,scope,descriptionVALUES(2,'所有者',2,null,'');INSERTINTOrole(roleId,name,type,scope,descriptionVALUES(3,'任何人INSERTINTOrole(roleId,name,type,scope,description)VALUES(4,'需求审核人',0,null,'');INSERTINTOrole(roleId,name,type,scope,description)VALUES(5,'文档管理员',0,null,'');INSERTINTOrole(roleId,name,type,scope,description)VALUES(6,'公告管理员',0,null,'');INSERTINTOroleroleId,name,type,scope,descriptionVALUES(7,'公司同事',4,240,'在同一个INSERTINTOrole(roleId,name,type,scope,description)VALUES(8,'同事',4,15,'在同一个直接INSERTINTOroleroleId,name,type,scope,descriptionVALUES(9,'室同事',4,5,'在同一个室工INSERTINTOrole(roleId,name,type,scope,description)VALUES(10,'中心同事',4,1,'在同一个INSERTINTOrole(roleId,name,type,scope,description)VALUES(11,'公司经理',3,240,'');INSERTINTOrole(roleId,name,type,scope,description)VALUES(12,'室经理',3,5,'');INSERTINTOrole(roleId,name,type,scope,description)VALUES(13,'中心经理',3,1,'');INSERTINTOrole(roleId,name,type,scope,descriptionVALUES(14,'公司副经理',3,240,'');INSERTINTOrole(roleId,name,type,scope,description)VALUES(15,'室副经理',3,5,'');INSERTINTOrole(roleId,name,type,scope,description)VALUES(16,'中心副经理',3,1,'');DROPTABLEUSER_OPERATIONSET; INTEGERNOT BIGINTNOT INTEGERNOTADDPRIMARYKEY(userId,realmId, VARCHAR(400), VARCHAR(64), ADDPRIMARYKEYINSERTINTOuser(userId,name,password,organizationId)VALUES('admin','系统管理员 ', ' ','123456' ', ' ' ' ','123456' values(101,'xionghanjie' ', ' values(101,'tanlili','谭丽丽',' ','tanlili@ ' ','zhouhui@ ', ' ', ' values(101,'cailing','彩铃','','','cailing@ ','weiyuhang@ values(101,'liqiang','',' ','','liqiang@ ''','123456' ''','123456', ' ' ' ,officePhone,,password) 京 ','chaojing@ ','123456'); ,officePhone,,password) 权 ' values(102,'huying','',' ','huying@ ','123456'); ', ' ','123456' ,officePhone,,password)values(102,'luowen','平',' ','','luowen@ ','123456'); ,officePhone,,password)values(102,'zonghang','宗航',' ','','zonghang@ ','123456'); ,officePhone,,password) ', ' ','123456' ,officePhone,,password)values(103,'tanghua','',' ','tanghua@ ,officePhone,,password) ', ' ' 强 ' ' values(103,'lidan2','',' ','lidan2@ ','123456'); ,'张海洋','' ,'','zhanghaiyang@ insertintouser(organizationId,userId,name,,officePhone,,password)values(2,'xurui','',' ','xurui@gz. ','123456'); values(2,'jiangying5','','','','jiangying5@gz. ','123456'); values(2,'jianghuiyang2','','' ,'','jianghuiyang2@gz. ','niujianguo@gz. ','123456'); values(2,'licheng','',' ','licheng@gz. ', ' ' ' ','123456' values(201,'chenkun','',' ','','chenkun@gz. 付宝剑 ' ,officePhone,,password) ' ','lisheng@gz. values(201,'huangwenqian','','','','HuangWenQian@gz. values(201,'liuyihui','',' ','','liuyihui@gz. ', ' ','123456' ', ' ', ' ', ' ' ', ','' ', ' ' ', ' ','liguohua2@gz. ','123456'); ','tangweizhen@gz. ','123456'); ', ' ,officePhone,,password) ', ' ','123456' ,officePhone,,password) ' ','','zhangpeng1@gz. values(202,'liuli','刘瓅',' ','liuli@gz. values(202,'linqiang','林强',' ','','linqiang@gz. ,officePhone,,password) ','zhouwei1@gz. ,officePhone,,password) ','chendong@gz. ,officePhone,,password)values(202,'xianghong','向红','','','xianghong@gz. ','123456'); ,officePhone,,password)values(202,'jianghuiyang','','','','jianghuiyang@gz. values(202,'jiangying2','',' ','','jiangying2@gz. 肖冠', ' 杨龙珍', ','','yanglongzhen@gz. ', ','' ','linyanchang@gz. ','123456'); 白文英', ','baiwenying@gz. ','','longxiaoqiong@gz. ','zhonghuan@gz. ','123456'); ,officePhone,,password) ' ' ,officePhone,,password)values(203,'yewucehua','业务策划','','','yewucehua@gz. ','123456'); ,officePhone,,password)values(203,'lifang3','','','','lifang3@gz. ,officePhone,,password) ','zengqiqi@gz. ,officePhone,,password) ' ','tmpliqiang@gz. ,officePhone,,password) ' ' ','123456' ,officePhone,,password)values(204,'caijian','蔡键',' ','','caijian@gz. ,officePhone,,password) ' ' ','123456' ' ' ','linkaiyan@sz. ','123456'); ','ninglinlin@sz. 张炎', '','123456' ','hanmengkang@sz. ','123456'); ','masongmei@sz. ','123456'); values(302,'panqing','潘青','','','','123456');insertintouser(organizationId,userId,name,,officePhone,,password)傅力', ' ','123456' values(302,'sujun','苏军',' ',' ','sujun@sz. values(302,'lixing','',' ','lixing@sz. ','123456'); ' ','zhangqian2@sz. ', ','' ', ','huyan ' ', ' ' ', ' ' ', ' values(303,'mao ', ','mao ','123456' ', ' ' ' ' 蒙志海', ','mengzhihai@sz. ','yua@sz. ', ' ', ','zhouxiaole@dg. ' ' ,officePhone,,password) ', ','123456' ,officePhone,,password) 魏宇航', ','tmpweiyuhang@dg. ,officePhone,,password)values(402,'yuanyuan3','','','','yuanyuan3@dg. ','123456'); ,officePhone,,password) ', ','' ,officePhone,,password) 张', ','zhangjianmin@dg. ,officePhone,,password) ', ,officePhone,,password) ', ','chenzhaobo@dg.gd..om','123456' ', ','' ', ','' ','123456' ' ', ','' 岑华山', ','cenhuashan@dg. values(403,'liruan','利如安',' ','123456'); values(403,'yaoguodong','','','','yaoguodong@dg. 张海洋','','','tmpzhanghaiyang@dg. ', ,officePhone,,password) ','','tmpchenyingguang@dg. ,officePhone,,password) ', ','123456' ,officePhone,,password) ', ' values('','','','huqing',1,'','123456'); values('','','','guangzhou',2,'广州操作员','123456'); values('','','','shenzhen',3,'操作员','123456'); values('','','','dongguan',4,'东莞操作员','123456'); values('','','','foshan',5,'佛山操作员','123456'); values('','','','shantou',6,'汕头操作员','123456'); values('','','','shunde',7,'顺德操作员','123456'); values('','','','qingyuan',8,'清远操作员','123456'); values('','','','meizhou',9,'梅州操作员','123456'); user(,officePhone, values('','','','yangjiang',19,'操作员','123456'); DROPTABLEORGANIZATION; INTEGERNOTNULL, INTEGER, INTEGERNOTADDPRIMARYKEYinsertintoorganization(organizationId,superordinate,name,description,type)values(1,null,'省公司insertintoorganization(organizationId,superordinate,name,description,type)values(101,1,'开发室insertintoorganization(organizationId,superordinate,name,description,type)values(102,1,'合作室insertintoorganization(organizationId,superordinate,name,description,type)values(103,1,'业务室insertintoorganization(organizationId,superordinate,name,description,type)values(2,1,'广州公司insertintoorganization(organizationId,superordinate,name,description,type)values(201,2,'合作管insertintoorganization(organizationId,superordinate,name,description,type)values(202,2,'业务拓insertintoorganization(organizationId,superordinate,name,description,type)values(203,2,'业务运insertintoorganization(organizationId,superordinate,name,description,type)values(204,2,'移动信insertintoorganization(organizationId,superordinate,name,description,type)values(3,1,'公insertintoorganization(organizationId,superordinate,name,description,type)values(301,3,'合作管insertintoorganization(organizationId,superordinate,name,description,type)values(302,3,'业务拓insertintoorganization(organizationId,superordinate,name,description,type)values(303,3,'业务运insertintoorganization(organizationId,superordinate,name,description,type)values(304,3,'移动信insertintoorganization(organizationId,superordinate,name,description,type)values(4,1,'东莞公司insertintoorganization(organizationId,superordinate,name,description,type)values(401,4,'合作管insertintoorganization(organizationId,superordinate,name,description,type)values(402,4,'业务拓insertintoorganization(organizationId,superordinate,name,description,type)values(403,4,'业务运insertintoorganization(organizationId,superordinate,name,description,type)values(404,4,'移动信insertintoorganization(organizationId,superordinate,name,description,type)values(5,1,'insertintoorganization(organizationId,superordinate,name,description,type)values(6,1,'汕头公司insertintoorganization(organizationId,superordinate,name,description,type)values(7,1,'顺德公司insertintoorganization(organizationId,superordinate,name,description,type)values(8,1,'清远公司insertintoorganization(organizationId,superordinate,name,description,type)values(9,1,'梅州公司insertintoorganization(organizationId,superordinate,name,description,type)values(10,1,'肇庆公insertintoorganization(organizationId,superordinate,name,description,type)values(11,1,'潮州公insertintoorganization(organizationId,superordinate,name,description,type)values(12,1,'公insertintoorganization(organizationId,superordinate,name,description,type)values(13,1,'云浮公insertintoorganization(organizationId,superordinate,name,description,type)values(14,1,'公insertintoorganization(organizationId,superordinate,name,description,type)values(15,1,'江门公insertintoorganization(organizationId,superordinate,name,description,type)values(16,1,'中山公insertintoorganization(organizationId,superordinate,name,description,type)values(17,1,'湛江公insertintoorganization(organizationId,superordinate,name,description,type)values(18,1,'茂名公insertintoorganization(organizationId,superordinate,name,description,type)values(19,1,'公insertintoorganization(organizationId,superordinate,name,description,type)values(20,1,'惠州公insertintoorganization(organizationId,superordinate,name,description,type)values(21,1,'河源公insertintoorganization(organizationId,superordinate,name,description,type)values(22,1,'韶关公insertintoorganization(organizationId,superordinate,name,description,type)values(23,1,'揭阳公insertintoorganization(organizationId,superordinate,name,description,type)司insertintoorganization(organizationId,superordinate,name,description,type)values(25,1,'公 BIGINTNOT INTEGERNOTADDPRIMARYKEY(realmId,DROPTABLEREALM; INTEGERNOT ADDPRIMARYKEYinsertintorealm(realmId,name,description)values(1,'项目管理','项目相关应用及管理');insertintorealm(realmId,name,description)values(2,'需求管理','需求相关应用及管理');insertintorealm(realmId,name,description)values(3,'文档管理','文档相关应用及管理');insertintorealm(realmId,name,description)values(4,'产品管理','产品相关应用及管理');insertintorealm(realmId,name,description)values(5,'新产品管理','新产品相关应用及管理');insertintorealm(realmId,name,description)values(6,'创新提案','创新提案相关应用及管理');insertintorealm(realmId,name,description)values(7,'安全管理','系统权限分配及管理');insertintorealm(realmId,name,description)values(8,'日志管理','日志管理');insertintorealm(realmId,name,description)values(9,'辅助功能','系统辅助功能DROPTABLEACL_ACI; INTEGERNOT INTEGERNOTADDPRIMARYKEY(aclId, INTEGERNOT ADDPRIMARYKEY INTEGERNOT INTEGERNOTADDPRIMARYKEYDROPTABLEOPERATION; INTEGERNOT ADDPRIMARYKEYinsertintooperation(opcode,name)values(257,'添加项目');insertintooperation(opcode,name)values(258,'编辑项目');insertintooperation(opcode,name)values(259,'删除项目');insertintooperation(opcode,name)values(260,'查看项目insertintooperation(opcode,name)values(261,'查看项目详细信息');insertintooperation(opcode,name)values(262,'由项目建立模版');insertintooperation(opcode,name)values(265,'添加项目环节');insertintooperation(opcode,name)values(266,'编辑项目环节');insertintooperation(opcode,name)values(267,'删除项目环节');insertintooperation(opcode,name)values(268,'查看项目环节insertintooperation(opcode,name)values(269,'查看项目环节详细信息insertintooperation(opcode,name)values(272,'添加附加信息');insertintooperation(opcode,name)values(273,'编辑附加信息');insertintooperation(opcode,name)values(274,'删除附加信息insertintooperation(opcode,name)values(277,'添加项目文档');insertintooperation(opcode,name)values(278,'删除项目文档');insertintooperation(opcode,name)values(279,'项目文档insertintooperation(opcode,name)values(281,'添加分类');insertintooperation(opcode,name)values(282,'编辑分类');insertintooperation(opcode,name)values(283,'删除分类');insertintooperation(opcode,name)values(284,'查看分类insertintooperation(opcode,name)values(285,'查看分类详细信息insertintooperation(opcode,name)values(288,'添加模板');insertintooperation(opcode,name)values(289,'编辑模板');insertintooperation(opcode,name)values(290,'删除模板');insertintooperation(opcode,name)values(291,'查看模板insertintooperation(opcode,name)values(292,'查看模板详细信息');insertintooperation(opcode,name)values(293,'由模板建立项目');insertintooperation(opcode,name)values(296,'添加模板环节');insertintooperation(opcode,name)values(297,'编辑模板环节');insertintooperation(opcode,name)values(298,'删除模板环节');insertintooperation(opcode,name)values(299,'查看模板环节insertintooperation(opcode,name)values(300,'查看模板环节详细信息insertintooperation(opcode,name)values(513,'添加需求');insertintooperation(opcode,name)values(514,'编辑需求');insertintooperation(opcode,name)values(515,'删除需求');insertintooperation(opcode,name)values(516,'查询需求insertintooperation(opcode,name)values(519,'撤消需求insertintooperation(opcode,name)values(520,'确认需求');insertintooperation(opcode,name)values(521,'归档需求');insertintooperation(opcode,name)values(522,'审核需求');insertintooperation(opcode,name)values(523,'处理需求insertintooperation(opcode,name)values(526,'需求留言insertintooperation(opcode,name)values(530,'需求文档上传');insertintooperation(opcode,name)values(531,'删除需求文档');insertintooperation(opcode,name)values(532,'需求文档insertintooperation(opcode,name)values(534,'添加需求类型');insertintooperation(opcode,name)values(535,'编辑需求类型');insertintooperation(opcode,name)values(536,'删除需求类型');insertintooperation(opcode,name)values(537,'查看需求类型insertintooperation(opcode,name)values(769,'检入新文档');insertintooperation(opcode,name)values(770,'检入已有文档insertintooperation(opcode,name)values(771,'更新文档');insertintooperation(opcode,name)values(772,'删除文档insertintooperation(opcode,name)values(773,'更新文档版本');insertintooperation(opcode,name)values(774,'删除文档版本insertintooperation(opcode,name)values(775,'检出文档');insertintooperation(opcode,name)values(776,'取消文档检出insertintooperation(opcode,name)values(777,'发布文档');insertintooperation(opcode,name)values(778,'取消文档发布insertintooperation(opcode,name)values(779,'阅读文档');insertintooperation(opcode,name)values(780,'检索文档insertintooperation(opcode,name)values(793,'设置文档权限insertintooperation(opcode,name)values(1025,'添加产品');insertintooperation(opcode,name)values(1026,'编辑产品');insertintooperation(opcode,name)values(1027,'删除产品');insertintooperation(opcode,name)values(1028,'查看产品insertintooperation(opcode,name)values(1031,'添加产品分类insertintooperation(opcode,name)values(1032,'编辑产品分类');insertintooperation(opcode,name)values(1033,'删除产品分类');insertintooperation(opcode,name)values(1034,'查看产品分类insertintooperation(opcode,name)values(1037,'添加产品体系');insertintooperation(opcode,name)values(1038,'编辑产品体系');insertintooperation(opcode,name)values(1039,'删除产品体系');insertintooperation(opcode,name)values(1040,'查看产品体系insertintooperation(opcode,name)values(1043,'添加业务');insertintooperation(opcode,name)values(1044,'编辑业务');insertintooperation(opcode,name)values(1045,'删除业务');insertintooperation(opcode,name)values(1046,'查看业务insertintooperation(opcode,name)values(1049,'添加业务类别');insertintooperation(opcode,name)values(1050,'编辑业务类别');insertintooperation(opcode,name)values(1051,'删除业务类别');insertintooperation(opcode,name)values(1052,'查看业务类别insertintooperation(opcode,name)values(1055,'上传产品文档');insertintooperation(opcode,name)values(1056,'删除产品文档');insertintooperation(opcode,name)values(1057,'产品文档insertintooperation(opcode,name)values(1281,'添加新产品');insertintooperation(opcode,name)values(1282,'编辑新产品');insertintooperation(opcode,name)values(1283,'删除新产品');insertintooperation(opcode,name)values(1284,'查看新产品');insertintooperation(opcode,name)values(1285,'查询新产品insertintooperation(opcode,name)values(1288,'添加报告');insertintooperation(opcode,name)values(1289,'编辑报告');insertintooperation(opcode,name)values(1290,'删除报告');insertintooperation(opcode,name)values(1291,'查看报告');insertintooperation(opcode,name)values(1292,'查询报告insertintooperation(opcode,name)values(1293,'新产品汇报项汇总insertintooperation(opcode,name)values(1296,'填写新产品汇报项');insertintooperation(opcode,name)values(1297,'编辑新产品汇报项');insertintooperation(opcode,name)values(1298,'删除新产品汇报项insertintooperation(opcode,name)values(1537,'添加创新提案');insertintooperation(opcode,name)values(1538,'编辑创新提案');insertintooperation(opcode,name)values(1539,'删除创新提案insertintooperation(opcode,name)values(1540,'查看创新提案');insertintooperation(opcode,name)values(1541,'查询创新提案insertintooperation(opcode,name)values(1542,'创新提案汇总insertintooperation(opcode,name)values(1544,'添加评估意见');insertintooperation(opcode,name)values(1545,'编辑评估意见');insertintooperation(opcode,name)values(1546,'删除评估意见');insertintooperation(opcode,name)values(1547,'查看评估意见');insertintooperation(opcode,name)values(1548,'查询评估意见insertintooperation(opcode,name)values(1793,'添加用户');insertintooperation(opcode,name)values(1794,'编辑用户');insertintooperation(opcode,name)values(1795,'删除用户');insertintooperation(opcode,name)values(1796,'查看用户');insertintooperation(opcode,name)values(1797,'修改用户');insertintooperation(opcode,name)values(1799,'添加组织');insertintooperation(opcode,name)values(1800,'编辑组织');insertintooperation(opcode,name)values(1801,'删除组织');insertintooperation(opcode,name)values(1802,'组织管理insertintooperation(opcode,name)values(1805,'添加角色');insertintooperation(opcode,name)values(1806,'编辑角色');insertintooperation(opcode,name)values(1807,'删除角色');insertintooperation(opcode,name)values(1808,'设置角色成员');insertintooperation(opcode,name)values(1809,'查看角色');insertintooperation(opcode,name)values(1812,'添加控制');insertintooperation(opcode,name)values(1813,'删除控制');insertintooperation(opcode,name)values(1814,'设置控制');insertintooperation(opcode,name)values(1815,'设置默认权限insertintooperation(opcode,name)values(1820,'用户登录insertintooperation(opcode,name)values(1823,'增力委托');insertintooperation(opcode,name)values(1824,'编辑权力委托');insertintooperation(opcode,name)values(1825,'删除权力委托');insertintooperation(opcode,name)values(1826,'查看权力委托');insertintooperation(opcode,name)values(1827,'查询权力委托');insertintooperation(opcode,name)values(1828,'设置权力委托状态');insertintooperation(opcode,name)values(2049,'查询日志');insertintooperation(opcode,name)values(2050,'备份日志insertintooperation(opcode,name)values(2051,'清除日志');insertintooperation(opcode,name)values(2052,'备份/清除日志');insertintooperation(opcode,name)values(2305,'添加公告');insertintooperation(opcode,name)values(2306,'修改公告');insertintooperation(opcode,name)values(2307,'删除公告');insertintooperation(opcode,name)values(2308,'查看公告insertintooperation(opcode,name)values(2311,'发布公告');insertintooperation(opcode,name)values(2312,'取消公告发布');insertintooperation(opcode,name)values(2313,'归档公告');insertintooperation(opcode,name)values(2316,'添加通知');insertintooperation(opcode,name)values(2317,'删除通知');insertintooperation(opcode,name)values(2318,'查询通知insertintooperation(opcode,name)values(2319,'自动发送邮件');insertintooperation(opcode,name)values(2320,'自动DROPTABLETEMTEPHASE; INTEGERNOTNULL, tem INTEGERNOT INTEGERNOTADDPRIMARYKEY(temtePhaseId,temDROPTABLEASSISTANT; INTEGERNOT INTEGERNOT INTEGERNOT INTEGERNOT INTEGERNOTADDPRIMARYKEY(projectId,phaseId, INTEGERNOT INTEGERNOT INTEGERNOT INTEGERNOT INTEGERNOT ADDPRIMARYKEY(projectId,DROPTABLETEMTE;tem INTEGERNOT INTEGERNOT ADDPRIMARYKEY(temDROPTABLEPROJECT; INTEGERNOT INTEGERNOT INTEGERNOT INTEGERNOTNULL, INTEGERNOTNULL, INTEGERNOT ADDPRIMARYKEYDROPTABLEPROJECTCLASS;projectClaINTEGERNOT ADDPRIMARYKEY insertinto ,superiorId,className,creator,timestamp)业务','admin',currentinsertinto ,superiorId,className,creator,timestamp)业务','admin',currentinsertintoprojectclass(projectCla ,superiorId,className,creator,timestamp)values(11,1,'3G业务','admin',currenttimestamp); values(12,1,'EDGE业务','admin',currenttimestamp);insertintoprojectclass(projectCla,superiorId,className,creator,timestamp)values(13,2,'产品类','admin',currenttimestamp);insertintoprojectclass(projectCla,superiorId,className,creator,timestamp)values(14,2,'功能类','admin',currenttimestamp);insertintoprojectclass(projectCla,superiorId,className,creator,timestamp)策略','admin',currentinsertintoprojectclass(projectCla,superiorId,className,creator,timestamp)应用','admin',currentinsertinto