Domovská stránka Prehľadávať Pomoc
Prihlásiť sa
lzz
/
yvjia
1
0
Fork 0
Súbory Issues 0 Pull requesty 0 Wiki
Strom: 482aa52e21
Branche Tagy
yvjia
/
db
/
sys_user_role_menu.sql

sys_user_role_menu.sql 10 KB
História Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140 
  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.     `path` VARCHAR(1000) NOT NULL COMMENT '路由',
    15. 

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

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

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

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

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

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

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

  22. 

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

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

  25. 

  26. #     (-1, '商城管理', 'B2c', '/b2c/good', '', '{}', 'Goods', '11', 2),
    27. 

  27. #     (2, '商品管理', 'Goods', '/b2c/good/b2cGood', '/src/views/b2c/good/b2cGood.vue', '{}', null, '11.1', 3),
    28. 

  28. #     (2, '商品详情', 'Goods Detail', '/b2c/good/b2cGoodDetail', '/src/views/b2c/good/b2cGoodDetail.vue', '{"isBack":true,"isHide":true}', null, '11.1.1', 3),
    29. 

  29. #     (2, '商品分类', 'Goods Categories', '/b2c/good/b2cGoodCategory', '/src/views/b2c/good/b2cGoodCategory.vue', '{}', null, '11.2', 4),
    30. 

  30. #     (2, '商品分类详情', 'Goods Categories Detail', '/b2c/good/b2cGoodCategoryDetail', '/src/views/b2c/good/b2cGoodCategoryDetail.vue', '{"isBack":true,"isHide":true}', null, '11.2.1', 4),
    31. 

  31. #     (2, '商品品牌', 'Goods Brands', '/b2c/good/b2cGoodBrand', '/src/views/b2c/good/b2cGoodBrand.vue', '{}', null, '11.3', 5),
    32. 

  32. #     (2, '商品品牌详情', 'Goods Brands Detail', '/b2c/good/b2cGoodBrandDetail', '/src/views/b2c/good/b2cGoodBrandDetail.vue', '{"isBack":true,"isHide":true}', null, '11.3.1', 5),
    33. 

  33. #     (2, '商品单位', 'Goods Units', '/b2c/good/b2cGoodUnit', '/src/views/b2c/good/b2cGoodUnit.vue', '{}', null, '11.4', 6),
    34. 

  34. #     (2, '商品单位详情', 'Goods Units Detail', '/b2c/good/b2cGoodUnitDetail', '/src/views/b2c/good/b2cGoodUnitDetail.vue', '{"isBack":true,"isHide":true}', null, '11.4.1', 6),
    35. 

  35. #
    36. 

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

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

  38. #
    39. 

  39. #     (-1, '内容管理', 'CMS', '/cms', '', '{}', 'Document', '12', 5),
    40. 

  40. #     (13, '页面管理', 'Pages', '/cms/page/cmsPage', '/src/views/cms/page/cmsPage.vue', '{}', 'Document', '12.1', 5),
    41. 

  41. #
    42. 

  42. #     (13, '资讯管理', 'Articles', '/cms/article/cmsArticle', '/src/views/cms/article/cmsArticle.vue', '{}', null, '10.3', 6),
    43. 

  43. #     (13, '资讯详情', 'Articles Detail', '/cms/article/cmsArticleDetail', '/src/views/cms/article/cmsArticleDetail.vue', '{"isBack":true,"isHide":true}', null, '10.3.1', 6),
    44. 

  44. #     (13, '资讯分类管理', 'Articles Categories', '/cms/article/cmsArticleCategory', '/src/views/cms/article/cmsArticleCategory.vue', '{}', null, '10.2', 7),
    45. 

  45. #     (13, '资讯分类详情', 'Articles Categorie Detail', '/cms/article/cmsArticleCategoryDetail', '/src/views/cms/article/cmsArticleCategoryDetail.vue', '{"isBack":true,"isHide":true}', null, '10.2.1', 7),
    46. 

  46. #     (13, '幻灯片管理', 'Banners', '/cms/banner/cmsBanner', '/src/views/cms/banner/cmsBanner.vue', '{}', null, '10.1', 8),
    47. 

  47. #     (13, '幻灯片详情', 'Banners Detail', '/cms/banner/cmsBannerDetail', '/src/views/cms/banner/cmsBannerDetail.vue', '{"isBack":true,"isHide":true}', null, '10.1.1', 8),
    48. 

  48. 

  49. #     (13, '站点信息', 'SiteInfo', '/cms/site/cmsSiteInfo', '/src/views/cms/site/cmsSiteInfo.vue', '{}', null, '13', 9),
    50. 

  50. 

  51.     (2, -1, 'AI文案', 'AI Copywriting', '/ai/copywriting', '/src/views/ai/copywriting.vue', '{}', 'Document', '31', 10),
    52. 

  52.     (3, -1, 'AI作画', 'AI Image Generator', '/ai/imageGenerator', '/src/views/ai/imageGenerator.vue', '{}', 'Picture', '32', 10),
    53. 

  53. 

  54. #     (-1, '素材管理', 'Material', '/material', '', '{}', 'MessageBox', '20', 10),
    55. 

  55. #     (4, '素材中心', 'Material', '/material/center', '/src/views/material/materialCenter.vue', '{}', null, '20.3', 10),
    56. 

  56. #     (4, '素材列表', 'Material List', '/material/list', '/src/views/material/materialList.vue', '{}', null, '20.1', 10),
    57. 

  57. #     (4, '素材分类', 'Material Category', '/material/category', '/src/views/material/materialCategory.vue', '{}', null, '20.2', 10),
    58. 

  58. #
    59. 

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

  60. #     (8, '我的素材', 'My Material', '/account/myMaterial', '', '{}', null, '21.1', 11),
    61. 

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

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

  63. 

  64.     (12, -1, '系统管理', 'Systems', '/system', '', '{}', 'Setting', '3', 12),
    65. 

  65.     (13, 12, '用户管理', 'Users', '/system/sysUser', '/src/views/system/sysUser/sysUserList.vue', '{}', null, '3.2', 12),
    66. 

  66.     (14, 12, '用户详情', 'Users Detail', '/system/sysUserDetail', '/src/views/system/sysUser/sysUserDetail.vue', '{"isBack":true,"isHide":true}', null, '3.2.1', 12),
    67. 

  67.     (15, 12, '角色管理', 'Users Roles', '/system/sysUserRole', '/src/views/system/sysUserRole/sysUserRoleList.vue', '{}', null, '4.1', 12),
    68. 

  68.     (16, 12, '角色详情', 'Users Role Detail', '/system/sysUserRoleDetail', '/src/views/system/sysUserRole/sysUserRoleDetail.vue', '{"isBack":true,"isHide":true}', null, '4.1.1', 12),
    69. 

  69.     (17, 12, '系统权限', 'System Permission', '/system/sysPermission', '/src/views/system/sysMenu/sysPermission.vue', '{}', null, '3.4', 12),
    70. 

  70.     (18, 12, '系统菜单', 'System Menu', '/system/sysMenu', '/src/views/system/sysMenu/sysMenu.vue', '{}', null, '3.5', 12)
    71. 

  71. ;
    72. 

  72. 

  73. 

  74. 

  75. # /**
    76. 

  76. # Source Server Version: 8.0.31
    77. 

  77. # Source Database: backendsys
    78. 

  78. # Date: 2023-12-30 12:49:53
    79. 

  79. # */
    80. 

  80. #
    81. 

  81. # DROP TABLE IF EXISTS `sys_user_role_menu`;
    82. 

  82. # CREATE TABLE `sys_user_role_menu` (
    83. 

  83. #     PRIMARY KEY (`id`),
    84. 

  84. #     `id` BIGINT AUTO_INCREMENT COMMENT 'ID',
    85. 

  85. #     `parent_id` BIGINT DEFAULT '-1' COMMENT '父ID',
    86. 

  86. #     `menu_name` VARCHAR(255) NOT NULL COMMENT '标题',
    87. 

  87. #     `menu_name_en` VARCHAR(255) NOT NULL COMMENT '标题 (英文)',
    88. 

  88. #     `path` VARCHAR(1000) NOT NULL COMMENT '跳转路径',
    89. 

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

  90. #     `icon` VARCHAR(100) COMMENT '图标',
    91. 

  91. #     `sort` INT DEFAULT '1' COMMENT '排序',
    92. 

  92. #     `status` TINYINT(1) DEFAULT '1' COMMENT '菜单状态 (-1禁用, 1启用)'
    93. 

  93. # ) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='系统菜单表';
    94. 

  94. #
    95. 

  95. # INSERT INTO sys_user_role_menu(id, parent_id, menu_name, menu_name_en, path, meta, icon, sort) VALUES
    96. 

  96. #     (1, -1, '创意中心', 'Idea Center', '/', '{}', 'House', 1),
    97. 

  97. #
    98. 

  98. # #     (-1, '商城管理', 'B2c', '/b2c/good', '{}', 'Goods', 2),
    99. 

  99. # #     (2, '商品管理', 'Goods', '/b2c/good/b2cGood', '{}', null, 3),
    100. 

  100. # #     (2, '商品详情', 'Goods Detail', '/b2c/good/b2cGoodDetail', '{"isBack":true,"isHide":true}', null, 3),
    101. 

  101. # #     (2, '商品分类', 'Goods Categories', '/b2c/good/b2cGoodCategory', '{}', null, 4),
    102. 

  102. # #     (2, '商品分类详情', 'Goods Categories Detail', '/b2c/good/b2cGoodCategoryDetail', '{"isBack":true,"isHide":true}', null, 4),
    103. 

  103. # #     (2, '商品品牌', 'Goods Brands', '/b2c/good/b2cGoodBrand', '{}', null, 5),
    104. 

  104. # #     (2, '商品品牌详情', 'Goods Brands Detail', '/b2c/good/b2cGoodBrandDetail', '{"isBack":true,"isHide":true}', null, 5),
    105. 

  105. # #     (2, '商品单位', 'Goods Units', '/b2c/good/b2cGoodUnit', '{}', null, 6),
    106. 

  106. # #     (2, '商品单位详情', 'Goods Units Detail', '/b2c/good/b2cGoodUnitDetail', '{"isBack":true,"isHide":true}', null, 6),
    107. 

  107. # #
    108. 

  108. # #     (2, '订单管理', 'Orders', '/b2c/order/b2cOrder', '{}', null, 4),
    109. 

  109. # #     (2, '订单详情', 'Orders Detail', '/b2c/order/b2cOrderDetail', '{"isBack":true,"isHide":true}', null, 4),
    110. 

  110. # #
    111. 

  111. # #     (-1, '内容管理', 'CMS', '/cms', '', '{}', 'Document', '12', 5),
    112. 

  112. # #     (13, '页面管理', 'Pages', '/cms/page/cmsPage', '{}', 'Document', 5),
    113. 

  113. # #
    114. 

  114. # #     (13, '资讯管理', 'Articles', '/cms/article/cmsArticle', '{}', null, 6),
    115. 

  115. # #     (13, '资讯详情', 'Articles Detail', '/cms/article/cmsArticleDetail', '{"isBack":true,"isHide":true}', null, 6),
    116. 

  116. # #     (13, '资讯分类管理', 'Articles Categories', '/cms/article/cmsArticleCategory', '{}', null, 7),
    117. 

  117. # #     (13, '资讯分类详情', 'Articles Categorie Detail', '/cms/article/cmsArticleCategoryDetail', '{"isBack":true,"isHide":true}', null, 7),
    118. 

  118. # #     (13, '幻灯片管理', 'Banners', '/cms/banner/cmsBanner', '{}', null, 8),
    119. 

  119. # #     (13, '幻灯片详情', 'Banners Detail', '/cms/banner/cmsBannerDetail', '{"isBack":true,"isHide":true}', null, 8),
    120. 

  120. #
    121. 

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

  122. #
    123. 

  123. #     (2, -1, 'AI文案', 'AI Copywriting', '/ai/chat/copywriting', '{}', 'Document', 10),
    124. 

  124. #     (3, -1, 'AI作画', 'AI Image Generator', '/ai/imageGenerator', '{}', 'Picture', 10),
    125. 

  125. #
    126. 

  126. # #     (-1, '素材管理', 'Material', '/material', '{}', 'MessageBox', 10),
    127. 

  127. # #     (4, '素材中心', 'Material', '/material/center', '{}', null, 10),
    128. 

  128. # #     (4, '素材列表', 'Material List', '/material/list', '{}', null, 10),
    129. 

  129. # #     (4, '素材分类', 'Material Category', '/material/category', '{}', null, 10),
    130. 

  130. #
    131. 

  131. # #     (-1, '我的', 'Account', '/account', '{}', 'User', 11),
    132. 

  132. # #     (8, '我的素材', 'My Material', '/account/myMaterial', '{}', null, 11),
    133. 

  133. # #     (8, '我的作品', 'My Work', '/account/myWork', '{}', null, 11),
    134. 

  134. # #     (8, '我的草稿', 'My Draft', '/account/myDraft', '{}', null, 11),
    135. 

  135. #
    136. 

  136. #     (12, -1, '系统管理', 'Systems', '/system', '{}', 'Setting', 12),
    137. 

  137. #     (13, 12, '用户管理', 'Users', '/system/sysUser', '{}', null, 12),
    138. 

  138. #     (14, 12, '角色管理', 'Users Roles', '/system/sysUserRole', '{}', null, 12),
    139. 

  139. #     (15, 12, '系统菜单', 'System Menu', '/system/sysMenu', '{}', null, 12)
    140. 

  140. # ;
    141.