text: /*
   Navicat Premium Data Transfer
  
   Source Server         : localhost
   Source Server Type    : MySQL
   Source Server Version : 80015
   Source Host           : localhost:3306
   Source Schema         : demo
  
   Target Server Type    : MySQL
   Target Server Version : 80015
   File Encoding         : 65001
  
   Date: 23/05/2019 15:21:50
  */
  
  SET NAMES utf8mb4;
  SET FOREIGN_KEY_CHECKS = 0;
  
  -- ----------------------------
  -- Table structure for user
  -- ----------------------------
  DROP TABLE IF EXISTS `user`;
  CREATE TABLE `user`  (
    `id` int(11) UNSIGNED NOT NULL COMMENT '主键',
    `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '姓名',
    `age` tinyint(2) UNSIGNED NULL DEFAULT NULL COMMENT '年龄',
    `sex` tinyint(2) UNSIGNED NULL DEFAULT NULL COMMENT '性别',
    `info` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '个人信息',
    `gmt_create` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    `gmt_modified` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
    PRIMARY KEY (`id`) USING BTREE,
    INDEX `idx_name`(`name`) USING BTREE COMMENT '主键索引名为 pk_ 字段名；唯一索引名为 uk _字段名 ； 普通索引名则为 idx _字段名。'
  ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  
  SET FOREIGN_KEY_CHECKS = 1;
  