1
2
3
4
5
6
7
8
9
10
11
12
13
| -- 2026-10-27 执行前检查（只读）
| -- 先在客户端选择目标数据库。
| SELECT DATABASE() AS selected_database, VERSION() AS mysql_version;
| -- 应有 8 张业务表；缺失的表请勿继续执行字段脚本。
| SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME IN ('erp_sale_order_items', 'mes_pro_mps', 'mes_pro_work_order', 'mes_qc_ipqc', 'mes_qc_oqc', 'mes_wm_product_produce_line', 'mes_wm_product_produce_detail', 'mes_wm_batch') ORDER BY TABLE_NAME;
| -- 列出已存在的盘号字段；预期均为 varchar(128)、允许 NULL。
| SELECT TABLE_NAME, COLUMN_NAME, COLUMN_TYPE, IS_NULLABLE, COLUMN_COMMENT FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME IN ('erp_sale_order_items', 'mes_pro_mps', 'mes_pro_work_order', 'mes_qc_ipqc', 'mes_qc_oqc', 'mes_wm_product_produce_line', 'mes_wm_product_produce_detail', 'mes_wm_batch') AND COLUMN_NAME = 'reel_no' ORDER BY TABLE_NAME;
| -- 查询权限清理涉及删除按钮和角色授权，请在确认前端兼容后再单独评估执行。
|
| -- 批量下发沿用单条下发权限；检查两种按钮及其状态。
| SELECT id, name, permission, type, status, deleted FROM system_menu
| WHERE permission IN ('mes:pro-mps:issue', 'mes:pro-mps:merge-issue')
| ORDER BY permission, id;
|
|
