mkcloud-platform-backend/db/menu.sql

use
admin;
/*
 Navicat Premium Data Transfer

 Source Server         : 主机
 Source Server Type    : MySQL
 Source Server Version : 50726
 Source Host           : localhost:3306
 Source Schema         : admin

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

 Date: 11/10/2021 16:58:59
*/

SET NAMES utf8mb4;
SET
FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu`
(
    `menu_id`   bigint(20) NOT NULL AUTO_INCREMENT,
    `parent_id` bigint(20) NULL DEFAULT NULL COMMENT '父菜单ID，一级菜单为0',
    `name`      varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '菜单名称',
    `url`       varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '菜单URL',
    `perms`     varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '授权(多个用逗号分隔，如：user:list,user:create)',
    `type`      int(11) NULL DEFAULT NULL COMMENT '类型   0：目录   1：菜单   2：按钮',
    `icon`      varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '菜单图标',
    `order_num` int(11) NULL DEFAULT NULL COMMENT '排序',
    PRIMARY KEY (`menu_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 53 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '菜单管理' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
INSERT INTO `sys_menu`
VALUES (1, 0, '系统管理', NULL, NULL, 0, 'system', 0);
INSERT INTO `sys_menu`
VALUES (2, 1, '管理员列表', 'sys/user', NULL, 1, 'admin', 1);
INSERT INTO `sys_menu`
VALUES (3, 1, '角色管理', 'sys/role', NULL, 0, 'role', 2);
INSERT INTO `sys_menu`
VALUES (4, 1, '菜单管理', 'sys/menu', NULL, 1, 'menu', 3);
INSERT INTO `sys_menu`
VALUES (5, 1, 'SQL监控', 'http://localhost:8080/renren-fast/druid/sql.html', NULL, 1, 'sql', 4);
INSERT INTO `sys_menu`
VALUES (6, 1, '定时任务', 'job/schedule', NULL, 1, 'job', 5);
INSERT INTO `sys_menu`
VALUES (7, 6, '查看', NULL, 'sys:schedule:list,sys:schedule:info', 2, NULL, 0);
INSERT INTO `sys_menu`
VALUES (8, 6, '新增', NULL, 'sys:schedule:save', 2, NULL, 0);
INSERT INTO `sys_menu`
VALUES (9, 6, '修改', NULL, 'sys:schedule:update', 2, NULL, 0);
INSERT INTO `sys_menu`
VALUES (10, 6, '删除', NULL, 'sys:schedule:delete', 2, NULL, 0);
INSERT INTO `sys_menu`
VALUES (11, 6, '暂停', NULL, 'sys:schedule:pause', 2, NULL, 0);
INSERT INTO `sys_menu`
VALUES (12, 6, '恢复', NULL, 'sys:schedule:resume', 2, NULL, 0);
INSERT INTO `sys_menu`
VALUES (13, 6, '立即执行', NULL, 'sys:schedule:run', 2, NULL, 0);
INSERT INTO `sys_menu`
VALUES (14, 6, '日志列表', NULL, 'sys:schedule:log', 2, NULL, 0);
INSERT INTO `sys_menu`
VALUES (15, 2, '查看', NULL, 'sys:user:list,sys:user:info', 2, NULL, 0);
INSERT INTO `sys_menu`
VALUES (16, 2, '新增', NULL, 'sys:user:save,sys:role:select', 2, NULL, 0);
INSERT INTO `sys_menu`
VALUES (17, 2, '修改', NULL, 'sys:user:update,sys:role:select', 2, NULL, 0);
INSERT INTO `sys_menu`
VALUES (18, 2, '删除', NULL, 'sys:user:delete', 2, NULL, 0);
INSERT INTO `sys_menu`
VALUES (19, 3, '查看', NULL, 'sys:role:list,sys:role:info', 2, NULL, 0);
INSERT INTO `sys_menu`
VALUES (20, 3, '新增', NULL, 'sys:role:save,sys:menu:list', 2, NULL, 0);
INSERT INTO `sys_menu`
VALUES (21, 3, '修改', NULL, 'sys:role:update,sys:menu:list', 2, NULL, 0);
INSERT INTO `sys_menu`
VALUES (22, 3, '删除', NULL, 'sys:role:delete', 2, NULL, 0);
INSERT INTO `sys_menu`
VALUES (23, 4, '查看', NULL, 'sys:menu:list,sys:menu:info', 2, NULL, 0);
INSERT INTO `sys_menu`
VALUES (24, 4, '新增', NULL, 'sys:menu:save,sys:menu:select', 2, NULL, 0);
INSERT INTO `sys_menu`
VALUES (25, 4, '修改', NULL, 'sys:menu:update,sys:menu:select', 2, NULL, 0);
INSERT INTO `sys_menu`
VALUES (26, 4, '删除', NULL, 'sys:menu:delete', 2, NULL, 0);
INSERT INTO `sys_menu`
VALUES (27, 1, '参数管理', 'sys/config',
        'sys:config:list,sys:config:info,sys:config:save,sys:config:update,sys:config:delete', 1, 'config', 6);
