Tolan/项目文档/chatbot_shop_items_default_z_index_回填.sql

-- /chatbot 商品 default_z_index 回填脚本
-- 目标层级：
--   幕布(backdrop)=0
--   窗(2x3 场景窗)=0
--   墙上小件(风铃/相框)=1
--   桌子/柜子(1x2)=2
--   凳子/沙发=3
--   其他道具(咖啡杯/零食/书/能量球/年宵花/巧克力树/铃兰花灯)=5

SET NAMES utf8mb4;
START TRANSACTION;

-- 1) 幕布
UPDATE `shop_items`
SET `default_z_index` = 0
WHERE `item_code` IN (
  'fresh_green_wallpaper',
  'midnight_blue_wallpaper',
  'springtime_wallpaper',
  'mocha_wallpaper'
);

-- 2) 窗（占 2x3 的场景窗）
UPDATE `shop_items`
SET `default_z_index` = 0
WHERE `item_code` IN (
  'french_window',
  'garden_balcony',
  'forest_round_window',
  'terra_cotta_window'
);

-- 3) 墙上小件
UPDATE `shop_items`
SET `default_z_index` = 1
WHERE `item_code` IN (
  'nut_wind_bell',
  'photo_frame'
);

-- 4) 桌子/柜子
UPDATE `shop_items`
SET `default_z_index` = 2
WHERE `item_code` IN (
  'vintage_table',
  'stump_table',
  'mushroom_table'
);

-- 5) 凳子/沙发
UPDATE `shop_items`
SET `default_z_index` = 3
WHERE `item_code` IN (
  'stump_stool',
  'forest_sofa'
);

-- 6) 其他道具
UPDATE `shop_items`
SET `default_z_index` = 5
WHERE `item_code` IN (
  'coffee_mug',
  'snacks',
  'books',
  'energy_ball',
  'chinese_new_year_bloom',
  'chocolate_tree',
  'lilybell_lamp'
);

COMMIT;

-- 执行后核验
SELECT
  `item_code`,
  `name`,
  `item_type`,
  `placement_type`,
  `scene_anchor_type`,
  `default_z_index`
FROM `shop_items`
WHERE `item_code` IN (
  'fresh_green_wallpaper','midnight_blue_wallpaper','springtime_wallpaper','mocha_wallpaper',
  'french_window','garden_balcony','forest_round_window','terra_cotta_window',
  'nut_wind_bell','photo_frame',
  'vintage_table','stump_table','mushroom_table',
  'stump_stool','forest_sofa',
  'coffee_mug','snacks','books','energy_ball','chinese_new_year_bloom','chocolate_tree','lilybell_lamp'
)
ORDER BY `item_code`;