-- CostusWorx © 2026 — Fund asset allocation breakdown columns
-- Run once. All default NULL (allocation unknown / not yet entered).
-- Values stored as percentage (e.g. 60.00 = 60%). Should sum to ~100 when all populated.

ALTER TABLE funds
  ADD COLUMN alloc_equity_local  DECIMAL(5,2) DEFAULT NULL COMMENT 'SA Equities %',
  ADD COLUMN alloc_equity_intl   DECIMAL(5,2) DEFAULT NULL COMMENT 'International Equities %',
  ADD COLUMN alloc_bonds         DECIMAL(5,2) DEFAULT NULL COMMENT 'Bonds (local + intl) %',
  ADD COLUMN alloc_cash          DECIMAL(5,2) DEFAULT NULL COMMENT 'Cash / Money Market %',
  ADD COLUMN alloc_resources     DECIMAL(5,2) DEFAULT NULL COMMENT 'Resources sector %',
  ADD COLUMN alloc_financials    DECIMAL(5,2) DEFAULT NULL COMMENT 'Financials sector %',
  ADD COLUMN alloc_unit_trust    DECIMAL(5,2) DEFAULT NULL COMMENT 'Unit Trusts / Linked funds %';