-- Run once in phpMyAdmin (after migrations 15 and 16).
-- Dual weighbridge at one site: every weighing remembers which weighbridge took it (for audit), and each camera can be tagged to a weighbridge.
ALTER TABLE tblTransaction_Weighing ADD COLUMN device_id VARCHAR(50) NULL;
UPDATE tblTransaction_Weighing w JOIN tblTransaction_Job j ON j.job_id = w.job_id SET w.device_id = j.device_id WHERE w.device_id IS NULL;

ALTER TABLE tblTransaction_Item_Line ADD COLUMN device_id VARCHAR(50) NULL;
UPDATE tblTransaction_Item_Line l JOIN tblTransaction_Job j ON j.job_id = l.job_id SET l.device_id = j.device_id
 WHERE l.device_id IS NULL AND l.from_weighing_id IS NULL AND l.to_weighing_id IS NULL;      -- direct-weighing lines only

ALTER TABLE tblCamera_Setting ADD COLUMN device_id VARCHAR(50) NULL;            -- NULL = shared by every weighbridge of the site
ALTER TABLE tblCamera_Capture_Request ADD COLUMN device_id VARCHAR(50) NULL;    -- the weighbridge that took the weighing (NULL = all cameras)