20260219_add_machine_unbind_cooldown_config.sql 775 B

123456789101112131415161718192021222324252627282930313233
  1. -- 机器解绑冷却周期配置(单位:天),默认 10 天
  2. INSERT INTO `system_config` (
  3. `config_key`,
  4. `config_value`,
  5. `config_type`,
  6. `app_name`,
  7. `description`,
  8. `is_system`,
  9. `is_editable`,
  10. `is_deleted`,
  11. `created_at`,
  12. `updated_at`
  13. ) VALUES (
  14. 'machine_unbind_cooldown_days',
  15. '10',
  16. 'int',
  17. 'backend-client',
  18. '客户端机器解绑冷却周期(天),绑定后需等待指定天数才可解绑',
  19. 1,
  20. 1,
  21. 0,
  22. NOW(),
  23. NOW()
  24. ) ON DUPLICATE KEY UPDATE
  25. `config_value` = VALUES(`config_value`),
  26. `config_type` = VALUES(`config_type`),
  27. `app_name` = VALUES(`app_name`),
  28. `description` = VALUES(`description`),
  29. `is_system` = VALUES(`is_system`),
  30. `is_editable` = VALUES(`is_editable`),
  31. `is_deleted` = 0,
  32. `updated_at` = NOW();