Customer-Service/verification/verification.sql

/*
 Navicat Premium Data Transfer

 Source Server         : 127.0.0.1
 Source Server Type    : MySQL
 Source Server Version : 50553
 Source Host           : localhost:3306
 Source Schema         : verification

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

 Date: 19/10/2019 17:48:07
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for verify_admin
-- ----------------------------
DROP TABLE IF EXISTS `verify_admin`;
CREATE TABLE `verify_admin`  (
  `admin_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '管理员ID',
  `admin_identity` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '管理员唯一标识',
  `admin_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '管理员名',
  `admin_nickname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '管理员昵称',
  `admin_full_name` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '管理员真实姓名',
  `admin_password` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '管理员密码',
  `admin_status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态-1：使用2：禁用',
  `admin_add_time` int(20) NOT NULL DEFAULT 0 COMMENT '新增时间',
  `admin_add_ip` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '新增IP',
  `admin_last_time` int(20) NOT NULL DEFAULT 0 COMMENT '最后登录时间',
  `admin_last_ip` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '最后登录IP',
  `admin_email` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '管理员邮箱',
  `admin_phone` bigint(20) NOT NULL DEFAULT 0 COMMENT '管理员手机号',
  `admin_remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '备注',
  `admin_salt` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '盐值',
  PRIMARY KEY (`admin_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '管理员表' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of verify_admin
-- ----------------------------
INSERT INTO `verify_admin` VALUES (1, '6d7dc40b-9a6c-9404-5eb5-05b9ba2df08a', 'admin', '', '', 'ea62fef8559b570c7dd47af9ca3116fc', 1, 1567590608, '192.168.2.187', 1571471854, '127.0.0.1', '', 15000000000, '', 'UyslvO');

-- ----------------------------
-- Table structure for verify_code
-- ----------------------------
DROP TABLE IF EXISTS `verify_code`;
CREATE TABLE `verify_code`  (
  `code_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '验证码id',
  `code_key` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '验证码',
  `code_time` int(11) NOT NULL COMMENT '时间',
  PRIMARY KEY (`code_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 24 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of verify_code
-- ----------------------------
INSERT INTO `verify_code` VALUES (1, 'ghhh-cSDH3bjsQi6yTgdFVZ2MJXftvGz8wIWU', 1571470830);
INSERT INTO `verify_code` VALUES (2, 'qwe-cSDH3bjsQi6yTgdFVZ2MJXftvGz8wIWU', 1571470830);
INSERT INTO `verify_code` VALUES (3, 'dfb-cSDH3bjsQi6yTgdFVZ2MJXftvGz8wIWU', 1571470830);
INSERT INTO `verify_code` VALUES (4, 'ghhh-cSDH3bjsQi6yTgdFVZ2MJXftvGz8wIWU', 1571470861);
INSERT INTO `verify_code` VALUES (5, 'qwe-cSDH3bjsQi6yTgdFVZ2MJXftvGz8wIWU', 1571470861);
INSERT INTO `verify_code` VALUES (6, 'dfb-cSDH3bjsQi6yTgdFVZ2MJXftvGz8wIWU', 1571470861);
INSERT INTO `verify_code` VALUES (7, 'qwe-cSDH3bjsQi6yTgdFVZ2MJXftvGz8wIWU', 1571470875);
INSERT INTO `verify_code` VALUES (8, 'dfb-cSDH3bjsQi6yTgdFVZ2MJXftvGz8wIWU', 1571470875);
INSERT INTO `verify_code` VALUES (9, 'dfb-cSDH3bjsQi6yTgdFVZ2MJXftvGz8wIWU', 1571470887);
INSERT INTO `verify_code` VALUES (10, 'dfb-cSDH3bjsQi6yTgdFVZ2MJXftvGz8wIWU', 1571471031);
INSERT INTO `verify_code` VALUES (11, 'dfb-cSDH3bjsQi6yTgdFVZ2MJXftvGz8wIWU', 1571471168);
INSERT INTO `verify_code` VALUES (12, 'dfb-cSDH3bjsQi6yTgdFVZ2MJXftvGz8wIWU', 1571471255);
INSERT INTO `verify_code` VALUES (13, 'dfb-cSDH3bjsQi6yTgdFVZ2MJXftvGz8wIWU', 1571471535);
INSERT INTO `verify_code` VALUES (14, 'dfb-cSDH3bjsQi6yTgdFVZ2MJXftvGz8wIWU', 1571471595);
INSERT INTO `verify_code` VALUES (15, 'dfb-cSDH3bjsQi6yTgdFVZ2MJXftvGz8wIWU', 1571471671);
INSERT INTO `verify_code` VALUES (16, 'dfb-cSDH3bjsQi6yTgdFVZ2MJXftvGz8wIWU', 1571471687);
INSERT INTO `verify_code` VALUES (17, 'dfb-cSDH3bjsQi6yTgdFVZ2MJXftvGz8wIWU', 1571471693);
INSERT INTO `verify_code` VALUES (18, 'dfb-cSDH3bjsQi6yTgdFVZ2MJXftvGz8wIWU', 1571471757);
INSERT INTO `verify_code` VALUES (19, 'vali-cSDH3bjsQi6yTgdFVZ2MJXftvGz8wIWU', 1571476603);
INSERT INTO `verify_code` VALUES (20, 'tank-cSDH3bjsQi6yTgdFVZ2MJXftvGz8wIWU', 1571476603);
INSERT INTO `verify_code` VALUES (21, 'vali-cSDH3bjsQi6yTgdFVZ2MJXftvGz8wIWU', 1571476627);
INSERT INTO `verify_code` VALUES (22, 'tank-cSDH3bjsQi6yTgdFVZ2MJXftvGz8wIWU', 1571476627);
INSERT INTO `verify_code` VALUES (23, 'tank-cSDH3bjsQi6yTgdFVZ2MJXftvGz8wIWU', 1571476655);

-- ----------------------------
-- Table structure for verify_message
-- ----------------------------
DROP TABLE IF EXISTS `verify_message`;
CREATE TABLE `verify_message`  (
  `message_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `message_title` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '主题',
  `message_content` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '内容',
  `message_identity` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '唯一标识',
  `message_time` int(20) NOT NULL DEFAULT 0 COMMENT '接收时间',
  `message_ip` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '接收IP',
  `platform_identity` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '平台唯一标识',
  PRIMARY KEY (`message_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '消息' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of verify_message
-- ----------------------------
INSERT INTO `verify_message` VALUES (1, '234334', '范德萨范德萨', 'ef8b8822-0113-deff-db2b-7dc0a13332c5', 1568190126, '192.168.2.187', '868ade9b-db29-a59e-7b6b-61c8686f1626');
INSERT INTO `verify_message` VALUES (2, '2343一天', '范德萨范德萨', '7811ca33-79e7-d86f-9405-9dec6700bd53', 1568197009, '192.168.2.187', '868ade9b-db29-a59e-7b6b-61c8686f1626');
INSERT INTO `verify_message` VALUES (3, '你付款的老师2343', '范德', 'caf87f45-304b-7486-efe6-ac48ff5a79b6', 1568198160, '192.168.2.187', '868ade9b-db29-a59e-7b6b-61c8686f1626');
INSERT INTO `verify_message` VALUES (4, 'ytr', '范德222222222222222', '71c757b9-c2dd-346c-cec0-0b9a679bd394', 1568256157, '192.168.2.187', '868ade9b-db29-a59e-7b6b-61c8686f1626');
INSERT INTO `verify_message` VALUES (5, '543', '范德222222222222222', '71c757b9-c2dd-346c-cec0-0b9a679bd3941', 1568256157, '192.168.2.187', '868ade9b-db29-a59e-7b6b-61c8686f1626');
INSERT INTO `verify_message` VALUES (6, '积极急急急', '范德222222222222222', '71c757b9-c2dd-346c-cec0-0b9a679bd3942', 1568256157, '192.168.2.187', '868ade9b-db29-a59e-7b6b-61c8686f1626');
INSERT INTO `verify_message` VALUES (7, '花港饭店', '范德222222222222222', '71c757b9-c2dd-346c-cec0-0b9a679bd3943', 1568256157, '192.168.2.187', '868ade9b-db29-a59e-7b6b-61c8686f1626');
INSERT INTO `verify_message` VALUES (8, '一头热糊涂人', '<strong><span style="color:#4C33E5;font-size:14px;"><span style="font-size:14px;color:#4C33E5;"> \n<p style="font-family:"color:#858585;font-size:14px;background-color:#F6F6F6;">\n	<strong> </strong> \n</p>\n<p style="font-family:"color:#858585;font-size:14px;background-color:#F6F6F6;">\n	<strong><strong><span style="font-size:12px;">❤欢迎莅临【500新彩】365天X24小时专业的客户服务，全天候处理相关事宜，严格训练的客服团队，以专业、亲切的态度，让每位玩家宾至如归的感觉！全新的充值方式，全新的服务理念，尽在500新彩！</span></strong></strong>\n</p>\n</span></span></strong><strong></strong>', '71c757b9-c2dd-346c-cec0-0b9a679bd3944', 1568256157, '192.168.2.187', '868ade9b-db29-a59e-7b6b-61c8686f1626');
INSERT INTO `verify_message` VALUES (11, '2343', 'gfete', 'f48d78c8-d1da-b75e-0d19-f4787ea091ad', 1568268100, '192.168.2.187', '868ade9b-db29-a59e-7b6b-61c8686f1626');

-- ----------------------------
-- Table structure for verify_message_user
-- ----------------------------
DROP TABLE IF EXISTS `verify_message_user`;
CREATE TABLE `verify_message_user`  (
  `message_user_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `message_identity` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '消息唯一标识',
  `user_identity` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户唯一标识',
  PRIMARY KEY (`message_user_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 23 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '消息-用户管理表' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of verify_message_user
-- ----------------------------
INSERT INTO `verify_message_user` VALUES (3, 'ef8b8822-0113-deff-db2b-7dc0a13332c5', '9e7340f6-e0ea-4284-8146-4d0b8309916f');
INSERT INTO `verify_message_user` VALUES (6, '7811ca33-79e7-d86f-9405-9dec6700bd53', '9e7340f6-e0ea-4284-8146-4d0b8309916f');
INSERT INTO `verify_message_user` VALUES (8, 'caf87f45-304b-7486-efe6-ac48ff5a79b6', '9e7340f6-e0ea-4284-8146-4d0b8309916f');
INSERT INTO `verify_message_user` VALUES (9, 'caf87f45-304b-7486-efe6-ac48ff5a79b6', '29f1a542-770e-1853-f36e-df59401e274e');
INSERT INTO `verify_message_user` VALUES (10, '7811ca33-79e7-d86f-9405-9dec6700bd53', '29f1a542-770e-1853-f36e-df59401e274e');
INSERT INTO `verify_message_user` VALUES (11, 'ef8b8822-0113-deff-db2b-7dc0a13332c5', '29f1a542-770e-1853-f36e-df59401e274e');
INSERT INTO `verify_message_user` VALUES (12, '71c757b9-c2dd-346c-cec0-0b9a679bd394', '6d7dc40b-9a6c-9404-5eb5-05b9ba2df08a');
INSERT INTO `verify_message_user` VALUES (13, '71c757b9-c2dd-346c-cec0-0b9a679bd394', '9e7340f6-e0ea-4284-8146-4d0b8309916f');
INSERT INTO `verify_message_user` VALUES (14, '71c757b9-c2dd-346c-cec0-0b9a679bd3946', '29f1a542-770e-1853-f36e-df59401e274e');
INSERT INTO `verify_message_user` VALUES (15, '71c757b9-c2dd-346c-cec0-0b9a679bd3945', '29f1a542-770e-1853-f36e-df59401e274e');
INSERT INTO `verify_message_user` VALUES (16, '71c757b9-c2dd-346c-cec0-0b9a679bd3944', '29f1a542-770e-1853-f36e-df59401e274e');
INSERT INTO `verify_message_user` VALUES (17, '71c757b9-c2dd-346c-cec0-0b9a679bd3943', '29f1a542-770e-1853-f36e-df59401e274e');
INSERT INTO `verify_message_user` VALUES (18, '71c757b9-c2dd-346c-cec0-0b9a679bd3942', '29f1a542-770e-1853-f36e-df59401e274e');
INSERT INTO `verify_message_user` VALUES (19, '71c757b9-c2dd-346c-cec0-0b9a679bd3941', '29f1a542-770e-1853-f36e-df59401e274e');
INSERT INTO `verify_message_user` VALUES (20, '71c757b9-c2dd-346c-cec0-0b9a679bd394', '29f1a542-770e-1853-f36e-df59401e274e');
INSERT INTO `verify_message_user` VALUES (21, 'f48d78c8-d1da-b75e-0d19-f4787ea091ad', '6d7dc40b-9a6c-9404-5eb5-05b9ba2df08a');
INSERT INTO `verify_message_user` VALUES (22, 'f48d78c8-d1da-b75e-0d19-f4787ea091ad', '9e7340f6-e0ea-4284-8146-4d0b8309916f');

-- ----------------------------
-- Table structure for verify_message_verify
-- ----------------------------
DROP TABLE IF EXISTS `verify_message_verify`;
CREATE TABLE `verify_message_verify`  (
  `message_verify_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `message_verify` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '消息认证内容',
  `message_verify_time` int(11) NOT NULL COMMENT '时间',
  PRIMARY KEY (`message_verify_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for verify_platform
-- ----------------------------
DROP TABLE IF EXISTS `verify_platform`;
CREATE TABLE `verify_platform`  (
  `platform_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `platform_name` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '平台名称',
  `platform_code` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '代号',
  `platform_identity` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '唯一标识',
  `platform_status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态-1：为启用2为停用',
  `platform_register_time` int(20) NOT NULL DEFAULT 0 COMMENT '注册时间',
  `platform_register_ip` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '注册IP',
  `platform_url` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '平台登录网址',
  `platform_email` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '邮箱',
  `platform_phone` bigint(20) NOT NULL DEFAULT 0 COMMENT '电话',
  `platform_remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '备注',
  `platform_img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '平台图标',
  PRIMARY KEY (`platform_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '注册商' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of verify_platform
-- ----------------------------
INSERT INTO `verify_platform` VALUES (1, '客服系统', 'CustomerService', '', 1, 1567590608, '192.168.2.187', '[\"http://kf.bocai186.com/?pid=%25u8FD9%25u5C31%25u662F%25u4E00%25u4E2A%25u7F16%25u7801%25u6CA1%25u6709%25u4EC0%25u4E48%25u7528%25u554A\",\"http://kf.bocai186.com/?pid=%25u8FD9%25u5C31%25u662F%25u4E00%25u4E2A%25u7F16%25u7801%25u6CA1%25u6709%25u4\",\"http://kf.bocai186.com/?pid=%25u8FD9%25u5C31%25u662F%25u4E00%25u4E2A%25u7F16%25u7801%25u6CA1%25u6709\"]', 'sas@qq.com', 15000000000, '客服系统是乾隆公司旗下的一个牛逼产品', '/uploads/20190923/1077da179d335f32c78eec9b68a920fc.jpeg');
INSERT INTO `verify_platform` VALUES (3, '大博集团', '', '', 2, 0, '', '[\"https://www.sina.com.cn/\",\"https://www.baidu.com/\"]', 'ew@qq.com', 15203000000, 'gfredgre', '/static/admin/img/map-marker-violet.png');
INSERT INTO `verify_platform` VALUES (4, '大博集团2', '20190910173012891489115', '77b71d43-0180-62c8-9a83-d2134eb03f49', 1, 1568107812, '192.168.2.187', '[\"https://www.baidu.com\",\"https://www.sina.com.cn/\"]', '354@qq.com', 15000000000, 'trrewwwwwwwwww', '/static/admin/img/map-marker-violet.png');
INSERT INTO `verify_platform` VALUES (5, '大博客服系统', 'mvHBKaPNxXhdSZgT', 'e86b68f7-cef3-524e-1578-2fb64d4f8e51', 1, 1568186382, '192.168.2.187', '[\"https://www.iconfont.cn\",\"https://www.layui.com\"]', 'dabo@163.com', 15800000000, '大博大博生活得博', '/static/admin/img/map-marker-violet.png');
INSERT INTO `verify_platform` VALUES (6, '大博客服系统', 'cSDH3bjsQi6yTgdFVZ2MJXftvGz8wIWU', '868ade9b-db29-a59e-7b6b-61c8686f1626', 1, 1568187100, '192.168.2.187', '[\"https://www.layui.com\",\"https://www.iconfont.cn\"]', 'dabo@163.com', 15800000000, '大博大博懂得生活', '/static/admin/img/map-marker-violet.png');

-- ----------------------------
-- Table structure for verify_platform_user
-- ----------------------------
DROP TABLE IF EXISTS `verify_platform_user`;
CREATE TABLE `verify_platform_user`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user_identity` int(11) NOT NULL COMMENT '用户id',
  `platform_id` int(11) NOT NULL COMMENT '平台id',
  `platform_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '平台验证码',
  `platform_code_time` int(11) NOT NULL COMMENT '时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 16 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of verify_platform_user
-- ----------------------------
INSERT INTO `verify_platform_user` VALUES (1, 0, 1, 'CustomerService', 1571471647);
INSERT INTO `verify_platform_user` VALUES (2, 5, 4, '20190910173012891489115', 1571471666);
INSERT INTO `verify_platform_user` VALUES (3, 5, 1, 'CustomerService', 1571471676);
INSERT INTO `verify_platform_user` VALUES (4, 5, 4, '20190910173012891489115', 1571471679);
INSERT INTO `verify_platform_user` VALUES (5, 0, 4, '20190910173012891489115', 1571471679);
INSERT INTO `verify_platform_user` VALUES (6, 5, 5, 'mvHBKaPNxXhdSZgT', 1571471681);
INSERT INTO `verify_platform_user` VALUES (7, 5, 6, 'cSDH3bjsQi6yTgdFVZ2MJXftvGz8wIWU', 1571471684);
INSERT INTO `verify_platform_user` VALUES (8, 0, 5, 'mvHBKaPNxXhdSZgT', 1571471689);
INSERT INTO `verify_platform_user` VALUES (9, 0, 5, 'mvHBKaPNxXhdSZgT', 1571471695);
INSERT INTO `verify_platform_user` VALUES (10, 817, 6, 'cSDH3bjsQi6yTgdFVZ2MJXftvGz8wIWU', 1571471875);
INSERT INTO `verify_platform_user` VALUES (11, 817, 4, '20190910173012891489115', 1571471880);
INSERT INTO `verify_platform_user` VALUES (12, 0, 6, 'cSDH3bjsQi6yTgdFVZ2MJXftvGz8wIWU', 1571476617);
INSERT INTO `verify_platform_user` VALUES (13, 0, 4, '20190910173012891489115', 1571477314);
INSERT INTO `verify_platform_user` VALUES (14, 0, 6, 'cSDH3bjsQi6yTgdFVZ2MJXftvGz8wIWU', 1571477359);
INSERT INTO `verify_platform_user` VALUES (15, 0, 1, 'CustomerService', 1571477379);

-- ----------------------------
-- Table structure for verify_user
-- ----------------------------
DROP TABLE IF EXISTS `verify_user`;
CREATE TABLE `verify_user`  (
  `user_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `user_identity` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用户唯一标识',
  `user_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用户名',
  `user_nickname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用户昵称',
  `user_full_name` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用户真实姓名',
  `user_password` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用户密码',
  `user_status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态-1：使用2：禁用',
  `user_register_time` int(20) NOT NULL DEFAULT 0 COMMENT '注册时间',
  `user_register_ip` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '注册IP',
  `user_last_time` int(20) NOT NULL DEFAULT 0 COMMENT '最后登录时间',
  `user_last_ip` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '最后登录IP',
  `user_email` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用户邮箱',
  `user_phone` bigint(20) NOT NULL DEFAULT 0 COMMENT '用户手机号',
  `user_remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '备注',
  `user_salt` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '盐值',
  `user_token` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户token',
  `user_lastOperation` int(20) NULL DEFAULT NULL COMMENT '操作时间',
  PRIMARY KEY (`user_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户表' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of verify_user
-- ----------------------------
INSERT INTO `verify_user` VALUES (1, '6d7dc40b-9a6c-9404-5eb5-05b9ba2df08a', 'ethan1', '', '', 'd7227d5e8725a0cad73b6c1eef7d165a', 1, 1567590608, '192.168.2.187', 1567753237, '192.168.2.194', '', 15000000000, '', 'L6H659', NULL, NULL);
INSERT INTO `verify_user` VALUES (2, '9e7340f6-e0ea-4284-8146-4d0b8309916f', 'ethan2', '', '', 'b2d6e887e2698c7e33060c1c7600c2d8', 1, 1567648108, '192.168.2.187', 1567648108, '192.168.2.187', '', 15000000000, '', 'r6oOnb', NULL, NULL);
INSERT INTO `verify_user` VALUES (3, '3b8b31d9-e70b-ef0b-0250-7cbcf4e3a826', 'ethan3', '', '', 'e763cc3e034cd866367f556467be999b', 1, 1567668220, '192.168.2.187', 1567668220, '192.168.2.187', '', 15000000000, '', 'Cfdkcl', NULL, NULL);
INSERT INTO `verify_user` VALUES (4, '846dd5b1-3f30-7ecf-6bee-a6f76b2afa8b', 'qidengji', '', '', '424b486da40d3e8e55269feef375008f', 1, 1567669268, '192.168.2.194', 1567670815, '192.168.2.194', '', 1111, '', 'uR8vpM', NULL, NULL);
INSERT INTO `verify_user` VALUES (5, 'bac12e82-acfc-38ea-8093-1315bc7e3c20', 'qidengji1', '', '', '141d3b3fb50abb9ac37f978d08b3b072', 1, 1567669533, '192.168.2.194', 1567669533, '192.168.2.194', '', 1111, '', 'upKx9Q', NULL, NULL);
INSERT INTO `verify_user` VALUES (6, '54515737-a8c1-9fe0-f7ad-faee4c319d94', 'qdj123', '', '', '5bec7b40e009877bfd3381e20fcbcffb', 1, 1567670044, '192.168.2.194', 1567739841, '192.168.2.194', '', 12345678912, '', 'nlnnIZ', NULL, NULL);
INSERT INTO `verify_user` VALUES (7, '4b224d21-9054-cb39-b1dd-8ec56fe862ee', 'qidengji2', '', '', '7ca4aa44762afb9f62ae5e006c1143bc', 1, 1567670648, '192.168.2.194', 1567670648, '192.168.2.194', '', 12345678901, '', 'JBteTU', NULL, NULL);
INSERT INTO `verify_user` VALUES (11, '246133f9-1a9e-ede4-2ade-9f7fd6ddeb54', 'jonlin3', '', '', 'f29ff87d209e468a9692d261646c6502', 1, 1569833951, '127.0.0.1', 1571121713, '127.0.0.1', '', 15000000000, '', 'BEvgMj', NULL, NULL);
INSERT INTO `verify_user` VALUES (12, 'bf81d1a6-d644-861d-07fd-9f7803d2f3a9', 'jonlin4', '', '', '484288ec18590c7c53806349494b5e6c', 1, 1569834693, '127.0.0.1', 1569834693, '127.0.0.1', '', 15000000000, '', 'cLjHy8', NULL, NULL);
INSERT INTO `verify_user` VALUES (13, '8e593a80-024e-aefb-758f-f97fcfdc8bd9', 'jonlin5', '', '', '01fe394ec92b6a3bb6a0b0c98fce438b', 1, 1571119371, '127.0.0.1', 1571196279, '192.168.2.153', '', 13211112222, '', '13EiAe', NULL, NULL);
INSERT INTO `verify_user` VALUES (14, 'de350ea4-f071-578a-a59f-4f557198edb4', '123456', '', '', '1855cf344e996959e0f2ceac01f77dec', 1, 1571123515, '192.168.2.194', 1571471251, '192.168.2.194', '', 0, '', '9rRSvv', '00sPqX15714712515daabf934987a', 1571471773);
INSERT INTO `verify_user` VALUES (17, '817da1ce-4432-c667-0044-0766dabe58f3', 'a123456', '', '', '00b38aa869e236622ba0fbad25023107', 1, 1571471854, '192.168.2.194', 1571471870, '192.168.2.194', '', 12345678911, '', 'yW6IbA', 'Zuts3115714718705daac1fe94688', 1571471881);

-- ----------------------------
-- Table structure for verify_user_platform
-- ----------------------------
DROP TABLE IF EXISTS `verify_user_platform`;
CREATE TABLE `verify_user_platform`  (
  `user_platform_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `user_identity` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户唯一标识',
  `platform_id` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '注册商唯一标识',
  `platform_user` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '所在平台名',
  `user_platform_rtime` int(20) NOT NULL COMMENT '注册时间',
  `user_platform_rip` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '注册IP',
  PRIMARY KEY (`user_platform_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户-注册商关联' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of verify_user_platform
-- ----------------------------
INSERT INTO `verify_user_platform` VALUES (1, '6d7dc40b-9a6c-9404-5eb5-05b9ba2df08a', '6', 'vali', 1567590608, '192.168.2.194');
INSERT INTO `verify_user_platform` VALUES (2, '6d7dc40b-9a6c-9404-5eb5-05b9ba2df08a', '6', 'tank', 1567590608, '192.168.2.194');

SET FOREIGN_KEY_CHECKS = 1;