text: /*
   Navicat Premium Data Transfer
  
   Source Server         : 本机mysql
   Source Server Type    : MySQL
   Source Server Version : 50719
   Source Host           : localhost:3306
   Source Schema         : game
  
   Target Server Type    : MySQL
   Target Server Version : 50719
   File Encoding         : 65001
  
   Date: 23/01/2018 14:35:39
  */
  
  SET NAMES utf8mb4;
  SET FOREIGN_KEY_CHECKS = 0;
  
  -- ----------------------------
  -- Table structure for order 
  -- ----------------------------
  DROP TABLE IF EXISTS `order`;
  CREATE TABLE `order` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `order_no` varchar(50) DEFAULT NULL COMMENT '订单号',
    `account` varchar(50) DEFAULT NULL COMMENT '账号',
    `password` varchar(50) DEFAULT NULL COMMENT '密码',
    `name` varchar(50) DEFAULT NULL COMMENT '角色名',
    `status` int(11) DEFAULT NULL COMMENT '订单状态',
    `create_time` int(11) DEFAULT NULL COMMENT '添加时间',
    `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Table structure for auth
  -- ----------------------------
  DROP TABLE IF EXISTS `auth`;
  CREATE TABLE `auth` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `account` varchar(100) DEFAULT NULL COMMENT '账号',
    `password` varchar(100) DEFAULT NULL COMMENT '密码',
    `name` varchar(100) DEFAULT NULL COMMENT '角色名',
    `create_time` int(11) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  SET FOREIGN_KEY_CHECKS = 1;
  