/*
Navicat MySQL Data Transfer
Source Server : zy
Source Server Version : 50713
Source Host : localhost:3306
Source Database : person
Target Server Type : MYSQL
Target Server Version : 50713
File Encoding : 65001
Date: 2017-08-14 13:07:02
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for applicant
-- ----------------------------
DROP TABLE IF EXISTS `applicant`;
CREATE TABLE `applicant` (
`id` int(11) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`sex` bit(1) DEFAULT NULL,
`age` int(11) DEFAULT NULL,
`job` varchar(255) DEFAULT NULL,
`specialty` varchar(255) DEFAULT NULL,
`experience` varchar(255) DEFAULT NULL,
`studyeffort` varchar(255) DEFAULT NULL,
`school` varchar(255) DEFAULT NULL,
`tel` varchar(255) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`createtime` datetime DEFAULT NULL,
`content` text,
`isstock` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of applicant
-- ----------------------------
-- ----------------------------
-- Table structure for login
-- ----------------------------
DROP TABLE IF EXISTS `login`;
CREATE TABLE `login` (
`userName` varchar(255) NOT NULL,
`passWord` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of login
-- ----------------------------
INSERT INTO `login` VALUES ('zhaoying', '0123');
-- ----------------------------
-- Table structure for persones
-- ----------------------------
DROP TABLE IF EXISTS `persones`;
CREATE TABLE `persones` (
`id` int(255) unsigned zerofill NOT NULL,
`username` varchar(255) NOT NULL,
`password` varchar(255) DEFAULT NULL,
`sex` bit(64) DEFAULT NULL,
`birthday` date DEFAULT NULL,
`creatertime` date DEFAULT NULL,
`isadmin` bit(64) DEFAULT NULL,
`content` text,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of persones
-- ----------------------------
INSERT INTO `persones` VALUES ('01', '张三', '123456', '\0\0\0\0\0\0\0?', null, null, null, null);
INSERT INTO `persones` VALUES ('02', '', null, null, null, null, null, null);
INSERT INTO `persones` VALUES ('03', '', null, null, null, null, null, null);
-- ----------------------------
-- Table structure for rewards_punishment
-- ----------------------------
DROP TABLE IF EXISTS `rewards_punishment`;
CREATE TABLE `rewards_punishment` (
`id` int(11) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`reason` varchar(255) DEFAULT NULL,
`explains` text,
`createtime` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of rewards_punishment
-- ----------------------------
-- ----------------------------
-- Table structure for salary
-- ----------------------------
DROP TABLE IF EXISTS `salary`;
CREATE TABLE `salary` (
`id` int(11) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`basic` varchar(255) NOT NULL,
`eat` float DEFAULT NULL,
`house` float DEFAULT NULL,
`granttime` datetime DEFAULT NULL,
`scot` float NOT NULL,
`duty` float DEFAULT NULL,
`punishment` float(255,0) DEFAULT NULL,
`other` float(255,0) DEFAULT NULL,
`totalize` float(225,0) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of salary
-- ----------------------------
-- ----------------------------
-- Table structure for training
-- ----------------------------
DROP TABLE IF EXISTS `training`;
CREATE TABLE `training` (
`id` int(11) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`purpose` varchar(255) DEFAULT NULL,
`begintime` datetime DEFAULT NULL,
`endtime` datetime DEFAULT NULL,
`datum` text,
`teacher` varchar(255) DEFAULT NULL,
`student` varchar(255) DEFAULT NULL,
`createtime` datetime DEFAULT NULL,
`educate` bit(64) DEFAULT NULL,
`effect` varchar(255) DEFAULT NULL,
`summarize` text,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of training
-- ----------------------------
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(20) NOT NULL,
`password` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', 'zy', '123456');
INSERT INTO `user` VALUES ('2', 'zz', '123');
