/*
 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:14
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for aa_role_operation
-- ----------------------------
DROP TABLE IF EXISTS `aa_role_operation`;
CREATE TABLE `aa_role_operation`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '???id ????',
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '???',
  `url` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '??url',
  `pid` int(11) NOT NULL DEFAULT 0 COMMENT '????id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 51 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '???????--' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of aa_role_operation
-- ----------------------------
INSERT INTO `aa_role_operation` VALUES (1, '总览', 'overview', 0);
INSERT INTO `aa_role_operation` VALUES (2, '总用户数', NULL, 1);
INSERT INTO `aa_role_operation` VALUES (3, '今日新增用户数', NULL, 1);
INSERT INTO `aa_role_operation` VALUES (4, '昨日新增用户数', NULL, 1);
INSERT INTO `aa_role_operation` VALUES (5, '总订单数', NULL, 1);
INSERT INTO `aa_role_operation` VALUES (6, '今日订单数', NULL, 1);
INSERT INTO `aa_role_operation` VALUES (7, '昨日订单数', NULL, 1);
INSERT INTO `aa_role_operation` VALUES (8, '总订单金额', NULL, 1);
INSERT INTO `aa_role_operation` VALUES (9, '今日订单总金额', NULL, 1);
INSERT INTO `aa_role_operation` VALUES (10, '昨日订单总金额', NULL, 1);
INSERT INTO `aa_role_operation` VALUES (11, '数据分析展示', NULL, 1);
INSERT INTO `aa_role_operation` VALUES (12, '客户管理', 'customer', 0);
INSERT INTO `aa_role_operation` VALUES (13, '查看全部客户', NULL, 12);
INSERT INTO `aa_role_operation` VALUES (14, '查看我组客户', NULL, 12);
INSERT INTO `aa_role_operation` VALUES (15, '查看我的客户', NULL, 12);
INSERT INTO `aa_role_operation` VALUES (16, '查看未分组客户', NULL, 12);
INSERT INTO `aa_role_operation` VALUES (17, '新建用户', NULL, 12);
INSERT INTO `aa_role_operation` VALUES (18, '修改用户信息', NULL, 12);
INSERT INTO `aa_role_operation` VALUES (19, '查看用户订单', NULL, 12);
INSERT INTO `aa_role_operation` VALUES (20, '导出所有用户', NULL, 12);
INSERT INTO `aa_role_operation` VALUES (21, '导出选中用户', NULL, 12);
INSERT INTO `aa_role_operation` VALUES (22, '生成推广二维码', NULL, 12);
INSERT INTO `aa_role_operation` VALUES (23, '给选中的用户发送消息', NULL, 12);
INSERT INTO `aa_role_operation` VALUES (24, '给所有用户发送消息', NULL, 12);
INSERT INTO `aa_role_operation` VALUES (25, '订单管理', 'order', 0);
INSERT INTO `aa_role_operation` VALUES (26, '报表管理', NULL, 0);
INSERT INTO `aa_role_operation` VALUES (27, '查看公司业绩', NULL, 26);
INSERT INTO `aa_role_operation` VALUES (28, '查看我组业绩', NULL, 26);
INSERT INTO `aa_role_operation` VALUES (29, '查看个人业绩', NULL, 26);
INSERT INTO `aa_role_operation` VALUES (30, '数据分析', NULL, 26);
INSERT INTO `aa_role_operation` VALUES (31, '日期搜索', NULL, 30);
INSERT INTO `aa_role_operation` VALUES (32, '查看公司业绩', NULL, 30);
INSERT INTO `aa_role_operation` VALUES (33, '查看个人业绩', NULL, 30);
INSERT INTO `aa_role_operation` VALUES (34, '查看我组业绩', NULL, 30);
INSERT INTO `aa_role_operation` VALUES (35, '数据列表', NULL, 26);
INSERT INTO `aa_role_operation` VALUES (36, '日期搜索', NULL, 35);
INSERT INTO `aa_role_operation` VALUES (37, '查看客户总数', NULL, 35);
INSERT INTO `aa_role_operation` VALUES (38, '查看我组客户', NULL, 35);
INSERT INTO `aa_role_operation` VALUES (39, '查看我的客户', NULL, 35);
INSERT INTO `aa_role_operation` VALUES (40, '查看公司总订单', NULL, 35);
INSERT INTO `aa_role_operation` VALUES (41, '查看我组订单', NULL, 35);
INSERT INTO `aa_role_operation` VALUES (42, '查看我的订单', NULL, 35);
INSERT INTO `aa_role_operation` VALUES (43, '查看公司业绩', NULL, 35);
INSERT INTO `aa_role_operation` VALUES (44, '查看我组业绩', NULL, 35);
INSERT INTO `aa_role_operation` VALUES (45, '查看个人业绩', NULL, 35);
INSERT INTO `aa_role_operation` VALUES (46, '导出数据', NULL, 35);
INSERT INTO `aa_role_operation` VALUES (47, '员工账号', 'EmployeesList', 0);
INSERT INTO `aa_role_operation` VALUES (48, '消息管理', 'message', 0);
INSERT INTO `aa_role_operation` VALUES (49, '型号列表', 'model', 0);
INSERT INTO `aa_role_operation` VALUES (50, '供货商列表', 'ProductPrice', 0);

SET FOREIGN_KEY_CHECKS = 1;
