/*
 Navicat Premium Data Transfer

 Source Server         : root
 Source Server Type    : MySQL
 Source Server Version : 80016
 Source Host           : localhost:3306
 Source Schema         : hscrm

 Target Server Type    : MySQL
 Target Server Version : 80016
 File Encoding         : 65001

 Date: 13/09/2021 21:32:12
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for customer
-- ----------------------------
DROP TABLE IF EXISTS `customer`;
CREATE TABLE `customer`  (
  `c_id` int(11) NOT NULL AUTO_INCREMENT,
  `c_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `c_sex` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '男',
  `c_tel` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `c_job` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `c_company` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`c_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 36 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of customer
-- ----------------------------
INSERT INTO `customer` VALUES (28, '肖邦', '男', '123', '音乐家', '世界');
INSERT INTO `customer` VALUES (29, '比尔盖茨', '男', '10002etrer', '程序员', 'MicroSoft');
INSERT INTO `customer` VALUES (30, '图灵', '男', '101', '程序员', '世界');
INSERT INTO `customer` VALUES (31, '曼德拉', '男', '1001', '总统', '南非');
INSERT INTO `customer` VALUES (32, '李小龙', '男', '001', '武林家', '世界');
INSERT INTO `customer` VALUES (33, '乔布斯', '男', 'apple', '项目经理', '苹果');
INSERT INTO `customer` VALUES (34, 'MJ', '男', '2121', '流行', '音乐');
INSERT INTO `customer` VALUES (35, '肖邦', '男', '3', 'd', 'd');

-- ----------------------------
-- Table structure for emp
-- ----------------------------
DROP TABLE IF EXISTS `emp`;
CREATE TABLE `emp`  (
  `e_id` int(11) NOT NULL AUTO_INCREMENT,
  `e_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `e_sex` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '男',
  `e_tel` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `username` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `passwd` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`e_id`) USING BTREE,
  UNIQUE INDEX `username`(`username`) USING BTREE,
  UNIQUE INDEX `emp_e_id_uindex`(`e_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 52 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of emp
-- ----------------------------
INSERT INTO `emp` VALUES (44, '周杰伦', '男', '周杰伦', '周杰伦', '2af54305f183778d87de0c70c591fae4');
INSERT INTO `emp` VALUES (46, 'jay', '男', 'j', '完美主义', '8277e0910d750195b448797616e091ad');
INSERT INTO `emp` VALUES (47, 'admin', '男', '1', 'admin', 'c4ca4238a0b923820dcc509a6f75849b');
INSERT INTO `emp` VALUES (48, '乔布斯', '男', '10001', '乔布斯', '4365a226666ea7b8e2e0336a7d53c248');
INSERT INTO `emp` VALUES (49, 'admi', '男', 'admi', 'admidsds', '60eb0f73e33ce3ffd4e51d974447db53');
INSERT INTO `emp` VALUES (50, 'jj', '男', 'jj', 'jj', 'bf2bc2545a4a5f5683d9ef3ed0d977e0');
INSERT INTO `emp` VALUES (51, 'xf', '男', 'xf', 'adminxfr', 'f6440da9c764840fa7cac028c8c6118a');

-- ----------------------------
-- Table structure for track
-- ----------------------------
DROP TABLE IF EXISTS `track`;
CREATE TABLE `track`  (
  `t_id` int(11) NOT NULL AUTO_INCREMENT,
  `c_id` int(11) NOT NULL,
  `e_id` int(11) NOT NULL,
  `record` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `intention` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`t_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of track
-- ----------------------------
INSERT INTO `track` VALUES (13, 33, 44, '改变世界', '正在考虑');
INSERT INTO `track` VALUES (15, 29, 44, 'sss', '正在沟通');

SET FOREIGN_KEY_CHECKS = 1;