-- 出库流通管理：销售出库与袋码/托盘码关联（无租户字段）
-- 执行前请确认目标数据库为 mom-thzy，并逐条执行。

ALTER TABLE mes_wm_product_sales
  ADD COLUMN client_name varchar(255) DEFAULT NULL COMMENT '经销商名称快照' AFTER client_id;
ALTER TABLE mes_wm_product_sales
  ADD COLUMN outbound_time datetime DEFAULT NULL COMMENT '实际出库时间' AFTER sales_date;
ALTER TABLE mes_wm_product_sales
  ADD COLUMN outbound_user_id bigint DEFAULT NULL COMMENT '执行出库操作人ID' AFTER outbound_time;
ALTER TABLE mes_wm_product_sales
  ADD INDEX idx_product_sales_outbound_time (outbound_time);

ALTER TABLE mes_wm_product_sales_detail
  ADD COLUMN bag_code_id bigint DEFAULT NULL COMMENT '袋码编号' AFTER area_id;
ALTER TABLE mes_wm_product_sales_detail
  ADD COLUMN pallet_code_id bigint DEFAULT NULL COMMENT '托盘码编号' AFTER bag_code_id;
ALTER TABLE mes_wm_product_sales_detail
  ADD INDEX idx_sales_detail_bag_code (bag_code_id);
ALTER TABLE mes_wm_product_sales_detail
  ADD INDEX idx_sales_detail_pallet_code (pallet_code_id);

ALTER TABLE mes_pro_bag_code
  ADD COLUMN sales_id bigint DEFAULT NULL COMMENT '最近销售出库单编号' AFTER inbound_line_code;
ALTER TABLE mes_pro_bag_code
  ADD COLUMN outbound_time datetime DEFAULT NULL COMMENT '最近销售出库时间' AFTER sales_id;
ALTER TABLE mes_pro_bag_code
  ADD INDEX idx_bag_code_sales (sales_id);

ALTER TABLE mes_pro_pallet
  ADD COLUMN sales_id bigint DEFAULT NULL COMMENT '最近销售出库单编号' AFTER status;
ALTER TABLE mes_pro_pallet
  ADD COLUMN outbound_time datetime DEFAULT NULL COMMENT '最近销售出库时间' AFTER sales_id;
ALTER TABLE mes_pro_pallet
  ADD INDEX idx_pallet_sales (sales_id);