wms / wms4_globalnancangkuangji · Files

-- =====================================================
-- 测试环境 SQL：为 receipt_container_detail 添加 status 字段
-- 执行前请确认在测试环境 91 运行
-- =====================================================

-- 1. 添加 status 字段
ALTER TABLE receipt_container_detail ADD COLUMN status INT NULL COMMENT '状态：0=新建, 10=组盘, 20=入库完成, 50=已回传';

-- 2. 同步现有数据状态（根据入库组盘头状态同步）
UPDATE receipt_container_detail rcd
SET status = rch.status
FROM receipt_container_header rch
WHERE rcd.receipt_container_id = rch.id;

-- 3. 验证添加结果
SELECT 
    '状态分布' as 检查项,
    status,
    COUNT(*) as 数量
FROM receipt_container_detail
GROUP BY status
ORDER BY status;