/*
SQLyog Ultimate v11.24 (32 bit)
MySQL - 5.5.28 : Database - carrental
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`carrental` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `carrental`;

/*Table structure for table `cars` */

DROP TABLE IF EXISTS `cars`;

CREATE TABLE `cars` (
  `CARNUMBER` varchar(20) NOT NULL,
  `CARTYPE` varchar(50) NOT NULL,
  `COLOR` varchar(10) NOT NULL,
  `PRICE` decimal(10,2) NOT NULL,
  `RENTPRICE` decimal(10,2) NOT NULL,
  `DEPOSIT` decimal(10,2) NOT NULL,
  `ISRENTING` varchar(20) NOT NULL,
  `CARDESC` varchar(500) DEFAULT NULL,
  `CARIMG` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`CARNUMBER`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `cars` */

insert  into `cars`(`CARNUMBER`,`CARTYPE`,`COLOR`,`PRICE`,`RENTPRICE`,`DEPOSIT`,`ISRENTING`,`CARDESC`,`CARIMG`) values ('2','奔驰','白色','1000.00','2313.00','3214.00','0','红色霸气suv','dfa039b4cc1548e39c6ff3ab5711e2c8.jpg'),('8888','宾利','灰色','787877.00','88877.00','88888.00','0','时速350km/h','8c78890d45e8412bbf43464667d2e189.png'),('京N121-112','奔驰','褐色','1000000.00','10000.00','10000.00','0','炫丽奔驰','276e2bd04e67499dad9dac6bf1e61136.jpg'),('京N88963','奥迪A80923','白色','1829343.00','23200.00','100000.00','1','奥迪A8','2864a42bde3942149b56e45f5a5ee5f8.jpg');

/*Table structure for table `checktable` */

DROP TABLE IF EXISTS `checktable`;

CREATE TABLE `checktable` (
  `CHECKID` decimal(8,0) NOT NULL,
  `CHECKDATE` datetime NOT NULL,
  `FIELD` varchar(100) DEFAULT NULL,
  `PROBLEM` varchar(100) DEFAULT NULL,
  `PAYING` decimal(10,2) DEFAULT NULL,
  `CHECKUSERID` varchar(40) NOT NULL,
  `RENTID` decimal(8,0) NOT NULL,
  PRIMARY KEY (`CHECKID`),
  KEY `CHECKTABLE_RENTTABLE_FK2` (`RENTID`),
  KEY `CHECKTABLE_USERS_FK1` (`CHECKUSERID`),
  CONSTRAINT `CHECKTABLE_RENTTABLE_FK2` FOREIGN KEY (`RENTID`) REFERENCES `renttable` (`TABLEID`),
  CONSTRAINT `CHECKTABLE_USERS_FK1` FOREIGN KEY (`CHECKUSERID`) REFERENCES `users` (`USERNAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `checktable` */

/*Table structure for table `customers` */

DROP TABLE IF EXISTS `customers`;

CREATE TABLE `customers` (
  `IDENTITY` varchar(20) NOT NULL,
  `CUSTNAME` varchar(40) NOT NULL,
  `SEX` varchar(10) NOT NULL,
  `ADDRESS` varchar(100) NOT NULL,
  `PHONE` varchar(20) NOT NULL,
  `CAREER` varchar(20) NOT NULL,
  `CUSTPWD` varchar(20) NOT NULL,
  PRIMARY KEY (`IDENTITY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `customers` */

insert  into `customers`(`IDENTITY`,`CUSTNAME`,`SEX`,`ADDRESS`,`PHONE`,`CAREER`,`CUSTPWD`) values ('111','看看','男','111','asd','哈哈哈','666'),('11111','111','111','1111','11','111','111'),('111112132131','王二下','男','北京','23232','1','1Aa12_dss'),('123','11212','213412','234123','2141','1234','12341'),('12312131114121','潘森','男','北京朝阳','13333387382','老师','1'),('123456','解决1','男','mmm','123',' 安德森','333'),('130729199503252113','老李','男','北京','18131371979','学生','点击显示密码'),('2222','於化','男','分打发','fsdf','dasda','88999955'),('4324234','打发','男','额头湾','65661','高大上','222'),('4535','5345','男','54353','3453453453','534535345','353'),('456745','於化安','男','额未全额','2313231','243424','4324234'),('4598','於化安','男','32131','3123123123','12312','123456'),('563463463','於化安','男','股份大股东','9879876545','防守对方','3234234'),('77755','你会看见好看','女','分打发','22','111','2222'),('789','111','女','北京ff','5737','解决','222'),('789745613213','於化安666','男','规范地方','253157','32434','444444'),('85258','阿门','男','2434','3244','4234','24342432'),('8885228963963','於化安','男','的事发生','333','asdad','586782'),('888999','张三22','男','回家','123456','流量','333333'),('95285252','於化安','男','分打发gf','45613','大锅饭的','123'),('9898','於化於','男','32131321','3123123','12312312','3123123');

/*Table structure for table `funs` */

DROP TABLE IF EXISTS `funs`;

CREATE TABLE `funs` (
  `FUNID` decimal(8,0) NOT NULL,
  `FUNNAME` varchar(40) NOT NULL,
  `FUNURL` varchar(80) NOT NULL,
  `MENUID` decimal(8,0) NOT NULL,
  PRIMARY KEY (`FUNID`),
  KEY `FUNS_FK` (`MENUID`),
  CONSTRAINT `FUNS_FK` FOREIGN KEY (`MENUID`) REFERENCES `menus` (`MENUID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `funs` */

insert  into `funs`(`FUNID`,`FUNNAME`,`FUNURL`,`MENUID`) values ('1','主页面','index.jsp','1'),('2','头页面','head.jsp','1'),('3','菜单页面','menu.jsp','1'),('4','脚页面','foot.jsp','1'),('5','操作页面','welcome.jsp','1'),('6','权限提示页面','norole.jsp','1'),('8','退出系统动作n','ExitSystemAction.do','1'),('9','菜单导航','modNavTop.jsp','1'),('10','菜单条','splitor.jsp','1'),('11','操作失败提示页面','error.jsp','1'),('12','系统崩溃提示页面','appError.jsp','1'),('13','成功页面','ok.jsp','1'),('15','添加角色功能n','RoleManagerAction.do','20'),('16','角色管理页面','roleManager.jsp','20'),('17','查询角色信息动作','FindRole.do','20'),('18','添加新角色的菜单查询动作','FindMenus.do','20'),('19','预修改角色信息查询动作','PreUpdateRole.do','20'),('20','修改角色信息动作','UpdateRole.do','20'),('21','删除角色动作','DeleteRole.do','20'),('22','添加新角色页面','addRole.jsp','20'),('23','查询日志信息页面','findLog.jsp','21'),('24','查询日志信息动作n','LogOperatorAction.do','21'),('25','显示日志信息页面','viewLog.jsp','21'),('26','删除日志信息动作','DeleteLog.do','21'),('27','查询登陆信息页面','findLoginInfo.jsp','22'),('28','查询登陆信息动作','LoginInfoOperatorAction.do','22'),('29','显示登陆信息页面','showLoginLogInfo.jsp','22'),('50','添加用户角色查询动作n','AddUserAction.do','3'),('51','添加用户页面','addUser.jsp','3'),('52','添加用户动作','AddUser.do','3'),('53','查询用户角色查询动作n','FindUserAction.do','4'),('54','查询用户页面','findUser.jsp','4'),('55','显示查询用户结果页面n','viewUser.jsp','4'),('56','查询用户动作','FindUser.do','4'),('57','预更新查询用户动作','PreUpdateUser.do','4'),('58','显示更新用户页面','updateUser.jsp','4'),('59','更新用户动作','UpdateUser.do','4'),('60','删除用户动作','DeleteUser.do','4'),('61','预修改用户密码','PreChangeUserPwd.do','4'),('62','修改用户密码页面','chengeUserPwd.jsp','4'),('63','修改用户密码动作','ChangeUserPwd.do','4'),('100','添加客户页面','addCustomers.jsp','6'),('101','添加客户动作n','AddCustomersAction.do','6'),('102','查询客户页面','findCustomers.jsp','7'),('103','查询客户信息动作n','FindCustomersAction.do','7'),('104','显示查询客户结果页面','viewCustomers.jsp','7'),('105','预更新客户查询动作','PreCustomers.do','7'),('106','显示更新客户页面','updateCustomers.jsp','7'),('107','更新客户动作','UpdateCustomers.do','7'),('108','删除客户动作','DeleteCustomers.do','7'),('109','预修改客户密码','PreChangeCustomerPwd.do','7'),('110','修改客户密码页面','chengeCustomersPwd.jsp','7'),('111','修改用户密码动作','ChangeCustomersPwd.do','7'),('200','添加汽车页面','addCar.jsp','9'),('201','添加汽车动作n','AddCarAction.do','9'),('202','查询汽车页面','findCar.jsp','10'),('203','显示查询汽车结果页面','viewCars.jsp','10'),('204','查询汽车信息动作n','FindCarAction.do','10'),('205','预更新查询汽车动作','PreUpdateCar.do','10'),('206','显示更新汽车结果页面','updateCar.jsp','10'),('207','更新汽车动作','UpdateCar.do','10'),('209','删除汽车动作','DeleteCar.do','10'),('300','租车页面','rentCar.jsp','12'),('301','预生成出租单动作n','RentingCarAction.do','12'),('302','预生成出租单页面','preCreateRenting.jsp','12'),('303','生成出租单动作','CreateRentCarTable.do','12'),('304','汽车出租单查询页面','returnCar.jsp','13'),('305','预还车查询动作','PreReturnCarSearch.do','13'),('306','创建检查单页面','createCheckTable.jsp','13'),('307','创建检查单动作','CreateCheckTable.do','13'),('308','出租单管理页面','rentManager.jsp','14'),('309','出租单管理查询动作','RentManagerSearch.do','14'),('310','显示查询出租单结果页面','viewRenttables.jsp','14'),('311','预更新出租单查询动作','PreUpdateRenttable.do','14'),('312','更新出租单页面','updateRenttable.jsp','14'),('313','更新出租单动作','UpdateRenttable.do','14'),('314','删除出租单动作','DeleteRenttable.do','14'),('315','检查单管理页面','checkManager.jsp','15'),('316','查询检查单动作','FindCheckTable.do','15'),('317','显示查询检查单结果页面','viewCheckTables.jsp','15'),('318','预更新检查单查询动作','PreUdateCheckTable.do','15'),('319','更新检查单页面','updateCheckTable.jsp','15'),('320','更新检查单动作','UpdateCheckTable.do','15'),('321','删除检查单动作','DeleteCheckTables.do','15'),('322','查询当月应还汽车动作n','MonthStatisticsCarAction.do','17'),('400','显示当月应还车结果页面','viewMonthReturnCarResult.jsp','17'),('401','查询当月应归还汽车相信信息','FindMonthReturnCarByInfo.do','17'),('402','显示当月应还汽车详细信息','findMonthReturnCarByInfo.jsp','17');

/*Table structure for table `loginlogs` */

DROP TABLE IF EXISTS `loginlogs`;

CREATE TABLE `loginlogs` (
  `LOGINLOGID` decimal(8,0) NOT NULL,
  `LOGINNAME` varchar(80) DEFAULT NULL,
  `LOGINIP` varchar(40) DEFAULT NULL,
  `LOGINTIME` datetime DEFAULT NULL,
  PRIMARY KEY (`LOGINLOGID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `loginlogs` */

/*Table structure for table `logs` */

DROP TABLE IF EXISTS `logs`;

CREATE TABLE `logs` (
  `ID` decimal(8,0) NOT NULL,
  `USERNAME` varchar(40) NOT NULL,
  `ACTION` varchar(40) NOT NULL,
  `ACTIONTIME` datetime NOT NULL,
  `FLAG` decimal(8,0) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `logs` */

/*Table structure for table `menus` */

DROP TABLE IF EXISTS `menus`;

CREATE TABLE `menus` (
  `MENUID` decimal(8,0) NOT NULL,
  `MENUNAME` varchar(40) NOT NULL,
  `CONNURL` varchar(80) DEFAULT NULL,
  `FATHERID` decimal(8,0) NOT NULL,
  PRIMARY KEY (`MENUID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `menus` */

insert  into `menus`(`MENUID`,`MENUNAME`,`CONNURL`,`FATHERID`) values ('1','汽车租赁管理系统',NULL,'-1'),('2','用户管理',NULL,'1'),('3','添加用户','car/user/findAllUsers','2'),('4','查询用户','car/user/findAllRoles','2'),('5','客户管理',NULL,'1'),('6','添加客户信息','custManager/addCustomers.jsp','5'),('7','查询客户信息','custManager/findCustomers.jsp','5'),('8','汽车管理',NULL,'1'),('9','添加汽车信息','carManager/addCar.jsp','8'),('10','查询汽车信息','carManager/findCar.jsp','8'),('11','业务管理',NULL,'1'),('12','汽车出租','operatorManager/rentCar.jsp','11'),('13','汽车入库','operatorManager/returnCar.jsp','11'),('14','出租单管理','operatorManager/rentManager.jsp','11'),('15','检查单管理','operatorManager/checkManager.jsp','11'),('16','业务统计',NULL,'1'),('17','当月应还汽车','car/statistics/getAllStati','16'),('20','角色管理','systemManager/roleManager.jsp','18'),('21','日志管理','systemManager/findLog.jsp','18'),('22','登陆信息管理','systemManager/findLoginInfo.jsp','18'),('23','查询所有用户信息','car/user/findUserByPage','2'),('24','统计每辆汽车的租金情况','car/countRent/countPriceAndNum','16'),('25','统计每月汽车的租赁次数','car/statistics/getMonthAmount','16');

/*Table structure for table `renttable` */

DROP TABLE IF EXISTS `renttable`;

CREATE TABLE `renttable` (
  `TABLEID` decimal(8,0) NOT NULL,
  `IMPREST` decimal(10,2) NOT NULL,
  `SHOULDPAYPRICE` decimal(10,2) NOT NULL,
  `PRICE` decimal(10,2) NOT NULL,
  `BEGINDATE` datetime NOT NULL,
  `SHOULDRETURNDATE` datetime NOT NULL,
  `RETURNDATE` datetime DEFAULT NULL,
  `RENTFLAG` decimal(8,0) NOT NULL,
  `CUSTID` varchar(20) NOT NULL,
  `CARID` varchar(20) NOT NULL,
  `USERID` varchar(40) NOT NULL,
  PRIMARY KEY (`TABLEID`),
  KEY `RENTTABLE_CUSTIONERS_FK3` (`USERID`),
  KEY `RENTTABLE_CUSTOMERS_FK1` (`CUSTID`),
  KEY `RENTTABLE_CUSTONERS_FK2` (`CARID`),
  CONSTRAINT `RENTTABLE_CUSTIONERS_FK3` FOREIGN KEY (`USERID`) REFERENCES `users` (`USERNAME`),
  CONSTRAINT `RENTTABLE_CUSTOMERS_FK1` FOREIGN KEY (`CUSTID`) REFERENCES `customers` (`IDENTITY`),
  CONSTRAINT `RENTTABLE_CUSTONERS_FK2` FOREIGN KEY (`CARID`) REFERENCES `cars` (`CARNUMBER`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `renttable` */

/*Table structure for table `roles` */

DROP TABLE IF EXISTS `roles`;

CREATE TABLE `roles` (
  `ROLEID` decimal(8,0) NOT NULL,
  `ROLENAME` varchar(20) NOT NULL,
  PRIMARY KEY (`ROLEID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `roles` */

insert  into `roles`(`ROLEID`,`ROLENAME`) values ('1','管理员'),('10','业务员'),('11','维护人员'),('12','用户1'),('13','用户2'),('14','管理员1'),('15','用户3'),('24','业务员2'),('25','业务员3'),('26','角色1'),('27','角色2'),('28','营业员'),('29','1');

/*Table structure for table `roles_menus` */

DROP TABLE IF EXISTS `roles_menus`;

CREATE TABLE `roles_menus` (
  `ROLEID` decimal(8,0) NOT NULL,
  `MENUID` decimal(8,0) NOT NULL,
  PRIMARY KEY (`ROLEID`,`MENUID`),
  KEY `ROLES_MENUS_FK2` (`MENUID`),
  CONSTRAINT `ROLES_MENUS_FK1` FOREIGN KEY (`ROLEID`) REFERENCES `roles` (`ROLEID`),
  CONSTRAINT `ROLES_MENUS_FK2` FOREIGN KEY (`MENUID`) REFERENCES `menus` (`MENUID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `roles_menus` */

insert  into `roles_menus`(`ROLEID`,`MENUID`) values ('10','1'),('11','1'),('12','1'),('13','1'),('14','1'),('15','1'),('24','1'),('25','1'),('26','1'),('27','1'),('28','1'),('29','1'),('1','2'),('12','2'),('13','2'),('14','2'),('15','2'),('24','2'),('27','2'),('1','3'),('12','3'),('13','3'),('14','3'),('15','3'),('24','3'),('27','3'),('1','4'),('12','4'),('13','4'),('14','4'),('15','4'),('24','4'),('27','4'),('1','5'),('10','5'),('12','5'),('13','5'),('14','5'),('15','5'),('24','5'),('26','5'),('27','5'),('28','5'),('1','6'),('10','6'),('12','6'),('13','6'),('14','6'),('15','6'),('26','6'),('27','6'),('28','6'),('1','7'),('10','7'),('12','7'),('13','7'),('14','7'),('15','7'),('24','7'),('26','7'),('27','7'),('28','7'),('1','8'),('10','8'),('12','8'),('13','8'),('14','8'),('24','8'),('26','8'),('27','8'),('28','8'),('1','9'),('10','9'),('12','9'),('13','9'),('14','9'),('24','9'),('26','9'),('27','9'),('28','9'),('1','10'),('10','10'),('12','10'),('13','10'),('14','10'),('24','10'),('26','10'),('27','10'),('28','10'),('1','11'),('10','11'),('14','11'),('24','11'),('28','11'),('1','12'),('10','12'),('14','12'),('24','12'),('28','12'),('1','13'),('10','13'),('14','13'),('24','13'),('28','13'),('1','14'),('10','14'),('14','14'),('24','14'),('28','14'),('1','15'),('10','15'),('14','15'),('24','15'),('28','15'),('1','16'),('13','16'),('14','16'),('28','16'),('1','17'),('13','17'),('14','17'),('28','17'),('1','20'),('11','20'),('14','20'),('1','21'),('11','21'),('14','21'),('1','22'),('11','22'),('14','22'),('1','23'),('12','23'),('13','23'),('14','23'),('15','23'),('24','23'),('27','23'),('1','24'),('1','25');

/*Table structure for table `t_logger_info` */

DROP TABLE IF EXISTS `t_logger_info`;

CREATE TABLE `t_logger_info` (
  `ali_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `ali_client_ip` varchar(30) DEFAULT NULL COMMENT '客户端请求ip',
  `ali_uri` varchar(100) DEFAULT NULL COMMENT '客户端请求路径',
  `ali_type` varchar(50) DEFAULT NULL COMMENT '终端请求方式普通请求，ajax请求',
  `ali_method` varchar(10) DEFAULT NULL COMMENT '请求方式method，post，get等',
  `ali_param_data` longtext COMMENT '请求参数内容，json',
  `ali_session_id` varchar(100) DEFAULT NULL COMMENT '请求接口唯一session标识',
  `ali_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '请求时间',
  `ali_return_time` varchar(50) DEFAULT NULL COMMENT '接口返回时间',
  `ali_return_data` longtext COMMENT '接口返回数据json',
  `ali_http_status_code` varchar(10) DEFAULT NULL COMMENT '请求时httpStatusCode代码，如200，400，404等',
  `ali_time_consuming` int(8) DEFAULT NULL COMMENT '请求耗时秒单位',
  PRIMARY KEY (`ali_id`)
) ENGINE=InnoDB AUTO_INCREMENT=103 DEFAULT CHARSET=utf8;

/*Data for the table `t_logger_info` */

insert  into `t_logger_info`(`ali_id`,`ali_client_ip`,`ali_uri`,`ali_type`,`ali_method`,`ali_param_data`,`ali_session_id`,`ali_time`,`ali_return_time`,`ali_return_data`,`ali_http_status_code`,`ali_time_consuming`) values (1,'0:0:0:0:0:0:0:1','/index/login',NULL,'GET','{\"name\":[\"liangyunqiang\"]}','27D52831534A4723A693DA88E4D34530','2018-03-30 22:51:57','null',NULL,'404',5),(2,'0:0:0:0:0:0:0:1','/error',NULL,'GET','{\"name\":[\"liangyunqiang\"]}','27D52831534A4723A693DA88E4D34530','2018-03-30 22:51:57','null',NULL,'404',52),(3,'0:0:0:0:0:0:0:1','/index/login',NULL,'GET','{\"name\":[\"liangyunqiang\"]}','27D52831534A4723A693DA88E4D34530','2018-03-30 22:54:36','{\"msg\":\"用户：liangyunqiang,登陆成功\"}',NULL,'200',440),(4,'127.0.0.1','/index/login',NULL,'GET','{\"name\":[\"liangyunqiang\"]}',NULL,'2018-03-30 23:01:45','{\"msg\":\"用户：liangyunqiang,登陆成功\"}',NULL,'200',4),(5,'127.0.0.1','/index/login',NULL,'GET','{\"name\":[\"liangyunqiang\"]}',NULL,'2018-03-30 23:10:47','1522422647314','{\"msg\":\"用户：liangyunqiang,登陆成功\"}','200',135),(6,'0:0:0:0:0:0:0:1','/error',NULL,'POST','{\"username\":[\"admin\"],\"userpwd\":[\"a1231\"]}','2732DDE28B0BB7ACB80E415BB45B621A','2018-03-31 14:27:57','1522477677136','null','405',74),(7,'0:0:0:0:0:0:0:1','/error',NULL,'POST','{\"username\":[\"admin\"],\"userpwd\":[\"a1231\"]}','2732DDE28B0BB7ACB80E415BB45B621A','2018-03-31 14:28:55','1522477735250','null','405',6),(8,'0:0:0:0:0:0:0:1','/user/index',NULL,'GET','{}','DCC14F8CED4482D3B949E987ABDA94E5','2018-03-31 14:36:20','1522478180231','null','200',392),(9,'0:0:0:0:0:0:0:1','/user/js/menu.js',NULL,'GET','{}','DCC14F8CED4482D3B949E987ABDA94E5','2018-03-31 14:36:20','1522478180281','null','404',1),(10,'0:0:0:0:0:0:0:1','/user/js/jquery.min.js',NULL,'GET','{}','DCC14F8CED4482D3B949E987ABDA94E5','2018-03-31 14:36:20','1522478180283','null','404',7),(11,'0:0:0:0:0:0:0:1','/error',NULL,'GET','{}','DCC14F8CED4482D3B949E987ABDA94E5','2018-03-31 14:36:20','1522478180535','null','404',76),(12,'0:0:0:0:0:0:0:1','/error',NULL,'GET','{}','DCC14F8CED4482D3B949E987ABDA94E5','2018-03-31 14:36:20','1522478180537','null','404',81),(13,'0:0:0:0:0:0:0:1','/user/index',NULL,'GET','{}','DCC14F8CED4482D3B949E987ABDA94E5','2018-03-31 14:47:50','1522478870879','null','200',3),(14,'0:0:0:0:0:0:0:1','/user/js/jquery.min.js',NULL,'GET','{}','DCC14F8CED4482D3B949E987ABDA94E5','2018-03-31 14:47:50','1522478870907','null','404',1),(15,'0:0:0:0:0:0:0:1','/user/js/menu.js',NULL,'GET','{}','DCC14F8CED4482D3B949E987ABDA94E5','2018-03-31 14:47:50','1522478870923','null','404',1),(16,'0:0:0:0:0:0:0:1','/error',NULL,'GET','{}','DCC14F8CED4482D3B949E987ABDA94E5','2018-03-31 14:47:51','1522478871032','null','404',5),(17,'0:0:0:0:0:0:0:1','/error',NULL,'GET','{}','DCC14F8CED4482D3B949E987ABDA94E5','2018-03-31 14:47:51','1522478871032','null','404',5),(18,'0:0:0:0:0:0:0:1','/user/js/jquery.min.js',NULL,'GET','{}','2540FFECFC3B9FDD83E1E7935C271760','2018-03-31 14:54:51','1522479291205','null','404',11),(19,'0:0:0:0:0:0:0:1','/user/index',NULL,'GET','{}','2540FFECFC3B9FDD83E1E7935C271760','2018-03-31 14:54:51','1522479291148','null','200',283),(20,'0:0:0:0:0:0:0:1','/user/js/menu.js',NULL,'GET','{}','2540FFECFC3B9FDD83E1E7935C271760','2018-03-31 14:54:51','1522479291211','null','404',18),(21,'0:0:0:0:0:0:0:1','/error',NULL,'GET','{}','2540FFECFC3B9FDD83E1E7935C271760','2018-03-31 14:54:51','1522479291368','null','404',46),(22,'0:0:0:0:0:0:0:1','/error',NULL,'GET','{}','2540FFECFC3B9FDD83E1E7935C271760','2018-03-31 14:54:51','1522479291379','null','404',2),(23,'0:0:0:0:0:0:0:1','/user/js/jquery.min.js',NULL,'GET','{}','846E16296E877335F9609A146FB607A9','2018-03-31 14:57:51','1522479471770','null','404',3),(24,'0:0:0:0:0:0:0:1','/user/js/menu.js',NULL,'GET','{}','846E16296E877335F9609A146FB607A9','2018-03-31 14:57:51','1522479471790','null','404',9),(25,'0:0:0:0:0:0:0:1','/user/index',NULL,'GET','{}','846E16296E877335F9609A146FB607A9','2018-03-31 14:57:51','1522479471729','null','200',286),(26,'0:0:0:0:0:0:0:1','/error',NULL,'GET','{}','846E16296E877335F9609A146FB607A9','2018-03-31 14:57:51','1522479471941','null','404',32),(27,'0:0:0:0:0:0:0:1','/error',NULL,'GET','{}','846E16296E877335F9609A146FB607A9','2018-03-31 14:57:51','1522479471952','null','404',5),(28,'0:0:0:0:0:0:0:1','/user/index',NULL,'GET','{}','846E16296E877335F9609A146FB607A9','2018-03-31 15:01:07','1522479667160','null','200',4),(29,'0:0:0:0:0:0:0:1','/user/js/jquery.min.js',NULL,'GET','{}','846E16296E877335F9609A146FB607A9','2018-03-31 15:01:07','1522479667220','null','404',4),(30,'0:0:0:0:0:0:0:1','/user/js/menu.js',NULL,'GET','{}','846E16296E877335F9609A146FB607A9','2018-03-31 15:01:07','1522479667220','null','404',2),(31,'0:0:0:0:0:0:0:1','/error',NULL,'GET','{}','846E16296E877335F9609A146FB607A9','2018-03-31 15:01:07','1522479667395','null','404',3),(32,'0:0:0:0:0:0:0:1','/error',NULL,'GET','{}','846E16296E877335F9609A146FB607A9','2018-03-31 15:01:07','1522479667395','null','404',2),(33,'0:0:0:0:0:0:0:1','/user/js/menu.js',NULL,'GET','{}','846E16296E877335F9609A146FB607A9','2018-03-31 15:01:07','1522479667413','null','404',4),(34,'0:0:0:0:0:0:0:1','/error',NULL,'GET','{}','846E16296E877335F9609A146FB607A9','2018-03-31 15:01:07','1522479667496','null','404',2),(35,'0:0:0:0:0:0:0:1','/user/index',NULL,'GET','{}','66A3786453719A4001C93920EBA1B468','2018-03-31 15:03:12','1522479792059','null','200',282),(36,'0:0:0:0:0:0:0:1','/user/js/jquery.min.js',NULL,'GET','{}','66A3786453719A4001C93920EBA1B468','2018-03-31 15:03:12','1522479792098','null','404',2),(37,'0:0:0:0:0:0:0:1','/user/js/menu.js',NULL,'GET','{}','66A3786453719A4001C93920EBA1B468','2018-03-31 15:03:12','1522479792107','null','404',2),(38,'0:0:0:0:0:0:0:1','/error',NULL,'GET','{}','66A3786453719A4001C93920EBA1B468','2018-03-31 15:03:12','1522479792262','null','404',30),(39,'0:0:0:0:0:0:0:1','/error',NULL,'GET','{}','66A3786453719A4001C93920EBA1B468','2018-03-31 15:03:12','1522479792266','null','404',34),(40,'0:0:0:0:0:0:0:1','/user/index',NULL,'GET','{}','4A5A0050938A04AEDF48B5F08D49EB41','2018-03-31 15:15:00','1522480499997','null','200',421),(41,'0:0:0:0:0:0:0:1','/user/js/menu.js',NULL,'GET','{}','4A5A0050938A04AEDF48B5F08D49EB41','2018-03-31 15:15:03','1522480503214','null','404',2),(42,'0:0:0:0:0:0:0:1','/user/js/jquery.min.js',NULL,'GET','{}','4A5A0050938A04AEDF48B5F08D49EB41','2018-03-31 15:15:03','1522480503225','null','404',1),(43,'0:0:0:0:0:0:0:1','/error',NULL,'GET','{}','4A5A0050938A04AEDF48B5F08D49EB41','2018-03-31 15:15:03','1522480503315','null','404',36),(44,'0:0:0:0:0:0:0:1','/error',NULL,'GET','{}','4A5A0050938A04AEDF48B5F08D49EB41','2018-03-31 15:15:03','1522480503320','null','404',4),(45,'0:0:0:0:0:0:0:1','/user/js/menu.js',NULL,'GET','{}','4A5A0050938A04AEDF48B5F08D49EB41','2018-03-31 15:15:03','1522480503332','null','404',3),(46,'0:0:0:0:0:0:0:1','/error',NULL,'GET','{}','4A5A0050938A04AEDF48B5F08D49EB41','2018-03-31 15:15:03','1522480503470','null','404',3),(47,'0:0:0:0:0:0:0:1','/user/index',NULL,'GET','{}','64E95C36FB85BEF67A9C41B15B67A794','2018-03-31 15:17:44','1522480664027','null','200',247),(48,'0:0:0:0:0:0:0:1','/user/js/jquery.min.js',NULL,'GET','{}','64E95C36FB85BEF67A9C41B15B67A794','2018-03-31 15:17:44','1522480664086','null','404',2),(49,'0:0:0:0:0:0:0:1','/user/js/menu.js',NULL,'GET','{}','64E95C36FB85BEF67A9C41B15B67A794','2018-03-31 15:17:44','1522480664120','null','404',3),(50,'0:0:0:0:0:0:0:1','/error',NULL,'GET','{}','64E95C36FB85BEF67A9C41B15B67A794','2018-03-31 15:17:44','1522480664193','null','404',25),(51,'0:0:0:0:0:0:0:1','/error',NULL,'GET','{}','64E95C36FB85BEF67A9C41B15B67A794','2018-03-31 15:17:44','1522480664196','null','404',2),(52,'0:0:0:0:0:0:0:1','/error','XMLHttpRequest','POST','{\"username\":[\"a\"],\"userpwd\":[\"a\"]}','64E95C36FB85BEF67A9C41B15B67A794','2018-03-31 15:18:18','1522480698206','null','500',3),(53,'0:0:0:0:0:0:0:1','/error','XMLHttpRequest','POST','{\"username\":[\"a\"],\"userpwd\":[\"a\"]}','64E95C36FB85BEF67A9C41B15B67A794','2018-03-31 15:18:39','1522480719628','null','500',2),(54,'0:0:0:0:0:0:0:1','/user/index',NULL,'GET','{}','C02614929F288BA4014CAF377B76A214','2018-03-31 16:20:33','1522484433236','null','200',252),(55,'0:0:0:0:0:0:0:1','/user/js/jquery.min.js',NULL,'GET','{}','C02614929F288BA4014CAF377B76A214','2018-03-31 16:20:33','1522484433281','null','404',3),(56,'0:0:0:0:0:0:0:1','/user/js/menu.js',NULL,'GET','{}','C02614929F288BA4014CAF377B76A214','2018-03-31 16:20:33','1522484433283','null','404',3),(57,'0:0:0:0:0:0:0:1','/error',NULL,'GET','{}','C02614929F288BA4014CAF377B76A214','2018-03-31 16:20:33','1522484433456','null','404',24),(58,'0:0:0:0:0:0:0:1','/error',NULL,'GET','{}','C02614929F288BA4014CAF377B76A214','2018-03-31 16:20:33','1522484433490','null','404',4),(59,'0:0:0:0:0:0:0:1','/user/js/jquery.min.js',NULL,'GET','{}','10C1FE2D97C2318F32D18B99A4E6A779','2018-03-31 16:28:58','1522484938369','null','404',4),(60,'0:0:0:0:0:0:0:1','/user/index',NULL,'GET','{}','10C1FE2D97C2318F32D18B99A4E6A779','2018-03-31 16:28:58','1522484938328','null','200',265),(61,'0:0:0:0:0:0:0:1','/user/js/menu.js',NULL,'GET','{}','10C1FE2D97C2318F32D18B99A4E6A779','2018-03-31 16:28:58','1522484938369','null','404',4),(62,'0:0:0:0:0:0:0:1','/error',NULL,'GET','{}','10C1FE2D97C2318F32D18B99A4E6A779','2018-03-31 16:28:58','1522484938542','null','404',29),(63,'0:0:0:0:0:0:0:1','/error',NULL,'GET','{}','10C1FE2D97C2318F32D18B99A4E6A779','2018-03-31 16:28:58','1522484938542','null','404',29),(64,'0:0:0:0:0:0:0:1','/user/js/menu.js',NULL,'GET','{}','10C1FE2D97C2318F32D18B99A4E6A779','2018-03-31 16:28:58','1522484938556','null','404',1),(65,'0:0:0:0:0:0:0:1','/error',NULL,'GET','{}','10C1FE2D97C2318F32D18B99A4E6A779','2018-03-31 16:28:58','1522484938626','null','404',3),(66,'0:0:0:0:0:0:0:1','/user/index',NULL,'GET','{}','10C1FE2D97C2318F32D18B99A4E6A779','2018-03-31 16:29:59','1522484999560','null','200',2),(67,'0:0:0:0:0:0:0:1','/user/js/menu.js',NULL,'GET','{}','10C1FE2D97C2318F32D18B99A4E6A779','2018-03-31 16:29:59','1522484999598','null','404',1),(68,'0:0:0:0:0:0:0:1','/user/js/jquery.min.js',NULL,'GET','{}','10C1FE2D97C2318F32D18B99A4E6A779','2018-03-31 16:29:59','1522484999604','null','404',2),(69,'0:0:0:0:0:0:0:1','/error',NULL,'GET','{}','10C1FE2D97C2318F32D18B99A4E6A779','2018-03-31 16:29:59','1522484999650','null','404',2),(70,'0:0:0:0:0:0:0:1','/error',NULL,'GET','{}','10C1FE2D97C2318F32D18B99A4E6A779','2018-03-31 16:29:59','1522484999689','null','404',2),(71,'0:0:0:0:0:0:0:1','/user/js/menu.js',NULL,'GET','{}','10C1FE2D97C2318F32D18B99A4E6A779','2018-03-31 16:29:59','1522484999704','null','404',1),(72,'0:0:0:0:0:0:0:1','/error',NULL,'GET','{}','10C1FE2D97C2318F32D18B99A4E6A779','2018-03-31 16:29:59','1522484999755','null','404',2),(73,'0:0:0:0:0:0:0:1','/user/index',NULL,'GET','{}','10C1FE2D97C2318F32D18B99A4E6A779','2018-03-31 16:30:44','1522485044886','null','200',10),(74,'0:0:0:0:0:0:0:1','/user/js/menu.js',NULL,'GET','{}','10C1FE2D97C2318F32D18B99A4E6A779','2018-03-31 16:30:44','1522485044929','null','404',1),(75,'0:0:0:0:0:0:0:1','/user/js/jquery.min.js',NULL,'GET','{}','10C1FE2D97C2318F32D18B99A4E6A779','2018-03-31 16:30:44','1522485044930','null','404',2),(76,'0:0:0:0:0:0:0:1','/error',NULL,'GET','{}','10C1FE2D97C2318F32D18B99A4E6A779','2018-03-31 16:30:45','1522485045016','null','404',2),(77,'0:0:0:0:0:0:0:1','/error',NULL,'GET','{}','10C1FE2D97C2318F32D18B99A4E6A779','2018-03-31 16:30:45','1522485045021','null','404',2),(78,'0:0:0:0:0:0:0:1','/user/js/menu.js',NULL,'GET','{}','10C1FE2D97C2318F32D18B99A4E6A779','2018-03-31 16:30:45','1522485045045','null','404',2),(79,'0:0:0:0:0:0:0:1','/error',NULL,'GET','{}','10C1FE2D97C2318F32D18B99A4E6A779','2018-03-31 16:30:45','1522485045106','null','404',3),(80,'0:0:0:0:0:0:0:1','/user/index',NULL,'GET','{}','DA3C2170019574F56A8C3C4D87FACF1D','2018-03-31 16:40:41','1522485641735','null','200',280),(81,'0:0:0:0:0:0:0:1','/error',NULL,'GET','{}','DA3C2170019574F56A8C3C4D87FACF1D','2018-03-31 16:43:43','1522485823469','null','404',29),(82,'0:0:0:0:0:0:0:1','/error',NULL,'GET','{}','DA3C2170019574F56A8C3C4D87FACF1D','2018-03-31 16:44:06','1522485846610','null','404',7),(83,'0:0:0:0:0:0:0:1','/error',NULL,'GET','{}','DA3C2170019574F56A8C3C4D87FACF1D','2018-03-31 16:44:16','1522485856585','null','404',3),(84,'0:0:0:0:0:0:0:1','/error',NULL,'GET','{}','DA3C2170019574F56A8C3C4D87FACF1D','2018-03-31 16:50:18','1522486218596','null','404',3),(85,'0:0:0:0:0:0:0:1','/user/index',NULL,'GET','{}','DB824B157C76DF08BF79D9C174E82F4A','2018-03-31 16:55:38','1522486538733','null','200',250),(86,'0:0:0:0:0:0:0:1','/error',NULL,'GET','{}','DB824B157C76DF08BF79D9C174E82F4A','2018-03-31 16:55:39','1522486539287','null','404',503),(87,'0:0:0:0:0:0:0:1','/error',NULL,'GET','{}','DB824B157C76DF08BF79D9C174E82F4A','2018-03-31 16:55:45','1522486545704','null','404',28),(88,'0:0:0:0:0:0:0:1','/user/index',NULL,'GET','{}','699A2CEF3468594EF66C3F30F9FFD7C5','2018-03-31 16:56:54','1522486614855','null','200',435),(89,'0:0:0:0:0:0:0:1','/error',NULL,'GET','{}','699A2CEF3468594EF66C3F30F9FFD7C5','2018-03-31 16:56:55','1522486615009','null','404',90),(90,'0:0:0:0:0:0:0:1','/error',NULL,'GET','{}','699A2CEF3468594EF66C3F30F9FFD7C5','2018-03-31 16:57:01','1522486621410','null','404',33),(91,'0:0:0:0:0:0:0:1','/user/index',NULL,'GET','{}','F8A841C728A3CC497928ECC532C045F4','2018-03-31 17:04:07','1522487047757','null','200',330),(92,'0:0:0:0:0:0:0:1','/error',NULL,'GET','{}','F8A841C728A3CC497928ECC532C045F4','2018-03-31 17:04:07','1522487047882','null','404',61),(93,'0:0:0:0:0:0:0:1','/user/index',NULL,'GET','{}','E64AE27B51B2098E63F825C644D82B97','2018-03-31 17:06:03','1522487163274','null','200',310),(94,'0:0:0:0:0:0:0:1','/error',NULL,'GET','{}','E64AE27B51B2098E63F825C644D82B97','2018-03-31 17:06:23','1522487183655','null','404',308),(95,'0:0:0:0:0:0:0:1','/user/index',NULL,'GET','{}','E64AE27B51B2098E63F825C644D82B97','2018-03-31 17:06:53','1522487213353','null','200',4),(96,'0:0:0:0:0:0:0:1','/error',NULL,'GET','{}','E64AE27B51B2098E63F825C644D82B97','2018-03-31 17:07:42','1522487262782','null','404',6),(97,'0:0:0:0:0:0:0:1','/user/index',NULL,'GET','{}','6C428F6E602824656804CFF00B5D12FF','2018-03-31 17:09:38','1522487378030','null','200',268),(98,'0:0:0:0:0:0:0:1','/user/index',NULL,'GET','{}','F4D5228C50E42FBF2609511B5250A8CE','2018-03-31 17:13:13','1522487593024','null','200',236),(99,'0:0:0:0:0:0:0:1','/error',NULL,'GET','{}','F4D5228C50E42FBF2609511B5250A8CE','2018-03-31 17:13:16','1522487596756','null','404',26),(100,'0:0:0:0:0:0:0:1','/user/index',NULL,'GET','{}','581FC6EAB30D5DEC0B0EDB1294733E40','2018-03-31 17:15:04','1522487704916','null','200',290),(101,'0:0:0:0:0:0:0:1','/user/index',NULL,'GET','{}','581FC6EAB30D5DEC0B0EDB1294733E40','2018-03-31 17:16:47','1522487807418','null','200',0),(102,'0:0:0:0:0:0:0:1','/error',NULL,'GET','{}','581FC6EAB30D5DEC0B0EDB1294733E40','2018-03-31 17:17:07','1522487827607','null','404',41);

/*Table structure for table `users` */

DROP TABLE IF EXISTS `users`;

CREATE TABLE `users` (
  `USERNAME` varchar(40) NOT NULL,
  `IDENTITY` varchar(20) NOT NULL,
  `FULLNAME` varchar(20) NOT NULL,
  `SEX` varchar(10) NOT NULL,
  `ADDRESS` varchar(40) NOT NULL,
  `PHONE` varchar(20) NOT NULL,
  `POSITION` varchar(20) NOT NULL,
  `USERLEVEL` decimal(8,0) NOT NULL,
  `USERPWD` varchar(40) NOT NULL,
  PRIMARY KEY (`USERNAME`),
  KEY `USERS_UK` (`IDENTITY`),
  KEY `USERS_FK` (`USERLEVEL`),
  CONSTRAINT `USERS_FK` FOREIGN KEY (`USERLEVEL`) REFERENCES `roles` (`ROLEID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `users` */

insert  into `users`(`USERNAME`,`IDENTITY`,`FULLNAME`,`SEX`,`ADDRESS`,`PHONE`,`POSITION`,`USERLEVEL`,`USERPWD`) values ('1231','王教授123','1235','男','1231','12131213','123512','10','123'),('3241234','王教授asd','12351232','男','1532','41512','1235','11','123'),('43242','2345236234','24623','男','2362345','23623','26','1','123'),('admin','111111111111111111','admin','男','北京','1112222211','Manager','1','a1231'),('小六','1223421123423','刘川枫','男','北京','12312312312','java架构师','10','123'),('小李','311324523','里斯','男','北京','12315325321','学生','10','123'),('小王','12132451523421341','王晓','女','北京通州','13358748374','学生','28','1'),('阿三','12131124312141','张三','男','北京','12312312312','java工程师','28','1Aa12_dss');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;