/*
Navicat MySQL Data Transfer
Source Server : localhost_3306
Source Server Version : 50556
Source Host : localhost:3306
Source Database : tims
Target Server Type : MYSQL
Target Server Version : 50556
File Encoding : 65001
Date: 2018-12-14 16:49:34
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for dept
-- ----------------------------
DROP TABLE IF EXISTS `dept`;
CREATE TABLE `dept` (
`deptno` int(5) NOT NULL,
`deptname` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
`remarks` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
PRIMARY KEY (`deptno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of dept
-- ----------------------------
INSERT INTO `dept` VALUES ('10', '校长办公室', '这里是校长办公室的员工');
INSERT INTO `dept` VALUES ('20', '党政处', '这里是党政处的员工');
INSERT INTO `dept` VALUES ('30', '教务处', '这里是教务处的员工');
INSERT INTO `dept` VALUES ('40', '总务处', '这里是总务处的员工');
INSERT INTO `dept` VALUES ('50', '教研室', '这里是教研室的员工');
-- ----------------------------
-- Table structure for reward_punishment
-- ----------------------------
DROP TABLE IF EXISTS `reward_punishment`;
CREATE TABLE `reward_punishment` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`name` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
`deptno` int(10) DEFAULT NULL,
`telephone` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
`email` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
`reward_or_punishment` int(5) DEFAULT NULL,
`text` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
`createdate` datetime DEFAULT NULL,
`donedate` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`state` varchar(5) CHARACTER SET utf8 DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of reward_punishment
-- ----------------------------
INSERT INTO `reward_punishment` VALUES ('1', '史博', '10', '15998286121', 'shibo960830@163.com', '0', '优秀干部', '2018-11-28 11:53:16', '2018-11-28 11:53:16', 'U');
INSERT INTO `reward_punishment` VALUES ('2', '史博', '10', '15998286121', 'shibo960830@163.com', '0', 'aa', '2018-11-28 11:53:16', '2018-11-28 16:12:01', 'E');
INSERT INTO `reward_punishment` VALUES ('3', '尹琨绍', '10', '151', 'yinkunshao@1.com', '1', '因偷鸡蛋罚两月工资', '2018-11-29 09:31:11', '2018-11-29 09:37:13', 'E');
INSERT INTO `reward_punishment` VALUES ('4', '尹琨绍', '30', '151', 'yinkunshao@1.com', '1', '因偷鸡蛋罚两月工资', '2018-11-29 10:59:24', '2018-11-29 10:59:24', 'U');
INSERT INTO `reward_punishment` VALUES ('5', '尹琨绍', '30', '151', 'yinkunshao@1.com', '0', '自觉归还鸡蛋奖励两个鸡蛋', '2018-11-29 16:17:21', '2018-11-29 16:17:21', 'U');
INSERT INTO `reward_punishment` VALUES ('6', '孙林达', '20', '151', 'sunlinda@1.com', '1', '偷吃尹琨绍的鸡蛋罚两月工资', '2018-11-29 16:18:08', '2018-11-29 16:18:08', 'U');
INSERT INTO `reward_punishment` VALUES ('7', '孙林达', '20', '151', 'sunlinda@1.com', '0', '补给尹琨绍鸡蛋奖励两个鸡蛋', '2018-11-29 16:19:23', '2018-11-29 16:19:23', 'U');
INSERT INTO `reward_punishment` VALUES ('8', '史博', '10', '15998286121', 'shibo960830@163.com', '0', '多次抓鸡蛋贼奖励四个月工资', '2018-11-29 16:20:03', '2018-11-29 16:20:03', 'U');
INSERT INTO `reward_punishment` VALUES ('9', '尹琨绍', '30', '151', 'yinkunshao@1.com', '1', '屡次偷鸡蛋罚孵鸡蛋49天', '2018-11-29 16:21:02', '2018-11-29 16:21:09', 'U');
INSERT INTO `reward_punishment` VALUES ('10', '索子玉', '40', '151', 'suoziyu@1.com', '1', '偷鸡蛋罚两个月工资', '2018-11-29 16:25:13', '2018-11-29 16:25:13', 'U');
INSERT INTO `reward_punishment` VALUES ('11', '索子玉', '40', '151', 'suoziyu@1.com', '1', '吃鸡蛋还不承认罚扫厕所一个月', '2018-11-29 16:27:06', '2018-11-29 16:27:06', 'U');
INSERT INTO `reward_punishment` VALUES ('12', '索子玉', '40', '151', 'suoziyu@1.com', '0', '厕所扫的很干净，提前释放', '2018-11-29 16:27:54', '2018-12-03 09:06:36', 'E');
-- ----------------------------
-- Table structure for teacher_base_info
-- ----------------------------
DROP TABLE IF EXISTS `teacher_base_info`;
CREATE TABLE `teacher_base_info` (
`user_id` int(10) NOT NULL AUTO_INCREMENT,
`name` varchar(10) DEFAULT NULL,
`sex` varchar(5) DEFAULT NULL,
`marriage` varchar(5) DEFAULT NULL,
`brithday` date DEFAULT NULL,
`country` varchar(20) DEFAULT NULL,
`political_status` varchar(10) DEFAULT NULL,
`nation` varchar(10) DEFAULT NULL,
`deptno` int(10) DEFAULT NULL,
`work` varchar(20) DEFAULT NULL,
`height` double(10,0) DEFAULT NULL,
`weight` double(10,0) DEFAULT NULL,
`blood_group` varchar(5) DEFAULT NULL,
`education` varchar(20) DEFAULT NULL,
`domicile_place` varchar(100) DEFAULT NULL,
`domicile_type` varchar(10) DEFAULT NULL,
`id` varchar(30) DEFAULT NULL,
`tel` varchar(11) DEFAULT NULL,
`telephone` varchar(11) DEFAULT NULL,
`addr` varchar(100) DEFAULT NULL,
`email` varchar(20) DEFAULT NULL,
`zip_code` varchar(10) DEFAULT NULL,
`emergrncy_name` varchar(10) DEFAULT NULL,
`emergrncy_sex` varchar(5) DEFAULT NULL,
`emergrncy_relection` varchar(10) DEFAULT NULL,
`emergrncy_tel` varchar(11) DEFAULT NULL,
`isleader` int(5) DEFAULT '0',
`password` varchar(50) DEFAULT NULL,
`createdate` datetime DEFAULT NULL,
`donedate` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`state` varchar(5) DEFAULT NULL,
PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of teacher_base_info
-- ----------------------------
INSERT INTO `teacher_base_info` VALUES ('1', '史博', '男', '未婚', '1996-08-30', '中国', '群众', '汉族', '10', '校长', '182', '100', 'B', '大学本科', '辽宁沈阳', '农村户口', '210111199608305318', '12345678910', '15998286121', '辽宁沈阳苏家屯区八一镇三家子村19组', 'shibo960830@163.com', '110103', '史娟', '女', '姐姐', '12345678910', '1', 'E10ADC3949BA59ABBE56E057F20F883E', null, '2018-11-28 11:21:31', 'U');
INSERT INTO `teacher_base_info` VALUES ('2', '尹琨绍', '男', '未婚', '1997-02-20', '中国', '群众', '汉族', '30', '副校长', '150', '50', 'B', '大学本科', '河南平顶山', '城市户口', '210111', '159', '151', 'da\'da', 'yinkunshao@1.com', '110110', '史博', '男', '爸爸', '15998286121', '0', null, null, '2018-11-29 10:58:33', 'U');
INSERT INTO `teacher_base_info` VALUES ('3', '123', '123', '213', null, null, null, null, null, null, null, null, null, null, null, null, '123', null, null, null, '123@qq.com', null, null, null, null, null, '1', 'E10ADC3949BA59ABBE56E057F20F883E', null, '2018-11-28 11:21:40', 'E');
INSERT INTO `teacher_base_info` VALUES ('4', '孙林达', '男', '未婚', '2018-11-29', '中国', '群众', '汉族', '20', '副校长', '175', '70', 'B', '大学本科', '黑龙江大庆', '城市户口', '210112', '159', '151', 'da\'da', 'sunlinda@1.com', '110110', '尹琨绍', '男', '儿砸', '213', '0', null, '2018-11-29 09:02:11', '2018-11-29 10:51:34', 'U');
INSERT INTO `teacher_base_info` VALUES ('5', '索子玉', '男', '未婚', '1997-09-01', '中国', '群众', '汉族', '40', '副校长', '170', '55', 'B', '大学本科', '', '城市户口', '210113', '159', '151', 'da\'da', 'suoziyu@1.com', '110110', '史博', '男', '爸爸', '15998286121', '0', null, '2018-11-29 16:23:55', '2018-11-29 16:23:55', 'U');
INSERT INTO `teacher_base_info` VALUES ('6', '123', '男', '未婚', '2018-11-30', '中国', '群众', '汉族', '10', '校长', '182', '110', 'B', '大学本科', '辽宁沈阳', '城市户口', '210114', '159', '151', '
