-- Existing V2.5+ installations only. Run once using phpMyAdmin.
ALTER TABLE products ADD COLUMN discount_rate DECIMAL(7,4) NULL DEFAULT NULL AFTER vat_rate;
-- NULL means fallback to supplier discount for legacy products. Zero is a valid product-specific discount.