ALTER TABLE product_attributes
    ADD COLUMN affects_pricing TINYINT NOT NULL DEFAULT 1 AFTER is_pricing_quantity;

UPDATE product_attributes
SET affects_pricing = 1
WHERE affects_pricing IS NULL;
