USE BeezifiIOM;

ALTER TABLE demand_forecasts
    ADD COLUMN IF NOT EXISTS safety_stock_qty DECIMAL(12,4) NOT NULL DEFAULT 0 AFTER confidence_score,
    ADD COLUMN IF NOT EXISTS reorder_point_qty DECIMAL(12,4) NOT NULL DEFAULT 0 AFTER safety_stock_qty;
