SET search_path TO atlas, public;

-- 俄文标题可由商品通用值或逐 SKU 值填写；空草稿也需要保存模式。
ALTER TABLE product_platform_profiles
    ADD COLUMN title_mode TEXT NOT NULL DEFAULT 'common'
        CHECK (title_mode IN ('common', 'variant'));

-- 既有 SKU 标题覆盖保留为逐 SKU 模式，不清除已有商品或 SKU 文案。
UPDATE product_platform_profiles p
SET title_mode = 'variant'
WHERE EXISTS (
    SELECT 1 FROM product_variant_platform_listings l
    JOIN product_variants v ON v.id = l.product_variant_id
    WHERE l.profile_id = p.id AND v.deleted_at IS NULL AND nullif(btrim(l.title), '') IS NOT NULL
);