/*
SQLyog Enterprise v13.1.1 (64 bit)
MySQL - 5.7.19 : Database - templatedb
*********************************************************************
*/

/*!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*/`templatedb` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci */;

USE `templatedb`;

/*Table structure for table `sys_dept` */

DROP TABLE IF EXISTS `sys_dept`;

CREATE TABLE `sys_dept` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '部门编号',
  `deptName` varchar(50) DEFAULT NULL COMMENT '部门名称',
  `address` varchar(255) DEFAULT NULL COMMENT '地址',
  `createDate` datetime DEFAULT NULL COMMENT '创建时间',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;

/*Data for the table `sys_dept` */

insert  into `sys_dept`(`id`,`deptName`,`address`,`createDate`,`remark`) values 
(1,'管理部','河南安阳林州市','2021-11-03 22:01:25','河南安阳林州市'),
(2,'保卫处','安阳市林州市太行路225号',NULL,'林州市红旗渠灌区管理处分水岭管理所'),
(3,'观光处','安阳林州观演广场',NULL,'休闲中心'),
(4,'纪念区','安阳市林州市红旗渠·分水苑(228省道东)分水苑内',NULL,'红旗渠纪念碑管辖中心'),
(5,'讲堂区','红旗渠·分水苑内',NULL,'廉政讲堂'),
(6,'民宿区','井头村228省道兄弟快餐西150米路南',NULL,'红旗渠印象民宿'),
(7,'络丝潭','任村镇红旗渠风景区络丝潭',NULL,'络丝潭景区'),
(8,'长生寺处','涉县合漳乡张头村',NULL,'长生寺庙'),
(9,'旅游超市','S228红旗渠风景区内',NULL,'旅游超市中心'),
(10,'志愿服务站','安阳市林州市红旗渠景区内',NULL,'志愿者！'),
(11,'红旗渠兴鑫农家乐','红旗渠青年洞卢家拐村',NULL,'农家乐'),
(12,'观光车售票处','安阳市林州市红旗渠景区内',NULL,'观光车售票处'),
(13,'青年洞-售票处','任村镇卢家拐村西','2021-11-21 03:19:46','红旗渠青年洞-售票处');

/*Table structure for table `sys_employee` */

DROP TABLE IF EXISTS `sys_employee`;

CREATE TABLE `sys_employee` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '员工编号',
  `loginname` varchar(50) DEFAULT NULL COMMENT '登录账号',
  `loginpwd` varchar(200) DEFAULT NULL COMMENT '登录密码',
  `name` varchar(50) DEFAULT NULL COMMENT '真实姓名',
  `sex` int(11) DEFAULT NULL COMMENT '性别（1-男 2-女）',
  `deptId` int(11) DEFAULT NULL COMMENT '部门编号',
  `hiredate` datetime DEFAULT NULL COMMENT '入职日期',
  `salt` varchar(100) DEFAULT NULL COMMENT '加密盐值',
  `createdBy` int(11) DEFAULT NULL COMMENT '创建人',
  `createDate` datetime DEFAULT NULL COMMENT '创建时间',
  `modifyBy` int(11) DEFAULT NULL COMMENT '修改人',
  `modifyDate` datetime DEFAULT NULL COMMENT '修改时间',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;

/*Data for the table `sys_employee` */

