/*

  Navicat Premium Data Transfer

  Source Server         : localhost_3306

  Source Server Type    : MySQL

  Source Server Version : 50717

  Source Host           : localhost:3306

  Source Schema         : clouddb01

  Target Server Type    : MySQL

  Target Server Version : 50717

  File Encoding         : 65001

  Date: 12/06/2018 13:31:53

 */

 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(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

   `db_source` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

   PRIMARY KEY (`deptno`) USING BTREE

 ) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

 -- ----------------------------

 -- Records of dept

 -- ----------------------------

 INSERT INTO `dept` VALUES (1, '开发部', DATABASE());

 INSERT INTO `dept` VALUES (2, '人事部', DATABASE());

 INSERT INTO `dept` VALUES (3, '财务部', DATABASE());

 INSERT INTO `dept` VALUES (4, '市场部', DATABASE());

 INSERT INTO `dept` VALUES (5, '运维部', DATABASE());

 SET FOREIGN_KEY_CHECKS = 1;