-- Replace expected_discount_pct with price_uplift.
-- price_uplift is a divisor applied to the competitor's price to get the ex-VAT price:
--   effective_price = price / price_uplift
-- Default 1.3 represents a typical VAT+margin uplift.
ALTER TABLE qt_competitors
    ADD COLUMN price_uplift DECIMAL(8,4) NOT NULL DEFAULT 1.3000
        COMMENT 'Price divisor: effective_price = price / price_uplift. Default 1.3.',
    DROP COLUMN expected_discount_pct;