text: /*
  Navicat MySQL Data Transfer
  
  Source Server         : demo
  Source Server Version : 50540
  Source Host           : localhost:3306
  Source Database       : crm
  
  Target Server Type    : MYSQL
  Target Server Version : 50540
  File Encoding         : 65001
  
  Date: 2016-12-25 16:46:41
  */
  
  SET FOREIGN_KEY_CHECKS=0;
  
  -- ----------------------------
  -- Table structure for `t_employee`
  -- ----------------------------
  DROP TABLE IF EXISTS `t_employee`;
  CREATE TABLE `t_employee` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `username` varchar(50) NOT NULL,
    `realName` varchar(50) NOT NULL,
    `password` varchar(32) NOT NULL,
    `tel` varchar(20) NOT NULL,
    `email` varchar(30) DEFAULT NULL,
    `inputTime` datetime DEFAULT NULL,
    `state` tinyint(4) NOT NULL DEFAULT '0',
    `department_id` bigint(20) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of t_employee
  -- ----------------------------
  INSERT INTO `t_employee` VALUES ('1', 'admin', 'admin', 'admin', '111', null, null, '0', null);
  