Calculation/sql/data/zh_manager.sql

/*
Navicat MySQL Data Transfer

Source Server         : ubuntu-jl
Source Server Version : 50722
Source Host           : 192.168.1.70:3306
Source Database       : calculation

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

Date: 2019-06-05 10:07:47
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for zh_manager
-- ----------------------------
DROP TABLE IF EXISTS `zh_manager`;
CREATE TABLE `zh_manager` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `username` varchar(25) NOT NULL COMMENT '用户名',
  `password` varchar(50) NOT NULL COMMENT '密码',
  `create_time` int(10) NOT NULL COMMENT '创建时间',
  `last_login` int(10) DEFAULT NULL COMMENT '最后一次登录时间',
  `group_id` int(8) DEFAULT '0' COMMENT '用户组ID',
  `real_name` varchar(12) DEFAULT '' COMMENT '真实姓名',
  `telephone` varchar(11) DEFAULT '' COMMENT '联系电话(CLD字段)',
  `login_ip` varchar(13) DEFAULT '' COMMENT '登录ip',
  `token` varchar(8) NOT NULL COMMENT '随机token',
  `can_login` tinyint(1) DEFAULT '1' COMMENT '是否可登录',
  `office` int(11) DEFAULT '12' COMMENT '办事处id(CLD字段)',
  `category` varchar(100) DEFAULT '总部' COMMENT '办事处名称(CLD字段)',
  `email` varchar(255) DEFAULT NULL COMMENT '邮箱(CLD字段)',
  `qq` varchar(15) DEFAULT NULL COMMENT 'qq号(CLD字段)',
  `fixedphone` varchar(15) DEFAULT NULL COMMENT '固定电话(CLD字段)',
  `position` varchar(255) DEFAULT NULL COMMENT '职位(CLD字段)',
  PRIMARY KEY (`id`),
  KEY `idx_username` (`username`),
  KEY `idx_office` (`office`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COMMENT='后台用户数据表';

-- ----------------------------
-- Records of zh_manager
-- ----------------------------
INSERT INTO `zh_manager` VALUES ('1', 'admin', 'YjE2yt4IiZ0/Il4imhHYTetjj9k=', '0', '1559533108', '1', '测试', '15888888888', '127.0.0.1', 't62dhf', '1', '12', null, null, '123546545', '0756-6850221', null);
INSERT INTO `zh_manager` VALUES ('11', 'caiaolin', 'CLD Password', '1508743822', '1509346385', '1', 'caiaolin', '15888888888', '127.0.0.1', 'CLD', '1', '2', null, null, '123456', '0756-3850888', null);
INSERT INTO `zh_manager` VALUES ('12', '赖国然', 'CLD Password', '1539834754', '1557799810', '6', '赖国然', '13726259839', '127.0.0.1', 'CLD', '1', '12', '总部', '2661135450@qq.com', '2661135450', '', '程序员');
INSERT INTO `zh_manager` VALUES ('13', '陈特', 'CLD Password', '1541389795', '1557133315', '7', '陈特', '15812644017', '192.168.1.104', 'CLD', '1', '12', '总部', '914630468@qq.com', '914630468', '0756-3850891', '产品经理/网页设计');
INSERT INTO `zh_manager` VALUES ('14', '康彤', 'CLD Password', '1542095275', '1559620042', '1', '康彤', '13823093010', '127.0.0.1', 'CLD', '1', '12', '总部', '68104795@QQ.COM', '68104795', '13823093010', '');
INSERT INTO `zh_manager` VALUES ('15', '梁琪波', 'CLD Password', '1546595464', '1559283062', '6', '梁琪波', '18476309326', '192.168.1.126', 'CLD', '1', '12', '总部', '2051618356@qq.com', '2051618356', '18476309326', '');
INSERT INTO `zh_manager` VALUES ('16', '曾沛文', 'CLD Password', '1546595662', '1559615153', '6', '曾沛文', '13192294553', '192.168.1.22', 'CLD', '1', '12', '总部', '3598557058@qq.com', '3598557058', '6918978', '');
INSERT INTO `zh_manager` VALUES ('17', '付青青', 'CLD Password', '1555914265', '1559632941', '1', '付青青', '13536547237', '192.168.1.25', 'CLD', '1', '12', '总部', '2417587264@qq.com', '2147483647', '0756-3850894', '软件测试工程师');
INSERT INTO `zh_manager` VALUES ('18', '林强', 'CLD Password', '1557713523', '1557713523', '0', '', '13726254840', '192.168.1.30', 'CLD', '1', '12', '总部', '2747554248@qq.com', '2747554248', '', '客服');