yvjia/db/sys_user_role_menu.sql

/**
Source Server Version: 8.0.31
Source Database: backendsys
Date: 2023-12-30 12:49:53
*/

DROP TABLE IF EXISTS `sys_user_role_menu`;
CREATE TABLE `sys_user_role_menu` (
    PRIMARY KEY (`id`),
    `id` BIGINT AUTO_INCREMENT COMMENT 'ID',
    `parent_id` BIGINT DEFAULT '-1' COMMENT '父ID',
    `menu_name` VARCHAR(255) NOT NULL COMMENT '标题',
    `menu_name_en` VARCHAR(255) NOT NULL COMMENT '标题 (英文)',
    `path` VARCHAR(1000) NOT NULL COMMENT '跳转路径',
    `meta` VARCHAR(255) NOT NULL DEFAULT '{}' COMMENT '路由元信息，以 JSON 格式存储',
    `icon` VARCHAR(100) COMMENT '图标',
    `sort` INT DEFAULT '1' COMMENT '排序',
    `status` TINYINT(1) DEFAULT '1' COMMENT '菜单状态 (-1禁用, 1启用)'
) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='系统菜单表';

INSERT INTO sys_user_role_menu(id, parent_id, menu_name, menu_name_en, path, meta, icon, sort) VALUES
    (1, -1, '创意中心', 'Idea Center', '/', '{}', 'House', 1),

#     (-1, '商城管理', 'B2c', '/b2c/good', '{}', 'Goods', 2),
#     (2, '商品管理', 'Goods', '/b2c/good/b2cGood', '{}', null, 3),
#     (2, '商品详情', 'Goods Detail', '/b2c/good/b2cGoodDetail', '{"isBack":true,"isHide":true}', null, 3),
#     (2, '商品分类', 'Goods Categories', '/b2c/good/b2cGoodCategory', '{}', null, 4),
#     (2, '商品分类详情', 'Goods Categories Detail', '/b2c/good/b2cGoodCategoryDetail', '{"isBack":true,"isHide":true}', null, 4),
#     (2, '商品品牌', 'Goods Brands', '/b2c/good/b2cGoodBrand', '{}', null, 5),
#     (2, '商品品牌详情', 'Goods Brands Detail', '/b2c/good/b2cGoodBrandDetail', '{"isBack":true,"isHide":true}', null, 5),
#     (2, '商品单位', 'Goods Units', '/b2c/good/b2cGoodUnit', '{}', null, 6),
#     (2, '商品单位详情', 'Goods Units Detail', '/b2c/good/b2cGoodUnitDetail', '{"isBack":true,"isHide":true}', null, 6),
#
#     (2, '订单管理', 'Orders', '/b2c/order/b2cOrder', '{}', null, 4),
#     (2, '订单详情', 'Orders Detail', '/b2c/order/b2cOrderDetail', '{"isBack":true,"isHide":true}', null, 4),
#
#     (-1, '内容管理', 'CMS', '/cms', '', '{}', 'Document', '12', 5),
#     (13, '页面管理', 'Pages', '/cms/page/cmsPage', '{}', 'Document', 5),
#
#     (13, '资讯管理', 'Articles', '/cms/article/cmsArticle', '{}', null, 6),
#     (13, '资讯详情', 'Articles Detail', '/cms/article/cmsArticleDetail', '{"isBack":true,"isHide":true}', null, 6),
#     (13, '资讯分类管理', 'Articles Categories', '/cms/article/cmsArticleCategory', '{}', null, 7),
#     (13, '资讯分类详情', 'Articles Categorie Detail', '/cms/article/cmsArticleCategoryDetail', '{"isBack":true,"isHide":true}', null, 7),
#     (13, '幻灯片管理', 'Banners', '/cms/banner/cmsBanner', '{}', null, 8),
#     (13, '幻灯片详情', 'Banners Detail', '/cms/banner/cmsBannerDetail', '{"isBack":true,"isHide":true}', null, 8),

#     (13, '站点信息', 'SiteInfo', '/cms/site/cmsSiteInfo', '{}', null, 9),

    (2, -1, 'AI文案', 'AI Copywriting', '/ai/chat/copywriting', '{}', 'Document', 10),
    (3, -1, 'AI作画', 'AI Image Generator', '/ai/imageGenerator', '{}', 'Picture', 10),

#     (-1, '素材管理', 'Material', '/material', '{}', 'MessageBox', 10),
#     (4, '素材中心', 'Material', '/material/center', '{}', null, 10),
#     (4, '素材列表', 'Material List', '/material/list', '{}', null, 10),
#     (4, '素材分类', 'Material Category', '/material/category', '{}', null, 10),

#     (-1, '我的', 'Account', '/account', '{}', 'User', 11),
#     (8, '我的素材', 'My Material', '/account/myMaterial', '{}', null, 11),
#     (8, '我的作品', 'My Work', '/account/myWork', '{}', null, 11),
#     (8, '我的草稿', 'My Draft', '/account/myDraft', '{}', null, 11),

    (12, -1, '系统管理', 'Systems', '/system', '{}', 'Setting', 12),
    (13, 12, '用户管理', 'Users', '/system/sysUser', '{}', null, 12),
    (14, 12, '角色管理', 'Users Roles', '/system/sysUserRole', '{}', null, 12),
    (15, 12, '系统菜单', 'System Menu', '/system/sysMenu', '{}', null, 12)
;