ReaourceLibSystem/res/libdb_navicat.sql at master · pangPython/ReaourceLibSystem

680 lines (644 loc) · 62.6 KB
Navicat MySQL Data Transfer
Source Server         : .
Source Server Version : 50547
Source Host           : localhost:3306
Source Database       : libdb
Target Server Type    : MYSQL
Target Server Version : 50547
File Encoding         : 65001
Date: 2016-12-07 15:44:26
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `admin`
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `pwd` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `type` int(10) NOT NULL DEFAULT '1',
  `telephone` varchar(255) NOT NULL,
  `create_time` varchar(255) NOT NULL,
  `status` int(10) NOT NULL,
  `area_id` int(255) NOT NULL,
  `auth` int(255) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `adminname` (`name`) USING HASH
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES ('1', 'whg_admin', '6E27C2CB46F6A4A06B9F3A40FCE42C84', '001@hjsoft.com', '0', '15757575757', '2016-10-12 15:13:12', '1', '1', '0');
INSERT INTO `admin` VALUES ('2', 'hjadmintest', 'B70BF36D137B011730979F7D3D9C3D9B', '001@hjsoft.com', '1', '15566886666', '2016-10-16 20:31:35', '1', '2', '1');
INSERT INTO `admin` VALUES ('8', 'whgdyadmin', 'C6D79C1484B9C5009B2EBF560A0C4A14', '125333333@huijia.com', '1', '15555555555', '2016-11-07 10:34:03', '1', '1', '0');
-- ----------------------------
-- Table structure for `area`
-- ----------------------------
DROP TABLE IF EXISTS `area`;
CREATE TABLE `area` (
  `area_id` int(11) NOT NULL AUTO_INCREMENT,
  `area_name` varchar(50) NOT NULL,
  `area_type` int(20) NOT NULL COMMENT '使用0代表市,1代表县区',
  PRIMARY KEY (`area_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of area
-- ----------------------------
INSERT INTO `area` VALUES ('1', '东营市', '0');
INSERT INTO `area` VALUES ('2', '东营区', '1');
INSERT INTO `area` VALUES ('3', ' 河口区', '1');
INSERT INTO `area` VALUES ('4', '广饶县', '1');
INSERT INTO `area` VALUES ('5', ' 垦利区', '1');
INSERT INTO `area` VALUES ('6', '利津县', '1');
-- ----------------------------
-- Table structure for `config`
-- ----------------------------
DROP TABLE IF EXISTS `config`;
CREATE TABLE `config` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `upload_size` int(255) NOT NULL,
  `examine_month` int(255) NOT NULL,
  `examine_times` int(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of config
-- ----------------------------
-- ----------------------------
-- Table structure for `declare_type`
-- ----------------------------
DROP TABLE IF EXISTS `declare_type`;
CREATE TABLE `declare_type` (
  `dec_id` int(11) NOT NULL AUTO_INCREMENT,
  `decname` varchar(20) NOT NULL,
  PRIMARY KEY (`dec_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of declare_type
-- ----------------------------
INSERT INTO `declare_type` VALUES ('1', '音乐');
INSERT INTO `declare_type` VALUES ('2', '舞蹈');
INSERT INTO `declare_type` VALUES ('3', '戏剧曲艺');
INSERT INTO `declare_type` VALUES ('4', '朗诵主持');
INSERT INTO `declare_type` VALUES ('5', ' 文学创作');
INSERT INTO `declare_type` VALUES ('6', ' 书画');
INSERT INTO `declare_type` VALUES ('7', ' 摄影');
INSERT INTO `declare_type` VALUES ('8', ' 杂技');
INSERT INTO `declare_type` VALUES ('9', ' 民间文艺');
INSERT INTO `declare_type` VALUES ('10', '电影电视');
-- ----------------------------
-- Table structure for `degree`
-- ----------------------------
DROP TABLE IF EXISTS `degree`;
CREATE TABLE `degree` (
  `degree_id` int(11) NOT NULL AUTO_INCREMENT,
  `degreename` varchar(20) NOT NULL,
  PRIMARY KEY (`degree_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of degree
-- ----------------------------
INSERT INTO `degree` VALUES ('1', '学士');
INSERT INTO `degree` VALUES ('2', '硕士');
INSERT INTO `degree` VALUES ('3', ' 博士');
-- ----------------------------
-- Table structure for `edu`
-- ----------------------------
DROP TABLE IF EXISTS `edu`;
CREATE TABLE `edu` (
  `edu_id` int(11) NOT NULL AUTO_INCREMENT,
  `eduname` varchar(20) NOT NULL,
  PRIMARY KEY (`edu_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of edu
-- ----------------------------
INSERT INTO `edu` VALUES ('1', ' 小学');
INSERT INTO `edu` VALUES ('2', ' 初中');
INSERT INTO `edu` VALUES ('3', ' 中专');
INSERT INTO `edu` VALUES ('4', ' 高中');
INSERT INTO `edu` VALUES ('5', ' 专科');
INSERT INTO `edu` VALUES ('6', ' 本科');
INSERT INTO `edu` VALUES ('7', ' 硕士研究生');
INSERT INTO `edu` VALUES ('8', ' 博士研究生');
-- ----------------------------
-- Table structure for `log`
-- ----------------------------
DROP TABLE IF EXISTS `log`;
CREATE TABLE `log` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `ip` varchar(255) NOT NULL,
  `uname` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=189 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of log
-- ----------------------------
INSERT INTO `log` VALUES ('1', '0:0:0:0:0:0:0:1', 'admin', '2016-10-16 20:29:23');
INSERT INTO `log` VALUES ('2', '127.0.0.1', 'admin', '2016-10-16 20:30:23');
INSERT INTO `log` VALUES ('3', '192.168.1.100', 'admin', '2016-10-16 20:31:01');
INSERT INTO `log` VALUES ('4', '192.168.1.100', 'admin', '2016-10-16 20:32:46');
INSERT INTO `log` VALUES ('5', '192.168.1.100', 'admin', '2016-10-16 20:36:04');
INSERT INTO `log` VALUES ('6', '192.168.1.100', 'admin', '2016-10-16 22:24:11');
INSERT INTO `log` VALUES ('7', '192.168.1.100', 'admin', '2016-10-16 22:54:25');
INSERT INTO `log` VALUES ('8', '192.168.1.100', 'admin', '2016-10-16 23:19:42');
INSERT INTO `log` VALUES ('9', '0:0:0:0:0:0:0:1', 'admin', '2016-10-17 08:11:49');
INSERT INTO `log` VALUES ('10', '0:0:0:0:0:0:0:1', 'admin', '2016-10-17 08:31:29');
INSERT INTO `log` VALUES ('11', '0:0:0:0:0:0:0:1', 'test11', '2016-10-17 08:32:09');
INSERT INTO `log` VALUES ('12', '0:0:0:0:0:0:0:1', 'test11', '2016-10-17 08:34:17');
INSERT INTO `log` VALUES ('13', '0:0:0:0:0:0:0:1', 'test11', '2016-10-17 08:34:55');
INSERT INTO `log` VALUES ('14', '0:0:0:0:0:0:0:1', 'admin', '2016-10-17 09:04:46');
INSERT INTO `log` VALUES ('15', '0:0:0:0:0:0:0:1', 'admin', '2016-10-17 09:57:43');
INSERT INTO `log` VALUES ('16', '0:0:0:0:0:0:0:1', 'admin', '2016-10-17 10:21:57');
INSERT INTO `log` VALUES ('17', '0:0:0:0:0:0:0:1', 'test11', '2016-10-17 10:23:25');
INSERT INTO `log` VALUES ('18', '0:0:0:0:0:0:0:1', 'admin', '2016-10-17 11:23:03');
INSERT INTO `log` VALUES ('19', '0:0:0:0:0:0:0:1', 'admin', '2016-10-17 13:46:26');
INSERT INTO `log` VALUES ('20', '0:0:0:0:0:0:0:1', 'admin', '2016-10-17 14:08:42');
INSERT INTO `log` VALUES ('21', '0:0:0:0:0:0:0:1', 'admin', '2016-10-17 14:49:19');
INSERT INTO `log` VALUES ('22', '0:0:0:0:0:0:0:1', 'admin', '2016-10-17 15:32:49');
INSERT INTO `log` VALUES ('23', '0:0:0:0:0:0:0:1', 'admin', '2016-10-17 15:44:54');
INSERT INTO `log` VALUES ('24', '0:0:0:0:0:0:0:1', 'admin', '2016-10-17 16:17:13');
INSERT INTO `log` VALUES ('25', '0:0:0:0:0:0:0:1', 'admin', '2016-10-17 16:32:29');
INSERT INTO `log` VALUES ('26', '0:0:0:0:0:0:0:1', 'admin', '2016-10-18 16:47:59');
INSERT INTO `log` VALUES ('27', '0:0:0:0:0:0:0:1', 'test11', '2016-10-18 17:27:57');
INSERT INTO `log` VALUES ('28', '0:0:0:0:0:0:0:1', 'admin', '2016-10-18 19:08:44');
INSERT INTO `log` VALUES ('29', '0:0:0:0:0:0:0:1', 'admin', '2016-10-18 19:13:21');
INSERT INTO `log` VALUES ('30', '0:0:0:0:0:0:0:1', 'admin', '2016-10-18 20:14:01');
INSERT INTO `log` VALUES ('31', '0:0:0:0:0:0:0:1', 'admin', '2016-10-18 20:28:00');
INSERT INTO `log` VALUES ('32', '0:0:0:0:0:0:0:1', 'admin', '2016-10-18 20:32:20');
INSERT INTO `log` VALUES ('33', '0:0:0:0:0:0:0:1', 'admin', '2016-10-18 21:03:52');
INSERT INTO `log` VALUES ('34', '0:0:0:0:0:0:0:1', 'admin', '2016-10-18 21:04:05');
INSERT INTO `log` VALUES ('35', '0:0:0:0:0:0:0:1', 'admin', '2016-10-18 22:12:52');
INSERT INTO `log` VALUES ('36', '0:0:0:0:0:0:0:1', 'admin', '2016-10-18 22:20:30');
INSERT INTO `log` VALUES ('37', '0:0:0:0:0:0:0:1', 'admin', '2016-10-18 23:00:40');
INSERT INTO `log` VALUES ('38', '0:0:0:0:0:0:0:1', 'admin', '2016-10-19 08:03:08');
INSERT INTO `log` VALUES ('39', '0:0:0:0:0:0:0:1', 'admin', '2016-10-19 10:33:24');
INSERT INTO `log` VALUES ('40', '0:0:0:0:0:0:0:1', 'admin', '2016-10-19 10:48:44');
INSERT INTO `log` VALUES ('41', '0:0:0:0:0:0:0:1', 'admin', '2016-10-19 10:59:53');
INSERT INTO `log` VALUES ('42', '0:0:0:0:0:0:0:1', 'admin', '2016-10-19 11:02:46');
INSERT INTO `log` VALUES ('43', '0:0:0:0:0:0:0:1', 'admin', '2016-10-19 11:13:07');
INSERT INTO `log` VALUES ('44', '0:0:0:0:0:0:0:1', 'admin', '2016-10-19 12:46:56');
INSERT INTO `log` VALUES ('45', '0:0:0:0:0:0:0:1', 'admin', '2016-10-19 12:57:52');
INSERT INTO `log` VALUES ('46', '0:0:0:0:0:0:0:1', 'admin', '2016-10-19 13:56:47');
INSERT INTO `log` VALUES ('47', '0:0:0:0:0:0:0:1', 'test11', '2016-10-19 14:01:25');
INSERT INTO `log` VALUES ('48', '0:0:0:0:0:0:0:1', 'admin', '2016-10-19 14:07:17');
INSERT INTO `log` VALUES ('49', '0:0:0:0:0:0:0:1', 'admin', '2016-10-19 14:32:34');
INSERT INTO `log` VALUES ('50', '0:0:0:0:0:0:0:1', 'admin', '2016-10-20 16:53:58');
INSERT INTO `log` VALUES ('51', '0:0:0:0:0:0:0:1', 'admin', '2016-10-20 17:10:27');
INSERT INTO `log` VALUES ('52', '0:0:0:0:0:0:0:1', 'admin', '2016-10-20 17:26:29');
INSERT INTO `log` VALUES ('53', '0:0:0:0:0:0:0:1', 'admin', '2016-10-20 19:02:09');
INSERT INTO `log` VALUES ('54', '0:0:0:0:0:0:0:1', 'admin', '2016-10-20 19:38:17');
INSERT INTO `log` VALUES ('55', '0:0:0:0:0:0:0:1', 'admin', '2016-10-20 19:48:52');
INSERT INTO `log` VALUES ('56', '0:0:0:0:0:0:0:1', 'admin', '2016-10-20 19:59:19');
INSERT INTO `log` VALUES ('57', '0:0:0:0:0:0:0:1', 'admin', '2016-10-20 20:10:59');
INSERT INTO `log` VALUES ('58', '0:0:0:0:0:0:0:1', 'admin', '2016-10-20 20:21:26');
INSERT INTO `log` VALUES ('59', '0:0:0:0:0:0:0:1', 'admin', '2016-10-20 20:40:01');
INSERT INTO `log` VALUES ('60', '0:0:0:0:0:0:0:1', 'admin', '2016-10-20 20:50:33');
INSERT INTO `log` VALUES ('61', '0:0:0:0:0:0:0:1', 'admin', '2016-10-20 21:00:57');
INSERT INTO `log` VALUES ('62', '0:0:0:0:0:0:0:1', 'admin', '2016-10-20 21:16:06');
INSERT INTO `log` VALUES ('63', '0:0:0:0:0:0:0:1', 'admin', '2016-10-20 21:24:59');
INSERT INTO `log` VALUES ('64', '0:0:0:0:0:0:0:1', 'admin', '2016-10-21 08:22:03');
INSERT INTO `log` VALUES ('65', '0:0:0:0:0:0:0:1', 'admin', '2016-10-21 08:35:42');
INSERT INTO `log` VALUES ('66', '0:0:0:0:0:0:0:1', 'admin', '2016-10-21 09:13:04');
INSERT INTO `log` VALUES ('67', '0:0:0:0:0:0:0:1', 'admin', '2016-10-21 09:35:17');
INSERT INTO `log` VALUES ('68', '0:0:0:0:0:0:0:1', 'admin', '2016-10-21 09:52:56');
INSERT INTO `log` VALUES ('69', '0:0:0:0:0:0:0:1', 'admin', '2016-10-21 10:03:12');
INSERT INTO `log` VALUES ('70', '0:0:0:0:0:0:0:1', 'admin', '2016-10-21 10:13:58');
INSERT INTO `log` VALUES ('71', '0:0:0:0:0:0:0:1', 'admin', '2016-10-21 10:36:37');
INSERT INTO `log` VALUES ('72', '0:0:0:0:0:0:0:1', 'admin', '2016-10-21 11:00:26');
INSERT INTO `log` VALUES ('73', '0:0:0:0:0:0:0:1', 'admin', '2016-10-21 11:32:23');
INSERT INTO `log` VALUES ('74', '0:0:0:0:0:0:0:1', 'admin', '2016-10-21 14:09:23');
INSERT INTO `log` VALUES ('75', '0:0:0:0:0:0:0:1', 'admin', '2016-10-21 14:46:24');
INSERT INTO `log` VALUES ('76', '0:0:0:0:0:0:0:1', 'admin', '2016-10-23 09:24:59');
INSERT INTO `log` VALUES ('77', '0:0:0:0:0:0:0:1', 'admin', '2016-10-23 15:56:26');
INSERT INTO `log` VALUES ('78', '0:0:0:0:0:0:0:1', 'admin', '2016-10-23 20:36:47');
INSERT INTO `log` VALUES ('79', '0:0:0:0:0:0:0:1', 'admin', '2016-10-23 20:52:49');
INSERT INTO `log` VALUES ('80', '0:0:0:0:0:0:0:1', 'admin', '2016-10-23 22:07:32');
INSERT INTO `log` VALUES ('81', '0:0:0:0:0:0:0:1', 'admin', '2016-10-23 22:17:54');
INSERT INTO `log` VALUES ('82', '0:0:0:0:0:0:0:1', 'admin', '2016-10-23 22:32:18');
INSERT INTO `log` VALUES ('83', '0:0:0:0:0:0:0:1', 'admin', '2016-10-23 23:32:01');
INSERT INTO `log` VALUES ('84', '0:0:0:0:0:0:0:1', 'admin', '2016-10-24 00:13:27');
INSERT INTO `log` VALUES ('85', '0:0:0:0:0:0:0:1', 'admin', '2016-10-24 08:48:19');
INSERT INTO `log` VALUES ('86', '127.0.0.1', 'admin', '2016-10-24 14:17:48');
INSERT INTO `log` VALUES ('87', '0:0:0:0:0:0:0:1', 'admin', '2016-10-24 16:30:14');
INSERT INTO `log` VALUES ('88', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-10-26 09:57:47');
INSERT INTO `log` VALUES ('89', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-10-26 10:56:29');
INSERT INTO `log` VALUES ('90', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-10-27 00:36:21');
INSERT INTO `log` VALUES ('91', '0:0:0:0:0:0:0:1', 'test11', '2016-10-27 08:18:38');
INSERT INTO `log` VALUES ('92', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-10-27 08:45:16');
INSERT INTO `log` VALUES ('93', '0:0:0:0:0:0:0:1', 'test11', '2016-10-27 09:25:20');
INSERT INTO `log` VALUES ('94', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-10-27 09:29:33');
INSERT INTO `log` VALUES ('95', '0:0:0:0:0:0:0:1', 'test3', '2016-10-27 09:31:52');
INSERT INTO `log` VALUES ('96', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-10-27 09:34:17');
INSERT INTO `log` VALUES ('97', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-10-27 09:35:05');
INSERT INTO `log` VALUES ('98', '0:0:0:0:0:0:0:1', 'hjadmintest', '2016-10-27 09:38:49');
INSERT INTO `log` VALUES ('99', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-10-27 15:22:22');
INSERT INTO `log` VALUES ('100', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-10-27 20:54:42');
INSERT INTO `log` VALUES ('101', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-10-27 21:25:50');
INSERT INTO `log` VALUES ('102', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-10-27 23:06:29');
INSERT INTO `log` VALUES ('103', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-10-28 08:10:18');
INSERT INTO `log` VALUES ('104', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-10-28 10:05:35');
INSERT INTO `log` VALUES ('105', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-10-28 14:45:02');
INSERT INTO `log` VALUES ('106', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-10-28 14:53:29');
INSERT INTO `log` VALUES ('107', '0:0:0:0:0:0:0:1', 'hjadmintest', '2016-10-28 15:57:59');
INSERT INTO `log` VALUES ('108', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-10-28 21:07:57');
INSERT INTO `log` VALUES ('109', '0:0:0:0:0:0:0:1', 'hjadmintest', '2016-10-28 21:18:53');
INSERT INTO `log` VALUES ('110', '0:0:0:0:0:0:0:1', 'hjadmintest', '2016-10-28 21:22:11');
INSERT INTO `log` VALUES ('111', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-10-29 06:12:26');
INSERT INTO `log` VALUES ('112', '0:0:0:0:0:0:0:1', 'hjadmintest', '2016-10-29 06:30:53');
INSERT INTO `log` VALUES ('113', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-10-29 08:38:24');
INSERT INTO `log` VALUES ('114', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-10-29 09:40:18');
INSERT INTO `log` VALUES ('115', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-10-30 20:20:49');
INSERT INTO `log` VALUES ('116', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-10-30 20:40:02');
INSERT INTO `log` VALUES ('117', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-10-31 09:22:49');
INSERT INTO `log` VALUES ('118', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-10-31 09:59:11');
INSERT INTO `log` VALUES ('119', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-10-31 10:15:52');
INSERT INTO `log` VALUES ('120', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-10-31 10:42:33');
INSERT INTO `log` VALUES ('121', '0:0:0:0:0:0:0:1', 'hjadmintest', '2016-10-31 10:45:15');
INSERT INTO `log` VALUES ('122', '0:0:0:0:0:0:0:1', 'hjadmintest', '2016-10-31 11:13:14');
INSERT INTO `log` VALUES ('123', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-10-31 11:28:21');
INSERT INTO `log` VALUES ('124', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-10-31 13:32:48');
INSERT INTO `log` VALUES ('125', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-11-02 09:43:30');
INSERT INTO `log` VALUES ('126', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-11-02 14:38:30');
INSERT INTO `log` VALUES ('127', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-11-02 20:50:03');
INSERT INTO `log` VALUES ('128', '0:0:0:0:0:0:0:1', 'hjadmintest', '2016-11-02 21:16:32');
INSERT INTO `log` VALUES ('129', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-11-03 08:47:38');
INSERT INTO `log` VALUES ('130', '0:0:0:0:0:0:0:1', 'hjadmintest', '2016-11-03 11:14:57');
INSERT INTO `log` VALUES ('131', '0:0:0:0:0:0:0:1', 'hjadmintest', '2016-11-03 13:48:47');
INSERT INTO `log` VALUES ('132', '0:0:0:0:0:0:0:1', 'hjadmintest', '2016-11-03 13:49:02');
INSERT INTO `log` VALUES ('133', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-11-03 19:03:20');
INSERT INTO `log` VALUES ('134', '0:0:0:0:0:0:0:1', 'hjadmintest', '2016-11-04 10:17:37');
INSERT INTO `log` VALUES ('135', '0:0:0:0:0:0:0:1', 'hjadmintest', '2016-11-04 10:20:13');
INSERT INTO `log` VALUES ('136', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-11-04 10:31:22');
INSERT INTO `log` VALUES ('137', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-11-04 10:39:15');
INSERT INTO `log` VALUES ('138', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-11-04 11:05:24');
INSERT INTO `log` VALUES ('139', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-11-04 13:44:21');
INSERT INTO `log` VALUES ('140', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-11-04 13:44:58');
INSERT INTO `log` VALUES ('141', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-11-04 15:58:07');
INSERT INTO `log` VALUES ('142', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-11-04 16:01:49');
INSERT INTO `log` VALUES ('143', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-11-05 08:35:51');
INSERT INTO `log` VALUES ('144', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-11-05 10:00:08');
INSERT INTO `log` VALUES ('145', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-11-05 10:18:49');
INSERT INTO `log` VALUES ('146', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-11-06 09:12:51');
INSERT INTO `log` VALUES ('147', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-11-06 09:18:47');
INSERT INTO `log` VALUES ('148', '0:0:0:0:0:0:0:1', 'hjadmintest', '2016-11-06 09:20:28');
INSERT INTO `log` VALUES ('149', '0:0:0:0:0:0:0:1', 'hjadmintest', '2016-11-06 12:24:41');
INSERT INTO `log` VALUES ('150', '0:0:0:0:0:0:0:1', 'hjadmintest', '2016-11-06 12:36:48');
INSERT INTO `log` VALUES ('151', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-11-06 12:50:31');
INSERT INTO `log` VALUES ('152', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-11-06 13:31:50');
INSERT INTO `log` VALUES ('153', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-11-06 15:12:21');
INSERT INTO `log` VALUES ('154', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-11-06 15:38:38');
INSERT INTO `log` VALUES ('155', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-11-06 17:39:17');
INSERT INTO `log` VALUES ('156', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-11-06 17:44:29');
INSERT INTO `log` VALUES ('157', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-11-06 18:56:26');
INSERT INTO `log` VALUES ('158', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-11-06 21:30:27');
INSERT INTO `log` VALUES ('159', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-11-06 22:47:39');
INSERT INTO `log` VALUES ('160', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-11-07 00:10:39');
INSERT INTO `log` VALUES ('161', '0:0:0:0:0:0:0:1', 'hjadmintest', '2016-11-07 07:32:38');
INSERT INTO `log` VALUES ('162', '0:0:0:0:0:0:0:1', 'hjadmintest', '2016-11-07 07:55:55');
INSERT INTO `log` VALUES ('163', '0:0:0:0:0:0:0:1', 'hjadmintest', '2016-11-07 08:09:24');
INSERT INTO `log` VALUES ('164', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-11-07 09:38:54');
INSERT INTO `log` VALUES ('165', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-11-07 09:46:55');
INSERT INTO `log` VALUES ('166', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-11-07 09:56:31');
INSERT INTO `log` VALUES ('167', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-11-07 10:23:16');
INSERT INTO `log` VALUES ('168', '0:0:0:0:0:0:0:1', 'whgdyadmin', '2016-11-07 10:40:04');
INSERT INTO `log` VALUES ('169', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-11-07 10:44:32');
INSERT INTO `log` VALUES ('170', '0:0:0:0:0:0:0:1', 'hjadmintest', '2016-11-07 10:44:57');
INSERT INTO `log` VALUES ('171', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-11-07 14:03:52');
INSERT INTO `log` VALUES ('172', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-11-07 17:00:58');
INSERT INTO `log` VALUES ('173', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-11-07 18:00:57');
INSERT INTO `log` VALUES ('174', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-11-07 19:10:46');
INSERT INTO `log` VALUES ('175', '0:0:0:0:0:0:0:1', 'whgdyadmin', '2016-11-07 19:33:54');
INSERT INTO `log` VALUES ('176', '0:0:0:0:0:0:0:1', 'whgdyadmin', '2016-11-07 19:54:06');
INSERT INTO `log` VALUES ('177', '0:0:0:0:0:0:0:1', 'whgdyadmin', '2016-11-07 20:00:29');
INSERT INTO `log` VALUES ('178', '0:0:0:0:0:0:0:1', 'whgdyadmin', '2016-11-07 20:56:29');
INSERT INTO `log` VALUES ('179', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-11-07 22:29:05');
INSERT INTO `log` VALUES ('180', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-11-07 23:15:17');
INSERT INTO `log` VALUES ('181', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-11-07 23:35:19');
INSERT INTO `log` VALUES ('182', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-11-08 08:28:34');
INSERT INTO `log` VALUES ('183', '0:0:0:0:0:0:0:1', 'whgdyadmin', '2016-11-08 08:42:20');
INSERT INTO `log` VALUES ('184', '0:0:0:0:0:0:0:1', 'whgdyadmin', '2016-11-08 08:46:47');
INSERT INTO `log` VALUES ('185', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-11-08 09:42:32');
INSERT INTO `log` VALUES ('186', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-11-08 11:00:05');
INSERT INTO `log` VALUES ('187', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-11-18 18:41:09');
INSERT INTO `log` VALUES ('188', '0:0:0:0:0:0:0:1', 'whg_admin', '2016-12-06 16:33:56');
-- ----------------------------
-- Table structure for `msg`
-- ----------------------------
DROP TABLE IF EXISTS `msg`;
CREATE TABLE `msg` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `user_id` int(255) NOT NULL,
  `content` varchar(255) NOT NULL,
  `admin_id` int(255) NOT NULL,
  `admin_name` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of msg
-- ----------------------------
INSERT INTO `msg` VALUES ('1', '64', '2222', '1', 'whg_admin', '2016-10-31 14:21:58');
INSERT INTO `msg` VALUES ('3', '61', ' 您的资料未完善！请完善重新提交审核！', '1', 'whg_admin', '2016-10-31 14:29:53');
INSERT INTO `msg` VALUES ('4', '38', ' 1111111', '1', 'whg_admin', '2016-11-06 17:56:43');
INSERT INTO `msg` VALUES ('5', '100', ' 0000', '1', 'whg_admin', '2016-11-07 22:47:15');
-- ----------------------------
-- Table structure for `mz`
-- ----------------------------
DROP TABLE IF EXISTS `mz`;
CREATE TABLE `mz` (
  `mz_id` int(11) NOT NULL AUTO_INCREMENT,
  `mzname` varchar(20) NOT NULL,
  PRIMARY KEY (`mz_id`)
) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of mz
-- ----------------------------
INSERT INTO `mz` VALUES ('1', '汉族');
INSERT INTO `mz` VALUES ('2', '蒙古族');
INSERT INTO `mz` VALUES ('3', '回族');
INSERT INTO `mz` VALUES ('4', '藏族');
INSERT INTO `mz` VALUES ('5', '维吾尔族');
INSERT INTO `mz` VALUES ('6', '苗族');
INSERT INTO `mz` VALUES ('7', '彝族');
INSERT INTO `mz` VALUES ('8', '壮族');
INSERT INTO `mz` VALUES ('9', '布依族');
INSERT INTO `mz` VALUES ('10', '朝鲜族');
INSERT INTO `mz` VALUES ('11', '满族');
INSERT INTO `mz` VALUES ('12', '侗族');
INSERT INTO `mz` VALUES ('13', '瑶族');
INSERT INTO `mz` VALUES ('14', '白族');
INSERT INTO `mz` VALUES ('15', '土家族');
INSERT INTO `mz` VALUES ('16', '哈尼族');
INSERT INTO `mz` VALUES ('17', '哈萨克族');
INSERT INTO `mz` VALUES ('18', '傣族');
INSERT INTO `mz` VALUES ('19', '黎族');
INSERT INTO `mz` VALUES ('20', '傈僳族');
INSERT INTO `mz` VALUES ('21', '佤族');
INSERT INTO `mz` VALUES ('22', '畲族');
INSERT INTO `mz` VALUES ('23', '高山族');
INSERT INTO `mz` VALUES ('24', '拉祜族');
INSERT INTO `mz` VALUES ('25', '水族');
INSERT INTO `mz` VALUES ('26', '东乡族');
INSERT INTO `mz` VALUES ('27', '纳西族');
INSERT INTO `mz` VALUES ('28', '景颇族');
INSERT INTO `mz` VALUES ('29', '柯尔克孜族');
INSERT INTO `mz` VALUES ('30', '土族');
INSERT INTO `mz` VALUES ('31', '达斡尔族');
INSERT INTO `mz` VALUES ('32', '仫佬族');
INSERT INTO `mz` VALUES ('33', '羌族');
INSERT INTO `mz` VALUES ('34', ' 布朗族');
INSERT INTO `mz` VALUES ('35', ' 撒拉族');
INSERT INTO `mz` VALUES ('36', ' 毛难族');
INSERT INTO `mz` VALUES ('37', ' 仡佬族');
INSERT INTO `mz` VALUES ('38', ' 锡伯族');
INSERT INTO `mz` VALUES ('39', ' 阿昌族');
INSERT INTO `mz` VALUES ('40', ' 普米族');
INSERT INTO `mz` VALUES ('41', ' 塔吉克族');
INSERT INTO `mz` VALUES ('42', ' 怒族');
INSERT INTO `mz` VALUES ('43', ' 乌孜别克族');
INSERT INTO `mz` VALUES ('44', ' 俄罗斯族');
INSERT INTO `mz` VALUES ('45', ' 鄂温克族');
INSERT INTO `mz` VALUES ('46', ' 崩龙族');
INSERT INTO `mz` VALUES ('47', ' 保安族');
INSERT INTO `mz` VALUES ('48', ' 裕固族');
INSERT INTO `mz` VALUES ('49', ' 京族');
INSERT INTO `mz` VALUES ('50', ' 塔塔尔族');
INSERT INTO `mz` VALUES ('51', ' 独龙族');
INSERT INTO `mz` VALUES ('52', ' 鄂伦春族');
INSERT INTO `mz` VALUES ('53', ' 赫哲族');
INSERT INTO `mz` VALUES ('54', ' 门巴族');
INSERT INTO `mz` VALUES ('55', ' 珞巴族');
INSERT INTO `mz` VALUES ('56', ' 基诺族');
INSERT INTO `mz` VALUES ('57', ' 其他');
-- ----------------------------
-- Table structure for `system`
-- ----------------------------
DROP TABLE IF EXISTS `system`;
CREATE TABLE `system` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `keywords` text,
  `description` text,
  `copyright` varchar(255) DEFAULT NULL,
  `record` varchar(255) DEFAULT NULL,
  `statistics_code` text,
  `open` int(11) NOT NULL,
  `version` float(20,3) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of system
-- ----------------------------
INSERT INTO `system` VALUES ('1', '东营市社会文艺人才信息资源库', '关键词设置2', '网站描述设置', '东营市文化馆版权所有', '鲁ICP备00000000001号', ' 统计代码设置', '0', '1.000');
-- ----------------------------
-- Table structure for `uploads`
-- ----------------------------
DROP TABLE IF EXISTS `uploads`;
CREATE TABLE `uploads` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `user_id` int(255) NOT NULL,
  `type` varchar(100) NOT NULL,
  `path` varchar(255) NOT NULL,
  `create_time` varchar(255) NOT NULL,
  `remarks` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of uploads
-- ----------------------------
INSERT INTO `uploads` VALUES ('1', '37', '1', '20160822020450_207881.png', '2016-10-16 12:37:05', null);
INSERT INTO `uploads` VALUES ('2', '37', '1', '20160822020450_207882.png', '2016-10-16 13:36:51', null);
INSERT INTO `uploads` VALUES ('3', '37', '1', '20160822020450_207884.png', '2016-10-17 13:47:06', null);
INSERT INTO `uploads` VALUES ('4', '37', '1', '20160822020450_207885.png', '2016-10-17 16:37:35', null);
INSERT INTO `uploads` VALUES ('5', '47', '1', '20130201170240514529.jpg', '2016-10-19 12:18:50', null);
INSERT INTO `uploads` VALUES ('6', '47', '1', '201302011702405145291.jpg', '2016-10-19 12:20:17', null);
INSERT INTO `uploads` VALUES ('7', '47', '1', '201302011702405145292.jpg', '2016-10-19 12:20:38', null);
-- ----------------------------
-- Table structure for `upload_audio`
-- ----------------------------
DROP TABLE IF EXISTS `upload_audio`;
CREATE TABLE `upload_audio` (
  `id` int(255) NOT NULL,
  `user_id` int(255) NOT NULL,
  `path` varchar(255) NOT NULL,
  `create_time` varchar(255) NOT NULL,
  `remarks` varchar(255) DEFAULT NULL,
  `size` int(255) NOT NULL DEFAULT '100',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of upload_audio
-- ----------------------------
-- ----------------------------
-- Table structure for `upload_photo`
-- ----------------------------
DROP TABLE IF EXISTS `upload_photo`;
CREATE TABLE `upload_photo` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `user_id` int(255) NOT NULL,
  `path` varchar(255) NOT NULL,
  `create_time` varchar(255) NOT NULL,
  `remarks` varchar(255) DEFAULT NULL,
  `size` int(255) NOT NULL DEFAULT '100',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of upload_photo
-- ----------------------------
INSERT INTO `upload_photo` VALUES ('2', '47', '1111111', '11111', '11111', '100');
INSERT INTO `upload_photo` VALUES ('1', '47', '22222', '22222', '22222', '100');
INSERT INTO `upload_photo` VALUES ('3', '47', '201302011702405145293.jpg', '2016-10-19 12:26:15', '庞勇', '100');
INSERT INTO `upload_photo` VALUES ('4', '47', '649830154.jpg', '2016-10-19 12:28:00', '庞勇', '100');
INSERT INTO `upload_photo` VALUES ('5', '47', '60-130220143607.jpg', '2016-10-24 00:33:34', '庞勇', '100');
INSERT INTO `upload_photo` VALUES ('6', '47', '60-1302201436072.jpg', '2016-10-24 09:11:13', '庞勇', '100');
INSERT INTO `upload_photo` VALUES ('7', '47', 'file', '2016-10-24 10:53:30', '庞勇', '100');
INSERT INTO `upload_photo` VALUES ('8', '47', '60-130220143607.jpg', '2016-10-24 11:08:19', '庞勇', '100');
INSERT INTO `upload_photo` VALUES ('9', '47', '60-130220143607.jpg', '2016-10-24 11:09:05', '庞勇', '100');
INSERT INTO `upload_photo` VALUES ('10', '47', 'jbg.jpg', '2016-10-24 11:12:13', '庞勇', '100');
INSERT INTO `upload_photo` VALUES ('11', '47', 'ec8d5256bc06f18449980ed7cca921f6.png', '2016-10-24 11:30:14', '庞勇', '100');
-- ----------------------------
-- Table structure for `upload_video`
-- ----------------------------
DROP TABLE IF EXISTS `upload_video`;
CREATE TABLE `upload_video` (
  `id` int(255) NOT NULL,
  `user_id` int(255) NOT NULL,
  `path` varchar(255) NOT NULL,
  `create_time` varchar(255) NOT NULL,
  `remarks` varchar(255) DEFAULT NULL,
  `size` int(255) NOT NULL DEFAULT '100',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of upload_video
-- ----------------------------
-- ----------------------------
-- Table structure for `user`
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uname` varchar(20) NOT NULL,
  `true_name` varchar(255) DEFAULT NULL,
  `pwd` varchar(255) DEFAULT NULL,
  `dec_id` int(11) unsigned zerofill DEFAULT NULL,
  `media_path` varchar(255) DEFAULT NULL,
  `join_work` varchar(30) DEFAULT NULL,
  `usersex` enum('1','0') DEFAULT '1',
  `mz_id` int(10) unsigned zerofill DEFAULT NULL,
  `zzmm_id` int(10) unsigned zerofill DEFAULT NULL,
  `p_degree_school` varchar(255) DEFAULT NULL,
  `p_edu_school` varchar(255) DEFAULT NULL,
  `p_degree_id` int(11) DEFAULT NULL,
  `p_edu_id` int(11) DEFAULT NULL,
  `f_edu_school` varchar(255) DEFAULT NULL,
  `f_degree_school` varchar(255) DEFAULT NULL,
  `f_degree_id` int(11) DEFAULT NULL,
  `f_edu_id` int(11) DEFAULT NULL,
  `card` varchar(255) DEFAULT NULL,
  `area_id` varchar(20) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `company` varchar(255) DEFAULT NULL,
  `ysjj` varchar(255) DEFAULT NULL,
  `health` varchar(255) DEFAULT NULL,
  `reg_date` varchar(255) NOT NULL,
  `status` int(10) DEFAULT NULL,
  `birth` datetime DEFAULT NULL,
  `photo_path` varchar(255) DEFAULT NULL,
  `technical_position` varchar(255) DEFAULT NULL,
  `company_tel` varchar(255) DEFAULT NULL,
  `socio_part_time` varchar(255) DEFAULT NULL,
  `telephone` varchar(100) DEFAULT NULL,
  `awards` varchar(255) DEFAULT NULL,
  `opinion` varchar(255) DEFAULT NULL,
  `business_achievement` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `qqwx` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=105 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('31', 'py', '张三', '5D23494D3D93A7EF5BDA2FCE1091C7A41', '00000000001', '111', '2016-10-20', '0', '0000000001', '0000000001', '国防科技大学', '中国科技大学', '1', '1', '东营职业学院', '山东师范大学', '1', '1', '372321199999999999', '1', '山东省东营市', '山东汇佳', '中央戏剧表演 ', '健康', '2016-10-08 16:05:55', '0', '2016-10-14 09:49:59', '235.jpg', '志愿者', '8086998', '社会兼职 ', '15762188888', '表演一等奖', '希望申请通过', '销售实习 ', 'sdhj@huijiasoft.com', '1253973173');
INSERT INTO `user` VALUES ('33', 'pangyong', '张三', '7B7047748C146671550A41036E2333EC1', '00000000001', '111', '2016-10-20', '0', '0000000001', '0000000001', '国防科技大学', '中国科技大学', '2', '2', '东营职业学院', '山东师范大学', '3', '2', '372321199999999999', '1', '山东省东营市', '山东汇佳', '中央戏剧表演  ', '健康', '2016-10-11 08:24:51', '0', '2016-10-08 16:05:55', '2317.jpg', '红年志愿者', '8086998', '社会兼职  ', '15762188888', ' 表演二等奖', '希望申请通过', '销售实习  ', 'fengxiao@dywhg.com', '1253973173');
INSERT INTO `user` VALUES ('35', '汇佳软件', '张三3', '9A42B2FDE562AD64942EE3058498251D1', '00000000001', '111', '2016-10-20', '0', '0000000001', '0000000001', '国防科技大学', '中国科技大学', '1', '1', '东营职业学院', '山东师范大学', '1', '1', '372321199999999999', '1', '山东省东营市', '山东汇佳', '艺术简介艺术简介', '健康', '2016-10-11 08:29:21', '1', '2016-10-08 16:05:55', 'defaultheadpic.jpg', '中年志愿者', '8086998', '社会兼职', '15762188888', '表演三等奖', '希望申请通过', '销售实习', 'fengxiao@dywhg.com', '1253973173');
INSERT INTO `user` VALUES ('36', '山东汇佳软件', '张三4', '3501B4E771BA5C7A744E8B16E8CEF916E1', '00000000001', '111', '2016-10-20', '1', '0000000001', '0000000001', '国防科技大学', '中国科技大学', '1', '1', '东营职业学院', '山东师范大学', '1', '1', '372321199999999999', '1', '山东省东营市', '山东汇佳', '艺术简介艺术简介', '健康', '2016-10-11 15:45:06', '1', '2016-10-08 16:05:55', 'defaultheadpic.jpg', '志愿者', '8086998', '社会兼职', '15762188888', ' 表演四等奖', '希望申请通过', '销售实习', 'fengxiao@dywhg.com', '1253973173');
INSERT INTO `user` VALUES ('37', '张三5', '张三5', '4501195721962DCDADBFC33F8C0DD6E31', '00000000001', '111', '2016-10-20', '1', '0000000001', '0000000001', '国防科技大学', '中国科技大学', '1', '1', '东营职业学院', '山东师范大学', '1', '1', '372321199999999999', '1', '山东省东营市', '山东汇佳', ' 中国表演大学', '健康', '2016-10-12 15:13:12', '1', '2016-10-08 16:05:55', 'c908593ded2e3450cd6656e64b95526c.png', '青年志愿', '8086998', '社会兼职', '15762188888', ' 表演五等奖', '希望申请通过', '销售实习', 'fengxiao@dywhg.com', '1253973173');
INSERT INTO `user` VALUES ('38', '庞庞', '张三6', '9D46A6083C6EBDDCFB898DAB58EAFD7F1', '00000000001', '111', '2016-10-20', '0', '0000000001', '0000000001', '国防科技大学', '中国科技大学', '3', '1', '东营职业学院', '山东师范大学', '1', '1', '372321199999999999', '1', '山东省东营市', '山东汇佳', '艺术简介艺术简介 ', '健康', '2016-10-13 22:47:39', '0', '2016-10-08 16:05:55', '14.jpg', '青年者远着', '8086998', '社会兼职 ', '15762188888', ' 表演特等奖', '希望申请通过', '销售实习 ', 'sdhj@huijiasoft.com', '1253973173');
INSERT INTO `user` VALUES ('39', 'admin', '张三7', '6E0F084E2078D7E28093027420CDD7761', '00000000001', '111', '2016-10-20', '1', '0000000006', '0000000004', '国防科技大学', '中国科技大学', '2', '1', '东营职业学院', '山东师范大学', '2', '1', '372321199999999999', '4', '山东省东营市', '山东汇佳', ' 中国表演大学', '健康', '2016-10-14 09:49:17', '1', '2016-10-08 16:05:55', 'defaultheadpic.jpg', '志愿者', '8086998', '社会兼职', '15762188888', ' 表演奖', '希望申请通过', '销售实习', 'fengxiao@dywhg.com', '1253973173');
INSERT INTO `user` VALUES ('40', '庞永', '张三8', 'DD015661785A22BDED41F84D206AF94E1', '00000000003', '111', '2016-10-20', '0', '0000000006', '0000000004', '国防科技大学', '中国科技大学', '2', '1', '东营职业学院', '山东师范大学', '3', '1', '372321199999999999', '3', '山东省东营市', '山东汇佳', '中央戏剧学院', '健康', '2016-10-14 09:49:59', '1', '2016-10-08 16:05:55', 'defaultheadpic.jpg', '志愿者', '8086998', '社会兼职', '15762188888', ' 参与奖', '希望申请通过', '销售实习', 'fengxiao@dywhg.com', '1253973173');
INSERT INTO `user` VALUES ('41', 'hjsoft', '李毅', 'D3D8CB79B6CF54CB37B49E9A33D64F7B1', '00000000001', '111', '2016-10-20', '1', '0000000001', '0000000001', '国防科技大学', '中国科技大学', '3', '1', '东营职业学院', '山东师范大学', '1', '1', '372321199999999999', '1', '山东省滨州市', '山东汇佳', ' 中国表演大学', '健康', '2016-10-16 09:24:42', '1', '2016-10-14 09:49:59', 'defaultheadpic.jpg', '志愿者', '8086998', '社会兼职', '15762188888', ' 参与奖', '希望申请通过', '销售实习', 'fengxiao@dywhg.com', '1253973173');
INSERT INTO `user` VALUES ('42', 'py1', '李毅', 'C8CDCB4D499B4586FD0204CAF0F025501', '00000000001', '111', '2016-10-20', '0', '0000000001', '0000000001', '国防科技大学', '中国科技大学', '1', '1', '东营职业学院', '山东师范大学', '1', '1', '372321199999999999', '1', '山东省滨州市', '山东汇佳', '艺术简介', '健康', '2016-10-16 13:55:02', '1', '2016-10-14 09:49:59', 'defaultheadpic.jpg', '志愿者', '8088098', '兼职', '15762182222', '获奖情况', '申请意见', '业务成就', 'fengxiao@dywhg.com', '1253973173');
INSERT INTO `user` VALUES ('43', 'py2', '庞庞', '2CEAF68A3D72AC13E036C18334B0EFE61', '00000000001', '111', '2016-10-20', '1', '0000000001', '0000000001', '国防科技大学', '中国科技大学', '2', '1', '东营职业学院', '山东师范大学', '1', '3', '372321199999999999', '1', '山东省滨州市', '山东汇佳', ' 中国表演大学', '健康', '2016-10-16 15:13:52', '0', '2016-10-14 09:49:59', '20160822020450_207883.png', '计算机', '8088098', '兼职', '15762182222', '获奖情况', '申请意见', '业务成就', 'fengxiao@dywhg.com', '1253973173');
INSERT INTO `user` VALUES ('47', 'huijia1', '庞庞', '3F88F8754440E99D904120FD9D706EB31', '00000000001', '111', '2016-10-20', '0', '0000000002', '0000000004', '国防科技大学', '中国科技大学', '2', '1', '东营职业学院', '山东师范大学', '1', '1', '372321199999999999', '2', '山东省东营市', '山东汇佳', '中央戏剧表演', '健康', '2016-10-19 09:55:21', '1', '2016-10-14 09:49:59', '2.png', '志愿者', '8088098', '社会兼职', '15762188888', '获奖情况', '申请意见', '销售实习', 'fengxiao@dywhg.com', '1253973173');
INSERT INTO `user` VALUES ('49', 'huijiaruanjian', '李毅', '61821777D6C4DCCFE12B17537B4CD67A1', '00000000007', '111', '2016-10-20', '1', '0000000004', '0000000002', '国防科技大学', '中国科技大学', '2', '1', '东营职业学院', '山东师范大学', '1', '1', '372321199999999999', '4', '山东省东营市', '山东汇佳', '中央戏剧表演', '健康', '2016-10-19 13:54:05', '0', '2016-10-14 09:49:59', '1.jpg', '志愿者', '8088098', '社会兼职', '15762188888', '获奖情况', '申请意见', '销售实习', 'fengxiao@dywhg.com', '1253973173');
INSERT INTO `user` VALUES ('51', '汇佳软件123', '赵六', 'D3934F91D32DB7D01525110DAA700B021', '00000000002', '111', '2016-10-20', '1', '0000000005', '0000000003', '国防科技大学', '中国科技大学', '2', '1', '东营职业学院', '山东师范大学', '1', '1', '372321199999999999', '2', '山东省东营市', '山东汇佳', '中央戏剧表演', '健康', '2016-10-21 14:19:14', '0', '2016-10-14 09:49:59', 'defaultheadpic.jpg', '志愿者', '8088098', '社会兼职', '15762188888', '获奖情况', '申请意见', '销售实习', 'fengxiao@dywhg.com', '1253973173');
INSERT INTO `user` VALUES ('56', 'test111', '王五', '6BE59AE979C90B444984AD796D30EEDF1', '00000000003', '111', '2016-10-20', '1', '0000000006', '0000000004', '国防科技大学', '中国科技大学', '2', '1', '东营职业学院', '山东师范大学', '1', '1', '372321199999999999', '1', '山东省东营市', '山东汇佳', '中央戏剧表演', '健康', '2016-10-23 21:59:55', '1', '2016-10-14 09:49:59', 'test7.jpg', '志愿者', '8088098', '社会兼职', '15762188888', '获奖情况', '申请意见', '销售实习', 'fengxiao@dywhg.com', '1253973173');
INSERT INTO `user` VALUES ('57', 'test121', '李四', '12B406E2D13873E684EAD9E7B4832DC01', '00000000004', '111', '2016-10-20', '1', '0000000007', '0000000003', '国防科技大学', '中国科技大学', '2', '1', '东营职业学院', '山东师范大学', '1', '1', '372321199999999999', '3', '山东省东营市', '山东汇佳', '中央戏剧表演', '健康', '2016-10-23 22:08:24', '0', '2016-10-14 09:49:59', 'test8.jpg', '志愿者', '8088098', '社会兼职', '15762188888', '获奖情况', '申请意见', '销售实习', 'fengxiao@dywhg.com', '1253973173');
INSERT INTO `user` VALUES ('58', 'test122', '张三', 'AE938DA2B3434577647CB4985A7FBCAA1', '00000000005', '111', '2016-10-20', '1', '0000000011', '0000000003', '国防科技大学', '中国科技大学', '2', '1', '东营职业学院', '山东师范大学', '1', '1', '372321199999999999', '4', '山东省东营市', '山东汇佳', '中央戏剧表演', '健康', '2016-10-23 22:15:06', '1', '2016-10-14 09:49:59', 'test9.jpg', '志愿者', '8088098', '社会兼职', '15762188888', '获奖情况', '申请意见', '销售实习', 'fengxiao@dywhg.com', '1253973173');
INSERT INTO `user` VALUES ('60', 'test222', '庞庞', '6B5ED554EBFF2FC7A0BAB042F4894D6C1', '00000000006', '111', '2016-10-20', '0', '0000000016', '0000000001', '国防科技大学', '中国科技大学', '2', '1', '东营职业学院', '山东师范大学', '1', '2', '372321199999999999', '2', '山东省滨州市', '山东汇佳', '中央戏剧表演', '健康', '2016-10-24 09:27:38', '1', '2016-10-14 09:49:59', 'test11.jpg', '志愿者', '8088098', '社会兼职', '15762182222', '获奖情况', '申请意见', '销售实习', 'fengxiao@dywhg.com', '1253973173');
INSERT INTO `user` VALUES ('61', 'whg_u_test', '冯晓', '541D8E7669A0D6433CB656564A9CABCA', '00000000001', '1busn9y9ac92y1ap9j4khzaej8', '2016-10-12', '0', '0000000001', '0000000001', '国防科技大学', '中国科技大学', '3', '2', '东营职业学院', '山东师范大学', '1', '1', '372321199999999999', '1', '山东省东营市', '山东汇佳', '中央戏剧表演 ', '健康', '2016-10-26 17:27:55', '1', '2016-10-14 09:49:59', '16.jpg', '志愿者', '8088098', '社会兼职 ', '15762182222', '获奖情况', '   申请意见', '销售实习 ', 'fengxiao@dywhg.com', '1253973173');
INSERT INTO `user` VALUES ('65', '1wqass', '李毅', '576161E8E1474F403F0D20D5D5A66C84', '00000000001', '111', '2016-10-20', '0', '0000000002', '0000000001', '国防科技大学', '中国科技大学', '2', '1', '东营职业学院', '山东师范大学', '2', '1', '372321199999999999', '1', '山东省滨州市', '山东汇佳', '中央戏剧表演', '健康', '2016-10-27 23:13:00', '1', '2016-10-14 09:49:59', 'test1.jpg', '志愿者', '8088098', '社会兼职', '15762188888', '获奖情况', '申请意见', '销售实习', 'fengxiao@dywhg.com', '1253973173');
INSERT INTO `user` VALUES ('66', 'testtest', '李毅', '65B1C226260E76882E0710061CD2328F', '00000000001', '111', '2016-10-24', '0', '0000000001', '0000000001', '国防科技大学', '中国科技大学', '2', '1', '东营职业学院', '山东师范大学', '1', '2', '372321199999999999', '3', '山东省滨州市', '山东汇佳', '12333', '健康', '2016-10-28 14:45:57', '1', '2016-10-14 09:49:59', 'test2.jpg', '志愿者', '8088098', '12333', '15762182222', '12333', '12333', '12333', 'fengxiao@dywhg.com', '1253973173');
INSERT INTO `user` VALUES ('67', '1111111', '李毅', '83B48D27C60F75238C97CD8E5176FCF5', '00000000001', '111', '2016-10-05', '0', '0000000001', '0000000001', '国防科技大学', '中国科技大学', '2', '1', '东营职业学院', '山东师范大学', '1', '1', '372321199999999999', '2', '山东省滨州市', '山东汇佳', '111111', '健康', '2016-10-28 14:56:54', '1', '2016-10-14 09:49:59', 'test3.jpg', '志愿者', '8088098', '111111', '15762182222', '111111', '111111', '111111', 'fengxiao@dywhg.com', '1253973173');
INSERT INTO `user` VALUES ('68', 'qqq', 'zhaa', 'AD365847CC139760C8AF73F2947BE605', '00000000001', '111', '2016-10-04', '0', '0000000001', '0000000001', '国防科技大学', '中国科技大学', '2', '1', '东营职业学院', '山东师范大学', '1', '1', '372321199999999999', '5', '山东省滨州市', '山东汇佳', '11111111111', '健康', '2016-10-28 15:10:31', '1', '2016-10-14 09:49:59', 'test4.jpg', '志愿者', '8088098', '11111111111', '15762182222', '11111111111', '11111111111', '11111111111', 'fengxiao@dywhg.com', '1253973173');
INSERT INTO `user` VALUES ('69', 'py123456', '我的真实姓名', '9FB0B49F9C221ED1FF01305709097B9D', '00000000001', '111', '2016-10-03', '0', '0000000001', '0000000001', '国防科技大学', '中国科技大学', '2', '1', '东营职业学院', '山东师范大学', '1', '1', '372321199999999999', '1', '山东省滨州市', '山东汇佳', '索引', '健康', '2016-10-31 09:24:13', '1', '2016-10-14 09:49:59', 'bkgrd2.png', '志愿者', '8088098', '索引', '15762182222', '索引', '索引', '索引', 'fengxiao@dywhg.com', '1253973173');
INSERT INTO `user` VALUES ('70', '前台', '我的真实姓名2', '4F1D9B55DA9D9B13685E3ED1A3CDAD99', '00000000001', '111', '2016-10-17', '0', '0000000001', '0000000001', '国防科技大学', '中国科技大学', '2', '1', '东营职业学院', '山东师范大学', '1', '1', '372321199999999999', '1', '山东省滨州市', '山东汇佳', '艺术', '健康', '2016-10-31 09:31:11', '1', '2016-10-14 09:49:59', '149b99c5a8fd16270fa050aacd2bd441.png', '志愿者', '8088098', '兼职', '15762182222', '获奖', '申请', '成就', 'fengxiao@dywhg.com', '1253973173');
INSERT INTO `user` VALUES ('76', 'pangPython', '我的真实姓名22', '8C5288517DF1185CFA6CEF8201353867', '00000000001', '1r23whlbnnxuvdkmcff9f130v', '2016-10-20', '0', '0000000001', '0000000001', '国防科技大学', '中国科技大学', '2', '1', '东营职业学院', '山东师范大学', '1', '1', '372321199999999999', '1', '山东省滨州市', '山东汇佳', '测试', '健康', '2016-10-31 10:17:43', '0', '2016-10-14 09:49:59', 'test.jpg', '志愿者', '8088098', '测试', '15762182222', '测试', '测试 ', '测试', 'fengxiao@dywhg.com', '1253973173');
INSERT INTO `user` VALUES ('77', 'mytest', '李毅', '4E426557FCBB5C29D96DFB1E35E754C9', '00000000001', '1bywtwx44rjrg148as4k95vjhy', '2016-10-25', '0', '0000000001', '0000000001', '国防科技大学', '中国科技大学', '2', '1', '东营职业学院', '山东师范大学', '1', '1', '372321199999999999', '1', '山东省滨州市', '山东汇佳', 'adasdasd', '健康', '2016-11-06 09:01:05', '0', '2016-11-06 00:00:00', 'test.jpg', '志愿者', '8088098', 'asdadasd', '15762182222', 'adasdasd', 'adasdasd ', 'adasdasd', 'fengxiao@dywhg.com', '1253973173');
INSERT INTO `user` VALUES ('78', 'yppang', '李毅', 'FCFDA46A7465BFCE567C582B0BFA3DA2', '00000000003', '111', '2016-11-06', '0', '0000000001', '0000000001', '国防科技大学', '中国科技大学', '2', '1', '东营职业学院', '山东师范大学', '1', '1', '372321199999999999', '1', '山东省滨州市', '山东汇佳', '按实际打开链接阿斯利康的', '健康', '2016-11-06 18:20:11', '1', '2016-11-06 00:00:00', '1.jpg', '志愿者', '8088098', '按实际打开链接阿斯利康的', '15762182222', '按实际打开链接阿斯利康的', '按实际打开链接阿斯利康的', '按实际打开链接阿斯利康的', 'sdhj@huijiasoft.com', '1253973173');
INSERT INTO `user` VALUES ('80', '庞庞', '张三6', 'C463746A12B1B964DE213A09C967455B', '00000000003', '111', '2016-10-20', '0', '0000000001', '0000000001', '国防科技大学', '中国科技大学', '2', '1', '东营职业学院', '山东师范大学', '1', '1', '372321199999999999', '1', '山东省东营市', '山东汇佳', '艺术简介艺术简介 ', '健康', '2016-11-06 23:54:21', '0', '2016-10-08 16:05:55', '12.jpg', '志愿者', '8086998', '社会兼职 ', '15762188888', ' 表演特等奖', '希望申请通过', '销售实习 ', 'sdhj@huijiasoft.com', '1253973173');
INSERT INTO `user` VALUES ('81', 'zheshi', '李毅', 'F698FE7D51C09F7D89E8E98E2CE01AB1', '00000000001', '111', '2016-11-07', '0', '0000000001', '0000000001', '国防科技大学', '中国科技大学', '2', '1', '东营职业学院', '山东师范大学', '1', '1', '372321199999999999', '1', '山东省滨州市', '山东汇佳', '这是测试', '健康', '2016-11-07 07:45:02', '0', '2016-11-07 00:00:00', '15.jpg', '志愿者', '8088098', '这是测试', '15762182222', '这是测试', '这是测试', '这是测试', 'sdhj@huijiasoft.com', '1253973173');
INSERT INTO `user` VALUES ('82', 'ceshiceshi', '李毅', '6BB847843FD5CBD61134A186EDF92018', '00000000001', '1b9o9p0u7nygr13lmb4yda9bd8', '2016-10-04', '0', '0000000001', '0000000001', '国防科技大学', '中国科技大学', '2', '1', '东营职业学院', '山东师范大学', '1', '1', '372321199999999999', '1', '山东省滨州市', '请问', 'ceshi', '健康', '2016-11-07 13:46:07', '0', '2016-11-08 00:00:00', '11.jpg', '志愿者', '8088098', 'ceshi', '15762182222', 'ceshi', 'ceshi ', 'ceshi', 'sdhj@huijiasoft.com', '1253973173');
INSERT INTO `user` VALUES ('83', 'zheshiceshi', '李毅', 'D416EE4EDEDD5BDC3EB460ECBC7220E1', '00000000001', '1rdq946mlwbgh1aoziots8u982', '2016-11-16', '0', '0000000001', '0000000001', '国防科技大学', '中国科技大学', '2', '1', '东营职业学院', '山东师范大学', '1', '1', '372321199999999999', '1', '山东省滨州市', '山东汇佳', 'http://www.wljx.net/forum-36-1.html', '健康', '2016-11-07 14:11:44', '0', '2016-11-06 00:00:00', '13.jpg', '计算机', '8088098', 'http://www.wljx.net/forum-36-1.html', '15762182222', 'http://www.wljx.net/forum-36-1.html', ' http://www.wljx.net/forum-36-1.html ', 'http://www.wljx.net/forum-36-1.html', 'sdhj@huijiasoft.com', '1253973173');
INSERT INTO `user` VALUES ('84', 'zheshiceshi2', '李毅', '0E6309477A60EAD622A0F0CB90987353', '00000000001', '111', '2016-11-08', '0', '0000000001', '0000000001', '国防科技大学', '中国科技大学', '2', '1', '东营职业学院', '山东师范大学', '1', '1', '372321199999999999', '1', '山东省滨州市', '山东汇佳', '这是测试', '健康', '2016-11-07 14:30:30', '0', '2016-11-06 00:00:00', '14.jpg', '计算机', '8088098', '这是测试', '15762182222', '这是测试', '这是测试', '这是测试', 'sdhj@huijiasoft.com', '1253973173');
INSERT INTO `user` VALUES ('85', '2ceshi', '李毅', 'A31CA07F50C7D8DFDA51892C85335643', '00000000001', 'kc7krjgl4fav1oa1sueioyk0f', '2016-11-07', '0', '0000000001', '0000000001', '国防科技大学', '中国科技大学', '1', '1', '东营职业学院', '山东师范大学', '1', '1', '372321199999999999', '1', '山东省滨州市', '山东汇佳', 'user. ', '健康', '2016-11-07 18:20:56', '0', '2016-11-07 00:00:00', '111.jpg', '计算机', '8088098', 'user ', '15762182222', 'user.', 'user.', 'user. ', 'sdhj@huijiasoft.com', '1253973173');
INSERT INTO `user` VALUES ('86', '3ceshi', '李毅', '6B1C5EF17C6F332A8526FA0F03BBC07E', '00000000001', 'ya9lv4hqnwiratldiyzyqlaf', '2016-11-06', '1', '0000000001', '0000000001', '国防科技大学', '中国科技大学', '2', '1', '东营职业学院', '山东师范大学', '2', '1', '372321199999999999', '1', '山东省滨州市', '山东汇佳', 'user.', '健康', '2016-11-07 18:31:39', '0', '2016-11-06 00:00:00', '1111.jpg', '计算机', '8088098', 'user·', '15762182222', 'user.', 'user.', 'user.', 'sdhj@huijiasoft.com', '1253973173');
INSERT INTO `user` VALUES ('87', '4ceshi', '李毅', '7CCB94DF56A46A836EC943A81CFEB2BE', '00000000002', '1t0f4wr6aurzl167uej9d9iqv8', '2016-11-07', '0', '0000000001', '0000000001', '国防科技大学', '中国科技大学', '3', '1', '东营职业学院', '山东师范大学', '1', '1', '372321199999999999', '1', '山东省滨州市', '山东汇佳', 'user.', '健康', '2016-11-07 18:38:17', '0', '2016-11-07 00:00:00', '23.jpg', '计算机', '8088098', 'user', '15762182222', 'user.', 'user.', 'user.', 'sdhj@huijiasoft.com', '1253973173');
INSERT INTO `user` VALUES ('88', 'ceshi123', '李毅', 'F528E897E7BBDB1E4F705BE349204EBF', '00000000001', 'tsgkbgf1rrrgwwd6js1saup4', '2016-11-09', '0', '0000000001', '0000000001', '国防科技大学', '中国科技大学', '2', '2', '东营职业学院', '山东师范大学', '1', '3', '372321199999999999', '1', '山东省滨州市', '山东汇佳', '测试', '健康', '2016-11-07 19:22:04', '0', '2016-10-04 00:00:00', '232.jpg', '计算机', '8088098', '测试', '15762182222', '测试', '测试', '测试', 'sdhj@huijiasoft.com', '1253973173');
INSERT INTO `user` VALUES ('89', 'ceshi1231', '李毅', 'EA06C129D5E18DA87B74C0ECBBBC802F', '00000000001', '2ywpjlgdvs01z5wm445y7id4', '2016-11-09', '0', '0000000001', '0000000001', '国防科技大学', '中国科技大学', '2', '2', '东营职业学院', '山东师范大学', '1', '3', '372321199999999999', '1', '山东省滨州市', '山东汇佳', '测试', '健康', '2016-11-07 19:24:28', '0', '2016-10-04 00:00:00', '1113.jpg', '计算机', '8088098', '测试', '15762182222', '测试', '测试', '测试', 'sdhj@huijiasoft.com', '1253973173');
INSERT INTO `user` VALUES ('90', 'cs123', '李毅', '64805426F2E4568F876162812E66AFFB', '00000000001', '1svfsnkas7u0jt7j3u91q5w73', '2016-11-07', '0', '0000000001', '0000000001', '国防科技大学', '中国科技大学', '2', '1', '东营职业学院', '山东师范大学', '1', '3', '372321199999999999', '1', '山东省滨州市', '山东汇佳', '测试', '健康', '2016-11-07 19:30:34', '0', '2016-11-07 00:00:00', '233.jpg', '计算机', '8088098', '测试', '15762182222', '测试', '测试', '测试', 'sdhj@huijiasoft.com', '1253973173');
INSERT INTO `user` VALUES ('91', 'mmytest12', '李毅', 'CB6572155898AE6A1B75981A514BB361', '00000000001', 'ouazhl1rcqidpspm28a8oykd', '2016-11-22', '0', '0000000001', '0000000001', '国防科技大学', '国防科技大学', '0', '0', '东营职业学院', '国防科技大学', '0', '0', '372321199999999999', '1', '山东省滨州市', '山东汇佳', '测试', '健康', '2016-11-07 19:31:35', '0', '2016-10-04 00:00:00', '234.jpg', '计算机', '8088098', '测试', '15762182222', '区测试', '测试', '测试', 'sdhj@huijiasoft.com', '1253973173');
INSERT INTO `user` VALUES ('92', 'mmytest123', '李毅', 'FB1FCDE4D43B3CD52EC698D4E0D47B6C', '00000000001', 'y5ig1g3x8mfo91t413xte1i8', '2016-11-09', '1', '0000000001', '0000000001', '国防科技大学', '中国科技大学', '1', '2', '东营职业学院2', '山东师范大学', '1', '1', '372321199999999999', '1', '山东省滨州市', '山东汇佳', '测试', '健康', '2016-11-07 19:48:21', '0', '2016-11-07 00:00:00', '237.jpg', null, '8088098', '测试', '15762182222', '测试', '测试', '测试', 'sdhj@huijiasoft.com', '1253973173');
INSERT INTO `user` VALUES ('93', 'mmytest4', '李惠安', '8F7881FD642DB50F14B257B30F05671B', '00000000001', 'ktfdgbo19x58f5udc5fr6n6g', '2016-11-07', '0', '0000000001', '0000000001', '国防科技大学', '中国科技大学', '2', '2', '东营职业学院2', '山东师范大学', '1', '2', '372321199999999999', '1', '山东省滨州市', '山东汇佳', '测试', '健康', '2016-11-07 19:55:15', '0', '2016-11-07 00:00:00', '238.jpg', '计算机', '8088098', '测试', '15762182222', '测试', '测试', '测试', 'sdhj@huijiasoft.com', '1253973173');
INSERT INTO `user` VALUES ('94', 'mmytest9', '李毅', '85E6857D16A8CBE045C9A2059D707AB0', '00000000001', '1fqsp4fhjxxvur9cuf03s4337', '2016-11-21', '0', '0000000001', '0000000001', '国防科技大学', '中国科技大学', '1', '1', '东营职业学院2', '山东师范大学', '1', '1', '372321199999999999', '1', '山东省滨州市', '山东汇佳', '测试', '健康', '2016-11-07 19:59:24', '0', '2016-11-06 00:00:00', '1115.jpg', '计算机', '8088098', '测试', '15762182222', '测试', '测试', '测试', 'sdhj@huijiasoft.com', '1253973173');
INSERT INTO `user` VALUES ('95', 'mmytest8', '汇华', 'C8A2E78E610187588D3AAF1E5867238B', '00000000001', '182jcx1hz8qtd9qhm9gtqx1rh', '2016-11-21', '0', '0000000001', '0000000001', '国防科技大学', '中国科技大学', '2', '1', '东营职业学院2', '山东师范大学', '3', '1', '372321199999999999', '1', '山东省滨州市', '山东汇佳', '测试', '健康', '2016-11-07 20:01:34', '0', '2016-11-07 00:00:00', '239.jpg', '计算机', '8088098', '测试', '15762182222', '测试', '测试', '测试', 'sdhj@huijiasoft.com', '1253973173');
INSERT INTO `user` VALUES ('96', 'mmytest7', '李毅', 'EFF0CEC062368CFB901853626EA3F20C', '00000000001', 'hwjq4r6iz4vu1mt9kjsinrif', '2016-11-22', '0', '0000000001', '0000000001', '国防科技大学', '中国科技大学', '3', '3', '东营职业学院', '山东师范大学', '1', '3', '372321199999999999', '1', '山东省滨州市', '山东汇佳', '测试', '健康', '2016-11-07 20:03:39', '0', '2016-11-14 00:00:00', '2310.jpg', '计算机', '8088098', '测试', '15762182222', '测试', '测试', '测试', 'sdhj@huijiasoft.com', '1253973173');
INSERT INTO `user` VALUES ('97', 'mmytest6', '李毅', '5A4FE3D5F3BFAEF2BBCA2DE780EEB74C', '00000000001', '1a2ovixp0hu0x1964yloi4jydu', '2016-11-07', '0', '0000000001', '0000000001', '国防科技大学', '中国科技大学', '3', '1', '东营职业学院', '山东师范大学', '2', '3', '372321199999999999', '1', '山东省滨州市', '山东汇佳', '测试', '健康', '2016-11-07 20:08:55', '0', '2016-11-07 00:00:00', '2311.jpg', '计算机', '8088098', '测试', '15762182222', '测试', '测试', '测试', 'sdhj@huijiasoft.com', '1253973173');
INSERT INTO `user` VALUES ('98', 'mmytest5', '李毅', 'BD7E1E15A35F038E85530DBE6DEC1555', '00000000001', '1l729es2zzhlo13lsupy0gq0m1', '2016-11-07', '0', '0000000001', '0000000001', '国防科技大学', '中国科技大学', '1', '1', '东营职业学院', '山东师范大学', '3', '1', '372321199999999999', '1', '山东省滨州市', '山东汇佳', '测试', '健康', '2016-11-07 20:10:27', '0', '2016-10-20 00:00:00', '2312.jpg', '计算机', '8088098', '测试', '15762182222', '测试', '测试', '测试', 'sdhj@huijiasoft.com', '1253973173');
INSERT INTO `user` VALUES ('99', 'mmytest43', '李毅', '8AEC0F2CE113E3DFEA7F6343BDA4E741', '00000000001', '1hu9atft6ewvx8v7ehnnvk5bd', '2016-11-15', '0', '0000000001', '0000000001', '国防科技大学', '中国科技大学', '1', '3', '东营职业学院', '山东师范大学', '2', '1', '372321199999999999', '1', '山东省滨州市', '山东汇佳', '测试', '健康', '2016-11-07 20:14:59', '0', '2016-10-03 00:00:00', '1116.jpg', '计算机', '8088098', '测试', '15762182222', '测试', '测试', '测试', 'sdhj@huijiasoft.com', '1253973173');
INSERT INTO `user` VALUES ('100', 'ceshi222', '李毅', '5FFBAC392F6568F4E9F59ABA8910D5F7', '00000000001', '12huslmcmcylk1w2u21nehji8g', '2016-11-22', '0', '0000000001', '0000000001', '国防科技大学', '中国科技大学', '0', '0', '东营职业学院', '山东师范大学', '0', '0', '372321199999999999', '1', '山东省滨州市', '山东汇佳', '测试测试  ', '健康', '2016-11-07 22:09:35', '0', '2016-11-07 00:00:00', '2315.jpg', '计算机', '8088098', '测试测试  ', '15762182222', '测试测试', ' 测试测试 ', '测试测试  ', 'sdhj@huijiasoft.com', '1253973173');
INSERT INTO `user` VALUES ('101', 'mmytest1231', '李毅', '843754618910BB606D46C836FB6FCC4B', '00000000001', '1uh19s7g30a1zqjggx3zfy6dq', '2016-11-07', '0', '0000000001', '0000000001', '国防科技大学', '中国科技大学', '1', '2', '东营职业学院', '山东师范大学', '1', '3', '372321199999999999', '1', '山东省滨州市', '山东汇佳', '测试', '健康', '2016-11-07 22:49:53', '0', '2016-11-07 00:00:00', '2316.jpg', '计算机', '8088098', '测试', '15762182222', '测试', '测试', '测试', 'sdhj@huijiasoft.com', '1253973173');
INSERT INTO `user` VALUES ('102', 'mmytest666', '李毅', '637D5F95E6A5CD60D4CF5F05C156A835', '00000000001', '68k1j7ygkf2e13dg7yyoh0y5t', '2016-11-07', '0', '0000000001', '0000000001', '国防科技大学', '中国科技大学', '2', '2', '东营职业学院', '山东师范大学', '2', '3', '372321199999999999', '1', '山东省滨州市', '山东汇佳', '稍等', '健康', '2016-11-08 08:44:50', '0', '2016-10-04 00:00:00', '2318.jpg', '计算机', '8088098', '稍等', '15762182222', '稍等', '稍等', '稍等', 'sdhj@huijiasoft.com', '1253973173');
INSERT INTO `user` VALUES ('103', 'haocunzheng', '郝存征', '918D0AB3DFA76DA203874B3EFFB9B879', '00000000001', '19ef9ahkav0rp1vyyfthxqacc8', '2016-11-09', '0', '0000000001', '0000000001', '滨州学院', '滨州学院', '1', '2', '滨州学院', '滨州学院', '1', '1', '1211111111111111', '1', '山偶的那个', '山东汇佳', '滨州行越远', '健康', '2016-11-18 18:16:35', '0', '2016-11-15 00:00:00', '19.jpg', '技术', '1765711', '滨州行越远', '1211212', '·滨州行越远', '滨州行越远 ', '滨州行越远', '12312@qq.com', '123123123');
INSERT INTO `user` VALUES ('104', 'admin123', '1111', '30D5C182D6CA8BF523139421C5080787', '00000000001', 'ck4pvnspxab71cjeu8i1wq2su', '2016-12-06', '0', '0000000001', '0000000001', ' ', ' ', '0', '0', ' ', ' ', '0', '0', '1111111', '1', '1111111', '1111111', null, '1111111', '2016-12-06 16:53:57', '0', '2016-12-07 00:00:00', 'timg1.jpg', '1111111', '1111111', null, '1111111', null, '                                  ', null, '1111111', '1111111');
-- ----------------------------
-- Table structure for `zzmm`
-- ----------------------------
DROP TABLE IF EXISTS `zzmm`;
CREATE TABLE `zzmm` (
  `zzmm_id` int(11) NOT NULL AUTO_INCREMENT,
  `zzmmname` varchar(20) NOT NULL,
  PRIMARY KEY (`zzmm_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of zzmm
-- ----------------------------
INSERT INTO `zzmm` VALUES ('1', '中共党员');
INSERT INTO `zzmm` VALUES ('2', ' 中共预备党员');
INSERT INTO `zzmm` VALUES ('3', ' 共青团员');
INSERT INTO `zzmm` VALUES ('4', ' 民革党员');
INSERT INTO `zzmm` VALUES ('5', ' 民盟盟员');
INSERT INTO `zzmm` VALUES ('6', ' 民建会员');
INSERT INTO `zzmm` VALUES ('7', ' 民进会员');
INSERT INTO `zzmm` VALUES ('8', ' 农工党党员');
INSERT INTO `zzmm` VALUES ('9', ' 致公党党员');
INSERT INTO `zzmm` VALUES ('10', ' 九三学社社员');
INSERT INTO `zzmm` VALUES ('11', ' 台盟盟员');
INSERT INTO `zzmm` VALUES ('12', ' 无党派民族人士');
INSERT INTO `zzmm` VALUES ('13', ' 普通公民(群众)');
Provide feedback

Saved searches

Use saved searches to filter your results more quickly

FilesExpand file tree

libdb_navicat.sql

Latest commit

History

libdb_navicat.sql

File metadata and controls