insert  into `sys_employee`(`id`,`loginname`,`loginpwd`,`name`,`sex`,`deptId`,`hiredate`,`salt`,`createdBy`,`createDate`,`modifyBy`,`modifyDate`,`remark`) values 
(1,'admin','2e629a6eeff78cd6a7512dc84ac24cf4','超级管理员',2,1,'2021-09-29 16:00:00','2e26150ca6cc4f7e83e894bb7e4aaadc',1,'2021-09-29 16:31:38',1,'2021-11-21 02:26:51','123'),
(2,'tom','e97f430306528925a81c73b4932cbdb6','汤姆',1,1,'2021-10-06 16:00:00','211d5006f25f4b7e9ab9b20721e709c8',1,'2021-10-07 01:39:15',NULL,NULL,''),
(3,'Jerry','91e776b66606f22aabd10be2c174ec98','杰瑞',1,2,'2018-08-29 16:00:00','88d8e83026194ebfb1bb767a4ac269f3',1,'2021-11-21 03:02:17',NULL,NULL,'杰瑞很聪明'),
(4,'shaoerkuai','f51d0450878df4fa2713f3d211d32f79','烧饵块',1,1,'2016-11-01 16:00:00','7af3e4577cc44e46bf50175593af2a63',1,'2021-11-21 03:03:19',NULL,NULL,'烧饵块是老员工了'),
(5,'fenzhengrou','334e2ef4d9b452f4e9ce8ac5b470e39e','粉蒸肉',1,3,'2007-11-08 16:00:00','d0dfa7f415cd4a54a20e244e58d635a5',1,'2021-11-21 03:04:42',1,'2021-11-21 03:04:55','粉蒸肉贼能吃'),
(6,'laoyoutiao','851f363f98904742839af72a684daf0e','老油条',1,4,'2021-11-20 16:00:00','89339851373d4d309bb95c6f6eae0d94',1,'2021-11-21 03:05:25',NULL,NULL,'老油条贼有钱'),
(7,'mike','622d6a23eb9b96b90d453fa4e0428389','麦克',1,4,'2020-08-31 16:00:00','309728345ede496388717f886cc09445',1,'2021-11-21 03:50:00',NULL,NULL,'麦克帅！'),
(8,'jiujiu','7a7cd00aa69b67f60634c2192e3d472c','啾啾',1,4,'2021-11-20 16:00:00','32fd53122c5541a3bb3f00e9020e717f',1,'2021-11-21 03:52:03',1,'2021-11-21 03:56:56','啾啾和麦克是爱宠大机密的角色，麦克的邻居，小博美啾啾暗恋着麦克，'),
(9,'xiaobai','ab07d18040928122c19926bd327272f0','小白',1,1,'2010-11-02 16:00:00','29c28ba15b3e4257837d2520dd32bec4',1,'2021-11-21 03:53:24',NULL,NULL,'纽约城里被遗弃宠物大军的带头大哥'),
(10,'gongjue','f79d1bbc01b17cab3b4e0831f0e1f801','公爵',1,2,'2021-02-02 16:00:00','c194ebdc1480433fb41a93c02de5ad7c',1,'2021-11-21 03:53:56',NULL,NULL,'麦克的主人凯蒂带回来的狗，一只名叫公爵的长毛狗。'),
(11,'bingbing','db23da3f227add6bd5b79f3973d942c0','冰冰',2,3,'2017-03-14 16:00:00','4efa556b892d4be2aac5b9f84a50edde',1,'2021-11-21 03:54:29',NULL,NULL,'麦克的好伙伴，一只贪吃的猫。'),
(12,'damao','e6540a97398f4962036bc330838041ed','大毛',1,5,'2021-11-15 16:00:00','0c7bf664801f4054bae293dc68d699c9',1,'2021-11-21 03:54:49',NULL,NULL,'麦克的好伙伴，脾气急躁的家伙。'),
(13,'liyunlong','768939faab2733408708e1944b25f138','李云龙',1,10,'2021-11-01 16:00:00','ab967714c40b447cbdac5ac3103eaeec',1,'2021-11-21 03:58:51',NULL,NULL,'李云龙是个志愿者'),
(14,'zhangdabiao','2b1fcc140aa1e7265d6344281ad0118b','张大彪',1,10,'2018-10-31 16:00:00','153b94bf9d654cecaf9952e95960c192',1,'2021-11-21 03:59:34',NULL,NULL,'张大彪和李云龙一样'),
(15,'heshang','833193c2cfb8c63d99121a705c71fa93','和尚',1,NULL,'2014-10-28 16:00:00','3b94b02fa2fe4ab7b8903f2f7131ee34',1,'2021-11-21 04:00:11',NULL,NULL,'和尚'),
(16,'heshang','e69aeb376c05eb8620a056a0c631f404','和尚',1,13,'2021-11-22 16:00:00','30377ae69c5c49668644f174a3b0c279',1,'2021-11-21 04:00:43',NULL,NULL,'和尚售票'),
(17,'xusanduo','b13efda0eb0eeb1f5eb0cb24419422f5','许三多',1,2,'2010-03-16 16:00:00','b30cbd61ed834dd8b29314145967ea3b',1,'2021-11-21 04:01:27',NULL,NULL,'许三多牛！'),
(18,'wuliuyi','8942eaeb5c1f9a1a30cefe82c935ff4b','伍六一',1,2,'2021-10-31 16:00:00','24ae3537d8284af0aaf140abc2777675',1,'2021-11-21 04:01:42',NULL,NULL,'伍六一'),
(19,'yuanlang','797aa1da1df8c5727ead26d8113fa23e','袁朗',1,7,'2021-11-15 16:00:00','9072e30f3dfd4c11bb4d73d5a136931c',1,'2021-11-21 04:02:06',NULL,NULL,'老A');

