v20260715_vt_tts.sql 2.2 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455
  1. -- 2026-07-15
  2. -- Add ViiTorTTS bridge configuration for mod_vt_tts.
  3. DELETE FROM `sys_role_menu`
  4. WHERE `menu_id` = 4033;
  5. DELETE FROM `sys_menu`
  6. WHERE `menu_id` = 4033
  7. OR `perms` = 'cc:vtttsconf:view'
  8. OR `url` = '/cc/fsconf/vtttsconf';
  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 (4033, 'ViiTorTTS配置', 'vtttsconf', 3019, 11, '/cc/fsconf/vtttsconf', 'menuItem', 'C', '0', '1', 'cc:vtttsconf:view', '#', 'admin', NOW(), 'mod_vt_tts 参数配置菜单');
  11. INSERT INTO `sys_role_menu` (`role_id`, `menu_id`)
  12. VALUES (2, 4033);
  13. DELETE FROM `sys_config`
  14. WHERE `config_key` = 'config_tts_provider_vt_tts';
  15. INSERT INTO `sys_config` (`config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `remark`)
  16. VALUES ('ViiTorTTS', 'config_tts_provider_vt_tts', 'vt_tts', 'Y', 'admin', NOW(), 'TTS厂商-ViiTorTTS');
  17. DELETE FROM `cc_params`
  18. WHERE `param_code` = 'vt-tts-account-json';
  19. INSERT INTO `cc_params` (`param_name`, `param_code`, `param_value`, `param_type`, `hide_value`)
  20. VALUES ('ViiTorTTS账号参数json', 'vt-tts-account-json', '{"appid":"","secret-key":"","voice-name":"juvenile","language":"zh-CN","format":"pcm","sample-rate":"8000","token-url":"https://tts.ilivedata.com/api/v2/speech/synthesis/ws-token","ws-url":"wss://tts.ilivedata.com/api/v1/speech/synthesis/ws","connect-timeout-ms":"10000","verify-peer":"false"}', 'tts', 1);
  21. DELETE FROM `fs_variables`
  22. WHERE `cat` = 5
  23. AND `var_field_name` IN (
  24. 'appid',
  25. 'secret-key',
  26. 'voice-name',
  27. 'language',
  28. 'format',
  29. 'sample-rate',
  30. 'token-url',
  31. 'ws-url',
  32. 'connect-timeout-ms',
  33. 'verify-peer'
  34. );
  35. INSERT INTO `fs_variables` (`cat`, `var_field_name`, `var_field_alias`) VALUES
  36. (5, 'appid', 'AppId'),
  37. (5, 'secret-key', 'SecretKey'),
  38. (5, 'voice-name', '默认音色名'),
  39. (5, 'language', '默认语种'),
  40. (5, 'format', '音频格式'),
  41. (5, 'sample-rate', '采样率'),
  42. (5, 'token-url', 'Token接口地址'),
  43. (5, 'ws-url', 'WebSocket地址'),
  44. (5, 'connect-timeout-ms', '连接超时(毫秒)'),
  45. (5, 'verify-peer', '校验证书');