text: /*
   Navicat MySQL Data Transfer
  
   Source Server         : 00
   Source Server Type    : MySQL
   Source Server Version : 50710
   Source Host           : localhost:3306
   Source Schema         : my-plus
  
   Target Server Type    : MySQL
   Target Server Version : 50710
   File Encoding         : 65001
  
   Date: 16/08/2021 11:03:47
  */
  
  SET NAMES utf8mb4;
  SET FOREIGN_KEY_CHECKS = 0;
  
  -- ----------------------------
  -- Table structure for user
  -- ----------------------------
  DROP TABLE IF EXISTS `user`;
  CREATE TABLE `user`  (
    `id` bigint(20) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT COMMENT '主键ID',
    `company_id` bigint(20) NOT NULL COMMENT '公司ID',
    `name` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '姓名',
    `age` int(11) NULL DEFAULT NULL COMMENT '年龄',
    `email` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '邮箱',
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of user
  -- ----------------------------
  INSERT INTO `user` VALUES (00000000000000000001, 1, 'Jone', 18, 'test1@baomidou.com');
  INSERT INTO `user` VALUES (00000000000000000002, 1, 'Jack', 20, 'test2@baomidou.com');
  INSERT INTO `user` VALUES (00000000000000000003, 1, 'Tom', 28, 'test3@baomidou.com');
  INSERT INTO `user` VALUES (00000000000000000004, 2, 'Sandy', 21, 'test4@baomidou.com');
  INSERT INTO `user` VALUES (00000000000000000005, 2, 'Billie', 24, 'test5@baomidou.com');
  
  SET FOREIGN_KEY_CHECKS = 1;
  