You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
194 lines
8.3 KiB
194 lines
8.3 KiB
/*
|
|
Navicat MySQL Data Transfer
|
|
|
|
Source Server : localhost_3306
|
|
Source Server Version : 50719
|
|
Source Host : localhost:3306
|
|
Source Database : ssm_hotel
|
|
|
|
Target Server Type : MYSQL
|
|
Target Server Version : 50719
|
|
File Encoding : 65001
|
|
|
|
Date: 2022-04-21 20:37:33
|
|
*/
|
|
|
|
SET FOREIGN_KEY_CHECKS=0;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for `dept_table`
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `dept_table`;
|
|
CREATE TABLE `dept_table` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`deptname` varchar(255) NOT NULL COMMENT '部门名称',
|
|
`address` varchar(255) NOT NULL COMMENT '部门地址',
|
|
`remark` text COMMENT '备注',
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
|
|
|
|
-- ----------------------------
|
|
-- Records of dept_table
|
|
-- ----------------------------
|
|
INSERT INTO `dept_table` VALUES ('1', '测试部', '云南省昭通市', '好像都错了');
|
|
INSERT INTO `dept_table` VALUES ('2', '测试部', '云南省昭通市', '什么也');
|
|
INSERT INTO `dept_table` VALUES ('3', '信息部', '楚雄', '尚硅谷');
|
|
INSERT INTO `dept_table` VALUES ('4', '技术部', '云南省', '33');
|
|
INSERT INTO `dept_table` VALUES ('5', '工程部', '东门', '');
|
|
INSERT INTO `dept_table` VALUES ('6', '测试部', '西门', '');
|
|
|
|
-- ----------------------------
|
|
-- Table structure for `employee_table`
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `employee_table`;
|
|
CREATE TABLE `employee_table` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户编号',
|
|
`username` varchar(100) NOT NULL COMMENT '用户名',
|
|
`password` varchar(100) NOT NULL COMMENT '登录密码',
|
|
`name` varchar(20) NOT NULL COMMENT '用户姓名',
|
|
`sex` varchar(5) DEFAULT NULL COMMENT '性别',
|
|
`deptId` int(11) DEFAULT NULL COMMENT '所在部门编号',
|
|
`hiredate` varchar(100) DEFAULT NULL COMMENT '入职时间',
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
|
|
|
|
-- ----------------------------
|
|
-- Records of employee_table
|
|
-- ----------------------------
|
|
INSERT INTO `employee_table` VALUES ('1', 'xyp1', '202cb962ac59075b964b07152d234b70', '谢应鹏', '男', '3', '2022年');
|
|
INSERT INTO `employee_table` VALUES ('8', 'xypp', '345', 'ss', '男', '1', '2022年');
|
|
INSERT INTO `employee_table` VALUES ('11', 'hh', '123', '解决', '男', '2', '2022年');
|
|
INSERT INTO `employee_table` VALUES ('12', '谢应鹏', 'kk', '哈哈', '男', '2', '2022年');
|
|
INSERT INTO `employee_table` VALUES ('14', 'xx', '202cb962ac59075b964b07152d234b70', '谢应鹏', '男', '3', '2022年');
|
|
|
|
-- ----------------------------
|
|
-- Table structure for `floor_table`
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `floor_table`;
|
|
CREATE TABLE `floor_table` (
|
|
`id` int(10) NOT NULL COMMENT '楼层号',
|
|
`name` varchar(100) DEFAULT NULL COMMENT '楼层名称',
|
|
`remark` varchar(100) DEFAULT NULL COMMENT '备注',
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
|
|
-- ----------------------------
|
|
-- Records of floor_table
|
|
-- ----------------------------
|
|
INSERT INTO `floor_table` VALUES ('2', '2楼', '旅馆2楼');
|
|
INSERT INTO `floor_table` VALUES ('3', '3楼', '东方向');
|
|
INSERT INTO `floor_table` VALUES ('4', '4楼', '酒店4楼');
|
|
|
|
-- ----------------------------
|
|
-- Table structure for `front_user`
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `front_user`;
|
|
CREATE TABLE `front_user` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`username` varchar(200) DEFAULT NULL,
|
|
`phone` varchar(11) DEFAULT NULL,
|
|
`password` varchar(100) DEFAULT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
|
|
|
|
-- ----------------------------
|
|
-- Records of front_user
|
|
-- ----------------------------
|
|
INSERT INTO `front_user` VALUES ('1', 'xyp', '15284524485', '123');
|
|
INSERT INTO `front_user` VALUES ('2', '谢应鹏', '15284524486', '202cb962ac59075b964b07152d234b70');
|
|
INSERT INTO `front_user` VALUES ('3', '谢应鹏1', '15284524485', '202cb962ac59075b964b07152d234b70');
|
|
|
|
-- ----------------------------
|
|
-- Table structure for `roomtype_table`
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `roomtype_table`;
|
|
CREATE TABLE `roomtype_table` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '房型编号',
|
|
`roomname` varchar(100) NOT NULL COMMENT '房型名称',
|
|
`price` double(11,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(200) DEFAULT NULL COMMENT '备注',
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;
|
|
|
|
-- ----------------------------
|
|
-- Records of roomtype_table
|
|
-- ----------------------------
|
|
INSERT INTO `roomtype_table` VALUES ('1', '单人间', '200.00', '2', '1', '20', '12', '20', '3', '2', null);
|
|
INSERT INTO `roomtype_table` VALUES ('2', '双人间', '66.00', '20', '12', '7', null, '7', null, '2', '');
|
|
INSERT INTO `roomtype_table` VALUES ('3', '标准间', '44.00', '8', '1', '7', null, null, null, '1', '');
|
|
INSERT INTO `roomtype_table` VALUES ('22', '总体套房', '888.00', '2', '2', '4', null, '4', null, '1', '');
|
|
|
|
-- ----------------------------
|
|
-- Table structure for `room_table`
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `room_table`;
|
|
CREATE TABLE `room_table` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`roomid` int(11) NOT NULL COMMENT '房间编号',
|
|
`typename` varchar(50) DEFAULT NULL COMMENT '房间类型',
|
|
`floorname` varchar(50) DEFAULT NULL COMMENT '所属楼层',
|
|
`status` int(4) DEFAULT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
|
|
|
|
-- ----------------------------
|
|
-- Records of room_table
|
|
-- ----------------------------
|
|
INSERT INTO `room_table` VALUES ('1', '20013', '总体套房', '2楼', '3');
|
|
INSERT INTO `room_table` VALUES ('4', '20012', '双人间', '2楼', '2');
|
|
|
|
-- ----------------------------
|
|
-- Table structure for `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(200) DEFAULT NULL COMMENT '菜单名称',
|
|
`href` varchar(200) DEFAULT NULL COMMENT '打开链接地址',
|
|
`spread` int(11) DEFAULT NULL COMMENT '是否展开 0 不1 展示',
|
|
`target` varchar(100) DEFAULT NULL COMMENT '打开方式',
|
|
`icon` varchar(255) DEFAULT NULL COMMENT '菜单图标',
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
|
|
|
|
-- ----------------------------
|
|
-- Records of sys_menu
|
|
-- ----------------------------
|
|
INSERT INTO `sys_menu` VALUES ('1', '0', '系统管理', null, '1', 'self', 'fa fa-user');
|
|
INSERT INTO `sys_menu` VALUES ('2', '0', '客房管理', null, '1', 'self', 'fa fa-user');
|
|
INSERT INTO `sys_menu` VALUES ('4', '2', '房间类型', null, '1', 'self', 'fa fa-user');
|
|
INSERT INTO `sys_menu` VALUES ('5', '1', '部门管理', '/admin/ToDeptManage', '1', 'self', 'fa fa-user');
|
|
INSERT INTO `sys_menu` VALUES ('6', '1', '员工管理', null, '1', 'self', 'fa fa-user');
|
|
INSERT INTO `sys_menu` VALUES ('7', '1', '系统设置', null, '1', 'self', 'fa fa-user');
|
|
|
|
-- ----------------------------
|
|
-- Table structure for `user_table`
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `user_table`;
|
|
CREATE TABLE `user_table` (
|
|
`id` varchar(11) NOT NULL COMMENT '员工编号',
|
|
`empname` varchar(100) DEFAULT NULL COMMENT '员工姓名',
|
|
`sex` varchar(10) DEFAULT NULL,
|
|
`deptname` varchar(100) DEFAULT NULL,
|
|
`address` varchar(200) DEFAULT NULL,
|
|
`hireDate` varchar(100) DEFAULT NULL,
|
|
`remark` varchar(200) DEFAULT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
|
|
-- ----------------------------
|
|
-- Records of user_table
|
|
-- ----------------------------
|
|
INSERT INTO `user_table` VALUES ('20221', '成成', '女', '财务部', '云南省', '2022年', '');
|
|
INSERT INTO `user_table` VALUES ('2022112', '航嘉', '女', '信息部', '云南省', '2019年', '');
|
|
INSERT INTO `user_table` VALUES ('2022113', '康熙', '男', '技术部', '云南省', '2022年', '');
|
|
INSERT INTO `user_table` VALUES ('235533', '湖广会馆', '女', '技术部', '同意后', '644', '');
|