buff3.0/backend-client/migrations/20260320_add_buff_sweep_pause_configs.sql

-- BUFF 扫货节流暂停配置
-- 用于控制扫描若干饰品后，主动暂停一段时间，降低触发 Steam 429 的概率

SET NAMES utf8mb4;

INSERT INTO `system_config` (
  `config_key`,
  `config_value`,
  `config_type`,
  `app_name`,
  `description`,
  `is_system`,
  `is_editable`,
  `is_deleted`,
  `created_at`,
  `updated_at`
) VALUES
  (
    'buff_sweep_pause_every_items',
    '0',
    'int',
    'backend-selection',
    'BUFF扫货：每扫描多少个饰品后暂停一次（0=不暂停）',
    1,
    1,
    0,
    NOW(),
    NOW()
  ),
  (
    'buff_sweep_pause_seconds',
    '0',
    'int',
    'backend-selection',
    'BUFF扫货：达到暂停阈值后暂停秒数（0=不暂停）',
    1,
    1,
    0,
    NOW(),
    NOW()
  )
ON DUPLICATE KEY UPDATE
  `config_value` = VALUES(`config_value`),
  `description` = VALUES(`description`),
  `updated_at` = NOW();