text: /*
   Navicat MySQL Data Transfer
  
   Source Server         : mysqlInDocker
   Source Server Type    : MySQL
   Source Server Version : 50724
   Source Host           : 192.168.56.101:3306
   Source Schema         : account
  
   Target Server Type    : MySQL
   Target Server Version : 50724
   File Encoding         : 65001
  
   Date: 25/01/2019 02:02:11
  */
  
  SET NAMES utf8mb4;
  SET FOREIGN_KEY_CHECKS = 0;
  
  CREATE DATABASE IF NOT EXISTS account;
  USE account;
  
  -- ----------------------------
  -- Table structure for tbl_token
  -- ----------------------------
  DROP TABLE IF EXISTS `tbl_token`;
  CREATE TABLE `tbl_token`  (
    `user_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `token` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `status` int(255) NOT NULL DEFAULT 1,
    `device` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
  ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Table structure for tbl_user
  -- ----------------------------
  DROP TABLE IF EXISTS `tbl_user`;
  CREATE TABLE `tbl_user`  (
    `uid` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '用户id',
    `user_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `pwd_hash` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `salt` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    PRIMARY KEY (`uid`) USING BTREE,
    UNIQUE INDEX `user_name_UNIQUE`(`user_name`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  
  SET FOREIGN_KEY_CHECKS = 1;
  