/*
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 `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 ('11231','王教授112','1235','男','32412','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 */;