-- v1.24: Add withholding tax (WHT) to purchase invoices
-- Run once after v1.23

SET NAMES utf8mb4;

ALTER TABLE purchase_invoices
  ADD COLUMN wht_enabled TINYINT(1) NOT NULL DEFAULT 0 AFTER tax_invoice_no,
  ADD COLUMN wht_rate DECIMAL(6,2) NOT NULL DEFAULT 1 AFTER wht_enabled,
  ADD COLUMN wht_amount DECIMAL(14,2) NOT NULL DEFAULT 0 AFTER wht_rate;