-- Add expected_weight column to the main batch data table (if missing).
-- Run once. "Duplicate column name" means the column already exists — skip that ALTER.
-- This stores the expected/target weight from the frontend or product table.

ALTER TABLE `data`
  ADD COLUMN `expected_weight` VARCHAR(50) NULL COMMENT 'Expected/target weight (from frontend or product)' AFTER `actual_weight`;
