-- ==============================================================
-- RUN THIS ONE FILE ONCE in phpMyAdmin (wbcorp_webapp).
-- It contains the two new migrations: operator signature + default deduction type.
-- ==============================================================

-- Run once in phpMyAdmin.
-- Operator signature chosen/drawn on the completion screen, per ticket.
-- NULL = use the operator's saved signature (as before); '' = deliberately left blank; otherwise the drawn image path.
ALTER TABLE tblTransaction_Job ADD COLUMN operator_signature_path VARCHAR(255) NULL;

-- Run once in phpMyAdmin.
-- Default deduction type pre-selected on the weighing screen (SuperAdmin setting). Fixed (kg) by default.
-- Values: Fixed | Percent | None | Item  (Item = use each item's own default)
ALTER TABLE tblTransaction_Setting ADD COLUMN default_deduction_type VARCHAR(10) NOT NULL DEFAULT 'Fixed';