-- ScanStation — migration: add piece_num to llx_mrp_mo_optracking
-- Stores the exact piece number that was confirmed or reversed,
-- so Op Log can display the correct Part # instead of a cumulative running sum.
-- NOTE: run only once — no IF NOT EXISTS (old MariaDB compatibility).
-- Date: 2026-04-12

ALTER TABLE llx_mrp_mo_optracking ADD COLUMN piece_num INT NULL DEFAULT NULL;
