-- Enterprise billing: cost breakdown columns
-- WalletTransaction: per-transaction provider cost + platform fee breakdown
ALTER TABLE `WalletTransaction`
  ADD COLUMN `baseCost` DOUBLE NULL,
  ADD COLUMN `twilioCost` DOUBLE NULL,
  ADD COLUMN `commioCost` DOUBLE NULL,
  ADD COLUMN `marginPercent` DOUBLE NULL,
  ADD COLUMN `marginAmount` DOUBLE NULL,
  ADD COLUMN `carrier` VARCHAR(191) NULL;

-- CallSession: actual billed cost of the completed call
ALTER TABLE `CallSession`
  ADD COLUMN `actualCost` DOUBLE NULL,
  ADD COLUMN `marginAmount` DOUBLE NULL,
  ADD COLUMN `totalCharged` DOUBLE NULL,
  ADD COLUMN `carrier` VARCHAR(191) NULL;
