-- 在brands表添加别名字段（支持多个别名）
ALTER TABLE brands 
ADD COLUMN aliases text[] DEFAULT ARRAY[]::text[];

COMMENT ON COLUMN brands.aliases IS '品牌别名列表，用于支持中英文等多语言搜索';

-- 更新现有品牌的别名数据
UPDATE brands SET aliases = ARRAY['redmi', 'hongmi'] WHERE name = '红米';
UPDATE brands SET aliases = ARRAY['huawei'] WHERE name = '华为';
UPDATE brands SET aliases = ARRAY['honor'] WHERE name = '荣耀';
UPDATE brands SET aliases = ARRAY['realme'] WHERE name = '真我';
UPDATE brands SET aliases = ARRAY['nike'] WHERE name = '耐克';