mescloud/db/mysql/add_mes_icons_category_default.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` = '';