Página inicial Explorar Ajuda
Registrar Entrar
wuzilong
/
Tolan
1
0
Fork 0
Arquivos Issues 0 Pull Requests 0 Wiki
Tree: 8d23ed28dd
Branches Tags
Tolan
/
shop_items.sql

shop_items.sql 12 KB
Histórico Raw

12345678910111213141516171819202122 
  1. INSERT INTO `Lyrria`.`shop_items` (`id`, `item_code`, `name`, `biz_type`, `item_type`, `placement_type`, `image_name`, `size_rows`, `size_cols`, `price_energy`, `price_crystal`, `default_z_index`, `scene_anchor_type`, `stock_mode`, `repeat_purchase_mode`, `max_per_user`, `is_active`, `sort_order`, `created_at`, `updated_at`) VALUES (39, 'books', '书', 'prop', 'furniture', 'floor', 'Books.png', 1, 1, 0.00, 0.00, 10, 'none', 'unlimited', 'single', 1, 1, 160, '2026-03-24 15:47:29', '2026-03-24 15:47:29');
    2. 

  2. INSERT INTO `Lyrria`.`shop_items` (`id`, `item_code`, `name`, `biz_type`, `item_type`, `placement_type`, `image_name`, `size_rows`, `size_cols`, `price_energy`, `price_crystal`, `default_z_index`, `scene_anchor_type`, `stock_mode`, `repeat_purchase_mode`, `max_per_user`, `is_active`, `sort_order`, `created_at`, `updated_at`) VALUES (40, 'chinese_new_year_bloom', '年宵花', 'prop', 'furniture', 'floor', 'Chinese-New-Year-Bloom.png', 2, 1, 50.00, 0.00, 10, 'none', 'unlimited', 'single', 1, 1, 180, '2026-03-24 15:47:29', '2026-03-24 15:47:29');
    3. 

  3. INSERT INTO `Lyrria`.`shop_items` (`id`, `item_code`, `name`, `biz_type`, `item_type`, `placement_type`, `image_name`, `size_rows`, `size_cols`, `price_energy`, `price_crystal`, `default_z_index`, `scene_anchor_type`, `stock_mode`, `repeat_purchase_mode`, `max_per_user`, `is_active`, `sort_order`, `created_at`, `updated_at`) VALUES (41, 'chocolate_tree', '巧克力树', 'prop', 'furniture', 'floor', 'Chocolate-Tree.png', 1, 1, 50.00, 0.00, 10, 'none', 'unlimited', 'single', 1, 1, 200, '2026-03-24 15:47:29', '2026-03-24 15:47:29');
    4. 

  4. INSERT INTO `Lyrria`.`shop_items` (`id`, `item_code`, `name`, `biz_type`, `item_type`, `placement_type`, `image_name`, `size_rows`, `size_cols`, `price_energy`, `price_crystal`, `default_z_index`, `scene_anchor_type`, `stock_mode`, `repeat_purchase_mode`, `max_per_user`, `is_active`, `sort_order`, `created_at`, `updated_at`) VALUES (42, 'coffee_mug', '咖啡杯', 'prop', 'furniture', 'floor', 'Coffee-Mug.png', 1, 1, 0.00, 0.00, 10, 'none', 'unlimited', 'single', 1, 1, 140, '2026-03-24 15:47:29', '2026-03-24 15:47:29');
    5. 

  5. INSERT INTO `Lyrria`.`shop_items` (`id`, `item_code`, `name`, `biz_type`, `item_type`, `placement_type`, `image_name`, `size_rows`, `size_cols`, `price_energy`, `price_crystal`, `default_z_index`, `scene_anchor_type`, `stock_mode`, `repeat_purchase_mode`, `max_per_user`, `is_active`, `sort_order`, `created_at`, `updated_at`) VALUES (43, 'energy_ball', '能量球', 'prop', 'furniture', 'floor', 'Energy-Ball.png', 1, 1, 50.00, 0.00, 10, 'none', 'unlimited', 'single', 1, 1, 170, '2026-03-24 15:47:29', '2026-03-24 15:47:29');
    6. 

  6. INSERT INTO `Lyrria`.`shop_items` (`id`, `item_code`, `name`, `biz_type`, `item_type`, `placement_type`, `image_name`, `size_rows`, `size_cols`, `price_energy`, `price_crystal`, `default_z_index`, `scene_anchor_type`, `stock_mode`, `repeat_purchase_mode`, `max_per_user`, `is_active`, `sort_order`, `created_at`, `updated_at`) VALUES (44, 'forest_round_window', '绿意圆窗', 'window', 'furniture', 'wall', 'Forest-Window.png', 2, 3, 150.00, 0.00, 20, 'window', 'unlimited', 'single', 1, 1, 80, '2026-03-24 15:47:29', '2026-03-24 15:47:29');
    7. 

  7. INSERT INTO `Lyrria`.`shop_items` (`id`, `item_code`, `name`, `biz_type`, `item_type`, `placement_type`, `image_name`, `size_rows`, `size_cols`, `price_energy`, `price_crystal`, `default_z_index`, `scene_anchor_type`, `stock_mode`, `repeat_purchase_mode`, `max_per_user`, `is_active`, `sort_order`, `created_at`, `updated_at`) VALUES (45, 'forest_sofa', '绿意沙发', 'seat_sofa', 'furniture', 'floor', 'Forest-Sofa.png', 1, 1, 150.00, 0.00, 10, 'seat', 'unlimited', 'single', 1, 1, 20, '2026-03-24 15:47:29', '2026-03-24 15:47:29');
    8. 

  8. INSERT INTO `Lyrria`.`shop_items` (`id`, `item_code`, `name`, `biz_type`, `item_type`, `placement_type`, `image_name`, `size_rows`, `size_cols`, `price_energy`, `price_crystal`, `default_z_index`, `scene_anchor_type`, `stock_mode`, `repeat_purchase_mode`, `max_per_user`, `is_active`, `sort_order`, `created_at`, `updated_at`) VALUES (46, 'french_window', '落地窗', 'window', 'furniture', 'wall', 'French-Window.png', 2, 3, 0.00, 0.00, 20, 'window', 'unlimited', 'single', 1, 1, 60, '2026-03-24 15:47:29', '2026-03-24 15:47:29');
    9. 

  9. INSERT INTO `Lyrria`.`shop_items` (`id`, `item_code`, `name`, `biz_type`, `item_type`, `placement_type`, `image_name`, `size_rows`, `size_cols`, `price_energy`, `price_crystal`, `default_z_index`, `scene_anchor_type`, `stock_mode`, `repeat_purchase_mode`, `max_per_user`, `is_active`, `sort_order`, `created_at`, `updated_at`) VALUES (47, 'fresh_green_wallpaper', '清新绿', 'wallpaper', 'backdrop', 'backdrop', 'Fresh-Green.png', 1, 1, 0.00, 0.00, 0, 'none', 'unlimited', 'single', 1, 1, 100, '2026-03-24 15:47:29', '2026-03-24 15:47:29');
    10. 

  10. INSERT INTO `Lyrria`.`shop_items` (`id`, `item_code`, `name`, `biz_type`, `item_type`, `placement_type`, `image_name`, `size_rows`, `size_cols`, `price_energy`, `price_crystal`, `default_z_index`, `scene_anchor_type`, `stock_mode`, `repeat_purchase_mode`, `max_per_user`, `is_active`, `sort_order`, `created_at`, `updated_at`) VALUES (48, 'garden_balcony', '花园阳台', 'window', 'furniture', 'wall', 'Garden-Balcony.png', 2, 3, 150.00, 0.00, 20, 'window', 'unlimited', 'single', 1, 1, 70, '2026-03-24 15:47:29', '2026-03-24 15:47:29');
    11. 

  11. INSERT INTO `Lyrria`.`shop_items` (`id`, `item_code`, `name`, `biz_type`, `item_type`, `placement_type`, `image_name`, `size_rows`, `size_cols`, `price_energy`, `price_crystal`, `default_z_index`, `scene_anchor_type`, `stock_mode`, `repeat_purchase_mode`, `max_per_user`, `is_active`, `sort_order`, `created_at`, `updated_at`) VALUES (49, 'lilybell_lamp', '铃兰花灯', 'prop', 'furniture', 'floor', 'Lilybell-Lamp.png', 2, 1, 50.00, 0.00, 10, 'none', 'unlimited', 'single', 1, 1, 210, '2026-03-24 15:47:29', '2026-03-24 15:47:29');
    12. 

  12. INSERT INTO `Lyrria`.`shop_items` (`id`, `item_code`, `name`, `biz_type`, `item_type`, `placement_type`, `image_name`, `size_rows`, `size_cols`, `price_energy`, `price_crystal`, `default_z_index`, `scene_anchor_type`, `stock_mode`, `repeat_purchase_mode`, `max_per_user`, `is_active`, `sort_order`, `created_at`, `updated_at`) VALUES (50, 'midnight_blue_wallpaper', '深夜蓝', 'wallpaper', 'backdrop', 'backdrop', 'Midnight-Blue.png', 1, 1, 50.00, 0.00, 0, 'none', 'unlimited', 'single', 1, 1, 110, '2026-03-24 15:47:29', '2026-03-24 15:47:29');
    13. 

  13. INSERT INTO `Lyrria`.`shop_items` (`id`, `item_code`, `name`, `biz_type`, `item_type`, `placement_type`, `image_name`, `size_rows`, `size_cols`, `price_energy`, `price_crystal`, `default_z_index`, `scene_anchor_type`, `stock_mode`, `repeat_purchase_mode`, `max_per_user`, `is_active`, `sort_order`, `created_at`, `updated_at`) VALUES (51, 'mocha_wallpaper', '摩卡浓情', 'wallpaper', 'backdrop', 'backdrop', 'Mocha.png', 1, 1, 50.00, 0.00, 0, 'none', 'unlimited', 'single', 1, 1, 130, '2026-03-24 15:47:29', '2026-03-24 15:47:29');
    14. 

  14. INSERT INTO `Lyrria`.`shop_items` (`id`, `item_code`, `name`, `biz_type`, `item_type`, `placement_type`, `image_name`, `size_rows`, `size_cols`, `price_energy`, `price_crystal`, `default_z_index`, `scene_anchor_type`, `stock_mode`, `repeat_purchase_mode`, `max_per_user`, `is_active`, `sort_order`, `created_at`, `updated_at`) VALUES (52, 'mushroom_table', '蘑菇长桌', 'table_cabinet', 'furniture', 'floor', 'Mushroom-Table.png', 1, 2, 150.00, 0.00, 10, 'none', 'unlimited', 'single', 1, 1, 50, '2026-03-24 15:47:29', '2026-03-24 15:47:29');
    15. 

  15. INSERT INTO `Lyrria`.`shop_items` (`id`, `item_code`, `name`, `biz_type`, `item_type`, `placement_type`, `image_name`, `size_rows`, `size_cols`, `price_energy`, `price_crystal`, `default_z_index`, `scene_anchor_type`, `stock_mode`, `repeat_purchase_mode`, `max_per_user`, `is_active`, `sort_order`, `created_at`, `updated_at`) VALUES (53, 'nut_wind_bell', '坚果风铃', 'prop', 'furniture', 'wall', 'Nut-Wind-Bell.png', 2, 1, 50.00, 0.00, 10, 'none', 'unlimited', 'single', 1, 1, 220, '2026-03-24 15:47:29', '2026-03-24 15:47:29');
    16. 

  16. INSERT INTO `Lyrria`.`shop_items` (`id`, `item_code`, `name`, `biz_type`, `item_type`, `placement_type`, `image_name`, `size_rows`, `size_cols`, `price_energy`, `price_crystal`, `default_z_index`, `scene_anchor_type`, `stock_mode`, `repeat_purchase_mode`, `max_per_user`, `is_active`, `sort_order`, `created_at`, `updated_at`) VALUES (54, 'photo_frame', '普通相框', 'prop', 'furniture', 'wall', 'Photo-Frame.png', 1, 1, 50.00, 0.00, 10, 'none', 'unlimited', 'single', 1, 1, 190, '2026-03-24 15:47:29', '2026-03-24 15:47:29');
    17. 

  17. INSERT INTO `Lyrria`.`shop_items` (`id`, `item_code`, `name`, `biz_type`, `item_type`, `placement_type`, `image_name`, `size_rows`, `size_cols`, `price_energy`, `price_crystal`, `default_z_index`, `scene_anchor_type`, `stock_mode`, `repeat_purchase_mode`, `max_per_user`, `is_active`, `sort_order`, `created_at`, `updated_at`) VALUES (55, 'snacks', '零食', 'prop', 'furniture', 'floor', 'Snacks.png', 1, 1, 0.00, 0.00, 10, 'none', 'unlimited', 'single', 1, 1, 150, '2026-03-24 15:47:29', '2026-03-24 15:47:29');
    18. 

  18. INSERT INTO `Lyrria`.`shop_items` (`id`, `item_code`, `name`, `biz_type`, `item_type`, `placement_type`, `image_name`, `size_rows`, `size_cols`, `price_energy`, `price_crystal`, `default_z_index`, `scene_anchor_type`, `stock_mode`, `repeat_purchase_mode`, `max_per_user`, `is_active`, `sort_order`, `created_at`, `updated_at`) VALUES (56, 'springtime_wallpaper', '春之意', 'wallpaper', 'backdrop', 'backdrop', 'Springtime.png', 1, 1, 50.00, 0.00, 0, 'none', 'unlimited', 'single', 1, 1, 120, '2026-03-24 15:47:29', '2026-03-24 15:47:29');
    19. 

  19. INSERT INTO `Lyrria`.`shop_items` (`id`, `item_code`, `name`, `biz_type`, `item_type`, `placement_type`, `image_name`, `size_rows`, `size_cols`, `price_energy`, `price_crystal`, `default_z_index`, `scene_anchor_type`, `stock_mode`, `repeat_purchase_mode`, `max_per_user`, `is_active`, `sort_order`, `created_at`, `updated_at`) VALUES (57, 'stump_stool', '小木桩', 'seat_sofa', 'furniture', 'floor', 'Stump-Stool.png', 1, 1, 0.00, 0.00, 10, 'seat', 'unlimited', 'single', 1, 1, 10, '2026-03-24 15:47:29', '2026-03-24 15:47:29');
    20. 

  20. INSERT INTO `Lyrria`.`shop_items` (`id`, `item_code`, `name`, `biz_type`, `item_type`, `placement_type`, `image_name`, `size_rows`, `size_cols`, `price_energy`, `price_crystal`, `default_z_index`, `scene_anchor_type`, `stock_mode`, `repeat_purchase_mode`, `max_per_user`, `is_active`, `sort_order`, `created_at`, `updated_at`) VALUES (58, 'stump_table', '木桩小桌', 'table_cabinet', 'furniture', 'floor', 'Stump-Table.png', 1, 2, 150.00, 0.00, 10, 'none', 'unlimited', 'single', 1, 1, 40, '2026-03-24 15:47:29', '2026-03-24 15:47:29');
    21. 

  21. INSERT INTO `Lyrria`.`shop_items` (`id`, `item_code`, `name`, `biz_type`, `item_type`, `placement_type`, `image_name`, `size_rows`, `size_cols`, `price_energy`, `price_crystal`, `default_z_index`, `scene_anchor_type`, `stock_mode`, `repeat_purchase_mode`, `max_per_user`, `is_active`, `sort_order`, `created_at`, `updated_at`) VALUES (59, 'terra_cotta_window', '红泥窗', 'window', 'furniture', 'wall', 'Terra-Cotta-Window.png', 2, 3, 50.00, 0.00, 20, 'window', 'unlimited', 'single', 1, 1, 90, '2026-03-24 15:47:29', '2026-03-24 15:47:29');
    22. 

  22. INSERT INTO `Lyrria`.`shop_items` (`id`, `item_code`, `name`, `biz_type`, `item_type`, `placement_type`, `image_name`, `size_rows`, `size_cols`, `price_energy`, `price_crystal`, `default_z_index`, `scene_anchor_type`, `stock_mode`, `repeat_purchase_mode`, `max_per_user`, `is_active`, `sort_order`, `created_at`, `updated_at`) VALUES (60, 'vintage_table', '复古小桌', 'table_cabinet', 'furniture', 'floor', 'Vintage-Table.png', 1, 2, 50.00, 0.00, 10, 'none', 'unlimited', 'single', 1, 1, 30, '2026-03-24 15:47:29', '2026-03-24 15:47:29');
    23.