/*
Navicat MySQL Data Transfer

Source Server         : ui
Source Server Version : 50557
Source Host           : localhost:3306
Source Database       : oa

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

Date: 2019-12-18 17:32:56
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `t_class`
-- ----------------------------
DROP TABLE IF EXISTS `t_class`;
CREATE TABLE `t_class` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `major_id` int(6) DEFAULT NULL,
  `class_name` varchar(30) DEFAULT NULL,
  `class_date` date DEFAULT NULL,
  `class_time` varchar(30) DEFAULT NULL,
  `class_address` varchar(30) DEFAULT NULL,
  `class_delete` int(5) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_major_id_01` (`major_id`),
  CONSTRAINT `FK_major_id_01` FOREIGN KEY (`major_id`) REFERENCES `t_major` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_class
-- ----------------------------
INSERT INTO `t_class` VALUES ('1', '1', '物联网01班', '2019-08-08', '50', '19楼1教室', '0');
INSERT INTO `t_class` VALUES ('2', '2', '商务外语1班', '2019-08-07', '60', '19楼2教室', '0');
INSERT INTO `t_class` VALUES ('3', '2', '计算机科学与技术', '2019-12-04', '50', 'd3133', '0');
INSERT INTO `t_class` VALUES ('4', '2', '电气', '2019-11-28', '50', 'z3133', '0');

-- ----------------------------
-- Table structure for `t_depart`
-- ----------------------------
DROP TABLE IF EXISTS `t_depart`;
CREATE TABLE `t_depart` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) DEFAULT NULL,
  `createtime` date DEFAULT NULL,
  `del` int(14) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_depart
-- ----------------------------
INSERT INTO `t_depart` VALUES ('1', '教学部', '2018-06-27', '0');
INSERT INTO `t_depart` VALUES ('2', '就业部', '2018-06-27', '0');
INSERT INTO `t_depart` VALUES ('3', '12', '2019-12-03', '1');
INSERT INTO `t_depart` VALUES ('4', '熊根滔', '2019-12-04', '0');
INSERT INTO `t_depart` VALUES ('5', '熊根滔', '2019-12-03', '0');
INSERT INTO `t_depart` VALUES ('6', '熊根滔我是', '2019-12-04', '0');
INSERT INTO `t_depart` VALUES ('7', '哈哈哈', '2019-12-03', '1');
INSERT INTO `t_depart` VALUES ('8', '吱吱吱吱吱吱吱吱', '2019-12-03', '1');
INSERT INTO `t_depart` VALUES ('9', '斤斤计较', '2019-12-01', '1');
INSERT INTO `t_depart` VALUES ('10', '红红火火恍恍惚惚', '2019-12-03', '0');
INSERT INTO `t_depart` VALUES ('11', '我是火车王', '2019-12-03', '0');
INSERT INTO `t_depart` VALUES ('12', '嘿嘿嘿呼嘿嘿', '2019-12-03', '0');
INSERT INTO `t_depart` VALUES ('13', '周周周', '2019-12-02', '0');
INSERT INTO `t_depart` VALUES ('14', '咿呀咿呀呦', '2019-12-02', '1');
INSERT INTO `t_depart` VALUES ('15', 'china', '2019-12-03', '0');
INSERT INTO `t_depart` VALUES ('16', '测试部门', '2019-12-02', '1');

-- ----------------------------
-- Table structure for `t_emp`
-- ----------------------------
DROP TABLE IF EXISTS `t_emp`;
CREATE TABLE `t_emp` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `no` varchar(20) DEFAULT NULL,
  `pass` varchar(200) DEFAULT NULL,
  `name` varchar(20) DEFAULT NULL,
  `did` int(11) DEFAULT NULL COMMENT '外键  部门ID',
  `flag` int(11) DEFAULT NULL,
  `sex` varchar(2) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `qq` varchar(20) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `createdate` date DEFAULT NULL,
  `photo` varchar(100) DEFAULT NULL,
  `del` int(4) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_DID` (`did`),
  CONSTRAINT `FK_DID` FOREIGN KEY (`did`) REFERENCES `t_depart` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_emp
-- ----------------------------
INSERT INTO `t_emp` VALUES ('1', 'qf000001', '123', '张三', '1', '1', '男', 'zhansgan@163.com', '222321', '110', '2018-03-03', '4354.jpg', '0');
INSERT INTO `t_emp` VALUES ('2', '15e', '123', '路飞', '1', '1', '女', '95388@qq.com', '95388', '1775492', '2019-12-17', '6a9f66bf-e585-4732-be62-fd46a4a1a6b0.jpg', '0');
INSERT INTO `t_emp` VALUES ('3', 'z123', '123', '公鸡大鱼怪', '1', '1', '男', '1@qq.com', '179', '179', '2019-12-10', '5d03b033-d4de-4b91-9d47-cc3e60f141b1.jpg', '0');
INSERT INTO `t_emp` VALUES ('6', '1', '1', '1', '1', '1', '男', '1', '1', '1', '2019-12-03', '15a3fd37-b1cb-4a6f-acc5-793c2c19f773.jpg', '1');
INSERT INTO `t_emp` VALUES ('7', '9527', '123', '周星驰', '11', '1', '男', '9527', '123', '123', '2019-12-03', '66946aa6-ad92-407c-80af-586c0390d464.jpg', '0');
INSERT INTO `t_emp` VALUES ('8', '测试', '123', '测试', '16', '1', '女', '123@qq.com', '123', '123', '2019-12-02', '425b51d8-9118-4b75-95fb-518f40e9bedc.jpg', '0');
INSERT INTO `t_emp` VALUES ('9', '123123', '123123', '嘿嘿嘿呼嘿嘿', '4', '1', '男', '123', '123', '123', '2019-12-12', '3fc8aa54-c16e-4230-a871-08b9466df928.jpg', '0');
INSERT INTO `t_emp` VALUES ('10', '436577', '123', '123', '1', '1', '男', '123@qq.com', '12', '12', '2019-12-30', '464b4f49-04e0-4c11-9c08-34fd17598744.jpg', '0');
INSERT INTO `t_emp` VALUES ('11', '4396', '123', '7酱', '15', '1', '男', '12@qq.com', '12', '123', '2019-12-17', 'c9bb43cc-a401-4f36-92b6-1dbcc394bbeb.jpg', '0');
INSERT INTO `t_emp` VALUES ('12', '35645', '123', '123', '1', '1', '女', '123@qq.com', '123', '123', '2019-12-31', '4184cf51-ef9f-4ba6-b6f7-9d9f68bd1fe1.jpg', '0');
INSERT INTO `t_emp` VALUES ('13', '123345', '123123', '123123', '1', '1', '男', '123@qq.com', ' ', ' ', '2019-12-25', '25fa7305-8c6a-4d21-a8de-26a05c834083.jpg', '0');
INSERT INTO `t_emp` VALUES ('14', '123124', '124', '124', '2', '1', '女', '', '123', '', '2019-12-30', 'd7201dcb-2e74-4a98-845b-f6e2b4d17a85.jpg', '0');

-- ----------------------------
-- Table structure for `t_emp_role`
-- ----------------------------
DROP TABLE IF EXISTS `t_emp_role`;
CREATE TABLE `t_emp_role` (
  `emp_role_id` int(6) NOT NULL AUTO_INCREMENT,
  `emp_id` int(6) DEFAULT NULL,
  `role_id` int(6) DEFAULT NULL,
  PRIMARY KEY (`emp_role_id`),
  KEY `fk_emp_id` (`emp_id`),
  KEY `fk_role_id` (`role_id`),
  CONSTRAINT `t_emp_role_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `t_role` (`r_id`),
  CONSTRAINT `t_emp_role_ibfk_2` FOREIGN KEY (`emp_id`) REFERENCES `t_emp` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_emp_role
-- ----------------------------
INSERT INTO `t_emp_role` VALUES ('1', '1', '1');
INSERT INTO `t_emp_role` VALUES ('3', '2', '4');
INSERT INTO `t_emp_role` VALUES ('4', '2', '3');
INSERT INTO `t_emp_role` VALUES ('5', '4', '1');
INSERT INTO `t_emp_role` VALUES ('6', '4', '4');
INSERT INTO `t_emp_role` VALUES ('7', '7', '2');

-- ----------------------------
-- Table structure for `t_loginlog`
-- ----------------------------
DROP TABLE IF EXISTS `t_loginlog`;
CREATE TABLE `t_loginlog` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `ip` varchar(20) DEFAULT NULL,
  `no` varchar(20) DEFAULT NULL,
  `createtime` datetime DEFAULT NULL,
  `location` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=152 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_loginlog
-- ----------------------------
INSERT INTO `t_loginlog` VALUES ('1', '117.159.15.221', 'admin', '2018-07-12 14:04:49', '河南省信阳市');
INSERT INTO `t_loginlog` VALUES ('2', '117.159.15.221', 'admin', '2018-07-12 16:02:08', '河南省信阳市');
INSERT INTO `t_loginlog` VALUES ('3', '117.159.15.221', 'admin', '2018-07-12 16:05:00', '河南省信阳市');
INSERT INTO `t_loginlog` VALUES ('4', '117.159.15.221', 'admin', '2018-07-12 16:13:30', '河南省信阳市');
INSERT INTO `t_loginlog` VALUES ('5', '117.159.15.221', 'admin', '2018-07-12 16:14:36', '河南省信阳市');
INSERT INTO `t_loginlog` VALUES ('6', '117.159.15.221', 'admin', '2018-07-12 16:23:53', '河南省信阳市');
INSERT INTO `t_loginlog` VALUES ('7', '117.159.15.221', 'admin', '2018-07-12 16:25:51', '河南省信阳市');
INSERT INTO `t_loginlog` VALUES ('8', '117.159.15.221', 'admin', '2018-07-12 16:27:00', '河南省信阳市');
INSERT INTO `t_loginlog` VALUES ('9', '117.159.15.221', 'admin', '2018-07-12 16:53:44', '河南省信阳市');
INSERT INTO `t_loginlog` VALUES ('10', '117.159.15.221', 'admin', '2018-07-12 17:01:38', '河南省信阳市');
INSERT INTO `t_loginlog` VALUES ('11', '117.159.15.221', 'admin', '2018-07-12 17:04:31', '河南省信阳市');
INSERT INTO `t_loginlog` VALUES ('55', '117.159.15.221', 'admin', '2018-07-14 16:03:21', '河南省信阳市');
INSERT INTO `t_loginlog` VALUES ('56', '182.149.160.175', 'admin', '2019-12-10 11:55:33', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('57', '182.149.160.175', 'admin', '2019-12-10 12:15:12', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('58', '182.149.160.175', 'admin', '2019-12-10 12:26:59', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('59', '182.149.160.175', 'zz', '2019-12-10 13:47:25', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('60', '182.149.160.175', 'zz', '2019-12-10 13:48:40', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('61', '182.149.160.175', 'zz', '2019-12-10 13:49:25', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('62', '182.149.160.175', 'zz', '2019-12-10 13:53:01', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('63', '182.149.160.175', 'zz', '2019-12-10 13:55:07', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('64', '182.149.160.175', 'zz', '2019-12-10 16:05:50', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('65', '', 'admin', '2019-12-10 17:52:41', '');
INSERT INTO `t_loginlog` VALUES ('66', '182.149.160.175', 'admin', '2019-12-10 18:41:31', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('67', '', 'admin', '2019-12-10 19:04:56', '');
INSERT INTO `t_loginlog` VALUES ('68', '', 'admin', '2019-12-10 19:04:56', '');
INSERT INTO `t_loginlog` VALUES ('69', '222.209.18.185', 'admin', '2019-12-10 21:57:16', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('70', '222.209.18.185', 'admin', '2019-12-10 22:29:14', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('71', '222.209.18.185', 'admin', '2019-12-10 22:29:14', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('72', '222.209.18.185', 'admin', '2019-12-10 22:29:14', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('73', '182.149.160.175', 'admin', '2019-12-11 09:38:08', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('74', '182.149.160.175', 'admin', '2019-12-11 09:43:45', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('75', '182.149.160.175', 'admin', '2019-12-11 09:43:45', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('76', '182.149.160.175', 'admin', '2019-12-11 10:41:58', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('77', '182.149.160.175', 'admin', '2019-12-11 10:50:58', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('78', '182.149.160.175', '9527', '2019-12-11 11:29:41', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('79', '182.149.160.175', 'admin', '2019-12-11 11:30:27', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('80', '182.149.160.175', '9527', '2019-12-11 11:32:46', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('81', '182.149.160.175', '9527', '2019-12-11 11:34:37', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('82', '182.149.160.175', '9527', '2019-12-11 12:25:34', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('83', '182.149.160.175', '9527', '2019-12-11 14:59:20', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('84', '182.149.160.175', '9527', '2019-12-11 16:46:05', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('85', '182.149.160.175', '9527', '2019-12-11 18:57:14', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('86', '222.209.18.185', '9527', '2019-12-11 22:01:45', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('87', '222.209.18.185', '9527', '2019-12-11 22:35:50', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('88', '182.149.160.175', '9527', '2019-12-12 09:25:36', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('89', '182.149.160.175', '9527', '2019-12-12 09:25:36', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('90', '182.149.160.175', '9527', '2019-12-12 09:25:36', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('91', '182.149.160.175', '9527', '2019-12-12 09:25:36', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('92', '182.149.160.175', '9527', '2019-12-12 10:42:39', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('93', '182.149.160.175', '9527', '2019-12-12 10:42:40', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('94', '182.149.160.175', '123123', '2019-12-12 10:52:18', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('95', '182.149.160.175', '9527', '2019-12-12 11:14:22', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('96', '182.149.160.175', 'z123', '2019-12-12 11:41:46', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('97', '182.149.160.175', 'z123', '2019-12-12 11:52:54', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('98', '182.149.160.175', 'z123', '2019-12-12 12:18:45', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('99', '182.149.160.175', 'z123', '2019-12-12 12:23:48', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('100', '182.149.160.175', 'z123', '2019-12-12 12:26:02', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('101', '182.149.160.175', 'z123', '2019-12-12 12:26:51', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('102', '182.149.160.175', 'z123', '2019-12-12 12:27:52', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('103', '182.149.160.175', 'z123', '2019-12-12 12:28:30', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('104', '182.149.160.175', '9527', '2019-12-12 16:35:23', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('105', '182.149.160.175', '9527', '2019-12-12 19:02:18', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('106', '182.149.160.175', '9527', '2019-12-12 19:02:18', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('107', '182.149.160.175', '9527', '2019-12-12 19:07:43', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('108', '182.149.160.175', '9527', '2019-12-12 19:09:58', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('109', '182.149.160.175', '9527', '2019-12-12 19:49:47', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('110', '182.149.160.175', '9527', '2019-12-12 19:49:48', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('111', '182.149.160.175', '9527', '2019-12-12 19:58:51', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('112', '', '9527', '2019-12-16 11:58:38', '');
INSERT INTO `t_loginlog` VALUES ('113', '222.209.10.166', '9527', '2019-12-16 12:01:23', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('114', '222.209.10.166', '9527', '2019-12-16 12:04:10', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('115', '222.209.10.166', '9527', '2019-12-16 12:10:55', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('116', '222.209.10.166', '9527', '2019-12-16 14:44:50', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('117', '222.209.10.166', '9527', '2019-12-16 14:44:50', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('118', '222.209.10.166', '9527', '2019-12-16 14:48:40', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('119', '222.209.10.166', 'z123', '2019-12-16 14:49:32', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('120', '222.209.10.166', '9527', '2019-12-16 14:51:52', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('121', '222.209.10.166', '9527', '2019-12-16 15:06:43', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('122', '222.209.10.166', '9527', '2019-12-16 16:40:13', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('123', '222.209.10.166', '9527', '2019-12-16 16:40:13', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('124', '222.209.10.166', '9527', '2019-12-16 17:53:36', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('125', '222.209.10.166', '9527', '2019-12-16 18:55:57', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('126', '222.209.10.166', '9527', '2019-12-16 20:10:34', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('127', '222.209.10.166', '9527', '2019-12-17 11:53:35', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('128', '222.209.10.166', '9527', '2019-12-17 18:55:50', '四川省,成都市');
INSERT INTO `t_loginlog` VALUES ('129', '222.209.10.166', '9527', '2019-12-17 20:08:16', '');
INSERT INTO `t_loginlog` VALUES ('130', '222.209.10.166', '9527', '2019-12-17 20:40:15', '');
INSERT INTO `t_loginlog` VALUES ('131', '222.209.10.166', '9527', '2019-12-17 20:45:17', '');
INSERT INTO `t_loginlog` VALUES ('132', '222.209.10.166', '9527', '2019-12-18 12:03:23', '');
INSERT INTO `t_loginlog` VALUES ('133', '222.209.10.166', '9527', '2019-12-18 12:03:23', '');
INSERT INTO `t_loginlog` VALUES ('134', '222.209.10.166', '9527', '2019-12-18 16:07:05', '');
INSERT INTO `t_loginlog` VALUES ('135', '222.209.10.166', '9527', '2019-12-18 16:07:37', '');
INSERT INTO `t_loginlog` VALUES ('136', '222.209.10.166', '9527', '2019-12-18 16:07:37', '');
INSERT INTO `t_loginlog` VALUES ('137', '', '9527', '2019-12-18 16:09:09', '');
INSERT INTO `t_loginlog` VALUES ('138', '', '9527', '2019-12-18 16:11:31', '');
INSERT INTO `t_loginlog` VALUES ('139', '222.209.10.166', '9527', '2019-12-18 16:13:33', '');
INSERT INTO `t_loginlog` VALUES ('140', '222.209.10.166', '9527', '2019-12-18 16:16:31', '');
INSERT INTO `t_loginlog` VALUES ('141', '222.209.10.166', '9527', '2019-12-18 16:16:54', '');
INSERT INTO `t_loginlog` VALUES ('142', '222.209.10.166', '15e', '2019-12-18 16:17:55', '');
INSERT INTO `t_loginlog` VALUES ('143', '222.209.10.166', '15e', '2019-12-18 16:18:59', '');
INSERT INTO `t_loginlog` VALUES ('144', '222.209.10.166', '15e', '2019-12-18 16:19:19', '');
INSERT INTO `t_loginlog` VALUES ('145', '222.209.10.166', '9527', '2019-12-18 16:58:19', '');
INSERT INTO `t_loginlog` VALUES ('146', '222.209.10.166', '9527', '2019-12-18 17:00:11', '');
INSERT INTO `t_loginlog` VALUES ('147', '222.209.10.166', '15e', '2019-12-18 17:04:36', '');
INSERT INTO `t_loginlog` VALUES ('148', '222.209.10.166', '15e', '2019-12-18 17:12:23', '');
INSERT INTO `t_loginlog` VALUES ('149', '222.209.10.166', '15e', '2019-12-18 17:12:24', '');
INSERT INTO `t_loginlog` VALUES ('150', '222.209.10.166', '15e', '2019-12-18 17:15:30', '');
INSERT INTO `t_loginlog` VALUES ('151', '222.209.10.166', '9527', '2019-12-18 17:15:56', '');

-- ----------------------------
-- Table structure for `t_major`
-- ----------------------------
DROP TABLE IF EXISTS `t_major`;
CREATE TABLE `t_major` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `major_name` varchar(20) DEFAULT NULL,
  `major_time` varchar(20) DEFAULT NULL,
  `major_date` date DEFAULT NULL,
  `major_type` int(6) DEFAULT NULL,
  `major_delete` int(6) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_major_id` (`major_type`),
  CONSTRAINT `FK_major_id` FOREIGN KEY (`major_type`) REFERENCES `t_majortype` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_major
-- ----------------------------
INSERT INTO `t_major` VALUES ('1', '物联网', '40', '2019-08-02', '1', '0');
INSERT INTO `t_major` VALUES ('2', '商务外语', '200', '2019-08-08', '2', '0');

-- ----------------------------
-- Table structure for `t_majortype`
-- ----------------------------
DROP TABLE IF EXISTS `t_majortype`;
CREATE TABLE `t_majortype` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `majortype` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_majortype
-- ----------------------------
INSERT INTO `t_majortype` VALUES ('1', '精品');
INSERT INTO `t_majortype` VALUES ('2', '业余');
INSERT INTO `t_majortype` VALUES ('3', '普通');

-- ----------------------------
-- Table structure for `t_permission`
-- ----------------------------
DROP TABLE IF EXISTS `t_permission`;
CREATE TABLE `t_permission` (
  `p_id` int(6) NOT NULL AUTO_INCREMENT,
  `p_icon` varchar(255) DEFAULT NULL,
  `p_name` varchar(255) DEFAULT NULL,
  `p_parentid` int(6) DEFAULT NULL,
  `p_url` varchar(255) DEFAULT NULL,
  `p_type` varchar(255) DEFAULT NULL,
  `p_delete` int(6) DEFAULT NULL,
  PRIMARY KEY (`p_id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_permission
-- ----------------------------
INSERT INTO `t_permission` VALUES ('1', 'layui-icon layui-icon-app', '我的工具', '0', null, 'menu', '0');
INSERT INTO `t_permission` VALUES ('2', null, '我的日历', '1', '/page_clock', 'menu', '0');
INSERT INTO `t_permission` VALUES ('3', null, '天气查询', '1', '/page_weather', 'menu', '0');
INSERT INTO `t_permission` VALUES ('4', null, '地图查询', '1', '/page_map', 'menu', '0');
INSERT INTO `t_permission` VALUES ('5', 'fa fa-sitemap', '部门管理', '0', null, 'menu', '0');
INSERT INTO `t_permission` VALUES ('6', null, '部门列表', '5', '/depart_show/1/3', 'menu', '0');
INSERT INTO `t_permission` VALUES ('7', null, '部门新增', '5', '/page_departadd', 'menu', '0');
INSERT INTO `t_permission` VALUES ('8', 'layui-icon layui-icon-user', '员工管理', '0', null, 'menu', '0');
INSERT INTO `t_permission` VALUES ('9', null, '员工列表', '8', '/emp_show/1/3', 'menu', '0');
INSERT INTO `t_permission` VALUES ('10', null, '员工新增', '8', '/page_empadd', 'menu', '0');
INSERT INTO `t_permission` VALUES ('11', null, '员工报表', '8', '/emp_getTongjiData', 'menu', '0');
INSERT INTO `t_permission` VALUES ('12', 'fa fa-graduation-cap', '专业管理', '0', null, 'menu', '0');
INSERT INTO `t_permission` VALUES ('13', null, '专业列表', '12', '/page_courselist', 'menu', '0');
INSERT INTO `t_permission` VALUES ('14', null, '专业新增', '12', '/page_courseadds', 'menu', '0');
INSERT INTO `t_permission` VALUES ('15', 'fa fa-cube', '班级管理', '0', null, 'menu', '0');
INSERT INTO `t_permission` VALUES ('16', null, '班级列表', '15', '/page_gradelist', 'menu', '0');
INSERT INTO `t_permission` VALUES ('17', null, '班级新增', '15', '/page_gradeadd', 'menu', '0');
INSERT INTO `t_permission` VALUES ('18', 'fa fa-user-secret', '学生管理', '0', null, 'menu', '0');
INSERT INTO `t_permission` VALUES ('19', null, '学生列表', '18', '/student_show/1/3', 'menu', '0');
INSERT INTO `t_permission` VALUES ('20', null, '学生新增', '18', '/page_studentadd', 'menu', '0');
INSERT INTO `t_permission` VALUES ('21', null, '学生导入', '18', '/page_studentbatch', 'menu', '0');

-- ----------------------------
-- Table structure for `t_role`
-- ----------------------------
DROP TABLE IF EXISTS `t_role`;
CREATE TABLE `t_role` (
  `r_id` int(8) NOT NULL AUTO_INCREMENT,
  `r_name` varchar(200) DEFAULT NULL,
  `r_delete` int(6) DEFAULT NULL,
  PRIMARY KEY (`r_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_role
-- ----------------------------
INSERT INTO `t_role` VALUES ('1', '超级管理员', '0');
INSERT INTO `t_role` VALUES ('2', '管理员', '0');
INSERT INTO `t_role` VALUES ('3', '普通员工', '0');
INSERT INTO `t_role` VALUES ('4', '教务', '0');

-- ----------------------------
-- Table structure for `t_role_permission`
-- ----------------------------
DROP TABLE IF EXISTS `t_role_permission`;
CREATE TABLE `t_role_permission` (
  `role_permission_id` int(6) NOT NULL AUTO_INCREMENT,
  `role_id` int(6) DEFAULT NULL,
  `permission_id` int(6) DEFAULT NULL,
  PRIMARY KEY (`role_permission_id`),
  KEY `fk_permission_id` (`permission_id`),
  KEY `fk_role_id123` (`role_id`),
  CONSTRAINT `t_role_permission_ibfk_1` FOREIGN KEY (`permission_id`) REFERENCES `t_permission` (`p_id`),
  CONSTRAINT `t_role_permission_ibfk_2` FOREIGN KEY (`role_id`) REFERENCES `t_role` (`r_id`)
) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_role_permission
-- ----------------------------
INSERT INTO `t_role_permission` VALUES ('1', '1', '1');
INSERT INTO `t_role_permission` VALUES ('2', '1', '2');
INSERT INTO `t_role_permission` VALUES ('3', '1', '3');
INSERT INTO `t_role_permission` VALUES ('4', '1', '4');
INSERT INTO `t_role_permission` VALUES ('5', '1', '5');
INSERT INTO `t_role_permission` VALUES ('6', '1', '6');
INSERT INTO `t_role_permission` VALUES ('7', '1', '7');
INSERT INTO `t_role_permission` VALUES ('8', '1', '8');
INSERT INTO `t_role_permission` VALUES ('9', '1', '9');
INSERT INTO `t_role_permission` VALUES ('10', '1', '10');
INSERT INTO `t_role_permission` VALUES ('11', '1', '11');
INSERT INTO `t_role_permission` VALUES ('12', '1', '12');
INSERT INTO `t_role_permission` VALUES ('13', '1', '13');
INSERT INTO `t_role_permission` VALUES ('14', '1', '14');
INSERT INTO `t_role_permission` VALUES ('15', '1', '15');
INSERT INTO `t_role_permission` VALUES ('16', '1', '16');
INSERT INTO `t_role_permission` VALUES ('17', '1', '17');
INSERT INTO `t_role_permission` VALUES ('18', '1', '18');
INSERT INTO `t_role_permission` VALUES ('19', '1', '19');
INSERT INTO `t_role_permission` VALUES ('20', '1', '20');
INSERT INTO `t_role_permission` VALUES ('21', '1', '21');
INSERT INTO `t_role_permission` VALUES ('22', '2', '1');
INSERT INTO `t_role_permission` VALUES ('23', '2', '2');
INSERT INTO `t_role_permission` VALUES ('24', '2', '3');
INSERT INTO `t_role_permission` VALUES ('25', '2', '4');
INSERT INTO `t_role_permission` VALUES ('26', '2', '5');
INSERT INTO `t_role_permission` VALUES ('27', '2', '6');
INSERT INTO `t_role_permission` VALUES ('28', '2', '7');
INSERT INTO `t_role_permission` VALUES ('29', '2', '8');
INSERT INTO `t_role_permission` VALUES ('30', '2', '9');
INSERT INTO `t_role_permission` VALUES ('31', '2', '10');
INSERT INTO `t_role_permission` VALUES ('32', '2', '11');
INSERT INTO `t_role_permission` VALUES ('33', '3', '1');
INSERT INTO `t_role_permission` VALUES ('34', '3', '2');
INSERT INTO `t_role_permission` VALUES ('35', '3', '3');
INSERT INTO `t_role_permission` VALUES ('36', '3', '4');
INSERT INTO `t_role_permission` VALUES ('37', '3', '5');
INSERT INTO `t_role_permission` VALUES ('38', '3', '6');
INSERT INTO `t_role_permission` VALUES ('39', '3', '8');
INSERT INTO `t_role_permission` VALUES ('40', '3', '9');
INSERT INTO `t_role_permission` VALUES ('41', '4', '1');
INSERT INTO `t_role_permission` VALUES ('42', '4', '2');
INSERT INTO `t_role_permission` VALUES ('43', '4', '3');
INSERT INTO `t_role_permission` VALUES ('44', '4', '4');
INSERT INTO `t_role_permission` VALUES ('45', '4', '15');
INSERT INTO `t_role_permission` VALUES ('46', '4', '16');
INSERT INTO `t_role_permission` VALUES ('47', '4', '17');
INSERT INTO `t_role_permission` VALUES ('48', '4', '18');
INSERT INTO `t_role_permission` VALUES ('49', '4', '19');
INSERT INTO `t_role_permission` VALUES ('50', '4', '20');
INSERT INTO `t_role_permission` VALUES ('51', '4', '21');

-- ----------------------------
-- Table structure for `t_student`
-- ----------------------------
DROP TABLE IF EXISTS `t_student`;
CREATE TABLE `t_student` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `no` varchar(20) NOT NULL,
  `name` varchar(50) DEFAULT NULL,
  `sex` varchar(2) DEFAULT NULL,
  `birthday` date DEFAULT NULL,
  `cardno` varchar(20) DEFAULT NULL,
  `school` varchar(50) DEFAULT NULL,
  `education` varchar(20) DEFAULT NULL,
  `class_id` int(11) DEFAULT NULL COMMENT '外键 和班级主键有关系',
  `flag` int(11) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `qq` varchar(20) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `createdate` date DEFAULT NULL,
  `photo` varchar(100) DEFAULT NULL,
  `del` int(2) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_student_class_id` (`class_id`),
  CONSTRAINT `FK_student_class_id` FOREIGN KEY (`class_id`) REFERENCES `t_class` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_student
-- ----------------------------
INSERT INTO `t_student` VALUES ('1', 'qf000002', '周亚科', '男', '1998-03-20', '321721199803203212', '郑州大学', '本科', '1', '1', 'zhansgan@163.com', '222321', '110', '2018-03-03', 'photos\\e49c64f2-0df8-464c-93ad-7ab95fb7867e_cw1.jpg', '0');
INSERT INTO `t_student` VALUES ('2', '2016442971', '周亚科=', '男', '2019-12-21', '5002341197923', '重庆科技学院', '博士', '1', '1', '179@qq.com', '179', '1775492', '2020-01-01', null, '0');
INSERT INTO `t_student` VALUES ('3', '2016442977', '周亚科测试', '男', '2020-01-05', '5001465131', '重庆科技许愿', '专科', '4', '1', '179@qq.com', '179', '13546445', '2019-12-04', null, '0');
INSERT INTO `t_student` VALUES ('4', '201613', '周亚科', '男', '2016-01-01', '3213243', '重庆科技学院', '本科', '2', '1', '123', '123', '123', '2016-11-04', null, '0');
INSERT INTO `t_student` VALUES ('5', '20161232', '周亚科zzzzz', '女', '2016-01-01', '2', '重庆科技学院', '本科', '3', '1', '123', '123', '123', '2016-11-04', null, '0');
INSERT INTO `t_student` VALUES ('6', '2016124', '42', '男', '2016-01-01', '32132245', '重庆科技学院', '初中', '2', '1', '123', '123', '123', '2016-11-04', null, '0');
INSERT INTO `t_student` VALUES ('7', '2016125', '周亚科7', '女', '2016-01-01', '321324254', '重庆科技学院', '本科', '1', '1', '123', '123', '123', '2016-11-04', null, '0');
INSERT INTO `t_student` VALUES ('8', '2016126', '周亚科725', '男', '2016-01-01', '321325434', '重庆科技学院', '博士', '1', '1', '123', '123', '123', '2016-11-04', null, '0');
INSERT INTO `t_student` VALUES ('9', '2016127', '周亚科4', '女', '2016-01-01', '3213273783', '重庆科技学院', '本科', '2', '1', '123', '123', '123', '2016-11-04', null, '0');
INSERT INTO `t_student` VALUES ('10', '2016128', '周亚科75', '女', '2016-01-01', '3213273573', '重庆科技学院', '本科', '3', '1', '123', '123', '123', '2016-11-04', null, '0');
INSERT INTO `t_student` VALUES ('11', '201613553', '周亚科752', '男', '2016-01-01', '32132735', '重庆科技学院', '专科', '1', '1', '123', '123', '123', '2016-11-04', null, '0');
INSERT INTO `t_student` VALUES ('12', '201613467', '周亚科72', '女', '2016-01-01', '32132753', '重庆科技学院', '本科', '4', '1', '123', '123', '123', '2016-11-04', null, '0');
INSERT INTO `t_student` VALUES ('13', '20161237', '周亚科752', '男', '2016-01-01', '32132753', '重庆科技学院', '本科', '1', '1', '123', '123', '123', '2016-11-04', null, '0');
INSERT INTO `t_student` VALUES ('14', '20161124', '周亚科752', '男', '2016-01-01', '3213221', '重庆科技学院', '高中', '4', '1', '123', '123', '123', '2016-11-04', null, '0');
INSERT INTO `t_student` VALUES ('15', '2016123', '周亚科72', '男', '2016-01-01', '32132753', '重庆科技学院', '本科', '1', '1', '123', '123', '123', '2016-11-04', null, '0');
INSERT INTO `t_student` VALUES ('16', '201123', '周亚科725', '女', '2016-01-01', '32132753', '重庆科技学院', '本科', '4', '1', '123', '123', '123', '2016-11-04', null, '0');
INSERT INTO `t_student` VALUES ('17', '20164429775', 'xgt', '男', '2019-12-31', '23', '哈佛', '博士', '3', '1', '12', '21', '123', '2019-12-31', null, '0');