صفحهٔ اصلی گشت‌و‌گذار راهنما
ورود
lzz
/
yvjia
1
0
انشعاب 0
پرونده‌ها مشکلات 0 درخواست واکشی 0 ویکی
درخت: 848e800964
شاخه‌ها تگ‌ها
yvjia
/
db
/
sys_user_role_menu.sql

sys_user_role_menu.sql 8.0 KB
تاريخچه خام

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596 
  1. /**
    2. 

  2. Source Server Version: 8.0.31
    3. 

  3. Source Database: backendsys
    4. 

  4. Date: 2023-12-30 12:49:53
    5. 

  5. */
    6. 

  6. 

  7. DROP TABLE IF EXISTS `sys_user_role_menu`;
    8. 

  8. CREATE TABLE `sys_user_role_menu` (
    9. 

  9.     PRIMARY KEY (`id`),
    10. 

  10.     `id` BIGINT AUTO_INCREMENT COMMENT 'ID',
    11. 

  11.     `parent_id` BIGINT DEFAULT '-1' COMMENT '父ID',
    12. 

  12.     `menu_name` VARCHAR(255) NOT NULL COMMENT '标题',
    13. 

  13.     `menu_name_en` VARCHAR(255) NOT NULL COMMENT '标题 (英文)',
    14. 

  14.     `type` TINYINT(1) NOT NULL COMMENT '菜单类型 (1菜单, 2按钮)',
    15. 

  15.     `path` VARCHAR(1000) NOT NULL COMMENT '路由',
    16. 

  16.     `component` VARCHAR(255) COMMENT '组件路径',
    17. 

  17.     `meta` VARCHAR(255) NOT NULL DEFAULT '{}' COMMENT '路由元信息，以 JSON 格式存储',
    18. 

  18.     `icon` VARCHAR(255) COMMENT '图标',
    19. 

  19.     `permission_id` VARCHAR(255) COMMENT '权限',
    20. 

  20.     `sort` INT DEFAULT '1' COMMENT '排序',
    21. 

  21.     `status` TINYINT(1) DEFAULT '1' COMMENT '菜单状态 (-1禁用, 1启用)'
    22. 

  22. ) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='系统菜单表';
    23. 

  23. 

  24. INSERT INTO sys_user_role_menu(id, parent_id, menu_name, menu_name_en, type, path, component, meta, icon, permission_id, sort) VALUES
    25. 

  25.     (1, -1, '创意中心', 'Idea Center', 1, '/', '/src/views/home/ideaCenter.vue', '{}', 'House', '2', 999),
    26. 

  26. 

  27. #
    28. 

  28. #     (2, '订单管理', 'Orders', 1, '/b2c/order/b2cOrder', '/src/views/b2c/order/b2cOrder.vue', '{}', null, null, 4),
    29. 

  29. #     (2, '订单详情', 'Orders Detail', 2, '/b2c/order/b2cOrderDetail', '/src/views/b2c/order/b2cOrderDetail.vue', '{"isBack":true,"isHide":true}', null, null, 4),
    30. 

  30. 

  31.     (2, -1, 'AI助手', 'AI Chat', 1, '/ai/chat/chat', '/src/views/ai/chat.vue', '{}', 'Document', '31', 900),
    32. 

  32. 

  33.     (3, -1, 'AI图片生成器', 'AI Image', 1, '/ai/imagePicker', '', '{}', 'Picture', '35', 901),
    34. 

  34.     (4, 3, 'AI模特', 'AI Model', 1, '/ai/modelCloth/make', '', '{}', '', '', 902),
    35. 

  35.     (5, 3, 'AI商品图', 'AI Goods', 1, '/ai/generate/image/good', '', '{}', '', '', 903),
    36. 

  36. 

  37.     (6, -1, 'AI数字人', 'AI Person', 1, '/ai/ivh', '', '{}', 'MessageBox', '33', 904),
    38. 

  38.     (7, 6, '网红IP形象', 'Hot Figure', 1, '/ai/ivh', '', '{}', '', '', 905),
    39. 

  39.     (8, 6, '数字人定制', 'Customized Figure', 1, '/ai/ivh/virtualman/my/virtualman', '', '{}', '', '', 906),
    40. 

  40.     (9, 6, '声音复刻', 'Customized Voice', 1, '/ai/ivh/virtualman/my/virtualman?make_type=VOICE', '', '{}', '', '', 907),
    41. 

  41.     (10, 6, '音视频生成', 'Generate Video', 1, '/ai/ivh/broadcast/my/broadcast', '', '{}', '', '', 908),
    42. 

  42. 

  43.     (11, -1, 'AI成片', 'AI Video', 1, '/ai/generate/video/broadcast/my/broadcast', '', '{}', 'VideoCamera', '34', 909),
    44. 

  44. 

  45. 

  46. 

  47.     (20, -1, '素材管理', 'Material', 1, '/material', '', '{}', 'MessageBox', '20', 13),
    48. 

  48.     (21, 20, '素材中心', 'Material Center', 1, '/material/materialList', '/src/views/material/materialList.vue', '{}', null, '20.1', 13),
    49. 

  49.     (22, 20, '素材用户', 'Material User', 1, '/material/materialUserList', '/src/views/material/materialUserList.vue', '{}', null, '20.4', 12),
    50. 

  50. #     (21, 20, '素材列表', 'Material List', 1, '/material/materialList', '/src/views/material/materialList.vue', '{}', null, '20.1', 13),
    51. 

  51. #     (21, 20, '沙雕素材', 'Material Sa Diao', 1, '/material/materialList?lora_id=1', '/src/views/material/materialList.vue', '{}', null, '20.1', 13),
    52. 

  52. #     (22, 20, '简笔画素材', 'Material Simple', 1, '/material/materialList?lora_id=2', '/src/views/material/materialList.vue', '{}', null, '20.1', 13),
    53. 

  53. 

  54. #     (-1, '我的', 'Account', 1, '/account', '', '{}', 'User', '21', 11),
    55. 

  55. #     (8, '我的素材', 'My MaterialService', 1, '/account/myMaterial', '', '{}', null, '21.1', 11),
    56. 

  56. #     (8, '我的作品', 'My Work', 1, '/account/myWork', '', '{}', null, '21.2', 11),
    57. 

  57. #     (8, '我的草稿', 'My Draft', 1, '/account/myDraft', '', '{}', null, '21.3', 11),
    58. 

  58. 

  59.     (30, -1, '内容管理', 'CMS', 1, '/cms', '', '{}', 'Document', '10', 5),
    60. 

  60.     (31, 30, '导航管理', 'Navigation', 1, '/cms/navigation/cmsNavigation', '/src/views/cms/navigation/cmsNavigation.vue', '{}', null, '10.6', 20),
    61. 

  61.     (32, 30, '单页管理', 'Pages', 1, '/cms/page/cmsPage', '/src/views/cms/page/cmsPage.vue', '{}', null, '10.4', 19),
    62. 

  62.     (33, 30, '资讯管理', 'Articles', 1, '/cms/article/cmsArticle', '/src/views/cms/article/cmsArticle.vue', '{}', null, '10.3', 18),
    63. 

  63.     (34, 30, '资讯详情', 'Articles Detail', 2, '/cms/article/cmsArticleDetail', '/src/views/cms/article/cmsArticleDetail.vue', '{"isBack":true,"isHide":true}', null, '10.3.1', 17),
    64. 

  64.     (35, 30, '资讯分类管理', 'Articles Categories', 1, '/cms/article/cmsArticleCategory', '/src/views/cms/article/cmsArticleCategory.vue', '{}', null, '10.2', 16),
    65. 

  65.     (36, 30, '资讯分类详情', 'Articles Categorie Detail', 2, '/cms/article/cmsArticleCategoryDetail', '/src/views/cms/article/cmsArticleCategoryDetail.vue', '{"isBack":true,"isHide":true}', null, '10.2.1', 15),
    66. 

  66.     (37, 30, '幻灯片管理', 'Banners', 1, '/cms/banner/cmsBanner', '/src/views/cms/banner/cmsBanner.vue', '{}', null, '10.1', 14),
    67. 

  67.     (38, 30, '幻灯片详情', 'Banners Detail', 2, '/cms/banner/cmsBannerDetail', '/src/views/cms/banner/cmsBannerDetail.vue', '{"isBack":true,"isHide":true}', null, '10.1.1', 13),
    68. 

  68.     (39, 30, '站点信息', 'SiteInfo', 1, '/cms/site/cmsSiteInfo', '/src/views/cms/site/cmsSiteInfo.vue', '{}', null, '10.5', 12),
    69. 

  69. 

  70. 

  71.     (50, -1, '商城管理', 'B2c', 1, '/b2c/good', '', '{}', 'Goods', '11', 4),
    72. 

  72.     (51, 50, '商品管理', 'Goods', 1, '/b2c/good/b2cGood', '/src/views/b2c/good/b2cGood.vue', '{}', null, '11.1', 20),
    73. 

  73.     (52, 50, '商品详情', 'Goods Detail', 2, '/b2c/good/b2cGoodDetail', '/src/views/b2c/good/b2cGoodDetail.vue', '{"isBack":true,"isHide":true}', null, '11.1.1', 19),
    74. 

  74.     (53, 50, '商品分类', 'Goods Categories', 1, '/b2c/good/b2cGoodCategory', '/src/views/b2c/good/b2cGoodCategory.vue', '{}', null, '11.2', 18),
    75. 

  75.     (54, 50, '商品分类详情', 'Goods Categories Detail', 2, '/b2c/good/b2cGoodCategoryDetail', '/src/views/b2c/good/b2cGoodCategoryDetail.vue', '{"isBack":true,"isHide":true}', null, '11.2.1', 17),
    76. 

  76.     (55, 50, '商品品牌', 'Goods Brands', 1, '/b2c/good/b2cGoodBrand', '/src/views/b2c/good/b2cGoodBrand.vue', '{}', null, '11.3', 16),
    77. 

  77.     (56, 50, '商品品牌详情', 'Goods Brands Detail', 2, '/b2c/good/b2cGoodBrandDetail', '/src/views/b2c/good/b2cGoodBrandDetail.vue', '{"isBack":true,"isHide":true}', null, '11.3.1', 15),
    78. 

  78.     (57, 50, '商品单位', 'Goods Units', 1, '/b2c/good/b2cGoodUnit', '/src/views/b2c/good/b2cGoodUnit.vue', '{}', null, '11.4', 14),
    79. 

  79.     (58, 50, '商品单位详情', 'Goods Units Detail', 2, '/b2c/good/b2cGoodUnitDetail', '/src/views/b2c/good/b2cGoodUnitDetail.vue', '{"isBack":true,"isHide":true}', null, '11.4.1', 13),
    80. 

  80. 

  81.     (70, -1, 'AI工具', 'AI Tool', 1, '/aiTool', '', '{}', 'MagicStick', '37', 905),
    82. 

  82.     (71, 70, '图生视频', 'ImgToVideo', 1, '/aiTool/imgToVideo', '', '{}', null, '37.1', 905),
    83. 

  83. 

  84. 

  85.     (1000, -1, '系统管理', 'Systems', 1, '/system', '', '{}', 'Setting', '3', 12),
    86. 

  86.     (1001, 1000, '用户管理', 'Users', 1, '/system/sysUserList', '/src/views/system/sysUser/sysUserList.vue', '{}', null, '3.2', 12),
    87. 

  87.     (1002, 1000, '用户详情', 'Users Detail', 2, '/system/sysUserDetail', '/src/views/system/sysUser/sysUserDetail.vue', '{"isBack":true,"isHide":true}', null, '3.2.1', 12),
    88. 

  88.     (1003, 1000, '角色管理', 'Users Roles', 1, '/system/sysUserRole', '/src/views/system/sysUserRole/sysUserRoleList.vue', '{}', null, '4.1', 12),
    89. 

  89. 

  90.     (1004, 1000, '文件管理', 'File', 1, '/system/sysFileList', '/src/views/system/sysFile/sysFileList.vue', '{}', null, '1.1', 12),
    91. 

  91.     (1005, 1000, '配置管理', 'Common', 1, '/system/sysCommonList', '/src/views/system/sysCommon/sysCommonList.vue', '{}', null, '6.1', 12),
    92. 

  92. 

  93.     (1006, 1000, '角色详情', 'Users Role Detail', 2, '/system/sysUserRoleDetail', '/src/views/system/sysUserRole/sysUserRoleDetail.vue', '{"isBack":true,"isHide":true}', null, '4.1.1', 12),
    94. 

  94.     (1007, 1000, '菜单管理', 'Menus', 1, '/system/sysUserRoleMenu', '/src/views/system/sysUserRoleMenu/sysUserRoleMenuDetail.vue', '{}', null, '4.3', 12),
    95. 

  95.     (1008, 1000, '日志管理', 'Logs', 1, '/system/sysLogList', '/src/views/system/sysLog/sysLogList.vue', '{}', null, '5.1', 12)
    96. 

  96. ;
    97.