mallplus/小程序功能列表

/*
 Navicat MySQL Data Transfer

 Source Server         : local
 Source Server Type    : MySQL
 Source Server Version : 50721
 Source Host           : localhost
 Source Database       : mallplus

 Target Server Type    : MySQL
 Target Server Version : 50721
 File Encoding         : utf-8

 Date: 04/19/2019 18:31:35 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `sys_permission`
-- ----------------------------
DROP TABLE IF EXISTS `sys_permission`;
CREATE TABLE `sys_permission` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `pid` bigint(20) DEFAULT NULL COMMENT '父级权限id',
  `name` varchar(100) DEFAULT NULL COMMENT '名称',
  `value` varchar(200) DEFAULT NULL COMMENT '权限值',
  `icon` varchar(500) DEFAULT NULL COMMENT '图标',
  `type` int(1) DEFAULT NULL COMMENT '权限类型：0->目录；1->菜单；2->按钮（接口绑定权限）',
  `uri` varchar(200) DEFAULT NULL COMMENT '前端资源路径',
  `status` int(1) DEFAULT NULL COMMENT '启用状态；0->禁用；1->启用',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=112 DEFAULT CHARSET=utf8 COMMENT='后台用户权限表';

-- ----------------------------
--  Records of `sys_permission`
-- ----------------------------
BEGIN;
INSERT INTO `sys_permission` VALUES ('1', '0', '商品', null, null, '0', '/pms', '1', '2018-09-29 16:15:14', '1'), ('2', '1', '商品列表', 'pms:product:read', null, '1', 'product', '1', '2018-09-29 16:17:01', '0'), ('3', '1', '添加商品', 'pms:product:create', null, '1', 'addProduct', '1', '2018-09-29 16:18:51', '0'), ('4', '1', '商品分类', 'pms:productCategory:read', null, '1', 'productCate', '1', '2018-09-29 16:23:07', '0'), ('5', '1', '商品类型', 'pms:productAttribute:read', null, '1', 'productAttr', '1', '2018-09-29 16:24:43', '0'), ('6', '1', '品牌管理', 'pms:brand:read', null, '1', 'brand', '1', '2018-09-29 16:25:45', '0'), ('7', '2', '编辑商品', 'pms:product:update', null, '2', 'updateProduct', '1', '2018-09-29 16:34:23', '0'), ('8', '2', '商品回收站', 'pms:product:delete', null, '2', 'productRecycle', '1', '2018-09-29 16:38:33', '0'), ('9', '4', '添加商品分类', 'pms:productCategory:create', null, '2', 'addProductCate', '1', '2018-09-29 16:43:23', '0'), ('10', '4', '修改商品分类', 'pms:productCategory:update', null, '2', 'updateProductCate', '1', '2018-09-29 16:43:55', '0'), ('11', '4', '删除商品分类', 'pms:productCategory:delete', null, '2', '/pms/productAttr/delete', '1', '2018-09-29 16:44:38', '0'), ('12', '5', '添加商品类型', 'pms:productAttribute:create', null, '2', 'addProductAttr', '1', '2018-09-29 16:45:25', '0'), ('13', '5', '修改商品类型', 'pms:productAttribute:update', null, '2', 'updateProductAttr', '1', '2018-09-29 16:48:08', '0'), ('14', '5', '删除商品类型', 'pms:productAttribute:delete', null, '2', '/pms/productAttr/delete', '1', '2018-09-29 16:48:44', '0'), ('15', '6', '添加品牌', 'pms:brand:create', null, '2', 'addBrand', '1', '2018-09-29 16:49:34', '0'), ('16', '6', '修改品牌', 'pms:brand:update', null, '2', 'updateBrand', '1', '2018-09-29 16:50:55', '0'), ('17', '6', '删除品牌', 'pms:brand:delete', null, '2', '/pms/brand/delete', '1', '2018-09-29 16:50:59', '0'), ('18', '0', '首页', null, null, '0', '/home', '1', '2018-09-29 16:51:57', '0'), ('19', '0', '系统管理', null, null, '0', '/sys', '1', '2018-09-29 16:15:14', '5'), ('20', '19', '角色管理', 'sys:role:read', null, '1', 'role', '1', '2018-09-29 16:18:51', '1'), ('21', '19', '菜单管理', 'sys:menu:read', null, '1', 'permission', '1', '2018-09-29 16:23:07', '2'), ('22', '19', '用户管理', 'sys:admin:read', null, '1', 'admin', '1', '2018-09-29 16:17:01', '0'), ('23', '0', '订单管理', null, null, '0', '/oms', '1', '2018-09-29 16:15:14', '2'), ('24', '23', '发货列表', 'oms:deliverOrderList:read', null, '1', 'deliverOrderList', '1', '2018-09-29 16:18:51', '0'), ('25', '23', '订单设置', 'oms:orderSetting:read', null, '1', 'orderSetting', '1', '2018-09-29 16:23:07', '0'), ('26', '23', '订单详情', 'oms:orderDetail:read', null, '2', 'orderDetail', '1', '2018-09-29 16:23:07', '0'), ('27', '23', '退货申请处理', 'oms:returnApply:read', null, '1', 'returnApply', '1', '2018-09-29 16:23:07', '0'), ('28', '23', '退货原因设置', 'oms:returnReason:read', null, '1', 'returnReason', '1', '2018-09-29 16:23:07', '0'), ('29', '1', '退货原因详情', 'oms:returnApplyDetail:read', null, '2', 'returnApplyDetail', '23', '2018-09-29 16:23:07', '0'), ('30', '23', '订单列表', 'oms:order:read', null, '1', 'order', '1', '2018-09-29 16:17:01', '0'), ('31', '0', '营销管理', null, null, '0', '/sms', '1', '2018-09-29 16:15:14', '4'), ('32', '31', '秒杀活动列表', 'sms:flash:read', null, '1', 'flash', '1', '2018-09-29 16:17:01', '0'), ('36', '31', '优惠券列表', 'sms:coupon:read', null, '1', 'coupon', '1', '2018-09-29 16:31:07', '0'), ('37', '31', '优惠券领取详情', 'sms:couponHistory:read', null, '2', 'couponHistory', '1', '2018-09-29 16:31:07', '0'), ('38', '31', '品牌推荐', 'sms:homeBrand:read', null, '1', 'homeBrand', '31', '2018-09-29 16:31:07', '0'), ('39', '31', '新品推荐', 'sms:homeNew:read', null, '1', 'homeNew', '31', '2018-09-29 16:31:07', '0'), ('40', '31', '人气推荐', 'sms:homeHot:read', null, '1', 'homeHot', 
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;



## 参考资料

 私聊群主qq 951449465
----------------------------------------
 -可获得完整代码 包括所有后台和pc h5 和小程序
 -涵盖全部功能 有专属的vip群，随时答疑和更新