v20260616_tx_tts1.sql 2.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475
  1. -- 2026-06-16
  2. -- Add Tencent Cloud TTS bridge configuration for mod_tx_tts1.
  3. DELETE FROM `sys_role_menu`
  4. WHERE `menu_id` = 4027;
  5. DELETE FROM `sys_menu`
  6. WHERE `menu_id` = 4027
  7. OR `perms` = 'cc:txtts1conf:view'
  8. OR `url` = '/cc/fsconf/txtts1conf';
  9. INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `menu_code`, `parent_id`, `order_num`, `url`, `target`, `menu_type`, `visible`, `is_refresh`, `perms`, `icon`, `create_by`, `create_time`, `remark`)
  10. VALUES (4027, '腾讯云TTS配置', 'txtts1conf', 3019, 9, '/cc/fsconf/txtts1conf', 'menuItem', 'C', '0', '1', 'cc:txtts1conf:view', '#', 'admin', NOW(), 'mod_tx_tts1 参数配置菜单');
  11. INSERT INTO `sys_role_menu` (`role_id`, `menu_id`)
  12. VALUES (2, 4027);
  13. DELETE FROM `sys_config`
  14. WHERE `config_key` = 'config_tts_provider_tx_tts1';
  15. INSERT INTO `sys_config` (`config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `remark`)
  16. VALUES ('腾讯云', 'config_tts_provider_tx_tts1', 'tx_tts1', 'Y', 'admin', NOW(), 'TTS厂商-腾讯云');
  17. DELETE FROM `cc_params`
  18. WHERE `param_code` = 'tx-tts1-account-json';
  19. INSERT INTO `cc_params` (`param_name`, `param_code`, `param_value`, `param_type`, `hide_value`)
  20. VALUES ('腾讯云tts账号参数json', 'tx-tts1-account-json', '{"appid":"","secret-id":""
  21. ,"secret-key":"","voice-id":"","websocket-host":"mps.cloud.tencent.com","text-lang":"zh","format":"ulaw","sample-rate":"8000","timeout-sec":"60","speed":"0","vol":"0","pitch":"","intensity":"","timbre":"","sound-effect":"","res-id":"","signature-expire-seconds":"3600","connect-timeout-ms":"10000","verify-peer":"false"}', 'tts', 1);
  22. DELETE FROM `fs_variables`
  23. WHERE `cat` = 5
  24. AND `var_field_name` IN (
  25. 'appid',
  26. 'secret-id',
  27. 'secret-key',
  28. 'voice-id',
  29. 'websocket-host',
  30. 'text-lang',
  31. 'format',
  32. 'sample-rate',
  33. 'timeout-sec',
  34. 'speed',
  35. 'vol',
  36. 'pitch',
  37. 'intensity',
  38. 'timbre',
  39. 'sound-effect',
  40. 'res-id',
  41. 'signature-expire-seconds',
  42. 'connect-timeout-ms',
  43. 'verify-peer'
  44. );
  45. INSERT INTO `fs_variables` (`cat`, `var_field_name`, `var_field_alias`) VALUES
  46. (5, 'appid', 'AppId'),
  47. (5, 'secret-id', 'SecretId'),
  48. (5, 'secret-key', 'SecretKey'),
  49. (5, 'voice-id', '音色ID'),
  50. (5, 'websocket-host', 'WebSocket域名'),
  51. (5, 'text-lang', '文本语言'),
  52. (5, 'format', '音频格式'),
  53. (5, 'sample-rate', '采样率'),
  54. (5, 'timeout-sec', '会话超时(秒)'),
  55. (5, 'speed', '语速'),
  56. (5, 'vol', '音量'),
  57. (5, 'pitch', '音高 Pitch'),
  58. (5, 'intensity', '强度 Intensity'),
  59. (5, 'timbre', '音色 Timbre'),
  60. (5, 'sound-effect', '音效 Effect'),
  61. (5, 'res-id', '资源标签'),
  62. (5, 'signature-expire-seconds', '签名有效期(秒)'),
  63. (5, 'connect-timeout-ms', '连接超时(毫秒)'),
  64. (5, 'verify-peer', '校验证书');
  65. -- 音色列表请在音色管理中维护 `voice_source=tx_tts1` 的系统音色或克隆音色。