-- MES SN码表结构修复（MySQL 5.7 兼容版）
|
-- 直接执行以下语句，如果字段已存在会报错，忽略即可
|
|
-- 1. 添加 uuid 字段
|
ALTER TABLE mes_wm_sn ADD COLUMN uuid VARCHAR(64) COMMENT '批次UUID' AFTER id;
|
|
-- 2. 添加 batch_code 字段
|
ALTER TABLE mes_wm_sn ADD COLUMN batch_code VARCHAR(100) COMMENT '批次号' AFTER item_id;
|
|
-- 3. 添加 work_order_id 字段
|
ALTER TABLE mes_wm_sn ADD COLUMN work_order_id BIGINT COMMENT '生产工单编号' AFTER batch_code;
|
|
-- 4. 添加索引
|
ALTER TABLE mes_wm_sn ADD INDEX idx_uuid (uuid);
|
ALTER TABLE mes_wm_sn ADD INDEX idx_item_id (item_id);
|
|
-- 5. 验证
|
SELECT COLUMN_NAME, COLUMN_TYPE, COLUMN_COMMENT
|
FROM information_schema.columns
|
WHERE table_schema = DATABASE() AND table_name = 'mes_wm_sn'
|
ORDER BY ORDINAL_POSITION;
|
