mescloud/db/mysql/add_mes_icons_category_id.sql

-- 功能模块关联分类

ALTER TABLE `mes_icons`
  ADD COLUMN `category_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所属分类ID' AFTER `id`,
  ADD INDEX `idx_category_id` (`category_id`) USING BTREE;

-- 默认分类「其他」（若已执行过 add_mes_icons_category.sql 可跳过插入）
INSERT IGNORE 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()
);

-- 历史未分类模块归入「其他」
UPDATE `mes_icons`
SET `category_id` = '1000000000000000001'
WHERE `category_id` IS NULL OR `category_id` = '';