springboot+vue酒店预约管理系统

/* Navicat MySQL Data Transfer Source Server : localhost_3306 Source Server Version : 80025 Source Host : localhost:3306 Source Database : qing Target Server Type : MYSQL Target Server Version : 80025 File Encoding : 65001 Date: 2022-07-04 16:22:27 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for quit -- ---------------------------- DROP TABLE IF EXISTS `quit`; CREATE TABLE `quit` ( `id` int NOT NULL AUTO_INCREMENT, `nick_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `phone` varchar(255) DEFAULT NULL, `note` varchar(255) DEFAULT NULL, `id_user` int DEFAULT NULL, `create_time` datetime DEFAULT NULL, `state` int DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- ---------------------------- -- Records of quit -- ---------------------------- INSERT INTO `quit` VALUES ('20', 'xiaohei', '[email protected]', '15545', '3', '38', '2022-05-14 09:15:42', '0'); -- ---------------------------- -- Table structure for reserve -- ---------------------------- DROP TABLE IF EXISTS `reserve`; CREATE TABLE `reserve` ( `id` int NOT NULL AUTO_INCREMENT, `id_user` int DEFAULT NULL, `nick_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `phone` varchar(255) DEFAULT NULL, `classify` varchar(255) DEFAULT NULL, `room_price` int DEFAULT NULL, `create_time` datetime DEFAULT NULL, `state` int DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- ---------------------------- -- Records of reserve -- ---------------------------- INSERT INTO `reserve` VALUES ('14', '17', '哈哈', '33333', '豪华间', '400', '2022-05-09 23:39:02', '2'); -- ---------------------------- -- Table structure for room -- ---------------------------- DROP TABLE IF EXISTS `room`; CREATE TABLE `room` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '房间名字', `room_no` varchar(255) DEFAULT NULL COMMENT '房间号', `price` int DEFAULT NULL COMMENT '价格', `floor` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '楼层', `classify` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '分类', `note` varchar(255) DEFAULT NULL COMMENT '描述', `state` int DEFAULT NULL COMMENT '状态', `img` varchar(255) DEFAULT NULL COMMENT '图片展示', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- ---------------------------- -- Records of room -- ---------------------------- INSERT INTO `room` VALUES ('17', '标准间01', '22', '2', '2', '标准间', '2', '0', '[\"http://localhost:9090/file/222314d37a264ce1aa9e7c262b11b932\"]'); INSERT INTO `room` VALUES ('18', '双人间01', '2', '2', '2', '豪华间', '2', '0', '[\"http://localhost:9090/file/a0e1082a01184f88a888b3e5070d2e5c\"]'); INSERT INTO `room` VALUES ('20', '豪华间01', '33', '333', '33', '双人间', '33', '0', '[\"http://localhost:9090/file/ce681b73f6f64f7f9fb8f2cab00c0437\",\"http://localhost:9090/file/985ad2e36ce247afbdad32bac0d29995\"]'); -- ---------------------------- -- Table structure for sys_dict -- ---------------------------- DROP TABLE IF EXISTS `sys_dict`; CREATE TABLE `sys_dict` ( `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '名称', `value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '内容', `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '类型' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of sys_dict -- ---------------------------- INSERT INTO `sys_dict` VALUES ('user', 'el-icon-user', 'icon'); INSERT INTO `sys_dict` VALUES ('house', 'el-icon-house', 'icon'); INSERT INTO `sys_dict` VALUES ('menu', 'el-icon-menu', 'icon'); INSERT INTO `sys_dict` VALUES ('s-custom', 'el-icon-s-custom', 'icon'); INSERT INTO `sys_dict` VALUES ('s-grid', 'el-icon-s-grid', 'icon'); INSERT INTO `sys_dict` VALUES ('document', 'el-icon-document', 'icon'); INSERT INTO `sys_dict` VALUES ('coffee', 'el-icon-coffee\r\n', 'icon'); INSERT INTO `sys_dict` VALUES ('s-marketing', 'el-icon-s-marketing', 'icon'); -- ---------------------------- -- Table structure for sys_menu -- ---------------------------- DROP TABLE IF EXISTS `sys_menu`; CREATE TABLE `sys_menu` ( `id` int NOT NULL AUTO_INCREMENT COMMENT 'id', `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '名称', `path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '路径', `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '图标', `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '描述', `pid` int DEFAULT NULL COMMENT '父级id', `page_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '页面路径', `sort_num` int DEFAULT NULL COMMENT '排序', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of sys_menu -- ---------------------------- INSERT INTO `sys_menu` VALUES ('4', '系统管理', null, 'el-icon-s-grid', null, null, null, '300'); INSERT INTO `sys_menu` VALUES ('5', '用户管理', '/user', 'el-icon-user', null, '4', 'User', '301'); INSERT INTO `sys_menu` VALUES ('6', '角色管理', '/role', 'el-icon-s-custom', null, '4', 'Role', '302'); INSERT INTO `sys_menu` VALUES ('7', '菜单管理', '/menu', 'el-icon-menu', null, '4', 'Menu', '303'); INSERT INTO `sys_menu` VALUES ('10', '主页', '/home', 'el-icon-house', null, null, 'Home', '0'); INSERT INTO `sys_menu` VALUES ('43', '客房管理', '/room', 'el-icon-house', null, null, 'Room', '1'); INSERT INTO `sys_menu` VALUES ('44', '员工管理', '/employer', 'el-icon-user', null, null, 'Employer', '2'); INSERT INTO `sys_menu` VALUES ('45', '预定管理', '/reserve', 'el-icon-document', null, null, 'Reserve', '3'); INSERT INTO `sys_menu` VALUES ('46', '修改密码', '/password', 'el-icon-s-marketing', null, '4', 'Password', '305'); INSERT INTO `sys_menu` VALUES ('49', '离职申请', '/leave', 'el-icon-s-marketing', null, '4', 'Leave', '2222'); -- ---------------------------- -- Table structure for sys_role -- ---------------------------- DROP TABLE IF EXISTS `sys_role`; CREATE TABLE `sys_role` ( `id` int NOT NULL AUTO_INCREMENT COMMENT 'id', `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '名称', `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '描述', `flag` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '唯一标识', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of sys_role -- ---------------------------- INSERT INTO `sys_role` VALUES ('1', '管理员', '管理员', 'ROLE_ADMIN'); INSERT INTO `sys_role` VALUES ('2', '员工', '员工', 'ROLE_EMPLOYEE'); INSERT INTO `sys_role` VALUES ('3', '用户', '用户', 'ROLE_USER'); -- ---------------------------- -- Table structure for sys_role_menu -- ---------------------------- DROP TABLE IF EXISTS `sys_role_menu`; CREATE TABLE `sys_role_menu` ( `role_