-- 橙虎小酒 - 轻简奢品主题：更新装修数据（TabBar + 个人中心）
-- 数据库：xgsc.gynhc.com
-- 可与 seed_xiongge_demo.sql 一起执行，或单独执行

UPDATE `fa_shopro_decorate_content`
SET `content` = JSON_SET(
    `content`,
    '$.color', '#BBBBBB',
    '$.activeColor', '#C4A574',
    '$.bgcolor', '#FFFFFF'
)
WHERE `category` = 'tabbar'
  AND JSON_VALID(`content`) = 1;

UPDATE `fa_shopro_decorate_content`
SET `content` = JSON_SET(`content`, '$.color', '#F5EFE4')
WHERE `category` = 'user'
  AND JSON_VALID(`content`) = 1
  AND (
    JSON_EXTRACT(`content`, '$.image') IS NULL
    OR JSON_UNQUOTE(JSON_EXTRACT(`content`, '$.image')) = ''
  );