text: /*
   Navicat Premium Data Transfer
  
   Source Server         : localMySQL
   Source Server Type    : MySQL
   Source Server Version : 80018
   Source Host           : localhost:3306
   Source Schema         : test_db
  
   Target Server Type    : MySQL
   Target Server Version : 80018
   File Encoding         : 65001
  
   Date: 08/11/2019 11:50:14
  */
  
  SET NAMES utf8mb4;
  SET FOREIGN_KEY_CHECKS = 0;
  
  -- ----------------------------
  -- Table structure for user_info
  -- ----------------------------
  DROP TABLE IF EXISTS `user_info`;
  CREATE TABLE `user_info`  (
    `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增主键',
    `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户名',
    `hashed_password` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '哈希密码',
    `phone_number` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号',
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 30 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of user_info
  -- ----------------------------
  INSERT INTO `user_info` VALUES (1, 'zhengxl', '123123', '123456');
  INSERT INTO `user_info` VALUES (2, 'zxl123', '123123', '123456');
  INSERT INTO `user_info` VALUES (3, 'zhangxin', '789', '13512345678');
  INSERT INTO `user_info` VALUES (4, 'renbin', '012', '13288887777');
  INSERT INTO `user_info` VALUES (5, 'ceshi', '123123', '123123');
  INSERT INTO `user_info` VALUES (7, 'ceshi2', '123123', '123123');
  
  SET FOREIGN_KEY_CHECKS = 1;
  