-- ==============================================================================
-- 恒链数通商城 - 旗舰主营产品装修模板与分类校准迁移脚本
-- 归档时间: 2026-09-17
-- 适用平台: WechatOfficialAccount, WechatMiniProgram, H5, App
-- ==============================================================================

-- 1. 商品分类绑定关系校准（白酒：154,155,158；美护：163,164）
UPDATE `hla_shopro_goods` SET `category_ids` = '153,154,155,158' WHERE `id` IN (34, 35);
UPDATE `hla_shopro_goods` SET `category_ids` = '153,163,164' WHERE `id` IN (32, 33);

-- 2. 分类横幅与封面更新
UPDATE `hla_shopro_category` SET `image` = '/uploads/henglian_goods/20260917/ff1b5f21/cc03fa9120352080.jpg' WHERE `id` = 154;
UPDATE `hla_shopro_category` SET `image` = '/uploads/henglian_goods/20260917/c76a38b6/0a6fed04b792a271.png' WHERE `id` = 163;
UPDATE `hla_shopro_category` SET `image` = '/uploads/henglian_goods/20260917/3a0470ce/e335dc712cf6d84a.jpg' WHERE `id` = 167;

-- 3. 启用模板2（恒链数通 · 旗舰臻选），清除软删除标记，全平台发布
UPDATE `hla_shopro_decorate` 
SET `name` = '恒链数通 · 旗舰臻选',
    `status` = 'enable',
    `platform` = 'WechatOfficialAccount,WechatMiniProgram,H5,App',
    `deletetime` = NULL
WHERE `id` = 2;

-- 4. 禁用其他冲突模板
UPDATE `hla_shopro_decorate` SET `status` = 'disabled' WHERE `id` != 2;