text: /*
   Navicat MySQL Data Transfer
  
   Source Server         : 127.0.0.1 root - root
   Source Server Type    : MySQL
   Source Server Version : 50731
   Source Host           : localhost:3306
   Source Schema         : sampledb
  
   Target Server Type    : MySQL
   Target Server Version : 50731
   File Encoding         : 65001
  
   Date: 18/02/2021 15:22:39
  */
  
  SET NAMES utf8mb4;
  SET FOREIGN_KEY_CHECKS = 0;
  
  -- ----------------------------
  -- Table structure for employee
  -- ----------------------------
  DROP TABLE IF EXISTS `employee`;
  CREATE TABLE `employee`  (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `lastName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    `gender` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    `email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of employee
  -- ----------------------------
  INSERT INTO `employee` VALUES (1, 'jianghui', 'NAN', 'jianghui@tom.com');
  
  SET FOREIGN_KEY_CHECKS = 1;
  