mescloud/db/mysql/add_mes_icons_category.sql

-- 功能模块分类表及后台菜单
-- 挂载位置：系统管理 / 系统设置 / 功能模块分类（在「功能模块」之前）

CREATE TABLE IF NOT EXISTS `mes_icons_category` (
  `id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主键',
  `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '分类名称',
  `sort_order` int NULL DEFAULT 0 COMMENT '排序（升序）',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '备注',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '状态（0正常 1删除 2停用）',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建者',
  `create_date` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新者',
  `update_date` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '功能模块分类表' ROW_FORMAT = DYNAMIC;

-- 默认分类「其他」：未指定分类的功能模块归属此处（固定 ID，勿删）
INSERT INTO `mes_icons_category` (
  `id`, `title`, `sort_order`, `remark`, `status`, `create_by`, `create_date`, `update_by`, `update_date`
) VALUES (
  '1000000000000000001', '其他', 9999, '未指定分类的功能模块默认归属', '0', 'system', NOW(), 'system', NOW()
);

INSERT INTO `js_sys_menu` (
  `menu_code`, `parent_code`, `parent_codes`, `tree_sort`, `tree_sorts`, `tree_leaf`, `tree_level`,
  `tree_names`, `menu_name`, `menu_type`, `menu_href`, `menu_target`, `menu_icon`, `menu_color`,
  `menu_title`, `permission`, `weight`, `is_show`, `sys_code`, `module_codes`, `component`, `params`,
  `status`, `create_by`, `create_date`, `update_by`, `update_date`, `remarks`
) VALUES (
  'mesIconsCategory', '1582259828007895040', '0,1582259822626603008,1582259828007895040,',
  115, '0000009000,0000000500,0000000115,', '1', 2,
  '系统管理/系统设置/功能模块分类', '功能模块分类', '1', '/mes/mesIconsCategory/list', '',
  'icon-layers', '', '', 'mes:mesIconsCategory:view,mes:mesIconsCategory:edit', 40, '1', 'default', 'app', NULL, NULL,
  '0', 'system', NOW(), 'system', NOW(), ''
);