/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 80015
 Source Host           : localhost:3306
 Source Schema         : mxsoha

 Target Server Type    : MySQL
 Target Server Version : 80015
 File Encoding         : 65001

 Date: 02/07/2021 14:07:24
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for promoters
-- ----------------------------
DROP TABLE IF EXISTS `promoters`;
CREATE TABLE `promoters`  (
  `id` int(6) NOT NULL AUTO_INCREMENT COMMENT '推广员id，也是推荐号码',
  `name` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名',
  `password` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码',
  `token` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码随机盐',
  `parent_id` char(6) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '上一级代理Id',
  `balance` int(10) NOT NULL COMMENT '余额',
  `log_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '最近登录时间',
  `invited_code` char(6) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '随机邀请码',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `name`(`name`) USING BTREE,
  UNIQUE INDEX `name_2`(`name`) USING BTREE,
  UNIQUE INDEX `name_3`(`name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 100009 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of promoters
-- ----------------------------
INSERT INTO `promoters` VALUES (100001, 'yzx2', 'YfI0ZOD8Cl6vbyQ0wCEW+A==', '6b9f55ffcbdd4b07ba58475a903d18bd', 'l6vbyQ', 0, '2018-02-07 17:53:39', 'YfI0ZO');
INSERT INTO `promoters` VALUES (100002, 'b', 'b', 'b', '100005', 1, '2018-02-04 11:07:32', NULL);
INSERT INTO `promoters` VALUES (100003, 'c', 'c', 'c', 'YfI0ZO', 1, '2018-02-04 11:07:44', NULL);
INSERT INTO `promoters` VALUES (100004, 'd', 'd', 'd', '100005', 1, '2018-02-04 14:42:11', NULL);
INSERT INTO `promoters` VALUES (100005, 'yzx', 'YfI0ZOD8Cl6vbyQ0wCEW+A==', '6b9f55ffcbdd4b07ba58475a903d18bd', NULL, 210000, '2018-02-09 16:05:06', 'l6vbyQ');
INSERT INTO `promoters` VALUES (100006, 'abcde', '46uxk2ZCT/5bf4IBAb4i5Q==', '369aba015f6e4ed7b949aaa0c23c7bc0', NULL, 0, '2018-05-14 14:08:51', '369aba');
INSERT INTO `promoters` VALUES (100007, 'qqqqq', 'NKKXZDnQjmI7yQ/v+0j+5w==', '679d82804747457db728ad9a16686240', NULL, 0, '2018-05-15 14:35:34', '679D82');
INSERT INTO `promoters` VALUES (100008, 'pinea', 'TJw9cDLIUCULElLpTN+Y4Q==', '47c136f0ac8945798c5d409937776918', NULL, 0, '2018-05-15 14:43:24', '47C136');

-- ----------------------------
-- Table structure for promoters_records
-- ----------------------------
DROP TABLE IF EXISTS `promoters_records`;
CREATE TABLE `promoters_records`  (
  `promId` int(6) NOT NULL COMMENT '推广员的id',
  `add` int(11) NOT NULL DEFAULT 0 COMMENT '充值的金币',
  `reduce` int(11) NOT NULL DEFAULT 0 COMMENT '减值的金币',
  `time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '操作时间',
  `by` int(6) UNSIGNED ZEROFILL NOT NULL COMMENT '操作对象，玩家id'
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of promoters_records
-- ----------------------------
INSERT INTO `promoters_records` VALUES (100005, 10, 0, '2018-02-04 14:27:59', 100001);
INSERT INTO `promoters_records` VALUES (100005, 0, 50, '2018-02-04 14:28:04', 100002);
INSERT INTO `promoters_records` VALUES (100005, 100, 0, '2018-02-05 14:28:08', 100002);
INSERT INTO `promoters_records` VALUES (100002, 50, 0, '2018-02-04 14:28:11', 100015);
INSERT INTO `promoters_records` VALUES (100002, 0, 10, '2018-02-04 14:28:18', 100005);
INSERT INTO `promoters_records` VALUES (100003, 0, 10, '2018-02-05 14:28:43', 100005);
INSERT INTO `promoters_records` VALUES (100003, 50, 0, '2018-02-04 14:28:52', 100006);
INSERT INTO `promoters_records` VALUES (100004, 50, 0, '2018-02-04 14:42:19', 100017);
INSERT INTO `promoters_records` VALUES (100001, 5200, 0, '2018-02-07 11:43:37', 100001);
INSERT INTO `promoters_records` VALUES (100001, 92000, 0, '2018-02-07 11:44:57', 100001);
INSERT INTO `promoters_records` VALUES (0, 102000, 0, '2018-02-07 11:45:42', 100001);
INSERT INTO `promoters_records` VALUES (0, 0, 52000, '2018-02-07 11:46:49', 100001);
INSERT INTO `promoters_records` VALUES (0, 10000, 0, '2018-02-07 15:26:04', 100002);
INSERT INTO `promoters_records` VALUES (100005, 0, 100000, '2018-02-07 15:35:28', 100002);
INSERT INTO `promoters_records` VALUES (100005, 0, 100000, '2018-02-09 09:43:28', 100002);
INSERT INTO `promoters_records` VALUES (100005, 50000, 0, '2018-02-09 09:44:28', 100001);
INSERT INTO `promoters_records` VALUES (100005, 0, 100000, '2018-02-09 14:05:27', 100008);
INSERT INTO `promoters_records` VALUES (100005, 10000, 0, '2018-02-09 14:07:04', 100009);
INSERT INTO `promoters_records` VALUES (100005, 1000, 0, '2018-02-09 14:15:07', 100138);
INSERT INTO `promoters_records` VALUES (100005, 1000, 0, '2018-02-09 14:29:24', 100140);
INSERT INTO `promoters_records` VALUES (100005, 1000, 0, '2018-02-09 14:30:43', 100139);
INSERT INTO `promoters_records` VALUES (100005, 0, 1000, '2018-02-09 14:31:43', 100009);
INSERT INTO `promoters_records` VALUES (0, 190000, 0, '2018-02-09 15:29:56', 100005);
INSERT INTO `promoters_records` VALUES (0, 200000, 0, '2018-02-09 15:30:13', 100005);
INSERT INTO `promoters_records` VALUES (0, 210000, 0, '2018-02-09 15:30:32', 100005);

-- ----------------------------
-- Table structure for records
-- ----------------------------
DROP TABLE IF EXISTS `records`;
CREATE TABLE `records`  (
  `user_id` int(10) NOT NULL COMMENT '用户id',
  `seat_id` int(3) NOT NULL COMMENT '座位号',
  `date` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '日期',
  `is_double` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否是比倍 2奖池得分',
  `pay_score` int(10) NOT NULL COMMENT '分数变化',
  `double` int(3) NOT NULL COMMENT '倍率',
  `got_score` int(11) NOT NULL COMMENT '得分',
  `room_double` int(2) NOT NULL COMMENT '房间的倍率'
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for room
-- ----------------------------
DROP TABLE IF EXISTS `room`;
CREATE TABLE `room`  (
  `room_id` int(4) NOT NULL COMMENT '房间Id',
  `room_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '房间名',
  `room_desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '房间描述',
  `multiply_power` int(4) NULL DEFAULT NULL COMMENT '房间倍率',
  `seat_count` int(4) NULL DEFAULT NULL COMMENT '房间的座位总数',
  PRIMARY KEY (`room_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of room
-- ----------------------------
INSERT INTO `room` VALUES (1, '新手房', '新手房间，难度简单', 2, 30);
INSERT INTO `room` VALUES (2, '普通房', '普通房间，大家都喜欢在这里玩', 5, 30);
INSERT INTO `room` VALUES (3, '土豪房', '倍率最高的房间，想赢大钱快来这里玩', 20, 30);

-- ----------------------------
-- Table structure for seats_info
-- ----------------------------
DROP TABLE IF EXISTS `seats_info`;
CREATE TABLE `seats_info`  (
  `seat_id` int(3) NOT NULL COMMENT '座位号',
  `game_time` int(3) NOT NULL DEFAULT 0 COMMENT '游戏局数',
  `pay_score` int(10) NOT NULL DEFAULT 0 COMMENT '座位总玩分，座位每次押分综合',
  `got_score` int(10) NOT NULL DEFAULT 0 COMMENT '座位总得分，座位每次得分总和',
  `hard` int(1) NOT NULL DEFAULT 0 COMMENT '当前座位难度',
  `seat_list_num` int(3) NOT NULL DEFAULT 0 COMMENT '座位集合，保存数据做算法计算',
  `double_pay_score` int(10) NOT NULL DEFAULT 0 COMMENT '当前座位花在比倍上的分',
  `double_got_score` int(10) NOT NULL DEFAULT 0 COMMENT '当前座位再比倍上得过的分',
  `reset_num` int(2) NOT NULL DEFAULT 0 COMMENT '串口保存的重置位',
  PRIMARY KEY (`seat_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of seats_info
-- ----------------------------
INSERT INTO `seats_info` VALUES (0, 1264, 142141, 36651, 90, 0, 530, 22549, 43);
INSERT INTO `seats_info` VALUES (1, 12611, 324339, 97024, 121, 0, 390, 13721, 0);
INSERT INTO `seats_info` VALUES (2, 10987, 276995, 146320, 58, 0, 523, 0, 0);
INSERT INTO `seats_info` VALUES (3, 9416, 233700, 98514, 98, 0, 146, 6400, 0);
INSERT INTO `seats_info` VALUES (4, 7915, 171754, 59508, 98, 0, 60, 0, 0);
INSERT INTO `seats_info` VALUES (5, 8849, 189944, 59999, 98, 0, 0, 0, 0);
INSERT INTO `seats_info` VALUES (6, 9604, 241401, 72927, 98, 0, 680, 444, 0);
INSERT INTO `seats_info` VALUES (7, 5868, 167920, 60278, 98, 0, 153, 0, 0);
INSERT INTO `seats_info` VALUES (8, 8386, 219352, 71954, 98, 0, 0, 0, 9);
INSERT INTO `seats_info` VALUES (9, 8479, 263972, 79905, 98, 2, 0, 0, 0);
INSERT INTO `seats_info` VALUES (10, 6226, 147800, 52031, 98, 0, 0, 0, 0);
INSERT INTO `seats_info` VALUES (11, 4591, 104842, 34404, 98, 0, 0, 0, 0);
INSERT INTO `seats_info` VALUES (12, 3096, 68682, 19804, 98, 0, 0, 0, 0);
INSERT INTO `seats_info` VALUES (13, 3124, 66151, 22707, 98, 0, 0, 0, 0);
INSERT INTO `seats_info` VALUES (14, 3466, 75416, 26108, 98, 0, 0, 0, 0);
INSERT INTO `seats_info` VALUES (15, 3510, 73400, 22600, 98, 0, 0, 0, 0);
INSERT INTO `seats_info` VALUES (16, 3935, 85638, 29362, 98, 0, 0, 0, 0);
INSERT INTO `seats_info` VALUES (17, 3817, 85858, 29252, 98, 0, 0, 0, 0);
INSERT INTO `seats_info` VALUES (18, 3226, 67242, 21483, 98, 0, 0, 0, 0);
INSERT INTO `seats_info` VALUES (19, 3797, 81787, 27927, 98, 0, 0, 0, 0);
INSERT INTO `seats_info` VALUES (20, 3785, 79912, 27248, 98, 0, 0, 0, 0);
INSERT INTO `seats_info` VALUES (21, 3505, 77334, 22914, 98, 0, 0, 0, 0);
INSERT INTO `seats_info` VALUES (22, 4451, 89020, 32960, 98, 50, 0, 0, 0);
INSERT INTO `seats_info` VALUES (23, 522, 13792, 7230, 98, 50, 0, 0, 0);
INSERT INTO `seats_info` VALUES (24, 500, 10000, 3340, 98, 0, 0, 0, 0);
INSERT INTO `seats_info` VALUES (25, 507, 10140, 11920, 98, 0, 0, 0, 0);
INSERT INTO `seats_info` VALUES (26, 1176, 23520, 7280, 98, 0, 0, 0, 0);
INSERT INTO `seats_info` VALUES (27, 1202, 24040, 11240, 98, 0, 0, 0, 0);
INSERT INTO `seats_info` VALUES (28, 1241, 24825, 7620, 98, 50, 21, 0, 0);
INSERT INTO `seats_info` VALUES (29, 23, 1840, 320, 98, 50, 0, 0, 1);
INSERT INTO `seats_info` VALUES (30, 1, 24, 0, 98, 0, 0, 0, 0);
INSERT INTO `seats_info` VALUES (31, 881, 17620, 4760, 98, 50, 0, 0, 0);
INSERT INTO `seats_info` VALUES (32, 678, 13560, 3740, 98, 50, 0, 0, 0);
INSERT INTO `seats_info` VALUES (33, 639, 12810, 3264, 98, 50, 0, 0, 0);
INSERT INTO `seats_info` VALUES (34, 4, 192, 57, 98, 0, 0, 0, 0);
INSERT INTO `seats_info` VALUES (35, 1, 21, 0, 98, 0, 0, 0, 0);
INSERT INTO `seats_info` VALUES (36, 5, 343, 80, 98, 50, 0, 0, 0);
INSERT INTO `seats_info` VALUES (37, 15, 512, 233, 98, 0, 0, 0, 0);
INSERT INTO `seats_info` VALUES (38, 8, 800, 100, 98, 50, 0, 0, 1);
INSERT INTO `seats_info` VALUES (39, 4, 226, 80, 98, 0, 0, 0, 0);
INSERT INTO `seats_info` VALUES (40, 0, 0, 0, 98, 37, 0, 0, 0);
INSERT INTO `seats_info` VALUES (41, 0, 0, 0, 98, 0, 0, 0, 0);
INSERT INTO `seats_info` VALUES (42, 0, 0, 0, 98, 0, 0, 0, 0);
INSERT INTO `seats_info` VALUES (43, 0, 0, 0, 98, 0, 0, 0, 0);
INSERT INTO `seats_info` VALUES (44, 0, 0, 0, 98, 0, 0, 0, 0);
INSERT INTO `seats_info` VALUES (45, 0, 0, 0, 98, 0, 0, 0, 0);
INSERT INTO `seats_info` VALUES (46, 0, 0, 0, 98, 0, 0, 0, 0);
INSERT INTO `seats_info` VALUES (47, 0, 0, 0, 98, 0, 0, 0, 0);
INSERT INTO `seats_info` VALUES (48, 0, 0, 0, 98, 0, 0, 0, 0);
INSERT INTO `seats_info` VALUES (49, 0, 0, 0, 98, 0, 0, 0, 0);
INSERT INTO `seats_info` VALUES (50, 0, 0, 0, 98, 30, 0, 0, 0);
INSERT INTO `seats_info` VALUES (51, 0, 0, 0, 98, 104, 0, 0, 0);
INSERT INTO `seats_info` VALUES (52, 0, 0, 0, 98, 4, 0, 0, 0);
INSERT INTO `seats_info` VALUES (53, 0, 0, 0, 98, 116, 0, 0, 0);
INSERT INTO `seats_info` VALUES (54, 0, 0, 0, 98, 116, 0, 0, 0);
INSERT INTO `seats_info` VALUES (55, 0, 0, 0, 98, 30, 0, 0, 0);
INSERT INTO `seats_info` VALUES (56, 0, 0, 0, 98, 115, 0, 0, 0);
INSERT INTO `seats_info` VALUES (57, 0, 0, 0, 98, 10, 0, 0, 0);
INSERT INTO `seats_info` VALUES (58, 0, 0, 0, 98, 116, 0, 0, 0);
INSERT INTO `seats_info` VALUES (59, 0, 0, 0, 98, 83, 0, 0, 0);
INSERT INTO `seats_info` VALUES (60, 8, 580, 240, 98, 0, 0, 0, 0);
INSERT INTO `seats_info` VALUES (61, 848, 17453, 5315, 98, 0, 0, 0, 0);
INSERT INTO `seats_info` VALUES (62, 823, 17708, 4609, 98, 50, 0, 0, 0);
INSERT INTO `seats_info` VALUES (63, 635, 13592, 3985, 98, 0, 0, 0, 1);
INSERT INTO `seats_info` VALUES (64, 55, 2375, 561, 98, 50, 0, 0, 1);
INSERT INTO `seats_info` VALUES (65, 140, 17458, 4641, 98, 0, 0, 0, 1);
INSERT INTO `seats_info` VALUES (66, 186, 8326, 55558, 98, 50, 0, 0, 0);
INSERT INTO `seats_info` VALUES (67, 565, 31129, 516285, 98, 0, 0, 0, 5);
INSERT INTO `seats_info` VALUES (68, 307, 12821, 43390, 98, 50, 0, 0, 0);
INSERT INTO `seats_info` VALUES (69, 93, 6636, 54216, 98, 50, 0, 0, 0);
INSERT INTO `seats_info` VALUES (70, 0, 0, 0, 98, 0, 0, 0, 0);
INSERT INTO `seats_info` VALUES (71, 53, 1581, 240, 98, 0, 0, 0, 0);
INSERT INTO `seats_info` VALUES (72, 53, 2216, 54, 98, 0, 0, 0, 0);
INSERT INTO `seats_info` VALUES (73, 16, 428, 56, 98, 0, 0, 0, 0);
INSERT INTO `seats_info` VALUES (74, 1, 29, 0, 98, 0, 0, 0, 0);
INSERT INTO `seats_info` VALUES (75, 0, 0, 0, 98, 0, 0, 0, 0);
INSERT INTO `seats_info` VALUES (76, 0, 0, 0, 98, 0, 0, 0, 0);
INSERT INTO `seats_info` VALUES (77, 3, 75, 0, 98, 50, 0, 0, 0);
INSERT INTO `seats_info` VALUES (78, 0, 0, 0, 98, 0, 0, 0, 0);
INSERT INTO `seats_info` VALUES (79, 0, 0, 0, 98, 0, 0, 0, 0);
INSERT INTO `seats_info` VALUES (80, 0, 0, 0, 98, 0, 0, 0, 0);
INSERT INTO `seats_info` VALUES (81, 0, 0, 0, 98, 0, 0, 0, 0);
INSERT INTO `seats_info` VALUES (82, 0, 0, 0, 98, 0, 0, 0, 0);
INSERT INTO `seats_info` VALUES (83, 0, 0, 0, 98, 88, 0, 0, 0);
INSERT INTO `seats_info` VALUES (84, 0, 0, 0, 98, 0, 0, 0, 0);
INSERT INTO `seats_info` VALUES (85, 1, 21, 0, 98, 0, 0, 0, 0);
INSERT INTO `seats_info` VALUES (86, 60, 1796, 4230, 98, 0, 0, 0, 0);
INSERT INTO `seats_info` VALUES (87, 7, 171, 0, 98, 50, 25, 0, 0);
INSERT INTO `seats_info` VALUES (88, 5, 101, 0, 98, 50, 0, 0, 0);
INSERT INTO `seats_info` VALUES (89, 8, 240, 0, 80, 50, 150, 60, 0);

-- ----------------------------
-- Table structure for super_administrator
-- ----------------------------
DROP TABLE IF EXISTS `super_administrator`;
CREATE TABLE `super_administrator`  (
  `name` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '用户名',
  `password` varchar(36) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '密码',
  `token` varchar(36) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '密码验证字符',
  `ip` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '上一次登录ip地址',
  `status` int(1) NOT NULL DEFAULT 0 COMMENT '当前用户状态0离线 1在线 2异常',
  PRIMARY KEY (`name`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of super_administrator
-- ----------------------------
INSERT INTO `super_administrator` VALUES ('admin', 'xMQdqL7SJ2GepDQO7Yg+3Q==', '9956aa51e865498eb944d69f8dca0d47', '127.0.0.1', 0);
INSERT INTO `super_administrator` VALUES ('controller', '******', 'mxsoha', '192.168.3.41', 1);

-- ----------------------------
-- Table structure for system_logs
-- ----------------------------
DROP TABLE IF EXISTS `system_logs`;
CREATE TABLE `system_logs`  (
  `time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '时间',
  `logs` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '操作记录',
  `system_id` int(11) NOT NULL COMMENT '推广员或管理员id'
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of system_logs
-- ----------------------------
INSERT INTO `system_logs` VALUES ('2018-02-09 09:35:23', '登录系统', 100005);
INSERT INTO `system_logs` VALUES ('2018-02-09 09:39:44', '登录系统', 100005);
INSERT INTO `system_logs` VALUES ('2018-02-09 09:43:28', '会员(100005)兑奖100000币', 0);
INSERT INTO `system_logs` VALUES ('2018-02-09 09:43:53', '登录系统', 100005);
INSERT INTO `system_logs` VALUES ('2018-02-09 09:44:28', '会员(100005)充值50000币', 100005);
INSERT INTO `system_logs` VALUES ('2018-02-09 09:45:15', '登录系统', 100005);
INSERT INTO `system_logs` VALUES ('2018-02-09 09:47:10', '登录系统', 100005);
INSERT INTO `system_logs` VALUES ('2018-02-09 10:23:12', '登录系统', 100005);
INSERT INTO `system_logs` VALUES ('2018-02-09 10:29:26', '登录系统', 100005);
INSERT INTO `system_logs` VALUES ('2018-02-09 10:30:52', '登录系统', 100005);
INSERT INTO `system_logs` VALUES ('2018-02-09 10:35:57', '登录系统', 100005);
INSERT INTO `system_logs` VALUES ('2018-02-09 11:49:28', '登录系统', 100005);
INSERT INTO `system_logs` VALUES ('2018-02-09 11:50:45', '登录系统', 100005);
INSERT INTO `system_logs` VALUES ('2018-02-09 11:51:54', '登录系统', 100005);
INSERT INTO `system_logs` VALUES ('2018-02-09 11:55:23', '登录系统', 100005);
INSERT INTO `system_logs` VALUES ('2018-02-09 14:00:12', '登录系统', 100005);
INSERT INTO `system_logs` VALUES ('2018-02-09 14:02:53', '登录系统', 100005);
INSERT INTO `system_logs` VALUES ('2018-02-09 14:05:27', '会员(100005)兑奖100000币', 0);
INSERT INTO `system_logs` VALUES ('2018-02-09 14:06:34', '登录系统', 100005);
INSERT INTO `system_logs` VALUES ('2018-02-09 14:07:04', '会员(100005)充值10000币', 100005);
INSERT INTO `system_logs` VALUES ('2018-02-09 14:09:49', '登录系统', 100005);
INSERT INTO `system_logs` VALUES ('2018-02-09 14:12:36', '登录系统', 100005);
INSERT INTO `system_logs` VALUES ('2018-02-09 14:15:07', '会员(100005)充值1000币', 100005);
INSERT INTO `system_logs` VALUES ('2018-02-09 14:18:55', '登录系统', 100005);
INSERT INTO `system_logs` VALUES ('2018-02-09 14:24:16', '登录系统', 100005);
INSERT INTO `system_logs` VALUES ('2018-02-09 14:29:03', '登录系统', 100005);
INSERT INTO `system_logs` VALUES ('2018-02-09 14:29:24', '会员(100005)充值1000币', 100005);
INSERT INTO `system_logs` VALUES ('2018-02-09 14:30:30', '登录系统', 100005);
INSERT INTO `system_logs` VALUES ('2018-02-09 14:30:43', '会员(100005)充值1000币', 100005);
INSERT INTO `system_logs` VALUES ('2018-02-09 14:31:43', '会员(100005)兑奖1000币', 0);
INSERT INTO `system_logs` VALUES ('2018-02-09 14:32:33', '登录系统', 100005);
INSERT INTO `system_logs` VALUES ('2018-02-09 14:39:37', '登录系统', 0);
INSERT INTO `system_logs` VALUES ('2018-02-09 14:39:37', '退出系统', 0);
INSERT INTO `system_logs` VALUES ('2018-02-09 14:41:32', '登录系统', 0);
INSERT INTO `system_logs` VALUES ('2018-02-09 14:41:32', '退出系统', 0);
INSERT INTO `system_logs` VALUES ('2018-02-09 14:44:44', '登录系统', 0);
INSERT INTO `system_logs` VALUES ('2018-02-09 14:44:44', '退出系统', 0);
INSERT INTO `system_logs` VALUES ('2018-02-09 14:50:29', '登录系统', 0);
INSERT INTO `system_logs` VALUES ('2018-02-09 14:50:29', '退出系统', 0);
INSERT INTO `system_logs` VALUES ('2018-02-09 14:53:38', '登录系统', 0);
INSERT INTO `system_logs` VALUES ('2018-02-09 14:53:38', '退出系统', 0);
INSERT INTO `system_logs` VALUES ('2018-02-09 14:54:11', '登录系统', 0);
INSERT INTO `system_logs` VALUES ('2018-02-09 14:54:11', '退出系统', 0);
INSERT INTO `system_logs` VALUES ('2018-02-09 14:54:47', '登录系统', 0);
INSERT INTO `system_logs` VALUES ('2018-02-09 14:54:47', '退出系统', 0);
INSERT INTO `system_logs` VALUES ('2018-02-09 14:55:35', '登录系统', 0);
INSERT INTO `system_logs` VALUES ('2018-02-09 14:55:35', '退出系统', 0);
INSERT INTO `system_logs` VALUES ('2018-02-09 15:01:59', '登录系统', 0);
INSERT INTO `system_logs` VALUES ('2018-02-09 15:01:59', '退出系统', 0);
INSERT INTO `system_logs` VALUES ('2018-02-09 15:02:44', '登录系统', 0);
INSERT INTO `system_logs` VALUES ('2018-02-09 15:02:44', '退出系统', 0);
INSERT INTO `system_logs` VALUES ('2018-02-09 15:10:01', '登录系统', 100005);
INSERT INTO `system_logs` VALUES ('2018-02-09 15:10:37', '登录系统', 0);
INSERT INTO `system_logs` VALUES ('2018-02-09 15:10:37', '退出系统', 0);
INSERT INTO `system_logs` VALUES ('2018-02-09 15:12:19', '登录系统', 0);
INSERT INTO `system_logs` VALUES ('2018-02-09 15:12:19', '退出系统', 0);
INSERT INTO `system_logs` VALUES ('2018-02-09 15:14:02', '登录系统', 0);
INSERT INTO `system_logs` VALUES ('2018-02-09 15:14:02', '退出系统', 0);
INSERT INTO `system_logs` VALUES ('2018-02-09 15:18:27', '登录系统', 0);
INSERT INTO `system_logs` VALUES ('2018-02-09 15:18:27', '退出系统', 0);
INSERT INTO `system_logs` VALUES ('2018-02-09 15:19:56', '登录系统', 0);
INSERT INTO `system_logs` VALUES ('2018-02-09 15:19:56', '退出系统', 0);
INSERT INTO `system_logs` VALUES ('2018-02-09 15:29:56', '推广员(100005)充值10000币', 0);
INSERT INTO `system_logs` VALUES ('2018-02-09 15:30:13', '推广员(100005)充值10000币', 0);
INSERT INTO `system_logs` VALUES ('2018-02-09 15:30:32', '推广员(100005)充值10000币', 0);
INSERT INTO `system_logs` VALUES ('2018-02-09 15:35:56', '登录系统', 0);
INSERT INTO `system_logs` VALUES ('2018-02-09 15:35:56', '退出系统', 0);
INSERT INTO `system_logs` VALUES ('2018-02-09 15:36:48', '登录系统', 100005);
INSERT INTO `system_logs` VALUES ('2018-02-09 15:44:03', '登录系统', 0);
INSERT INTO `system_logs` VALUES ('2018-02-09 15:44:03', '退出系统', 0);
INSERT INTO `system_logs` VALUES ('2018-02-09 15:45:14', '登录系统', 0);
INSERT INTO `system_logs` VALUES ('2018-02-09 15:45:14', '退出系统', 0);
INSERT INTO `system_logs` VALUES ('2018-02-09 15:47:14', '登录系统', 0);
INSERT INTO `system_logs` VALUES ('2018-02-09 15:47:14', '退出系统', 0);
INSERT INTO `system_logs` VALUES ('2018-02-09 15:52:35', '登录系统', 0);
INSERT INTO `system_logs` VALUES ('2018-02-09 15:52:35', '退出系统', 0);
INSERT INTO `system_logs` VALUES ('2018-02-09 15:59:23', '登录系统', 0);
INSERT INTO `system_logs` VALUES ('2018-02-09 15:59:23', '退出系统', 0);
INSERT INTO `system_logs` VALUES ('2018-02-09 16:01:21', '登录系统', 0);
INSERT INTO `system_logs` VALUES ('2018-02-09 16:01:21', '退出系统', 0);
INSERT INTO `system_logs` VALUES ('2018-02-09 16:04:54', '登录系统', 100005);

-- ----------------------------
-- Table structure for user_info
-- ----------------------------
DROP TABLE IF EXISTS `user_info`;
CREATE TABLE `user_info`  (
  `user_id` int(10) NOT NULL AUTO_INCREMENT COMMENT '外键，关联用户id',
  `pay_score` int(10) NOT NULL DEFAULT 0 COMMENT '用户总玩分，所有押分总和',
  `got_score` int(10) NOT NULL DEFAULT 0 COMMENT '用户总得分，所有得分总和',
  `game_time` int(5) NOT NULL COMMENT '游戏总局数',
  `check_id` int(5) NOT NULL COMMENT '用户校验id',
  `hard` int(1) NOT NULL DEFAULT 98 COMMENT '玩家难度',
  PRIMARY KEY (`user_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 100143 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user_info
-- ----------------------------
INSERT INTO `user_info` VALUES (100001, 13153, 9877, 232, 308, 98);
INSERT INTO `user_info` VALUES (100002, 23441, 660446, 1006, 1093, 123);
INSERT INTO `user_info` VALUES (100003, 26658, 50668, 822, 0, 98);
INSERT INTO `user_info` VALUES (100004, 1931, 13531, 35, 10556, 98);
INSERT INTO `user_info` VALUES (100005, 11005, 18730, 164, 14385, 98);
INSERT INTO `user_info` VALUES (100006, 0, 0, 0, 7211, 98);
INSERT INTO `user_info` VALUES (100007, 622, 158, 28, 23138, 98);
INSERT INTO `user_info` VALUES (100008, 173498, 89948, 8655, 0, 200);
INSERT INTO `user_info` VALUES (100009, 12645, 14915, 153, 21552, 98);
INSERT INTO `user_info` VALUES (100010, 0, 0, 0, 0, 98);
INSERT INTO `user_info` VALUES (100011, 0, 0, 0, 0, 98);
INSERT INTO `user_info` VALUES (100014, 0, 0, 0, 0, 98);
INSERT INTO `user_info` VALUES (100015, 5411, 3675, 245, 14687, 98);
INSERT INTO `user_info` VALUES (100016, 2960, 31160, 40, 14385, 98);
INSERT INTO `user_info` VALUES (100019, 5116, 15744, 202, 14687, 98);
INSERT INTO `user_info` VALUES (100020, 130454, 68949, 6245, 10556, 98);
INSERT INTO `user_info` VALUES (100021, 124186, 72334, 5514, 10556, 98);
INSERT INTO `user_info` VALUES (100022, 99821, 62125, 4987, 10556, 98);
INSERT INTO `user_info` VALUES (100023, 118652, 65897, 5913, 10556, 98);
INSERT INTO `user_info` VALUES (100024, 115848, 60377, 5791, 10556, 98);
INSERT INTO `user_info` VALUES (100025, 122361, 64369, 5376, 10556, 98);
INSERT INTO `user_info` VALUES (100026, 107988, 59622, 5399, 10556, 98);
INSERT INTO `user_info` VALUES (100027, 14220, 27080, 711, 21552, 98);
INSERT INTO `user_info` VALUES (100038, 141544, 51326, 6176, 14687, 98);
INSERT INTO `user_info` VALUES (100039, 101045, 34565, 4604, 14687, 98);
INSERT INTO `user_info` VALUES (100040, 2900, 1180, 145, 14687, 98);
INSERT INTO `user_info` VALUES (100041, 3944, 1508, 136, 14687, 98);
INSERT INTO `user_info` VALUES (100042, 8879, 3679, 190, 14687, 98);
INSERT INTO `user_info` VALUES (100043, 2340, 1180, 117, 14687, 98);
INSERT INTO `user_info` VALUES (100044, 11758, 3659, 200, 14687, 98);
INSERT INTO `user_info` VALUES (100045, 2037, 903, 97, 14687, 98);
INSERT INTO `user_info` VALUES (100046, 1800, 480, 90, 14687, 98);
INSERT INTO `user_info` VALUES (100047, 2430, 990, 81, 14687, 98);
INSERT INTO `user_info` VALUES (100048, 74099, 27151, 3534, 14687, 98);
INSERT INTO `user_info` VALUES (100049, 42720, 19660, 1012, 14687, 98);
INSERT INTO `user_info` VALUES (100050, 98400, 39180, 3868, 14687, 98);
INSERT INTO `user_info` VALUES (100051, 84286, 33071, 4188, 14687, 98);
INSERT INTO `user_info` VALUES (100052, 79500, 38080, 3975, 14687, 98);
INSERT INTO `user_info` VALUES (100053, 92058, 35022, 4412, 14687, 98);
INSERT INTO `user_info` VALUES (100054, 91247, 36403, 4137, 14687, 98);
INSERT INTO `user_info` VALUES (100055, 73760, 29900, 3688, 14687, 98);
INSERT INTO `user_info` VALUES (100056, 84888, 33787, 3850, 14687, 98);
INSERT INTO `user_info` VALUES (100057, 121740, 53000, 4275, 14687, 98);
INSERT INTO `user_info` VALUES (100058, 71904, 21924, 3424, 10556, 98);
INSERT INTO `user_info` VALUES (100059, 79360, 27360, 3968, 10556, 98);
INSERT INTO `user_info` VALUES (100060, 0, 0, 0, 18228, 98);
INSERT INTO `user_info` VALUES (100061, 0, 0, 0, 11571, 98);
INSERT INTO `user_info` VALUES (100062, 0, 0, 0, 18227, 98);
INSERT INTO `user_info` VALUES (100063, 0, 0, 0, 18227, 98);
INSERT INTO `user_info` VALUES (100064, 0, 0, 0, 24841, 98);
INSERT INTO `user_info` VALUES (100065, 0, 0, 0, 18228, 98);
INSERT INTO `user_info` VALUES (100066, 0, 0, 0, 11304, 98);
INSERT INTO `user_info` VALUES (100067, 0, 0, 0, 11571, 98);
INSERT INTO `user_info` VALUES (100068, 0, 0, 0, 18018, 98);
INSERT INTO `user_info` VALUES (100069, 0, 0, 0, 2091, 98);
INSERT INTO `user_info` VALUES (100070, 0, 0, 0, 18227, 98);
INSERT INTO `user_info` VALUES (100071, 0, 0, 0, 0, 98);
INSERT INTO `user_info` VALUES (100072, 0, 0, 0, 0, 98);
INSERT INTO `user_info` VALUES (100073, 0, 0, 0, 0, 98);
INSERT INTO `user_info` VALUES (100074, 0, 0, 0, 0, 98);
INSERT INTO `user_info` VALUES (100075, 0, 0, 0, 0, 98);
INSERT INTO `user_info` VALUES (100076, 0, 0, 0, 4683, 98);
INSERT INTO `user_info` VALUES (100077, 0, 0, 0, 0, 98);
INSERT INTO `user_info` VALUES (100078, 18763, 6903, 935, 0, 98);
INSERT INTO `user_info` VALUES (100079, 5428, 50874, 183, 0, 98);
INSERT INTO `user_info` VALUES (100080, 3806, 2229, 159, 2, 98);
INSERT INTO `user_info` VALUES (100081, 44, 44, 2, 0, 98);
INSERT INTO `user_info` VALUES (100082, 12488, 3260, 188, 213, 98);
INSERT INTO `user_info` VALUES (100083, 158, 90, 7, 0, 98);
INSERT INTO `user_info` VALUES (100084, 22, 0, 1, 0, 98);
INSERT INTO `user_info` VALUES (100085, 71, 69, 3, 0, 98);
INSERT INTO `user_info` VALUES (100086, 254, 754, 9, 0, 98);
INSERT INTO `user_info` VALUES (100087, 23, 23, 1, 0, 98);
INSERT INTO `user_info` VALUES (100088, 252, 0, 11, 0, 98);
INSERT INTO `user_info` VALUES (100089, 29, 29, 1, 0, 98);
INSERT INTO `user_info` VALUES (100090, 29, 0, 1, 0, 98);
INSERT INTO `user_info` VALUES (100091, 45, 0, 1, 0, 98);
INSERT INTO `user_info` VALUES (100092, 109, 126, 5, 0, 98);
INSERT INTO `user_info` VALUES (100093, 336, 21, 16, 0, 98);
INSERT INTO `user_info` VALUES (100094, 0, 0, 0, 0, 98);
INSERT INTO `user_info` VALUES (100095, 230, 92, 10, 0, 98);
INSERT INTO `user_info` VALUES (100096, 330, 110, 15, 0, 98);
INSERT INTO `user_info` VALUES (100097, 0, 0, 0, 0, 98);
INSERT INTO `user_info` VALUES (100098, 0, 0, 0, 0, 98);
INSERT INTO `user_info` VALUES (100099, 0, 0, 0, 0, 98);
INSERT INTO `user_info` VALUES (100100, 0, 0, 0, 0, 98);
INSERT INTO `user_info` VALUES (100101, 0, 0, 0, 0, 98);
INSERT INTO `user_info` VALUES (100102, 0, 0, 0, 0, 98);
INSERT INTO `user_info` VALUES (100103, 0, 0, 0, 0, 98);
INSERT INTO `user_info` VALUES (100104, 0, 0, 0, 0, 98);
INSERT INTO `user_info` VALUES (100105, 0, 0, 0, 0, 98);
INSERT INTO `user_info` VALUES (100106, 0, 0, 0, 0, 98);
INSERT INTO `user_info` VALUES (100107, 0, 0, 0, 0, 98);
INSERT INTO `user_info` VALUES (100108, 0, 0, 0, 0, 98);
INSERT INTO `user_info` VALUES (100109, 0, 0, 0, 0, 98);
INSERT INTO `user_info` VALUES (100110, 0, 0, 0, 0, 98);
INSERT INTO `user_info` VALUES (100112, 0, 0, 0, 0, 98);
INSERT INTO `user_info` VALUES (100113, 0, 0, 0, 0, 98);
INSERT INTO `user_info` VALUES (100114, 0, 0, 0, 0, 98);
INSERT INTO `user_info` VALUES (100115, 0, 0, 0, 0, 98);
INSERT INTO `user_info` VALUES (100116, 0, 0, 0, 0, 98);
INSERT INTO `user_info` VALUES (100117, 0, 0, 0, 0, 98);
INSERT INTO `user_info` VALUES (100118, 0, 0, 0, 0, 98);
INSERT INTO `user_info` VALUES (100121, 0, 0, 0, 0, 98);
INSERT INTO `user_info` VALUES (100122, 0, 0, 0, 0, 98);
INSERT INTO `user_info` VALUES (100124, 0, 0, 0, 0, 98);
INSERT INTO `user_info` VALUES (100126, 0, 0, 0, 0, 98);
INSERT INTO `user_info` VALUES (100127, 0, 0, 0, 0, 98);
INSERT INTO `user_info` VALUES (100128, 518, 135, 19, 0, 98);
INSERT INTO `user_info` VALUES (100129, 6270, 2262, 111, 0, 98);
INSERT INTO `user_info` VALUES (100130, 0, 0, 0, 0, 98);
INSERT INTO `user_info` VALUES (100131, 0, 0, 0, 0, 98);
INSERT INTO `user_info` VALUES (100132, 0, 0, 0, 0, 98);
INSERT INTO `user_info` VALUES (100133, 0, 0, 0, 0, 98);
INSERT INTO `user_info` VALUES (100134, 352, 253, 17, 0, 98);
INSERT INTO `user_info` VALUES (100135, 0, 0, 0, 0, 98);
INSERT INTO `user_info` VALUES (100136, 0, 0, 0, 0, 98);
INSERT INTO `user_info` VALUES (100137, 0, 0, 0, 0, 98);
INSERT INTO `user_info` VALUES (100138, 0, 0, 0, 0, 98);
INSERT INTO `user_info` VALUES (100139, 0, 0, 0, 0, 98);
INSERT INTO `user_info` VALUES (100140, 0, 0, 0, 0, 98);
INSERT INTO `user_info` VALUES (100141, 0, 0, 0, 0, 0);
INSERT INTO `user_info` VALUES (100142, 0, 0, 0, 0, 80);

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users`  (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '用户id',
  `username` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '用户名',
  `password` varchar(36) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '用户密码',
  `token` varchar(36) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '密码随机验证字符',
  `ip` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '上一次登录ip',
  `phone` varchar(11) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '手机号',
  `money` bigint(13) NOT NULL DEFAULT 0 COMMENT '当前余额',
  `status` int(1) NOT NULL DEFAULT 0 COMMENT '当前状态 0离线 1在线 2非法操作已冻结 3用户暂时离线，可随时重新登陆',
  `last_play_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '用户上一次操作时间',
  `stay_seat_time` int(1) NOT NULL DEFAULT 3 COMMENT '剩余留机次数',
  `invitation_code` int(6) NULL DEFAULT NULL COMMENT '用户邀请码',
  `be_invited` char(6) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '邀请人的邀请码',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `uk_name`(`username`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 100143 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES (100001, 'admin', 'YfI0ZOD8Cl6vbyQ0wCEW+A==', '6b9f55ffcbdd4b07ba58475a903d18bd', '127.0.0.1', NULL, 1359929, 1, '2021-07-01 17:19:26', 3, NULL, NULL);
INSERT INTO `users` VALUES (100002, 'yzx', 'hTY8/HaoQZliYNcQWA64vw==', '779d63934c8a4c9c9e20dcf5e74193e8', '192.168.0.104', NULL, 2557253, 0, '2018-02-08 16:49:28', 3, NULL, NULL);
INSERT INTO `users` VALUES (100003, 'hk', 'n6648xsOc/HjAK4iaPMacQ==', 'd386a23f66384cde9a59558709ec205a', '192.168.0.108', NULL, 1272496, 1, '2018-02-08 13:17:57', 3, NULL, NULL);
INSERT INTO `users` VALUES (100004, 'wl', '6DIb9QULhsqsxO7mEJU16g==', '9e18ff87ebc84a9398b835ae355da2ac', '192.168.3.20', NULL, 1276692, 0, '2018-01-27 14:40:42', 0, NULL, NULL);
INSERT INTO `users` VALUES (100005, 'zmr', '/RKV6N5dPw3BARrSWrb/UA==', '0b28cb7bf562455a9a608783d2478846', '192.168.3.42', NULL, 1283846, 0, '2018-01-28 11:07:12', 3, NULL, '100005');
INSERT INTO `users` VALUES (100006, 'lbs', 'qtJBwnsfNC+dCzE7FTH/oQ==', '26a04c3bb6d947beaa1ee2a22bf1ae8d', '192.168.3.45', NULL, 1208275, 0, '2018-01-09 13:05:09', 3, NULL, NULL);
INSERT INTO `users` VALUES (100007, 'pinea', 'IZhyBfG3KaY5v1uHs/qxag==', '5aab9c2b06d44a1ca3e32bceaf9dd37a', '192.168.0.109', NULL, 1209796, 0, '2018-05-15 13:54:14', 3, NULL, '100005');
INSERT INTO `users` VALUES (100008, 'yzx2', 'hTY8/HaoQZliYNcQWA64vw==', '779d63934c8a4c9c9e20dcf5e74193e8', '192.168.0.104', NULL, 1099545, 0, '2018-02-08 15:27:15', 3, NULL, '100005');
INSERT INTO `users` VALUES (100009, 'hk2', 'hTY8/HaoQZliYNcQWA64vw==', '779d63934c8a4c9c9e20dcf5e74193e8', '192.168.0.108', NULL, 1218996, 1, '2018-02-08 13:24:57', 3, NULL, '100005');
INSERT INTO `users` VALUES (100010, 'wl2', 'hTY8/HaoQZliYNcQWA64vw==', '779d63934c8a4c9c9e20dcf5e74193e8', '192.168.3.20', NULL, 1210000, 3, '2018-01-27 14:58:49', 0, NULL, '100005');
INSERT INTO `users` VALUES (100011, 'zmr2', 'hTY8/HaoQZliYNcQWA64vw==', '779d63934c8a4c9c9e20dcf5e74193e8', '192.168.3.64', NULL, 1210000, 0, '2018-01-30 14:13:11', 2, NULL, NULL);
INSERT INTO `users` VALUES (100014, 'lbs2', 'hTY8/HaoQZliYNcQWA64vw==', '779d63934c8a4c9c9e20dcf5e74193e8', NULL, NULL, 1210000, 0, '2018-01-11 10:20:40', 3, NULL, NULL);
INSERT INTO `users` VALUES (100015, 'pineapple', 'hTY8/HaoQZliYNcQWA64vw==', '779d63934c8a4c9c9e20dcf5e74193e8', '192.168.0.109', NULL, 1209727, 0, '2018-02-06 10:41:21', 3, NULL, NULL);
INSERT INTO `users` VALUES (100016, 'wyw', 'hTY8/HaoQZliYNcQWA64vw==', '779d63934c8a4c9c9e20dcf5e74193e8', '192.168.3.45', NULL, 1221612, 0, '2018-01-16 15:59:47', 3, NULL, NULL);
INSERT INTO `users` VALUES (100019, 'gfc', 'hTY8/HaoQZliYNcQWA64vw==', '779d63934c8a4c9c9e20dcf5e74193e8', '192.168.3.65', NULL, 1217949, 0, '2018-01-31 15:58:11', 3, NULL, '100005');
INSERT INTO `users` VALUES (100020, 'yzx3', 'hTY8/HaoQZliYNcQWA64vw==', '779d63934c8a4c9c9e20dcf5e74193e8', '192.168.3.22', NULL, 1200902, 0, '2018-01-30 10:29:12', 0, NULL, NULL);
INSERT INTO `users` VALUES (100021, 'yzx4', 'hTY8/HaoQZliYNcQWA64vw==', '779d63934c8a4c9c9e20dcf5e74193e8', '192.168.3.22', NULL, 1198978, 0, '2018-01-30 10:42:31', 2, NULL, NULL);
INSERT INTO `users` VALUES (100022, 'yzx5', 'hTY8/HaoQZliYNcQWA64vw==', '779d63934c8a4c9c9e20dcf5e74193e8', '192.168.0.100', NULL, 1201101, 1, '2018-02-06 16:15:21', 3, NULL, NULL);
INSERT INTO `users` VALUES (100023, 'yzx6', 'hTY8/HaoQZliYNcQWA64vw==', '779d63934c8a4c9c9e20dcf5e74193e8', '192.168.3.20', NULL, 1198842, 0, '2018-01-30 09:38:25', 0, NULL, NULL);
INSERT INTO `users` VALUES (100024, 'yzx7', 'hTY8/HaoQZliYNcQWA64vw==', '779d63934c8a4c9c9e20dcf5e74193e8', '192.168.3.20', NULL, 1199179, 0, '2018-01-30 09:54:19', 0, NULL, NULL);
INSERT INTO `users` VALUES (100025, 'yzx8', 'hTY8/HaoQZliYNcQWA64vw==', '779d63934c8a4c9c9e20dcf5e74193e8', '192.168.3.20', NULL, 1198563, 0, '2018-01-30 10:12:12', 1, NULL, NULL);
INSERT INTO `users` VALUES (100026, 'yzx9', 'hTY8/HaoQZliYNcQWA64vw==', '779d63934c8a4c9c9e20dcf5e74193e8', '192.168.3.20', NULL, 1199559, 0, '2018-01-30 10:26:52', 0, NULL, '100005');
INSERT INTO `users` VALUES (100027, 'yzx10', 'hTY8/HaoQZliYNcQWA64vw==', '779d63934c8a4c9c9e20dcf5e74193e8', '192.168.3.20', NULL, 1205433, 0, '2018-01-30 10:44:25', 0, NULL, NULL);
INSERT INTO `users` VALUES (100038, 'gfc1', 'sdyaTKn7+0NKQ0ARxqWnZA==', '366ad77fe50c4643b97e79dbeeb31568', '192.168.3.65', NULL, 1201696, 0, '2018-01-31 15:58:12', 3, NULL, NULL);
INSERT INTO `users` VALUES (100039, 'gfc2', 'thvtxJiJ6lSMrzjlHR+6/A==', '59d93d6a40224e90a995b531199c8d12', '192.168.3.65', NULL, 1204003, 0, '2018-01-31 15:58:09', 3, NULL, NULL);
INSERT INTO `users` VALUES (100040, 'gfc3', 'PENKhiQgCdkpoQXXR5Gcnw==', '93489800fb144bd096be6cee3bd27e12', '192.168.3.65', NULL, 1207152, 0, '2018-01-31 15:58:12', 3, NULL, NULL);
INSERT INTO `users` VALUES (100041, 'gfc4', 'KmHgdwx8mPn29iUNvrNIEw==', 'c03780b6cfce40048f4642ced174facb', '192.168.3.65', NULL, 1207253, 0, '2018-01-31 15:58:12', 3, NULL, '100005');
INSERT INTO `users` VALUES (100042, 'gfc5', 'h7njg4qTht8SFJymxMGRUA==', '77cca7dc9fa544faa5089284555c809b', '192.168.3.65', NULL, 1207245, 0, '2018-01-31 15:58:15', 3, NULL, NULL);
INSERT INTO `users` VALUES (100043, 'gfc6', 'ZVH7GE/VlcBzRV+6S5YayA==', 'f807af88dec24e23beaef292c1a0d4f1', '192.168.3.65', NULL, 1207228, 0, '2018-01-31 15:58:12', 3, NULL, NULL);
INSERT INTO `users` VALUES (100044, 'gfc7', '03qJ+g7eFQapMxvXLXSldw==', 'dc481a772041490b87539c92be702771', '192.168.3.65', NULL, 1206486, 0, '2018-01-31 15:58:14', 3, NULL, NULL);
INSERT INTO `users` VALUES (100045, 'gfc8', 'TZ9il38E1BQvtlu+61Zh1g==', '6d595aa79f2045b78fa5daea20ba2616', '192.168.3.65', NULL, 1207522, 0, '2018-01-31 15:58:10', 3, NULL, NULL);
INSERT INTO `users` VALUES (100046, 'gfc9', 'o85xoz02GD9WOSyosC/1yg==', '4756150c4b3e49c2b11de01935121b70', '192.168.3.65', NULL, 1207434, 0, '2018-01-31 15:58:11', 3, NULL, NULL);
INSERT INTO `users` VALUES (100047, 'gfc10', 'iAyvcIO8A+F0hotd6W7RTg==', '65a66a68253941b5ba9f0caee94db128', '192.168.3.65', NULL, 1207591, 0, '2018-01-31 15:58:12', 3, NULL, '100005');
INSERT INTO `users` VALUES (100048, 'scb1', 'tLTBfit0qriOsQxoprNzhg==', 'a4588b15cecb4fedb0d582f6a941ffb6', '192.168.3.22', NULL, 1205669, 3, '2018-01-31 15:57:38', 3, NULL, NULL);
INSERT INTO `users` VALUES (100049, 'scb2', 'tLTBfit0qriOsQxoprNzhg==', 'a4588b15cecb4fedb0d582f6a941ffb6', '192.168.3.22', NULL, 1206784, 3, '2018-01-31 15:57:38', 3, NULL, '100005');
INSERT INTO `users` VALUES (100050, 'scb3', 'tLTBfit0qriOsQxoprNzhg==', 'a4588b15cecb4fedb0d582f6a941ffb6', '192.168.3.22', NULL, 1205057, 3, '2018-01-31 15:57:18', 3, NULL, NULL);
INSERT INTO `users` VALUES (100051, 'scb4', 'tLTBfit0qriOsQxoprNzhg==', 'a4588b15cecb4fedb0d582f6a941ffb6', '192.168.0.101', NULL, 1204089, 0, '2018-02-03 16:21:28', 2, NULL, NULL);
INSERT INTO `users` VALUES (100052, 'scb5', 'tLTBfit0qriOsQxoprNzhg==', 'a4588b15cecb4fedb0d582f6a941ffb6', '192.168.0.101', NULL, 1205649, 0, '2018-02-03 16:51:25', 1, NULL, NULL);
INSERT INTO `users` VALUES (100053, 'scb6', 'tLTBfit0qriOsQxoprNzhg==', 'a4588b15cecb4fedb0d582f6a941ffb6', '192.168.0.101', NULL, 1205179, 0, '2018-02-03 17:19:30', 1, NULL, NULL);
INSERT INTO `users` VALUES (100054, 'scb7', 'tLTBfit0qriOsQxoprNzhg==', 'a4588b15cecb4fedb0d582f6a941ffb6', '192.168.0.104', NULL, 1200046, 0, '2018-02-04 18:37:26', 3, NULL, NULL);
INSERT INTO `users` VALUES (100055, 'scb8', 'tLTBfit0qriOsQxoprNzhg==', 'a4588b15cecb4fedb0d582f6a941ffb6', '192.168.3.22', NULL, 1200792, 3, '2018-01-31 15:57:18', 3, NULL, NULL);
INSERT INTO `users` VALUES (100056, 'scb9', 'tLTBfit0qriOsQxoprNzhg==', 'a4588b15cecb4fedb0d582f6a941ffb6', '192.168.3.22', NULL, 1199289, 3, '2018-01-31 15:57:18', 3, NULL, NULL);
INSERT INTO `users` VALUES (100057, 'scb10', 'tLTBfit0qriOsQxoprNzhg==', 'a4588b15cecb4fedb0d582f6a941ffb6', '192.168.0.101', NULL, 1200178, 0, '2018-02-02 17:22:22', 3, NULL, NULL);
INSERT INTO `users` VALUES (100058, 'scb11', 'tLTBfit0qriOsQxoprNzhg==', 'a4588b15cecb4fedb0d582f6a941ffb6', '192.168.3.22', NULL, 1201845, 0, '2018-01-30 10:45:52', 2, NULL, NULL);
INSERT INTO `users` VALUES (100059, 'scb12', 'tLTBfit0qriOsQxoprNzhg==', 'a4588b15cecb4fedb0d582f6a941ffb6', '192.168.3.22', NULL, 1201808, 0, '2018-01-30 10:46:07', 2, NULL, NULL);
INSERT INTO `users` VALUES (100060, 'scb13', 'tLTBfit0qriOsQxoprNzhg==', 'a4588b15cecb4fedb0d582f6a941ffb6', '192.168.3.22', NULL, 1204416, 0, '2018-01-30 10:46:23', 2, NULL, NULL);
INSERT INTO `users` VALUES (100061, 'scb14', 'tLTBfit0qriOsQxoprNzhg==', 'a4588b15cecb4fedb0d582f6a941ffb6', '192.168.3.22', NULL, 1204464, 0, '2018-01-30 10:46:37', 2, NULL, NULL);
INSERT INTO `users` VALUES (100062, 'scb15', 'tLTBfit0qriOsQxoprNzhg==', 'a4588b15cecb4fedb0d582f6a941ffb6', '192.168.3.22', NULL, 1204292, 0, '2018-01-30 10:46:54', 2, NULL, '100005');
INSERT INTO `users` VALUES (100063, 'scb16', 'tLTBfit0qriOsQxoprNzhg==', 'a4588b15cecb4fedb0d582f6a941ffb6', '192.168.3.22', NULL, 1204552, 0, '2018-01-30 10:47:11', 2, NULL, NULL);
INSERT INTO `users` VALUES (100064, 'scb17', 'tLTBfit0qriOsQxoprNzhg==', 'a4588b15cecb4fedb0d582f6a941ffb6', '192.168.3.22', NULL, 1204380, 0, '2018-01-30 10:47:24', 2, NULL, NULL);
INSERT INTO `users` VALUES (100065, 'scb18', 'tLTBfit0qriOsQxoprNzhg==', 'a4588b15cecb4fedb0d582f6a941ffb6', '192.168.3.22', NULL, 1208634, 0, '2018-01-30 10:47:43', 2, NULL, NULL);
INSERT INTO `users` VALUES (100066, 'scb19', 'tLTBfit0qriOsQxoprNzhg==', 'a4588b15cecb4fedb0d582f6a941ffb6', '192.168.3.22', NULL, 1204512, 0, '2018-01-30 10:47:58', 2, NULL, NULL);
INSERT INTO `users` VALUES (100067, 'scb20', 'tLTBfit0qriOsQxoprNzhg==', 'a4588b15cecb4fedb0d582f6a941ffb6', '192.168.3.22', NULL, 1204604, 0, '2018-01-30 10:48:13', 2, NULL, NULL);
INSERT INTO `users` VALUES (100068, 'scb21', 'tLTBfit0qriOsQxoprNzhg==', 'a4588b15cecb4fedb0d582f6a941ffb6', '192.168.3.22', NULL, 1200000, 0, '2018-01-30 10:48:27', 2, NULL, NULL);
INSERT INTO `users` VALUES (100069, 'scb22', 'tLTBfit0qriOsQxoprNzhg==', 'a4588b15cecb4fedb0d582f6a941ffb6', '192.168.3.22', NULL, 1200000, 0, '2018-01-30 10:48:40', 2, NULL, NULL);
INSERT INTO `users` VALUES (100070, 'scb23', 'tLTBfit0qriOsQxoprNzhg==', 'a4588b15cecb4fedb0d582f6a941ffb6', '192.168.3.22', NULL, 1204716, 0, '2018-01-30 10:48:52', 2, NULL, NULL);
INSERT INTO `users` VALUES (100071, 'scb24', 'tLTBfit0qriOsQxoprNzhg==', 'a4588b15cecb4fedb0d582f6a941ffb6', '192.168.3.22', NULL, 1210000, 0, '2018-01-30 10:49:05', 2, NULL, NULL);
INSERT INTO `users` VALUES (100072, 'scb25', 'tLTBfit0qriOsQxoprNzhg==', 'a4588b15cecb4fedb0d582f6a941ffb6', '192.168.3.22', NULL, 1210000, 0, '2018-01-30 10:49:19', 2, NULL, NULL);
INSERT INTO `users` VALUES (100073, 'scb26', 'tLTBfit0qriOsQxoprNzhg==', 'a4588b15cecb4fedb0d582f6a941ffb6', '192.168.3.22', NULL, 1210000, 0, '2018-01-30 10:49:33', 2, NULL, NULL);
INSERT INTO `users` VALUES (100074, 'scb27', 'tLTBfit0qriOsQxoprNzhg==', 'a4588b15cecb4fedb0d582f6a941ffb6', '192.168.3.22', NULL, 1210000, 0, '2018-01-30 10:49:45', 2, NULL, '100005');
INSERT INTO `users` VALUES (100075, 'scb28', 'tLTBfit0qriOsQxoprNzhg==', 'a4588b15cecb4fedb0d582f6a941ffb6', '192.168.3.22', NULL, 1210000, 0, '2018-01-30 10:50:54', 2, NULL, NULL);
INSERT INTO `users` VALUES (100076, 'scb29', 'tLTBfit0qriOsQxoprNzhg==', 'a4588b15cecb4fedb0d582f6a941ffb6', '192.168.3.22', NULL, 1209643, 0, '2018-01-30 10:58:41', 2, NULL, NULL);
INSERT INTO `users` VALUES (100077, 'scb30', 'tLTBfit0qriOsQxoprNzhg==', 'a4588b15cecb4fedb0d582f6a941ffb6', '192.168.3.45', NULL, 1210000, 0, '2018-01-15 14:06:09', 3, NULL, NULL);
INSERT INTO `users` VALUES (100078, 'user1', 'yBMs9xUEZMj44iH+SNsB4A==', '407ed3cadc6c40e09ea7ad80dbfc207e', '192.168.0.104', NULL, 1209407, 0, '2018-02-08 18:24:38', 3, NULL, NULL);
INSERT INTO `users` VALUES (100079, 'user2', 'pBOAZxLOege9vOsXUG9RAg==', '63b4bbfa8953442f89e69b759358f32a', '192.168.0.108', NULL, 1212228, 0, '2018-02-08 17:21:46', 3, NULL, NULL);
INSERT INTO `users` VALUES (100080, 'user3', 'izHFwmYvjqwqavaD37rOnA==', '8261efb6a4164f85b034000669048433', '192.168.0.104', NULL, 1209912, 0, '2018-02-08 19:30:19', 3, NULL, NULL);
INSERT INTO `users` VALUES (100081, 'user4', '2uwZLOl5jl0dGbFeQZcs5g==', '6aa0d853ea2f4cf0ac3f8b3abd779975', '192.168.0.100', NULL, 1210000, 0, '2018-02-06 11:06:29', 3, NULL, NULL);
INSERT INTO `users` VALUES (100082, 'user5', 'Ze01XLE9c7Y2vDXYFrwOfA==', '7e564d0ca54446a782d1125642392052', '192.168.0.100', NULL, 1209539, 0, '2018-02-09 10:43:16', 3, NULL, NULL);
INSERT INTO `users` VALUES (100083, 'user6', 'C5q89J/lDTBx+xlLhmmlIA==', 'a8436016eea94eac961967c8dbfbadd0', '192.168.0.100', NULL, 1209997, 0, '2018-02-06 11:31:02', 3, NULL, NULL);
INSERT INTO `users` VALUES (100084, 'user7', 'o/gv7lNsZ/suUvon00B5vw==', 'b4c34059c3a74ab1ac11f0ffdc11f8d7', '192.168.0.100', NULL, 1209999, 0, '2018-02-06 11:38:21', 3, NULL, NULL);
INSERT INTO `users` VALUES (100085, 'user8', 'Z6IDEXxs2nE/t6W4a0nzGw==', '527a0875364548b9a62acbe874b2ede1', '192.168.0.100', NULL, 1210000, 0, '2018-02-06 11:45:26', 3, NULL, NULL);
INSERT INTO `users` VALUES (100086, 'user9', '3+44APYL3nC0GV/XRzJaLQ==', '659d2e1e949c49308feeec8b720cafaf', '192.168.0.100', NULL, 1210025, 3, '2018-02-06 11:52:08', 3, NULL, NULL);
INSERT INTO `users` VALUES (100087, 'user10', '5On9LoyHMnpG6CmUTcGD8A==', '0a7f7f308607416d88be907f8a7809c9', '192.168.0.100', NULL, 1210000, 3, '2018-02-06 11:56:24', 3, NULL, NULL);
INSERT INTO `users` VALUES (100088, 'user11', '3snYKZkea0HpvD55tibUNA==', 'c445233a6167469b89d9f71f05a5bf52', '192.168.0.100', NULL, 1209987, 0, '2018-02-06 11:57:02', 3, NULL, NULL);
INSERT INTO `users` VALUES (100089, 'user12', 'kOBZwdb+OPJ/Zz3+w2VTsg==', 'ad0cd9fbe32647bfa4a5195e273853a4', '192.168.0.100', NULL, 1210000, 0, '2018-02-06 13:55:00', 3, NULL, NULL);
INSERT INTO `users` VALUES (100090, 'user13', 'qyonhaO59g9UQZQcBSTSMg==', 'a9edbb6bba784c5b8786f713d61a0e7b', '192.168.0.100', NULL, 1209999, 0, '2018-02-06 13:58:02', 3, NULL, NULL);
INSERT INTO `users` VALUES (100091, 'user14', '4nH9dur3infRYc8PfMWttQ==', 'd748cfb2c6e74960952d1c3150b77c8b', '192.168.0.101', NULL, 1209998, 0, '2018-02-06 14:41:52', 3, NULL, NULL);
INSERT INTO `users` VALUES (100092, 'user15', 'SYk8b1q/e1/OziJ1TCOr8g==', '08700b87d8a741a788db8c61c3b3ce9b', '192.168.0.101', NULL, 1210001, 0, '2018-02-06 14:47:11', 3, NULL, NULL);
INSERT INTO `users` VALUES (100093, 'user16', 'ZDz8JftpXxqqe0c6hBZFQg==', '4a866fd0f98c43398a658728b84791b3', '192.168.0.101', NULL, 1209984, 0, '2018-02-06 14:51:23', 3, NULL, NULL);
INSERT INTO `users` VALUES (100094, 'user17', '6/byvDozVibnbDZGCL+R8Q==', 'c954ce312af04a53b197b773995ca842', '127.0.0.1', NULL, 1210000, 0, '2018-01-16 09:56:43', 3, NULL, NULL);
INSERT INTO `users` VALUES (100095, 'user18', 'DJjkXfAcRUMG6WSUcTVOZg==', 'f8edb09a0fc448c69797d88dfaeff02c', '192.168.0.101', NULL, 1209993, 0, '2018-02-06 14:54:13', 3, NULL, NULL);
INSERT INTO `users` VALUES (100096, 'user19', 'coIjGI+mtge0XMXOPYQ/hQ==', '04a2f81c1ad4402aaf1d25fb7d0927ce', '192.168.0.101', NULL, 1209989, 0, '2018-02-06 14:58:10', 3, NULL, NULL);
INSERT INTO `users` VALUES (100097, 'user20', 'nMB3ZoFK5w2rDN48ab9iHQ==', '1cc1e8a2c9fe46ab8bc024d580a57984', '127.0.0.1', NULL, 1210000, 0, '2018-01-16 09:56:43', 3, NULL, NULL);
INSERT INTO `users` VALUES (100098, 'user21', 'Gqr8teBvalmPcueGZXg7sg==', '11a9048bff324cbfa03b522233b5215e', '192.168.0.101', NULL, 1210000, 0, '2018-02-06 15:34:57', 3, NULL, NULL);
INSERT INTO `users` VALUES (100099, 'user22', '+8/AKpiiuxsZfd8V5ooTkw==', 'd3d830104b864df28e4829f1ba0d1083', '127.0.0.1', NULL, 1210000, 0, '2018-01-16 09:56:43', 3, NULL, NULL);
INSERT INTO `users` VALUES (100100, 'user23', 'y2yBGOQwjZ7dBlcAeTvdDg==', '2edb494797b64f18b55e961a9fff6bcb', '127.0.0.1', NULL, 1210000, 0, '2018-01-16 09:56:43', 3, NULL, NULL);
INSERT INTO `users` VALUES (100101, 'user24', '7zW8q4pomdCkA6Gs0XEP3g==', '955612c2e49545b1a420b9f0dc3104d7', '127.0.0.1', NULL, 1210000, 0, '2018-01-16 09:56:43', 3, NULL, NULL);
INSERT INTO `users` VALUES (100102, 'user25', 't/p7Nn1cemoxkTnXdN/kcQ==', '5f893522067f41daaa62f9bc835ed42b', '127.0.0.1', NULL, 1210000, 0, '2018-01-16 09:56:43', 3, NULL, NULL);
INSERT INTO `users` VALUES (100103, 'user26', 'IywAbKQB8Mezyn3Io5ODkQ==', '32374f7fe11f45b094afb6391c49e341', '127.0.0.1', NULL, 1210000, 0, '2018-01-16 09:56:43', 3, NULL, NULL);
INSERT INTO `users` VALUES (100104, 'user27', 'G6OVMV3f78+ZiQvBnRZS6Q==', '3e6278765e124b04aed1c6881878234c', '127.0.0.1', NULL, 1210000, 0, '2018-01-16 09:56:43', 3, NULL, NULL);
INSERT INTO `users` VALUES (100105, 'user28', '7kLUw9E4lV2VMFhJ7+728g==', '55079e61629c43f38ba433edf285ccdf', '127.0.0.1', NULL, 1210000, 0, '2018-01-16 09:56:43', 3, NULL, NULL);
INSERT INTO `users` VALUES (100106, 'user29', 'eg30kvzfVU6ytN2P47to1Q==', '10b4fa8812c24cbbbe1417af644e0d60', '127.0.0.1', NULL, 1210000, 0, '2018-01-16 09:56:43', 3, NULL, NULL);
INSERT INTO `users` VALUES (100107, 'user30', 'v5oQFO89A9QBDJSSExjZ4Q==', '42df77e601654e11b2244272672ff23f', '127.0.0.1', NULL, 1210000, 0, '2018-01-16 09:56:43', 3, NULL, NULL);
INSERT INTO `users` VALUES (100108, 'user31', 'Y+rmv8/U8g5vMSJyt7XKig==', '66cb43cc3f594e818ee0501158866f44', '0', NULL, 600000, 0, '2018-01-24 10:32:31', 3, NULL, NULL);
INSERT INTO `users` VALUES (100109, 'yzx11', 'Y+rmv8/U8g5vMSJyt7XKig==', '66cb43cc3f594e818ee0501158866f44', '192.168.3.22', NULL, 600000, 0, '2018-01-24 16:20:57', 3, NULL, NULL);
INSERT INTO `users` VALUES (100110, 'zhuminrui1', 'bpm89vSEZfJGC5sllU9NpQ==', '5f0b4f410a254a8b86f3aee063c5a6a1', '192.168.3.42', NULL, 600000, 0, '2018-01-24 15:55:56', 3, NULL, NULL);
INSERT INTO `users` VALUES (100112, 'yzx12', 'cTQvhEad7Q8G/yjukl5DAw==', 'cf3a540e93324ee691118f39e89eb04f', '192.168.3.22', NULL, 600000, 0, '2018-01-24 16:21:52', 3, NULL, NULL);
INSERT INTO `users` VALUES (100113, 'zhuminrui2', 'XS5AjtY6kQA7XTmHJSTJuQ==', 'e3c084e728a34531bac9b53bfb17604d', '192.168.3.42', NULL, 600000, 0, '2018-01-24 16:07:41', 3, NULL, NULL);
INSERT INTO `users` VALUES (100114, 'zhuminrui3', 'TSasoR0ZqNQwWH9BRChMSA==', 'c00af5a451f24b889bbca79e17128bfa', '192.168.3.42', NULL, 600000, 0, '2018-01-24 16:10:02', 3, NULL, NULL);
INSERT INTO `users` VALUES (100115, 'zhuminrui4', 'uEBeQtrm8+pR0Pw+/Rhnnw==', '0075360ec4e7433e87cd1e6edac955a4', '192.168.3.42', NULL, 600000, 0, '2018-01-24 16:13:01', 3, NULL, '100005');
INSERT INTO `users` VALUES (100116, 'zhuminrui5', 'bUdwQiGFpxwTfobd3YriAA==', '7c366b88bfe64bef94760cbb396edf35', '192.168.3.42', NULL, 600000, 0, '2018-01-24 18:05:05', 3, NULL, '100005');
INSERT INTO `users` VALUES (100117, 'zhuminrui6', 'B1IV1GYd78zwUDKTMTAddQ==', '2e2834102b52424bb736b32fdbb11f72', '192.168.3.42', NULL, 600000, 0, '2018-01-24 16:16:43', 3, NULL, '100005');
INSERT INTO `users` VALUES (100118, 'zhuminrui7', 'GGunyM7mC9aNobFkhSbkww==', '09bbcc6e0fb04513881add9484fe5576', '192.168.3.42', NULL, 600000, 0, '2018-01-24 16:20:34', 3, NULL, '100005');
INSERT INTO `users` VALUES (100121, 'yzx13', 'Bh91o330f7aPxlA+nn/oTQ==', '9ad2f78ddefb4917ac4c439d7744322c', '192.168.3.22', NULL, 600000, 0, '2018-01-24 17:32:23', 3, NULL, '100005');
INSERT INTO `users` VALUES (100122, 'zhuminrui8', 'LNaE4Veu+lM3NP3NITFtew==', '7b59bfd26d5343238cd02d1b57a73eef', '192.168.3.42', NULL, 600000, 0, '2018-01-24 16:24:21', 3, NULL, '100005');
INSERT INTO `users` VALUES (100124, 'zmr1', 'HxjZ93j3AsvneNCTstyGFA==', 'a07cbb5613154b03b8566fe686a325ca', '192.168.3.42', NULL, 600000, 0, '2018-01-24 16:34:04', 3, NULL, '100005');
INSERT INTO `users` VALUES (100126, 'zmr3', 'YgFLMhAP818DnNBU1L/eAA==', '21a7dca987fa4a42a470ea8aeb387fe4', '192.168.3.42', NULL, 600000, 0, '2018-01-24 16:36:00', 3, NULL, '100005');
INSERT INTO `users` VALUES (100127, 'zmr4', 'kWz3SUgKlBCRtxvenNUJrg==', '08852999a1934ca7a83d0be558ee5785', '192.168.3.42', NULL, 600000, 0, '2018-01-24 16:40:36', 3, NULL, '100005');
INSERT INTO `users` VALUES (100128, 'zmr5', 'Y95oGIBYLaCD/fysrMH3kQ==', '6f8a376f811042898c2ce7d923edf09d', '192.168.3.20', NULL, 599981, 0, '2018-01-28 11:14:03', 1, NULL, '100005');
INSERT INTO `users` VALUES (100129, 'zmr6', '+QMVZnuzi3gVJ7lxUAajvA==', 'fcf57373c4114adea8ba6a6f8a82a70c', '192.168.3.20', NULL, 598982, 0, '2018-01-28 10:34:04', 0, NULL, '100005');
INSERT INTO `users` VALUES (100130, 'zmr7', 'tJnULe3GzYAZdUUPMDUmQQ==', '2f5d843d2cad486a858fcabc65ec575e', '192.168.3.42', NULL, 600000, 0, '2018-01-24 16:50:08', 3, NULL, '100005');
INSERT INTO `users` VALUES (100131, 'zmr11', 'sViuPHTN0coAS/48i/gPgw==', '62f46b029a6c45879a0d7533ae016c51', '192.168.3.42', NULL, 600000, 0, '2018-01-24 17:34:59', 3, NULL, '100005');
INSERT INTO `users` VALUES (100132, '中华小酱油', 'RKpPwX8DlmPjMi9zpkRb0w==', 'f3c24f312415440a9012610c24a97368', '192.168.3.22', NULL, 600000, 0, '2018-01-24 17:36:57', 3, NULL, '100005');
INSERT INTO `users` VALUES (100133, 'hk99999', 'rm9zhLHY6AtJXDUDvGaeTg==', '725f41d21292430784c9de66d629dee4', '192.168.3.20', NULL, 600000, 0, '2018-01-24 17:35:57', 3, NULL, '100005');
INSERT INTO `users` VALUES (100134, '我是伟大的中华小酱油', 'm5QRnyr39S34GUA5GyaxmA==', 'a9ebe25b7eb045c1b4f291af02872b19', '192.168.3.22', NULL, 599998, 0, '2018-01-29 15:01:40', 1, NULL, '100005');
INSERT INTO `users` VALUES (100135, 'zmr9', 'rZjadvNyv27s36trqqY+Dw==', 'da6f1d5d09d84d478a8a544f8b34cad5', '192.168.3.42', NULL, 600000, 0, '2018-01-25 09:03:19', 3, NULL, '100005');
INSERT INTO `users` VALUES (100136, 'zmr01', 'X+mLIQeNTGJRWwfss2BCXw==', '9cea7a22a5b54dbd909171a172584b51', '192.168.3.42', NULL, 600000, 0, '2018-01-25 10:32:08', 3, NULL, '100005');
INSERT INTO `users` VALUES (100137, '酱油酱', 'EhDKPBFP3YXhBqLIhxiKvg==', '6f60f47c2d864bbab1557a0ce647ec19', '192.168.0.104', NULL, 0, 0, '2018-02-09 09:41:56', 3, NULL, '100005');
INSERT INTO `users` VALUES (100138, '酱油', '5UO/9Hd+UAa5Ton+SMPyxw==', 'ea9e1f837e564a4bb5a90ca3ecff3305', '192.168.0.100', NULL, 1000, 0, '2018-02-09 14:12:25', 3, NULL, '100005');
INSERT INTO `users` VALUES (100139, '酱油3', 'FA+jXbHwhJorlQ0SQBYKKQ==', '0c9f59aefbb145eebe531b81229c17be', '192.168.0.100', NULL, 1000, 0, '2018-02-09 14:13:44', 3, NULL, '100005');
INSERT INTO `users` VALUES (100140, '酱油2', '7zHgZw6s/RGvhiLFawtbEQ==', 'a08e88ba2e5b4e35bdbf29641e2011ff', '192.168.0.100', NULL, 1000, 0, '2018-02-09 14:14:31', 3, NULL, '100005');
INSERT INTO `users` VALUES (100141, 'testPinea', 'RZQyUl9x3hXi8arLCNtpww==', 'b3eadfe966874016a4bc66302229e7ef', '127.0.0.1', NULL, 0, 0, '2018-05-15 15:31:06', 3, NULL, '47C136');
INSERT INTO `users` VALUES (100142, 'hq323', 'o5W5ZiU/JnAycxtTS9kDOw==', 'b957ef1f65834024832fb40e0d11e890', '127.0.0.1', NULL, 0, 0, '2021-06-26 17:37:52', 3, NULL, 'L6VBYQ');

SET FOREIGN_KEY_CHECKS = 1;