/*
Navicat MySQL Data Transfer

Source Server         : onlyone
Source Server Version : 50730
Source Host           : localhost:3306
Source Database       : javaee_work

Target Server Type    : MYSQL
Target Server Version : 50730
File Encoding         : 65001

Date: 2020-09-02 22:23:22
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `admin`
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
  `a_id` int(11) NOT NULL AUTO_INCREMENT,
  `a_name` varchar(32) NOT NULL COMMENT '管理员名称',
  `a_pwd` varchar(32) NOT NULL COMMENT '管理员密码',
  PRIMARY KEY (`a_id`)
) ENGINE=InnoDB AUTO_INCREMENT=103 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES ('101', 'root', '123');

-- ----------------------------
-- Table structure for `department`
-- ----------------------------
DROP TABLE IF EXISTS `department`;
CREATE TABLE `department` (
  `d_id` int(11) NOT NULL AUTO_INCREMENT,
  `d_name` varchar(32) NOT NULL COMMENT '部门名称',
  PRIMARY KEY (`d_id`)
) ENGINE=InnoDB AUTO_INCREMENT=403 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of department
-- ----------------------------
INSERT INTO `department` VALUES ('102', '9859');
INSERT INTO `department` VALUES ('401', '体力劳动');
INSERT INTO `department` VALUES ('402', '脑力劳动');

-- ----------------------------
-- Table structure for `recruitment`
-- ----------------------------
DROP TABLE IF EXISTS `recruitment`;
CREATE TABLE `recruitment` (
  `r_id` int(11) NOT NULL AUTO_INCREMENT,
  `r_type` varchar(32) NOT NULL COMMENT '招聘类型',
  `r_details` varchar(256) DEFAULT NULL COMMENT '鎷涜仒淇℃伅',
  PRIMARY KEY (`r_id`)
) ENGINE=InnoDB AUTO_INCREMENT=515 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of recruitment
-- ----------------------------
INSERT INTO `recruitment` VALUES ('501', '招聘销售', 'z1.jpg');
INSERT INTO `recruitment` VALUES ('502', '招聘销售', 'z2.jpg');
INSERT INTO `recruitment` VALUES ('503', '招聘女销售', 'z3.jpg');
INSERT INTO `recruitment` VALUES ('504', '诚聘经理', 'z3.jpg');
INSERT INTO `recruitment` VALUES ('505', '诚聘女经理', 'z1.jpg');
INSERT INTO `recruitment` VALUES ('506', '诚聘老板', 'z3.jpg');
INSERT INTO `recruitment` VALUES ('507', '招聘后厨', 'z2.jpg');
INSERT INTO `recruitment` VALUES ('514', '看门', '69fa3e4dcda743b89078cf7ecfffd30864.png');

-- ----------------------------
-- Table structure for `r_u`
-- ----------------------------
DROP TABLE IF EXISTS `r_u`;
CREATE TABLE `r_u` (
  `rid` int(11) NOT NULL COMMENT 'rid',
  `uid` int(11) NOT NULL COMMENT 'uid',
  PRIMARY KEY (`rid`,`uid`),
  KEY `fk_reference2` (`uid`),
  CONSTRAINT `fk_reference1` FOREIGN KEY (`rid`) REFERENCES `recruitment` (`r_id`),
  CONSTRAINT `fk_reference2` FOREIGN KEY (`uid`) REFERENCES `user` (`u_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of r_u
-- ----------------------------
INSERT INTO `r_u` VALUES ('501', '201');
INSERT INTO `r_u` VALUES ('502', '201');
INSERT INTO `r_u` VALUES ('503', '201');
INSERT INTO `r_u` VALUES ('505', '201');
INSERT INTO `r_u` VALUES ('506', '201');
INSERT INTO `r_u` VALUES ('501', '202');
INSERT INTO `r_u` VALUES ('502', '202');

-- ----------------------------
-- Table structure for `staff`
-- ----------------------------
DROP TABLE IF EXISTS `staff`;
CREATE TABLE `staff` (
  `s_id` int(11) NOT NULL AUTO_INCREMENT,
  `s_name` varchar(32) NOT NULL COMMENT '员工名称',
  `s_age` int(3) DEFAULT NULL COMMENT '年龄',
  `s_sex` char(1) DEFAULT NULL COMMENT '性别',
  `s_position` varchar(32) DEFAULT NULL COMMENT '职位',
  `s_salary` double(11,0) DEFAULT NULL COMMENT '宸ヨ祫',
  `s_d_id` int(11) DEFAULT NULL COMMENT '所属部门',
  PRIMARY KEY (`s_id`),
  KEY `FK_Reference_9` (`s_d_id`),
  CONSTRAINT `FK_Reference_9` FOREIGN KEY (`s_d_id`) REFERENCES `department` (`d_id`)
) ENGINE=InnoDB AUTO_INCREMENT=316 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of staff
-- ----------------------------
INSERT INTO `staff` VALUES ('301', '存储', '21', '男', '销售', '4563', '401');
INSERT INTO `staff` VALUES ('302', '咄咄书空', '23', '男', '销售', '4569', '401');
INSERT INTO `staff` VALUES ('303', '李逵', '25', '女', '销售', '6523', '401');
INSERT INTO `staff` VALUES ('304', '模拟', '24', '女', '经理', '7563', '401');
INSERT INTO `staff` VALUES ('305', '句话', '29', '女', '领导', '9999', '402');
INSERT INTO `staff` VALUES ('306', '省道', '35', '男', '领导', '12345', '402');
INSERT INTO `staff` VALUES ('307', '瓦尔塔', '46', '男', '总裁', '666666', '402');
INSERT INTO `staff` VALUES ('308', '体育馆', '23', '女', '经理', '7451', '402');
INSERT INTO `staff` VALUES ('309', '恰当', '29', '男', '经理', '8546', '402');
INSERT INTO `staff` VALUES ('310', '效果好', '26', '男', '销售', '4589', '401');

-- ----------------------------
-- Table structure for `user`
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `u_id` int(11) NOT NULL AUTO_INCREMENT,
  `u_name` varchar(32) NOT NULL COMMENT '普通用户名称',
  `u_pwd` varchar(32) NOT NULL COMMENT '普通用户密码',
  `u_resume` varchar(256) DEFAULT NULL COMMENT '绠€鍘?',
  PRIMARY KEY (`u_id`)
) ENGINE=InnoDB AUTO_INCREMENT=207 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('201', '258', '123', 'r1.jpg');
INSERT INTO `user` VALUES ('202', '258', '66666', 'r2.jpg');
INSERT INTO `user` VALUES ('203', '258', '123456', 'r1.jpg');
INSERT INTO `user` VALUES ('204', '258', '123456', 'r2.jpg');
INSERT INTO `user` VALUES ('205', '258', '123456', 'r2.jpg');
INSERT INTO `user` VALUES ('206', '258', '123456', 'r1.jpg');