/** 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 '标题 (英文)', `type` TINYINT(1) NOT NULL COMMENT '菜单类型 (1菜单, 2按钮)', `path` VARCHAR(1000) NOT NULL COMMENT '路由', `component` VARCHAR(255) COMMENT '组件路径', `meta` VARCHAR(255) NOT NULL DEFAULT '{}' COMMENT '路由元信息，以 JSON 格式存储', `icon` VARCHAR(255) COMMENT '图标', `permission_id` VARCHAR(255) 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, type, path, component, meta, icon, permission_id, sort) VALUES (1, -1, '创意中心', 'Idea Center', 1, '/', '/src/views/home/ideaCenter.vue', '{}', 'House', '2', 999), # (-1, '商城管理', 'B2c', 1, '/b2c/good', '', '{}', 'Goods', '11', 2), # (2, '商品管理', 'Goods', 1, '/b2c/good/b2cGood', '/src/views/b2c/good/b2cGood.vue', '{}', null, '11.1', 3), # (2, '商品详情', 'Goods Detail', 2, '/b2c/good/b2cGoodDetail', '/src/views/b2c/good/b2cGoodDetail.vue', '{"isBack":true,"isHide":true}', null, '11.1.1', 3), # (2, '商品分类', 'Goods Categories', 1, '/b2c/good/b2cGoodCategory', '/src/views/b2c/good/b2cGoodCategory.vue', '{}', null, '11.2', 4), # (2, '商品分类详情', 'Goods Categories Detail', 2, '/b2c/good/b2cGoodCategoryDetail', '/src/views/b2c/good/b2cGoodCategoryDetail.vue', '{"isBack":true,"isHide":true}', null, '11.2.1', 4), # (2, '商品品牌', 'Goods Brands', 1, '/b2c/good/b2cGoodBrand', '/src/views/b2c/good/b2cGoodBrand.vue', '{}', null, '11.3', 5), # (2, '商品品牌详情', 'Goods Brands Detail', 2, '/b2c/good/b2cGoodBrandDetail', '/src/views/b2c/good/b2cGoodBrandDetail.vue', '{"isBack":true,"isHide":true}', null, '11.3.1', 5), # (2, '商品单位', 'Goods Units', 1, '/b2c/good/b2cGoodUnit', '/src/views/b2c/good/b2cGoodUnit.vue', '{}', null, '11.4', 6), # (2, '商品单位详情', 'Goods Units Detail', 2, '/b2c/good/b2cGoodUnitDetail', '/src/views/b2c/good/b2cGoodUnitDetail.vue', '{"isBack":true,"isHide":true}', null, '11.4.1', 6), # # (2, '订单管理', 'Orders', 1, '/b2c/order/b2cOrder', '/src/views/b2c/order/b2cOrder.vue', '{}', null, null, 4), # (2, '订单详情', 'Orders Detail', 2, '/b2c/order/b2cOrderDetail', '/src/views/b2c/order/b2cOrderDetail.vue', '{"isBack":true,"isHide":true}', null, null, 4), (2, -1, 'AI文案', 'AI Copywriting', 1, '/ai/chat/copywriting', '/src/views/ai/copywriting.vue', '{}', 'Document', '31', 900), (3, -1, 'AI图片生成器', 'AI Image', 1, '/ai/imagePicker', '', '{}', 'Picture', '35', 901), (4, 3, 'AI模特', 'AI Model', 1, '/ai/modelCloth/make', '', '{}', '', '', 902), (5, 3, 'AI商品图', 'AI Goods', 1, '/ai/generate/image/good', '', '{}', '', '', 903), (6, -1, 'AI数字人', 'AI Person', 1, '/ai/ivh', '', '{}', 'MessageBox', '33', 904), (7, 6, '网红IP形象', 'Hot Figure', 1, '/ai/ivh', '', '{}', '', '', 905), (8, 6, '数字人定制', 'Customized Figure', 1, '/ai/ivh/virtualman/my/virtualman', '', '{}', '', '', 906), (9, 6, '声音复刻', 'Customized Voice', 1, '/ai/ivh/virtualman/my/virtualman?make_type=VOICE', '', '{}', '', '', 907), (10, 6, '音视频生成', 'Generate Video', 1, '/ai/ivh/broadcast/my/broadcast', '', '{}', '', '', 908), (11, -1, 'AI成片', 'AI Video', 1, '/ai/generate/video/broadcast/my/broadcast', '', '{}', 'VideoCamera', '34', 909), # (-1, '素材管理', 'Material', 1, '/material', '', '{}', 'MessageBox', '20', 10), # (4, '素材中心', 'Material', 1, '/material/center', '/src/views/material/materialCenter.vue', '{}', null, '20.3', 10), # (4, '素材列表', 'Material List', 1, '/material/list', '/src/views/material/materialList.vue', '{}', null, '20.1', 10), # (4, '素材分类', 'Material Category', 1, '/material/category', '/src/views/material/materialCategory.vue', '{}', null, '20.2', 10), # # (-1, '我的', 'Account', 1, '/account', '', '{}', 'User', '21', 11), # (8, '我的素材', 'My Material', 1, '/account/myMaterial', '', '{}', null, '21.1', 11), # (8, '我的作品', 'My Work', 1, '/account/myWork', '', '{}', null, '21.2', 11), # (8, '我的草稿', 'My Draft', 1, '/account/myDraft', '', '{}', null, '21.3', 11), (30, -1, '内容管理', 'CMS', 1, '/cms', '', '{}', 'Document', '13', 5), (31, 30, '页面管理', 'Pages', 1, '/cms/page/cmsPage', '/src/views/cms/page/cmsPage.vue', '{}', 'Document', '13.1', 5), (32, 30, '资讯管理', 'Articles', 1, '/cms/article/cmsArticle', '/src/views/cms/article/cmsArticle.vue', '{}', null, '10.3', 6), (33, 30, '资讯详情', 'Articles Detail', 2, '/cms/article/cmsArticleDetail', '/src/views/cms/article/cmsArticleDetail.vue', '{"isBack":true,"isHide":true}', null, '10.3.1', 6), (34, 30, '资讯分类管理', 'Articles Categories', 1, '/cms/article/cmsArticleCategory', '/src/views/cms/article/cmsArticleCategory.vue', '{}', null, '10.2', 7), (35, 30, '资讯分类详情', 'Articles Categorie Detail', 2, '/cms/article/cmsArticleCategoryDetail', '/src/views/cms/article/cmsArticleCategoryDetail.vue', '{"isBack":true,"isHide":true}', null, '10.2.1', 7), (36, 30, '幻灯片管理', 'Banners', 1, '/cms/banner/cmsBanner', '/src/views/cms/banner/cmsBanner.vue', '{}', null, '10.1', 8), (37, 30, '幻灯片详情', 'Banners Detail', 2, '/cms/banner/cmsBannerDetail', '/src/views/cms/banner/cmsBannerDetail.vue', '{"isBack":true,"isHide":true}', null, '10.1.1', 8), (38, 30, '站点信息', 'SiteInfo', 1, '/cms/site/cmsSiteInfo', '/src/views/cms/site/cmsSiteInfo.vue', '{}', null, '13', 9), (12, -1, '系统管理', 'Systems', 1, '/system', '', '{}', 'Setting', '3', 12), (13, 12, '用户管理', 'Users', 1, '/system/sysUserList', '/src/views/system/sysUser/sysUserList.vue', '{}', null, '3.2', 12), (14, 12, '用户详情', 'Users Detail', 2, '/system/sysUserDetail', '/src/views/system/sysUser/sysUserDetail.vue', '{"isBack":true,"isHide":true}', null, '3.2.1', 12), (15, 12, '角色管理', 'Users Roles', 1, '/system/sysUserRole', '/src/views/system/sysUserRole/sysUserRoleList.vue', '{}', null, '4.1', 12), (16, 12, '配置管理', 'Common', 1, '/system/sysCommonList', '/src/views/system/sysCommon/sysCommonList.vue', '{}', null, '6.1', 12), (17, 12, '角色详情', 'Users Role Detail', 2, '/system/sysUserRoleDetail', '/src/views/system/sysUserRole/sysUserRoleDetail.vue', '{"isBack":true,"isHide":true}', null, '4.1.1', 12), (18, 12, '菜单管理', 'Menus', 1, '/system/sysUserRoleMenu', '/src/views/system/sysUserRoleMenu/sysUserRoleMenuDetail.vue', '{}', null, '4.3', 12), (19, 12, '日志管理', 'Logs', 1, '/system/sysLogList', '/src/views/system/sysLog/sysLogList.vue', '{}', null, '5.1', 12) ; # /** # 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) # ;