-- =========================================================
-- MIGRATION: Cost/Profit tracking on transactions
-- Lets admin reports show real margin per VTU purchase
-- =========================================================

ALTER TABLE transactions
    ADD COLUMN cost_amount   DECIMAL(12,2) DEFAULT NULL AFTER amount,
    ADD COLUMN profit_amount DECIMAL(12,2) DEFAULT NULL AFTER cost_amount;