struts jsp hibernate

  • U7_403669
    了解作者
  • 23.1MB
    文件大小
  • zip
    文件格式
  • 0
    收藏次数
  • VIP专享
    资源类型
  • 0
    下载次数
  • 2022-05-11 08:22
    上传日期
struts学习中,研究中,努力中,你也知道的
struts.zip
内容介绍
/* Navicat MySQL Data Transfer Source Server : localhost Source Server Version : 50516 Source Host : localhost:3306 Source Database : authcloud Target Server Type : MYSQL Target Server Version : 50516 File Encoding : 65001 Date: 2013-03-03 23:45:12 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `change_equipment_info` -- ---------------------------- -- ---------------------------- -- Table structure for `dict_info` -- ---------------------------- DROP TABLE IF EXISTS `dict_info`; CREATE TABLE `dict_info` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `DICT_TYPE` varchar(30) NOT NULL, `DICT_ID` int(11) DEFAULT NULL, `DICT_NAME` varchar(30) NOT NULL, `DICT_DESC` varchar(30) DEFAULT NULL, PRIMARY KEY (`ID`) ) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=gbk; -- ---------------------------- -- Records of dict_info -- ---------------------------- INSERT INTO `dict_info` VALUES ('10', 'SYSLOG_TYPE', '1', '证书申请', '证书申请'); INSERT INTO `dict_info` VALUES ('11', 'SYSLOG_TYPE', '2', '证书更新', '证书申请'); INSERT INTO `dict_info` VALUES ('12', 'SYSLOG_TYPE', '3', '获取随机数', '获取随机数'); INSERT INTO `dict_info` VALUES ('13', 'SYSLOG_TYPE', '4', '认证', '认证'); INSERT INTO `dict_info` VALUES ('14', 'SYSLOG_TYPE', '5', '检查是否使用过云服务', '检查是否使用过云服务'); INSERT INTO `dict_info` VALUES ('15', 'SYSLOG_TYPE', '6', '检查用户状态', '检查用户状态'); INSERT INTO `dict_info` VALUES ('16', 'OPERATELOGTYPE', '1', '添加业务', '添加业务信息'); INSERT INTO `dict_info` VALUES ('17', 'OPERATELOGTYPE', '2', '修改业务', '修改业务信息'); INSERT INTO `dict_info` VALUES ('18', 'OPERATELOGTYPE', '3', '删除业务', '修改业务信息'); -- ---------------------------- -- Table structure for `operate_log` -- ---------------------------- DROP TABLE IF EXISTS `operate_log`; CREATE TABLE `operate_log` ( `LOGID` int(11) NOT NULL AUTO_INCREMENT, `OPERATORACC` varchar(30) DEFAULT NULL, `OPERATETYPE` varchar(2) DEFAULT NULL, `OPERATEOBJECT` varchar(30) DEFAULT NULL, `LOG` varchar(500) DEFAULT NULL, `LOGTIME` varchar(30) NOT NULL, PRIMARY KEY (`LOGID`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gbk; -- ---------------------------- -- Records of operate_log -- ---------------------------- INSERT INTO `operate_log` VALUES ('1', 'admin', '1', '', '添加操作员信息', '2013-03-03 22:22:07'); INSERT INTO `operate_log` VALUES ('2', 'admin', '1', '', '添加操作员信息', '2013-03-03 22:22:51'); -- ---------------------------- -- Table structure for `operator_info` -- ---------------------------- DROP TABLE IF EXISTS `operator_info`; CREATE TABLE `operator_info` ( `OPERATORID` int(11) NOT NULL AUTO_INCREMENT, `OPERATORNAME` varchar(30) DEFAULT NULL, `OPERATORACC` varchar(30) NOT NULL, `PASSWORD` varchar(30) NOT NULL, `STATUS` int(11) DEFAULT NULL COMMENT '操作员状态:0:不可用;1:可用', `PRIVILEGE` varchar(255) DEFAULT NULL COMMENT '权限', `TYPE` int(2) DEFAULT NULL COMMENT '操作员类型(0:系统管理员;1:代理;2:会员)', `MANAGEID` int(11) DEFAULT NULL COMMENT '上级用户ID', `CREDIT` int(32) NOT NULL COMMENT '信用额度', `ADDTIME` varchar(30) NOT NULL, PRIMARY KEY (`OPERATORID`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gbk; -- ---------------------------- -- Records of operator_info -- ---------------------------- INSERT INTO `operator_info` VALUES ('1', 'admin', 'admin', 'IOq+XWSw4hZ5boNPUtYaf0LcDMvw=', '1', '2010-09-13', '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17', '0'); INSERT INTO `operator_info` VALUES ('2', '1234567', 'a', 'IOq+XWSw4hZ5boNPUtYf0LcDMvw=', '1', '2013-03-03 22:22:07', '1,2,17,', '1'); -- ---------------------------- -- Table structure for `privilege` -- ---------------------------- DROP TABLE IF EXISTS `privilege`; CREATE TABLE `privilege` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `NAME` varchar(255) DEFAULT NULL, `PARENT_ID` int(11) DEFAULT NULL, `ACTION_PATH` varchar(255) DEFAULT NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=gbk; -- ---------------------------- -- Records of privilege -- ---------------------------- INSERT INTO `privilege` VALUES ('1', '用户管理', '0', null); INSERT INTO `privilege` VALUES ('2', '操作员管理', '1', 'goOperatorAdmin.do'); INSERT INTO `privilege` VALUES ('3', '业务管理', '0', null); INSERT INTO `privilege` VALUES ('4', '增加业务信息', '3', 'preAddServiceInfoAction.do'); INSERT INTO `privilege` VALUES ('5', '查询业务信息', '3', 'preQryServiceInfoListAction.do'); INSERT INTO `privilege` VALUES ('6', '用户管理', '0', null); INSERT INTO `privilege` VALUES ('7', '用户信息管理', '6', 'preusermgr.do'); INSERT INTO `privilege` VALUES ('8', '用户换机信息查询', '6', 'preQryChangeEquipList.do'); INSERT INTO `privilege` VALUES ('9', '审计', '0', null); INSERT INTO `privilege` VALUES ('10', '操作审计', '9', 'preqryoperate.do'); INSERT INTO `privilege` VALUES ('11', '用户审计', '9', 'preuseradu.do'); INSERT INTO `privilege` VALUES ('12', '业务审计', '9', 'preqrysys.do'); INSERT INTO `privilege` VALUES ('13', '统计分析', '0', null); INSERT INTO `privilege` VALUES ('14', '用户使用信息统计', '13', 'serarchSysLogAction.do'); INSERT INTO `privilege` VALUES ('16', '修改密码', '1', 'premodifipassword.do'); INSERT INTO `privilege` VALUES ('17', '权限配置', '1', 'goPrivilegeAdmin.do');
评论
    相关推荐