text: /*
   Navicat Premium Data Transfer
  
   Source Server         : 本地ASUS
   Source Server Type    : MySQL
   Source Server Version : 50727
   Source Host           : localhost:3306
   Source Schema         : db01
  
   Target Server Type    : MySQL
   Target Server Version : 50727
   File Encoding         : 65001
  
   Date: 08/04/2020 14:32:57
  */
  
  SET NAMES utf8mb4;
  SET FOREIGN_KEY_CHECKS = 0;
  
  -- ----------------------------
  -- Table structure for dept
  -- ----------------------------
  DROP TABLE IF EXISTS `dept`;
  CREATE TABLE `dept`  (
    `deptno` bigint(20) NOT NULL AUTO_INCREMENT,
    `dname` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `db_source` varchar(60) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`deptno`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '这是一个员工表' ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of dept
  -- ----------------------------
  INSERT INTO `dept` VALUES (1, '开发部', 'db01');
  INSERT INTO `dept` VALUES (2, '人事部', 'db01');
  INSERT INTO `dept` VALUES (3, '财务部', 'db01');
  INSERT INTO `dept` VALUES (4, '市场部', 'db01');
  INSERT INTO `dept` VALUES (5, '运维部', 'db01');
  
  SET FOREIGN_KEY_CHECKS = 1;
  