-- CostusWorx © 2026 — retireuk.costusworx.co.za
-- Offshore-equity return slot for the segment engine.
-- Adds the column the simulation needs to treat offshore (global) equity as a
-- DISTINCT segment, not proxied by the FTSE All-Share. DATA STILL REQUIRED: a
-- per-year MSCI World total return expressed in GBP (USD index return compounded
-- with the year's GBP/USD move). Until this is populated AND the engine reads it,
-- AssetAllocationResolver folds offshore into UK equity.
SET NAMES utf8mb4;

ALTER TABLE market_data
    ADD COLUMN IF NOT EXISTS offshore_equity_return DECIMAL(6,4) DEFAULT NULL
        COMMENT 'Global equity total return in GBP (e.g. MSCI World x GBP/USD), annual fraction',
    ADD COLUMN IF NOT EXISTS offshore_equity_index  VARCHAR(20)  DEFAULT NULL
        COMMENT 'Offshore equity index used, e.g. MSCI World / S&P 500';