/*
 Navicat MySQL Data Transfer

 Source Server         : locahost
 Source Server Type    : MySQL
 Source Server Version : 50726
 Source Host           : 127.0.0.1:3306
 Source Schema         : anang-api

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

 Date: 11/10/2019 15:12:03
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for aa_employees_role
-- ----------------------------
DROP TABLE IF EXISTS `aa_employees_role`;
CREATE TABLE `aa_employees_role`  (
  `role_id` tinyint(3) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID?????',
  `role_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '????',
  `role_describe` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '????',
  PRIMARY KEY (`role_id`) USING BTREE,
  INDEX `role_name`(`role_name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '?????' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of aa_employees_role
-- ----------------------------
INSERT INTO `aa_employees_role` VALUES (2, '客服', '客服客服客服。');
INSERT INTO `aa_employees_role` VALUES (3, '业务', '业务业务赚钱吧');
INSERT INTO `aa_employees_role` VALUES (4, '供应商管理员', '供应商管理员');
INSERT INTO `aa_employees_role` VALUES (5, '管理员', '我是管理员我谁也不怕~~');
INSERT INTO `aa_employees_role` VALUES (6, '发货员', '专业发货5年');
INSERT INTO `aa_employees_role` VALUES (8, '业务队长', '业务部队长专用');
INSERT INTO `aa_employees_role` VALUES (9, '打单员', '打单员');
INSERT INTO `aa_employees_role` VALUES (10, '客服组长', '');
INSERT INTO `aa_employees_role` VALUES (11, '采购', '');
INSERT INTO `aa_employees_role` VALUES (12, '业务助理', '业务助理');
INSERT INTO `aa_employees_role` VALUES (13, '测试业务', '测试业务');

SET FOREIGN_KEY_CHECKS = 1;