INSERT INTO `sys_menu`
VALUES (29, 1, '系统日志', 'sys/log', 'sys:log:list', 1, 'log', 7);
INSERT INTO `sys_menu`
VALUES (30, 1, '文件上传', 'oss/oss', 'sys:oss:all', 1, 'oss', 6);
INSERT INTO `sys_menu`
VALUES (31, 1, '镜像管理', 'generator/images', NULL, 1, 'config', 6);
INSERT INTO `sys_menu`
VALUES (32, 31, '查看', NULL, 'generator:images:list,generator:images:info', 2, NULL, 6);
INSERT INTO `sys_menu`
VALUES (33, 31, '新增', NULL, 'generator:images:save', 2, NULL, 6);
INSERT INTO `sys_menu`
VALUES (34, 31, '修改', NULL, 'generator:images:update', 2, NULL, 6);
INSERT INTO `sys_menu`
VALUES (35, 31, '删除', NULL, 'generator:images:delete', 2, NULL, 6);
INSERT INTO `sys_menu`
VALUES (36, 1, '存储器管理', 'generator/volumes', NULL, 1, 'config', 6);
INSERT INTO `sys_menu`
VALUES (37, 36, '查看', NULL, 'generator:volumes:list,generator:volumes:info', 2, NULL, 6);
INSERT INTO `sys_menu`
VALUES (38, 36, '新增', NULL, 'generator:volumes:save', 2, NULL, 6);
INSERT INTO `sys_menu`
VALUES (39, 36, '修改', NULL, 'generator:volumes:update', 2, NULL, 6);
INSERT INTO `sys_menu`
VALUES (40, 36, '删除', NULL, 'generator:volumes:delete', 2, NULL, 6);
INSERT INTO `sys_menu`
VALUES (41, 1, '边缘节点管理', 'generator/edgenodes', NULL, 1, 'config', 6);
INSERT INTO `sys_menu`
VALUES (42, 41, '查看', NULL, 'generator:edgenodes:list,generator:edgenodes:info', 2, NULL, 6);
INSERT INTO `sys_menu`
VALUES (43, 41, '新增', NULL, 'generator:edgenodes:save', 2, NULL, 6);
INSERT INTO `sys_menu`
VALUES (44, 41, '修改', NULL, 'generator:edgenodes:update', 2, NULL, 6);
INSERT INTO `sys_menu`
VALUES (45, 41, '删除', NULL, 'generator:edgenodes:delete', 2, NULL, 6);
INSERT INTO `sys_menu`
VALUES (46, 1, '算法管理', 'generator/algorithm', '', 1, 'config', 6);
INSERT INTO `sys_menu`
VALUES (47, 46, '查看', NULL, 'generator:algorithm:list,generator:algorithm:info', 2, NULL, 6);
INSERT INTO `sys_menu`
VALUES (48, 46, '新增', NULL, 'generator:algorithm:save', 2, NULL, 6);
INSERT INTO `sys_menu`
VALUES (49, 46, '修改', NULL, 'generator:algorithm:update', 2, NULL, 6);
INSERT INTO `sys_menu`
VALUES (50, 46, '删除', NULL, 'generator:algorithm:delete', 2, NULL, 6);
INSERT INTO `sys_menu`
VALUES (51, 1, '应用管理', 'generator/applications', '', 1, 'tubiao', 8);
INSERT INTO `sys_menu`
VALUES (52, 0, '监控', 'monitor/index', '', 1, 'suanfa2', 7);

SET
FOREIGN_KEY_CHECKS = 1;