/*Table structure for table `sys_menu` */

DROP TABLE IF EXISTS `sys_menu`;

CREATE TABLE `sys_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '菜单编号',
  `pid` int(11) DEFAULT NULL COMMENT '所属父级菜单',
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '菜单名称',
  `href` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '链接',
  `spread` int(11) DEFAULT NULL COMMENT '是否展开菜单(0表示不展开)',
  `target` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '链接打开方式',
  `icon` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '菜单图标样式',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*Data for the table `sys_menu` */

insert  into `sys_menu`(`id`,`pid`,`title`,`href`,`spread`,`target`,`icon`) values 
(1,0,'系统管理',NULL,1,'_self','fa fa-users'),
(2,0,'旅游住宿',NULL,1,'_self','fa fa-bed'),
(3,1,'红旗员工','/admin/toEmployeeManager',0,'_self','fa fa-users'),
(4,1,'部门分配','/admin/toDeptManager',0,'_self','fa fa-drivers-license'),
(5,2,'房型管理','/admin/toRoomTypeManager',0,'_self','fa fa-bullseye'),
(6,2,'房间管理','/admin/toRoomManager',0,'_self','fa fa-american-sign-language-interpreting'),
(7,1,'权限分配','/admin/toRoleManager',0,'_self','fa fa-address-book-o'),
(8,1,'菜单管理','/admin/tomenuManager',0,'_self','fa fa-briefcase'),
(10,2,'楼层管理','/admin/toFloorManager',0,'_self','fa fa-align-left');

/*Table structure for table `sys_role` */

DROP TABLE IF EXISTS `sys_role`;

CREATE TABLE `sys_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rolename` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `roledesc` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*Data for the table `sys_role` */

insert  into `sys_role`(`id`,`rolename`,`roledesc`) values 
(1,'超级管理员','拥有所有操作权限'),
(2,'系统管理员','拥有系统管理操作权限'),
(3,'民宿老板','开设自己的小民宿'),
(4,'保卫处','红旗渠安保守卫'),
(5,'青年洞售票中心','青年洞售票处'),
(6,'游船码头售票处','游船码头售票处'),
(7,'观景台','观演中心'),
(8,'志愿服务处','志愿者'),
(9,'文物维护部','维护文物古迹'),
(10,'清洁部','负责场地清洁');

/*Table structure for table `sys_role_employee` */

DROP TABLE IF EXISTS `sys_role_employee`;

CREATE TABLE `sys_role_employee` (
  `eid` int(11) NOT NULL COMMENT '员工编号',
  `rid` int(11) NOT NULL COMMENT '角色编号'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*Data for the table `sys_role_employee` */

insert  into `sys_role_employee`(`eid`,`rid`) values 
(1,1),
(2,3),
(4,2);

/*Table structure for table `sys_role_menu` */

DROP TABLE IF EXISTS `sys_role_menu`;

CREATE TABLE `sys_role_menu` (
  `mid` int(11) NOT NULL COMMENT '菜单编号',
  `rid` int(11) NOT NULL COMMENT '角色编号'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `sys_role_menu` */

insert  into `sys_role_menu`(`mid`,`rid`) values 
(2,3),
(5,3),
(6,3),
(10,3),
(1,2),
(7,2),
(8,2),
(1,1),
(3,1),
(4,1),
(7,1),
(8,1),
(2,1),
(5,1),
(6,1),
(10,1),
(30,1),
(35,1),
(36,1),
(9,1),
(32,1),
(33,1),
(34,1),
(37,1),
(11,1),
(12,1),
(13,1),
(14,1),
(15,1),
(16,1),
(18,1),
(38,1),
(39,1),
(19,1),
(20,1),
(21,1),
(22,1),
(23,1),
(24,1),
(25,1),
(26,1),
(27,1),
(40,1),
(29,1),
(31,1);

/*Table structure for table `t_floor` */

DROP TABLE IF EXISTS `t_floor`;

CREATE TABLE `t_floor` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `name` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '楼层名称',
  `remark` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*Data for the table `t_floor` */

insert  into `t_floor`(`id`,`name`,`remark`) values 
(1,'1楼','汤臣一品'),
(3,'2楼','汤臣二品'),
(4,'3楼','汤臣四品'),
(5,'4楼','汤臣三品');

/*Table structure for table `t_room` */

DROP TABLE IF EXISTS `t_room`;

CREATE TABLE `t_room` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `photo` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '房间图片',
  `roomNum` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '房间编号',
  `roomTypeId` int(11) DEFAULT NULL COMMENT '房型',
  `floorId` int(11) DEFAULT NULL COMMENT '所属楼层',
  `status` int(11) DEFAULT NULL COMMENT '状态',
  `roomDesc` text COLLATE utf8_bin COMMENT '房间描述',
  `roomRequirement` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '要求',
  `remark` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*Data for the table `t_room` */

insert  into `t_room`(`id`,`photo`,`roomNum`,`roomTypeId`,`floorId`,`status`,`roomDesc`,`roomRequirement`,`remark`) values 
(1,'1','1',3,1,1,'<u>这个房间不错</u>','无要求',NULL),
(2,'images/defaultimg.jpg','101',2,1,1,'',NULL,'1'),
(3,'images/defaultimg.jpg','1011',2,3,1,'',NULL,'1'),
(4,'images/defaultimg.jpg','10',2,1,1,'','测试','测试'),
(5,'2021-10-09/ed67e1ee50f1453a842b67f2d88987ed.jpg','123',2,4,3,'<img src=\"http://localhost:8080/statics/layui/lib/layui-v2.5.5/images/face/27.gif\" alt=\"[疑问]\">','测试','测试1');

/*Table structure for table `t_room_type` */

DROP TABLE IF EXISTS `t_room_type`;

CREATE TABLE `t_room_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '房型编号',
  `typeName` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '房型名称',
  `photo` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '房型图片',
  `price` decimal(8,2) DEFAULT NULL COMMENT '参考价格',
  `liveNum` int(11) DEFAULT NULL COMMENT '可入住人数',
  `bedNum` int(11) DEFAULT NULL COMMENT '床位数',
  `roomNum` int(11) DEFAULT NULL COMMENT '房间数量',
  `reservedNum` int(11) DEFAULT NULL COMMENT '已预定数量',
  `avilableNum` int(11) DEFAULT NULL COMMENT '可住房间数',
  `livedNum` int(11) DEFAULT NULL COMMENT '已入住数量',
  `status` int(11) DEFAULT NULL COMMENT '房型状态',
  `remark` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*Data for the table `t_room_type` */

