/* 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:&quot;color:#858585;font-size:14px;background-color:#F6F6F6;">\n <strong> </strong> \n</p>\n<p style="font-family:&quot;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;