Accueil Explorer Aide
S'inscrire Connexion
Epans
/
calf-feed-pc
1
0
Fork 0
Fichiers Tickets 0 Pull Requests 0 Wiki
Branche: develop
Branches Tags
calf-feed-pc
/
系统导航Sql备份
/
system_menu.sql

system_menu.sql 11 KB
Lien permanent Historique Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101 
  1. /*
    2. 

  2.  Navicat MySQL Data Transfer
    3. 

  3. 

  4.  Source Server         : 192.168.1.70
    5. 

  5.  Source Server Type    : MySQL
    6. 

  6.  Source Server Version : 50736 (5.7.36)
    7. 

  7.  Source Host           : 192.168.1.70:3306
    8. 

  8.  Source Schema         : calf_feed
    9. 

  9. 

  10.  Target Server Type    : MySQL
    11. 

  11.  Target Server Version : 50736 (5.7.36)
    12. 

  12.  File Encoding         : 65001
    13. 

  13. 

  14.  Date: 18/10/2023 13:45:49
    15. 

  15. */
    16. 

  16. 

  17. SET NAMES utf8mb4;
    18. 

  18. SET FOREIGN_KEY_CHECKS = 0;
    19. 

  19. 

  20. -- ----------------------------
    21. 

  21. -- Table structure for system_menu
    22. 

  22. -- ----------------------------
    23. 

  23. DROP TABLE IF EXISTS `system_menu`;
    24. 

  24. CREATE TABLE `system_menu`  (
    25. 

  25.   `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id',
    26. 

  26.   `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '菜单名称',
    27. 

  27.   `menu_type` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '菜单类型 0 无效 1 菜单 2 按钮',
    28. 

  28.   `level` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '菜单等级 1 一级 2 二级 3 三级',
    29. 

  29.   `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '标题',
    30. 

  30.   `path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '路径',
    31. 

  31.   `component` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '组件',
    32. 

  32.   `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '图标',
    33. 

  33.   `sort` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序',
    34. 

  34.   `redirect` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '重定向',
    35. 

  35.   `parent_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '父id',
    36. 

  36.   `is_show` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否启用 0 无效 1 启动 2 关闭',
    37. 

  37.   `is_delete` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否删除 0 无效 1 未删除 2 已删除',
    38. 

  38.   `created_at` bigint(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',
    39. 

  39.   `updated_at` bigint(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新时间',
    40. 

  40.   PRIMARY KEY (`id`) USING BTREE,
    41. 

  41.   INDEX `idx_name`(`name`) USING BTREE,
    42. 

  42.   INDEX `idx_parent_id`(`parent_id`) USING BTREE
    43. 

  43. ) ENGINE = InnoDB AUTO_INCREMENT = 141 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统菜单表' ROW_FORMAT = Dynamic;
    44. 

  44. 

  45. -- ----------------------------
    46. 

  46. -- Records of system_menu
    47. 

  47. -- ----------------------------
    48. 

  48. INSERT INTO `system_menu` VALUES (87, '数据统计', 1, 1, '数据统计', 'process:time', 'Layout', 'iconfont el-icon-s-ORDER', 7, '', 0, 1, 1, 1692689011, 1692689011);
    49. 

  49. INSERT INTO `system_menu` VALUES (88, '牛只管理', 1, 1, '牛只管理', 'calf:management ', 'Layout', 'iconfont el-icon-s-ORDER', 6, '', 0, 1, 1, 1692689011, 1692689011);
    50. 

  50. INSERT INTO `system_menu` VALUES (89, '栏舍管理', 1, 1, '栏舍管理', 'barn:management', 'Layout', 'iconfont el-icon-s-ORDER', 5, '', 0, 1, 1, 1692689011, 1692689011);
    51. 

  51. INSERT INTO `system_menu` VALUES (90, '配方计划', 1, 1, '配方计划', 'feed:plan', 'Layout', 'iconfont el-icon-s-ORDER', 4, '', 0, 1, 1, 1692689011, 1692689011);
    52. 

  52. INSERT INTO `system_menu` VALUES (91, '工单管理', 1, 1, '工单管理', 'work:order', 'Layout', 'iconfont el-icon-s-ORDER', 3, '', 0, 1, 1, 1692689011, 1692689011);
    53. 

  53. INSERT INTO `system_menu` VALUES (92, '基础设置', 1, 1, '基础设置', 'base:setting', 'Layout', 'iconfont el-icon-s-ORDER', 2, '', 0, 1, 1, 1692689011, 1692689011);
    54. 

  54. INSERT INTO `system_menu` VALUES (93, '系统设置', 1, 1, '系统设置', 'system:setting', 'Layout', 'iconfont el-icon-s-ORDER', 1, '', 0, 1, 1, 1692689011, 1692689011);
    55. 

  55. INSERT INTO `system_menu` VALUES (95, '饲喂过程', 1, 2, '饲喂过程', 'FeedProcess', '', 'iconfont el-icon-s-ORDER', 1, '', 87, 1, 1, 1683707629, 1684290645);
    56. 

  56. INSERT INTO `system_menu` VALUES (96, '牛只信息', 1, 2, '牛只信息', 'CowInfo', '', 'iconfont el-icon-s-ORDER', 1, '', 88, 1, 1, 1683707629, 1684290645);
    57. 

  57. INSERT INTO `system_menu` VALUES (97, '事件记录', 1, 2, '事件记录', 'EventRecord', 'systemManagement/eventInfo/index', 'iconfont el-icon-s-ORDER', 1, '', 88, 1, 1, 1683707629, 1684290645);
    58. 

  58. INSERT INTO `system_menu` VALUES (98, '牛只栏舍', 1, 2, '牛只栏舍', 'CowCowShed', 'systemManagement/calfBarn/index', 'iconfont el-icon-s-ORDER', 1, '', 89, 1, 1, 1683707629, 1684290645);
    59. 

  59. INSERT INTO `system_menu` VALUES (99, '栏舍分组', 1, 2, '栏舍分组', 'CowShedGroup', 'systemManagement/calfBarnGroup/index', 'iconfont el-icon-s-ORDER', 1, '', 89, 1, 1, 1683707629, 1684290645);
    60. 

  60. INSERT INTO `system_menu` VALUES (100, '饲喂计划', 1, 2, '饲喂计划', 'FeedPlan', 'systemManagement/feedPlan/index', 'iconfont el-icon-s-ORDER', 1, '', 90, 1, 1, 1683707629, 1684290645);
    61. 

  61. INSERT INTO `system_menu` VALUES (101, '配方模板', 1, 2, '配方模板', 'FormulaTemplate', 'systemManagement/forageInfo/index', 'iconfont el-icon-s-ORDER', 1, '', 90, 1, 1, 1683707629, 1684290645);
    62. 

  62. INSERT INTO `system_menu` VALUES (102, '犊牛类型', 1, 2, '犊牛类型', 'CalfType', 'systemManagement/calfInfo/index', 'iconfont el-icon-s-ORDER', 1, '', 92, 1, 1, 1683707629, 1684290645);
    63. 

  63. INSERT INTO `system_menu` VALUES (103, '饲喂车管理', 1, 2, '饲喂车管理', 'FeedCarManagement', 'systemManagement/feedVehicle/index', 'iconfont el-icon-s-ORDER', 1, '', 92, 1, 1, 1683707629, 1684290645);
    64. 

  64. INSERT INTO `system_menu` VALUES (104, '预设饲喂模板', 1, 2, '预设饲喂模板', 'FeedTemplate', 'systemManagement/feedVehicle/index', 'iconfont el-icon-s-ORDER', 1, '', 92, 1, 1, 1683707629, 1684290645);
    65. 

  65. INSERT INTO `system_menu` VALUES (105, '默认标准参数', 1, 2, '默认标准参数', 'DefaultPara', 'systemManagement/feedVehicle/index', 'iconfont el-icon-s-ORDER', 1, '', 92, 1, 1, 1683707629, 1684290645);
    66. 

  66. INSERT INTO `system_menu` VALUES (106, '饲料成本设置', 1, 2, '饲料成本设置', 'FeedCostSet', 'systemManagement/feedVehicle/index', 'iconfont el-icon-s-ORDER', 1, '', 92, 1, 1, 1683707629, 1684290645);
    67. 

  67. INSERT INTO `system_menu` VALUES (107, '角色管理', 1, 2, '角色管理', 'Role', 'systemManagement/role/index', 'iconfont el-icon-s-ORDER', 1, '', 93, 1, 1, 1683707629, 1684290645);
    68. 

  68. INSERT INTO `system_menu` VALUES (108, '用户管理', 1, 2, '用户管理', 'User', 'user/feedVehicle/index', 'iconfont el-icon-s-ORDER', 1, '', 93, 1, 1, 1683707629, 1684290645);
    69. 

  69. INSERT INTO `system_menu` VALUES (109, '牛只信息编辑', 2, 3, '牛只信息编辑', '', 'console/menu/show/index', 'iconfont el-icon-s-ORDER', 1, '', 96, 1, 1, 1683707629, 1685417159);
    70. 

  70. INSERT INTO `system_menu` VALUES (110, '事件记录编辑', 2, 3, '事件记录编辑', '', 'console/menu/show/index', 'iconfont el-icon-s-ORDER', 1, '', 97, 1, 1, 1683707629, 1685417159);
    71. 

  71. INSERT INTO `system_menu` VALUES (111, '牛只栏舍编辑', 2, 3, '牛只栏舍编辑', '', 'console/menu/show/index', 'iconfont el-icon-s-ORDER', 1, '', 98, 1, 1, 1683707629, 1685417159);
    72. 

  72. INSERT INTO `system_menu` VALUES (112, '栏舍分组编辑', 2, 3, '栏舍分组编辑', '', 'console/menu/show/index', 'iconfont el-icon-s-ORDER', 1, '', 99, 1, 1, 1683707629, 1685417159);
    73. 

  73. INSERT INTO `system_menu` VALUES (113, '饲喂计划编辑', 2, 3, '饲喂计划编辑', '', 'console/menu/show/index', 'iconfont el-icon-s-ORDER', 1, '', 100, 1, 1, 1683707629, 1685417159);
    74. 

  74. INSERT INTO `system_menu` VALUES (114, '配方模板编辑', 2, 3, '配方模板编辑', '', 'console/menu/show/index', 'iconfont el-icon-s-ORDER', 1, '', 101, 1, 1, 1683707629, 1685417159);
    75. 

  75. INSERT INTO `system_menu` VALUES (115, '犊牛类型编辑', 2, 3, '犊牛类型编辑', '', 'console/menu/show/index', 'iconfont el-icon-s-ORDER', 1, '', 102, 1, 1, 1683707629, 1685417159);
    76. 

  76. INSERT INTO `system_menu` VALUES (116, '饲喂车管理编辑', 2, 3, '饲喂车管理编辑', '', 'console/menu/show/index', 'iconfont el-icon-s-ORDER', 1, '', 103, 1, 1, 1683707629, 1685417159);
    77. 

  77. INSERT INTO `system_menu` VALUES (117, '预设饲喂模板编辑', 2, 3, '预设饲喂模板编辑', '', 'console/menu/show/index', 'iconfont el-icon-s-ORDER', 1, '', 104, 1, 1, 1683707629, 1685417159);
    78. 

  78. INSERT INTO `system_menu` VALUES (118, '默认标准参数编辑', 2, 3, '默认标准参数编辑', '', 'console/menu/show/index', 'iconfont el-icon-s-ORDER', 1, '', 105, 1, 1, 1683707629, 1685417159);
    79. 

  79. INSERT INTO `system_menu` VALUES (119, '饲料成本设置编辑', 2, 3, '饲料成本设置编辑', '', 'console/menu/show/index', 'iconfont el-icon-s-ORDER', 1, '', 106, 1, 1, 1683707629, 1685417159);
    80. 

  80. INSERT INTO `system_menu` VALUES (120, '用户管理编辑', 2, 3, '用户管理编辑', '', 'console/menu/show/index', 'iconfont el-icon-s-ORDER', 1, '', 108, 1, 1, 1683707629, 1685417159);
    81. 

  81. INSERT INTO `system_menu` VALUES (121, '角色管理编辑', 2, 3, '角色管理编辑', '', 'console/menu/show/index', 'iconfont el-icon-s-ORDER', 1, '', 107, 1, 1, 1683707629, 1685417159);
    82. 

  82. INSERT INTO `system_menu` VALUES (123, '工单任务分派', 1, 2, '工单任务分派', 'WorkTaskAssign', '', '', 0, '', 91, 1, 1, 0, 0);
    83. 

  83. INSERT INTO `system_menu` VALUES (124, '工单任务执行', 1, 2, '工单任务执行', 'WorkTaskImplement', '', '', 0, '', 91, 1, 1, 0, 0);
    84. 

  84. INSERT INTO `system_menu` VALUES (125, '增重趋势', 1, 2, '增重趋势', 'WeightTrend', '', '', 0, '', 87, 1, 1, 0, 0);
    85. 

  85. INSERT INTO `system_menu` VALUES (126, '配方效果', 1, 2, '配方效果', 'FormulaEffect', '', '', 0, '', 87, 1, 1, 0, 0);
    86. 

  86. INSERT INTO `system_menu` VALUES (127, '成长达标率', 1, 2, '成长达标率', 'GrowthRate', '', '', 0, '', 87, 1, 1, 0, 0);
    87. 

  87. INSERT INTO `system_menu` VALUES (128, '饲料成本', 1, 2, '饲料成本', 'FeedCost', '', '', 0, '', 87, 1, 1, 0, 0);
    88. 

  88. INSERT INTO `system_menu` VALUES (129, '疾病情况', 1, 2, '疾病情况', 'DiseaseSituation', '', '', 0, '', 87, 1, 1, 0, 0);
    89. 

  89. INSERT INTO `system_menu` VALUES (130, '存活率', 1, 2, '存活率', 'SurvivalRate', '', '', 0, '', 87, 1, 1, 0, 0);
    90. 

  90. INSERT INTO `system_menu` VALUES (131, '称量记录', 1, 2, '称量记录', 'WeightRecord', '', '', 0, '', 88, 1, 1, 0, 0);
    91. 

  91. INSERT INTO `system_menu` VALUES (132, '工单类型', 1, 2, '工单类型', 'WorkOrderType', '', '', 0, '', 92, 1, 1, 0, 0);
    92. 

  92. INSERT INTO `system_menu` VALUES (133, '疾病管理', 1, 2, '疾病管理', 'DiseaseManagement', '', '', 0, '', 92, 1, 1, 0, 0);
    93. 

  93. INSERT INTO `system_menu` VALUES (134, '消息提醒', 1, 2, '消息提醒', 'InfoRemind', '', '', 0, '', 92, 1, 1, 0, 0);
    94. 

  94. INSERT INTO `system_menu` VALUES (135, '称量记录编辑', 2, 3, '称量记录编辑', '', '', '', 0, '', 131, 1, 1, 0, 0);
    95. 

  95. INSERT INTO `system_menu` VALUES (136, '工单任务分派编辑', 2, 3, '工单任务分派编辑', '', '', '', 0, '', 123, 1, 1, 0, 0);
    96. 

  96. INSERT INTO `system_menu` VALUES (137, '工单任务执行编辑', 2, 3, '工单任务执行编辑', '', '', '', 0, '', 124, 1, 1, 0, 0);
    97. 

  97. INSERT INTO `system_menu` VALUES (138, '工单类型编辑', 2, 3, '工单类型编辑', '', '', '', 0, '', 132, 1, 1, 0, 0);
    98. 

  98. INSERT INTO `system_menu` VALUES (139, '疾病管理编辑', 2, 3, '疾病管理编辑', '', '', '', 0, '', 133, 1, 1, 0, 0);
    99. 

  99. INSERT INTO `system_menu` VALUES (140, '消息提醒编辑', 2, 3, '消息提醒编辑', '', '', '', 0, '', 134, 1, 1, 0, 0);
    100. 

  100. 

  101. SET FOREIGN_KEY_CHECKS = 1;
    102.