menu_2006-12-15.sql

1、激活企业硬件投资

DROP TABLE IF EXISTS SYS_MENU;CREATE TABLE `SYS_MENU` ( `MENU_ID` VARCHAR(10) NOT NULL DEFAULT \'0\', `MENU_NAME` VARCHAR(100) NOT NULL DEFAULT \'\', `IMAGE` VARCHAR(100) NOT NULL DEFAULT \'\', PRIMARY KEY (`MENU_ID`)) TYPE=MYISAM;INSERT INTO SYS_MENU VALUES(\'01\',\'我的办公桌\',\'mytable\');INSERT INTO SYS_MENU VALUES(\'09\',\'信息交流\',\'comm\');INSERT INTO SYS_MENU VALUES(\'05\',\'公共事务\',\'erp\');INSERT INTO SYS_MENU VALUES(\'13\',\'销售管理\',\'sale_manage\');INSERT INTO SYS_MENU VALUES(\'20\',\'系统管理\',\'sys\');INSERT INTO SYS_MENU VALUES(\'30\',\'附件程序\',\'info_query\');INSERT INTO SYS_MENU VALUES(\'10\',\'人力资源\',\'hrms\');INSERT INTO SYS_MENU VALUES(\'03\',\'工作流\',\'workflow\');DROP TABLE IF EXISTS SYS_FUNCTION;CREATE TABLE `SYS_FUNCTION` ( `FUNC_ID` INT(11) NOT NULL DEFAULT \'0\', `MENU_ID` VARCHAR(10) NOT NULL DEFAULT \'0\', `FUNC_NAME` VARCHAR(100) NOT NULL DEFAULT \'\', `FUNC_CODE` TEXT NOT NULL, PRIMARY KEY (`FUNC_ID`)) TYPE=MYISAM;INSERT INTO SYS_FUNCTION VALUES(\'1\',\'010401\',\'内部邮件\',\'email\');INSERT INTO SYS_FUNCTION VALUES(\'2\',\'010402\',\'Internet 邮件\',\'webmail\');INSERT INTO SYS_FUNCTION VALUES(\'3\',\'010802\',\'内部短信\',\'sms\');INSERT INTO SYS_FUNCTION VALUES(\'4\',\'0116\',\'公告通知\',\'notify/show\');INSERT INTO SYS_FUNCTION VALUES(\'62\',\'090402\',\'内部讨论区\',\'bbs\');INSERT INTO SYS_FUNCTION VALUES(\'7\',\'0120\',\'个人考勤\',\'attendance/personal\');INSERT INTO SYS_FUNCTION VALUES(\'8\',\'0124\',\'日程安排\',\'calendar\');INSERT INTO SYS_FUNCTION VALUES(\'9\',\'0128\',\'工作日志\',\'diary\');INSERT INTO SYS_FUNCTION VALUES(\'10\',\'0132\',\'通讯簿\',\'address/private\');INSERT INTO SYS_FUNCTION VALUES(\'11\',\'0140\',\'控制面板\',\'person_info\');INSERT INTO SYS_FUNCTION VALUES(\'12\',\'0904\',\'讨论区\',\'@bbs\');INSERT INTO SYS_FUNCTION VALUES(\'13\',\'0908\',\'网络会议\',\'@netmeeting\');INSERT INTO SYS_FUNCTION VALUES(\'14\',\'0912\',\'聊天室\',\'@chatroom\');INSERT INTO SYS_FUNCTION VALUES(\'15\',\'0916\',\'公共文件柜\',\'file_folder/index1.php\');INSERT INTO SYS_FUNCTION VALUES(\'16\',\'0136\',\'个人文件柜\',\'file_folder/index2.php\');INSERT INTO SYS_FUNCTION VALUES(\'17\',\'056002\',\'单位信息查询\',\'info/unit\');INSERT INTO SYS_FUNCTION VALUES(\'18\',\'056004\',\'部门信息查询\',\'info/dept\');INSERT INTO SYS_FUNCTION VALUES(\'19\',\'056006\',\'用户信息查询\',\'info/user\');INSERT INTO SYS_FUNCTION VALUES(\'20\',\'300408\',\'列车时刻查询\',\'info/train\');INSERT INTO SYS_FUNCTION VALUES(\'21\',\'300402\',\'电话区号查询\',\'info/tel_no\');INSERT INTO SYS_FUNCTION VALUES(\'22\',\'300404\',\'邮政编码查询\',\'info/post_no\');INSERT INTO SYS_FUNCTION VALUES(\'23\',\'300412\',\'法律法规查询\',\'info/law\');INSERT INTO SYS_FUNCTION VALUES(\'24\',\'0512\',\'公告通知管理\',\'notify/manage\');INSERT INTO SYS_FUNCTION VALUES(\'25\',\'090801\',\'文本网络会议管理\',\'netmeeting/manage\');INSERT INTO SYS_FUNCTION VALUES(\'26\',\'1020\',\'考勤管理\',\'attendance/manage\');INSERT INTO SYS_FUNCTION VALUES(\'27\',\'1010\',\'人事档案\',\'@hrms\');INSERT INTO SYS_FUNCTION VALUES(\'28\',\'103004\',\'财务工资录入\',\'salary/submit\');INSERT INTO SYS_FUNCTION VALUES(\'29\',\'103002\',\'工资流程管理\',\'salary/manage\');INSERT INTO SYS_FUNCTION VALUES(\'30\',\'200402\',\'单位管理\',\'system/unit\');INSERT INTO SYS_FUNCTION VALUES(\'31\',\'200406\',\'部门管理\',\'system/dept\');INSERT INTO SYS_FUNCTION VALUES(\'32\',\'200410\',\'角色与权限管理\',\'system/user_priv\');INSERT INTO SYS_FUNCTION VALUES(\'33\',\'200408\',\'用户管理\',\'system/user\');INSERT INTO SYS_FUNCTION VALUES(\'34\',\'201202\',\'内部讨论区设置\',\'system/bbs\');INSERT INTO SYS_FUNCTION VALUES(\'35\',\'201204\',\'文本聊天室设置\',\'system/chatroom\');INSERT INTO SYS_FUNCTION VALUES(\'36\',\'201206\',\'公共文件柜设置\',\'system/file_folder\');INSERT INTO SYS_FUNCTION VALUES(\'37\',\'200610\',\'设计表单\',\'system/workflow/flow_form\');INSERT INTO SYS_FUNCTION VALUES(\'38\',\'2040\',\'系统信息\',\'system/reg_view\');INSERT INTO SYS_FUNCTION VALUES(\'39\',\'200804\',\'考勤设置\',\'system/attendance\');INSERT INTO SYS_FUNCTION VALUES(\'40\',\'0104\',\'电子邮件\',\'@mail\');INSERT INTO SYS_FUNCTION VALUES(\'41\',\'0108\',\'短信息\',\'@sms\');INSERT INTO SYS_FUNCTION VALUES(\'42\',\'010804\',\'手机短信\',\'mobile_sms\');INSERT INTO SYS_FUNCTION VALUES(\'43\',\'0560\',\'组织机构信息\',\'@unit\');INSERT INTO SYS_FUNCTION VALUES(\'44\',\'1310\',\'客户关系\',\'@crm\');INSERT INTO SYS_FUNCTION VALUES(\'45\',\'3020\',\'游戏\',\'game\');INSERT INTO SYS_FUNCTION VALUES(\'46\',\'3004\',\'实用信息\',\'@infofind\');INSERT INTO SYS_FUNCTION VALUES(\'47\',\'090804\',\'互动会议\',\'netchat\');INSERT INTO SYS_FUNCTION VALUES(\'48\',\'090802\',\'文本网络会议\',\'netmeeting\');INSERT INTO SYS_FUNCTION VALUES(\'49\',\'091202\',\'文本聊天室\',\'chatroom\');INSERT INTO SYS_FUNCTION VALUES(\'50\',\'091204\',\'语音聊天室\',\'vchat\');INSERT INTO SYS_FUNCTION VALUES(\'51\',\'0536\',\'图书管理\',\'@book\');INSERT INTO SYS_FUNCTION VALUES(\'52\',\'053602\',\'图书类别定义\',\'book/type\');INSERT INTO SYS_FUNCTION VALUES(\'53\',\'053604\',\'图书信息录入管理\',\'book/manage\');INSERT INTO SYS_FUNCTION VALUES(\'54\',\'053606\',\'图书查询\',\'book/query\');INSERT INTO SYS_FUNCTION VALUES(\'55\',\'1030\',\'劳资管理\',\'@salary\');INSERT INTO SYS_FUNCTION VALUES(\'56\',\'2004\',\'组织机构设置\',\'@system\');INSERT INTO SYS_FUNCTION VALUES(\'57\',\'2008\',\'公共事务设置\',\'@system\');INSERT INTO SYS_FUNCTION VALUES(\'58\',\'2012\',\'交流设置\',\'@system\');INSERT INTO SYS_FUNCTION VALUES(\'5\',\'0320\',\'待办工作\',\'workflow/list\');INSERT INTO SYS_FUNCTION VALUES(\'60\',\'101002\',\'人事档案管理\',\'hrms/manage\');INSERT INTO SYS_FUNCTION VALUES(\'61\',\'101004\',\'人事档案查询\',\'hrms/query\');INSERT INTO SYS_FUNCTION VALUES(\'63\',\'090404\',\'超级论坛\',\'bbs2\');INSERT INTO SYS_FUNCTION VALUES(\'64\',\'131002\',\'客户基本信息管理\',\'sale_manage/crm/customer\');INSERT INTO SYS_FUNCTION VALUES(\'65\',\'131004\',\'联系人信息管理\',\'sale_manage/crm/linkman\');INSERT INTO SYS_FUNCTION VALUES(\'66\',\'131006\',\'客户服务管理\',\'sale_manage/crm/contact\');INSERT INTO SYS_FUNCTION VALUES(\'67\',\'1320\',\'销售管理\',\'@sale\');INSERT INTO SYS_FUNCTION VALUES(\'68\',\'132002\',\'产品信息管理\',\'sale_manage/sale/product\');INSERT INTO SYS_FUNCTION VALUES(\'69\',\'132004\',\'销售记录管理\',\'sale_manage/sale/sale_history\');INSERT INTO SYS_FUNCTION VALUES(\'70\',\'131008\',\'综合查询\',\'sale_manage/crm/query\');INSERT INTO SYS_FUNCTION VALUES(\'71\',\'132003\',\'销售合同管理\',\'sale_manage/sale/contract\');INSERT INTO SYS_FUNCTION VALUES(\'72\',\'1330\',\'供应商\',\'@provider\');INSERT INTO SYS_FUNCTION VALUES(\'73\',\'133002\',\'供应商信息管理\',\'sale_manage/supply/provider\');INSERT INTO SYS_FUNCTION VALUES(\'74\',\'133004\',\'供应联系人管理\',\'sale_manage/supply/linkman\');INSERT INTO SYS_FUNCTION VALUES(\'76\',\'0920\',\'网络硬盘\',\'netdisk\');INSERT INTO SYS_FUNCTION VALUES(\'77\',\'201208\',\'网络硬盘设置\',\'system/netdisk\');INSERT INTO SYS_FUNCTION VALUES(\'78\',\'2020\',\'界面设置\',\'system/interface\');INSERT INTO SYS_FUNCTION VALUES(\'79\',\'300410\',\'公交线路查询\',\'info/bus\');INSERT INTO SYS_FUNCTION VALUES(\'80\',\'0516\',\'日程安排查询\',\'calendar/info\');INSERT INTO SYS_FUNCTION VALUES(\'81\',\'0518\',\'工作日志查询\',\'diary/info\');INSERT INTO SYS_FUNCTION VALUES(\'82\',\'3024\',\'万年历\',\'calendar2\');INSERT INTO SYS_FUNCTION VALUES(\'83\',\'3028\',\'世界时间\',\'world_time\');INSERT INTO SYS_FUNCTION VALUES(\'84\',\'2024\',\'数据库管理\',\'system/database\');INSERT INTO SYS_FUNCTION VALUES(\'85\',\'0550\',\'会议申请与安排\',\'@meeting\');INSERT INTO SYS_FUNCTION VALUES(\'86\',\'055001\',\'会议申请\',\'meeting/apply\');INSERT INTO SYS_FUNCTION VALUES(\'87\',\'055002\',\'会议查询\',\'meeting/query\');INSERT INTO SYS_FUNCTION VALUES(\'88\',\'055003\',\'会议管理\',\'meeting/manage\');INSERT INTO SYS_FUNCTION VALUES(\'89\',\'055004\',\'会议室设置\',\'meeting/meeting_room\');INSERT INTO SYS_FUNCTION VALUES(\'90\',\'0555\',\'车辆申请与安排\',\'@vehicle\');INSERT INTO SYS_FUNCTION VALUES(\'91\',\'055503\',\'车辆使用申请\',\'vehicle\');INSERT INTO SYS_FUNCTION VALUES(\'92\',\'055506\',\'车辆使用查询\',\'vehicle/query\');INSERT INTO SYS_FUNCTION VALUES(\'93\',\'055508\',\'车辆使用管理\',\'vehicle/checkup\');INSERT INTO SYS_FUNCTION VALUES(\'94\',\'055510\',\'车辆维护管理\',\'vehicle/maintenance\');INSERT INTO SYS_FUNCTION VALUES(\'95\',\'055512\',\'车辆信息管理\',\'vehicle/manage\');INSERT INTO SYS_FUNCTION VALUES(\'96\',\'0520\',\'工作计划\',\'@work_plan\');INSERT INTO SYS_FUNCTION VALUES(\'97\',\'052003\',\'工作计划查询\',\'work_plan/show\');INSERT INTO SYS_FUNCTION VALUES(\'98\',\'052006\',\'工作计划管理\',\'work_plan/manage\');INSERT INTO SYS_FUNCTION VALUES(\'99\',\'2028\',\'系统日志管理\',\'system/log\');INSERT INTO SYS_FUNCTION VALUES(\'100\',\'2032\',\'系统资源管理\',\'system/res_manage\');INSERT INTO SYS_FUNCTION VALUES(\'101\',\'2036\',\'系统访问控制\',\'system/access_control\');INSERT INTO SYS_FUNCTION VALUES(\'105\',\'0513\',\'新闻管理\',\'news/manage\');INSERT INTO SYS_FUNCTION VALUES(\'103\',\'200810\',\'公共网址设置\',\'system/url\');INSERT INTO SYS_FUNCTION VALUES(\'104\',\'2022\',\'菜单设置\',\'system/menu\');INSERT INTO SYS_FUNCTION VALUES(\'106\',\'0557\',\'公共通讯簿\',\'address/public\');INSERT INTO SYS_FUNCTION VALUES(\'107\',\'200815\',\'公共通讯簿设置\',\'system/address\');INSERT INTO SYS_FUNCTION VALUES(\'108\',\'0531\',\'固定资产\',\'@asset\');INSERT INTO SYS_FUNCTION VALUES(\'109\',\'053103\',\'参数设置\',\'asset/config\');INSERT INTO SYS_FUNCTION VALUES(\'110\',\'053105\',\'固定资产管理\',\'asset/manage\');INSERT INTO SYS_FUNCTION VALUES(\'111\',\'053115\',\'固定资产折旧\',\'asset/dpct\');INSERT INTO SYS_FUNCTION VALUES(\'112\',\'053120\',\'固定资产查询\',\'asset/query\');INSERT INTO SYS_FUNCTION VALUES(\'113\',\'2038\',\'系统安全设置\',\'system/security\');INSERT INTO SYS_FUNCTION VALUES(\'114\',\'052009\',\'工作计划类型设置\',\'work_plan/type\');INSERT INTO SYS_FUNCTION VALUES(\'115\',\'0925\',\'图片浏览\',\'picture\');INSERT INTO SYS_FUNCTION VALUES(\'116\',\'201210\',\'图片浏览设置\',\'system/picture\');INSERT INTO SYS_FUNCTION VALUES(\'118\',\'055515\',\'调度人员管理\',\'vehicle/operator\');INSERT INTO SYS_FUNCTION VALUES(\'119\',\'0514\',\'投票管理\',\'vote/manage\');INSERT INTO SYS_FUNCTION VALUES(\'117\',\'1340\',\'统计分析\',\'@finance\');INSERT INTO SYS_FUNCTION VALUES(\'6\',\'2016\',\'手机短信设置\',\'system/mobile_sms\');INSERT INTO SYS_FUNCTION VALUES(\'120\',\'101006\',\'统计分析\',\'hrms/statistic\');INSERT INTO SYS_FUNCTION VALUES(\'121\',\'2023\',\'系统代码设置\',\'system/code\');INSERT INTO SYS_FUNCTION VALUES(\'122\',\'1040\',\'人员考核\',\'@score\');INSERT INTO SYS_FUNCTION VALUES(\'123\',\'104010\',\'考核项目设定\',\'score/group\');INSERT INTO SYS_FUNCTION VALUES(\'124\',\'104020\',\'考核任务管理\',\'score/flow\');INSERT INTO SYS_FUNCTION VALUES(\'125\',\'104030\',\'进行考核\',\'score/submit\');INSERT INTO SYS_FUNCTION VALUES(\'126\',\'0525\',\'办公用品管理\',\'@office_Product\');INSERT INTO SYS_FUNCTION VALUES(\'127\',\'052503\',\'办公用品信息管理\',\'office_Product/Product\');INSERT INTO SYS_FUNCTION VALUES(\'128\',\'052506\',\'办公用品登记管理\',\'office_Product/TransHistory\');INSERT INTO SYS_FUNCTION VALUES(\'129\',\'103006\',\'部门工资上报\',\'salary/report\');INSERT INTO SYS_FUNCTION VALUES(\'130\',\'0310\',\'新建工作\',\'workflow/new\');INSERT INTO SYS_FUNCTION VALUES(\'131\',\'0330\',\'工作查询\',\'workflow/query\');INSERT INTO SYS_FUNCTION VALUES(\'132\',\'0340\',\'工作监控\',\'workflow/manage\');INSERT INTO SYS_FUNCTION VALUES(\'134\',\'2006\',\'工作流设置\',\'@system\');INSERT INTO SYS_FUNCTION VALUES(\'135\',\'200620\',\'设计流程\',\'system/workflow/flow_type\');INSERT INTO SYS_FUNCTION VALUES(\'136\',\'200630\',\'流程分类\',\'system/workflow/flow_sort\');INSERT INTO SYS_FUNCTION VALUES(\'137\',\'055010\',\'管理员设置\',\'meeting/operator\');INSERT INTO SYS_FUNCTION VALUES(\'138\',\'055020\',\'会议纪要\',\'meeting/summary\');INSERT INTO SYS_FUNCTION VALUES(\'139\',\'1350\',\'基础数据设置\',\'@crmsetting\');INSERT INTO SYS_FUNCTION VALUES(\'140\',\'135002\',\'销售主管指派\',\'sale_manage/crmsetting/set_manager\');INSERT INTO SYS_FUNCTION VALUES(\'150\',\'0540\',\'资源申请与管理\',\'source\');INSERT INTO SYS_FUNCTION VALUES(\'142\',\'134002\',\'客户统计\',\'sale_manage/finance/sum_customer\');INSERT INTO SYS_FUNCTION VALUES(\'143\',\'132006\',\'综合查询\',\'sale_manage/sale/query\');INSERT INTO SYS_FUNCTION VALUES(\'144\',\'134004\',\'客户服务统计\',\'sale_manage/finance/sum_contact\');INSERT INTO SYS_FUNCTION VALUES(\'145\',\'134006\',\'销售统计\',\'sale_manage/finance/sum_sale\');INSERT INTO SYS_FUNCTION VALUES(\'146\',\'200813\',\'工作日志设置\',\'system/diary\');INSERT INTO SYS_FUNCTION VALUES(\'147\',\'0117\',\'新闻\',\'news/show\');INSERT INTO SYS_FUNCTION VALUES(\'148\',\'0118\',\'投票\',\'vote/show\');INSERT INTO SYS_FUNCTION VALUES(\'149\',\'2023\',\'自定义字段设置\',\'system/field\');INSERT INTO SYS_FUNCTION VALUES(\'151\',\'2014\',\'短信提醒设置\',\'system/remind\');INSERT INTO SYS_FUNCTION VALUES(\'152\',\'055507\',\'部门审批管理\',\'vehicle/dept_manage\');INSERT INTO SYS_FUNCTION VALUES(\'153\',\'053608\',\'借还书管理\',\'book/borrow_manage\');INSERT INTO SYS_FUNCTION VALUES(\'154\',\'133006\',\'采购订单\',\'sale_manage/supply/supply_order\');