insert  into `t_room_type`(`id`,`typeName`,`photo`,`price`,`liveNum`,`bedNum`,`roomNum`,`reservedNum`,`avilableNum`,`livedNum`,`status`,`remark`) values 
(2,'单人间','images/defaultimg.jpg',200.00,2,1,20,12,20,0,1,'无'),
(3,'双人间','images/defaultimg.jpg',300.00,2,2,20,13,20,0,1,'无'),
(4,'标准间','images/defaultimg.jpg',300.00,2,1,20,4,20,0,1,'无'),
(5,'商务间','images/defaultimg.jpg',400.00,1,1,20,2,20,0,1,'无'),
(6,'大林的房子','images/defaultimg.jpg',10000.00,8,10,10,1,10,0,1,'无'),
(7,'豪华套房','images/defaultimg.jpg',10000.00,8,10,10,8,10,0,1,'豪华套房'),
(8,'一室一厅','images/defaultimg.jpg',200.00,2,2,10,29,10,0,1,'一室一厅'),
(9,'大床房','images/defaultimg.jpg',500.00,5,5,5,5,5,5,1,'大床房'),
(10,'带阳台大床房','images/defaultimg.jpg',600.00,5,5,5,5,5,5,1,'带阳台大床房'),
(11,'亲子套房','images/defaultimg.jpg',300.00,3,3,12,13,35,0,1,'亲子套房'),
(12,'漫威主题','images/defaultimg.jpg',680.00,5,5,5,5,5,0,1,'漫威主题'),
(13,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

/*Table structure for table `t_user` */

DROP TABLE IF EXISTS `t_user`;

CREATE TABLE `t_user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '用户编号',
  `loginName` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '登录账号',
  `password` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '登录密码',
  `realName` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '真实姓名',
  `idCard` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '身份证号码',
  `phone` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '电话号码',
  `email` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '邮箱',
  `status` int(11) DEFAULT NULL COMMENT '状态1-可用 0-异常',
  `createDate` datetime DEFAULT NULL COMMENT '注册时间',
  `salt` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '盐值',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*Data for the table `t_user` */

insert  into `t_user`(`id`,`loginName`,`password`,`realName`,`idCard`,`phone`,`email`,`status`,`createDate`,`salt`) values 
(1,'zhangsan','49ace71310721e9cadc8b5f88d02a04d',NULL,NULL,'15691368177',NULL,NULL,NULL,'6aa74934bb9d4f689cf1e1b58e2e35d2');

/*!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 */;