v20260614_tx_asr.sql 3.0 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283
  1. -- 2026-06-14
  2. -- Add Tencent realtime ASR bridge configuration for mod_tx_asr.
  3. DELETE FROM `sys_config`
  4. WHERE `config_key` = 'config_asr_provider_tx';
  5. INSERT INTO `sys_config` (`config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `remark`)
  6. VALUES ('腾讯ASR', 'config_asr_provider_tx', 'tx', 'Y', 'admin', NOW(), 'ASR厂商-mod_tx_asr');
  7. DELETE FROM `sys_role_menu`
  8. WHERE `menu_id` = 4023;
  9. DELETE FROM `sys_menu`
  10. WHERE `menu_id` = 4023
  11. OR `perms` = 'cc:txasrbridgeconf:view'
  12. OR `url` = '/cc/fsconf/txasrbridgeconf';
  13. 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`)
  14. VALUES (4023, '腾讯ASR配置', 'txAsrBridgeConf', 3018, 8, '/cc/fsconf/txasrbridgeconf', 'menuItem', 'C', '0', '1', 'cc:txasrbridgeconf:view', '#', 'admin', NOW(), 'mod_tx_asr 参数配置菜单');
  15. INSERT INTO `sys_role_menu` (`role_id`, `menu_id`)
  16. VALUES (2, 4023);
  17. DELETE FROM `fs_variables`
  18. WHERE `var_field_name` IN (
  19. 'appid',
  20. 'secret-id',
  21. 'secret-key',
  22. 'websocket-host',
  23. 'engine-model-type',
  24. 'voice-format',
  25. 'need-vad',
  26. 'filter-dirty',
  27. 'filter-modal',
  28. 'filter-punc',
  29. 'filter-empty-result',
  30. 'convert-num-mode',
  31. 'word-info',
  32. 'vad-silence-time',
  33. 'max-speak-time',
  34. 'hotword-id',
  35. 'hotword-list',
  36. 'customization-id',
  37. 'noise-threshold',
  38. 'signature-expire-seconds'
  39. )
  40. AND `cat` = 5;
  41. INSERT INTO `fs_variables` (`id`, `cat`, `var_field_name`, `var_field_alias`) VALUES
  42. (400, 5, 'appid', '腾讯 ASR AppID'),
  43. (401, 5, 'secret-id', '腾讯 ASR SecretId'),
  44. (402, 5, 'secret-key', '腾讯 ASR SecretKey'),
  45. (403, 5, 'websocket-host', 'WebSocket Host'),
  46. (404, 5, 'engine-model-type', '引擎模型'),
  47. (405, 5, 'voice-format', '音频编码格式'),
  48. (406, 5, 'need-vad', '启用 VAD'),
  49. (407, 5, 'filter-dirty', '脏词过滤'),
  50. (408, 5, 'filter-modal', '语气词过滤'),
  51. (409, 5, 'filter-punc', '标点过滤'),
  52. (410, 5, 'filter-empty-result', '过滤空识别结果'),
  53. (411, 5, 'convert-num-mode', '数字转换模式'),
  54. (412, 5, 'word-info', '词级时间戳'),
  55. (413, 5, 'vad-silence-time', '句尾静音时长(毫秒)'),
  56. (414, 5, 'max-speak-time', '强制断句时长(毫秒)'),
  57. (415, 5, 'hotword-id', '热词表 ID'),
  58. (416, 5, 'hotword-list', '临时热词表'),
  59. (417, 5, 'customization-id', '自学习模型 ID'),
  60. (418, 5, 'noise-threshold', '噪音阈值'),
  61. (419, 5, 'signature-expire-seconds', '签名有效期(秒)');
  62. DELETE FROM `cc_asr_languages`
  63. WHERE `asr_provider` = 'tx';
  64. INSERT INTO `cc_asr_languages` (`asr_provider`, `models`, `language_code`, `language_name`) VALUES
  65. ('tx', '8k_zh', 'zh-CN', '中文(8k)'),
  66. ('tx', '16k_zh', 'zh-CN', '中文(16k)'),
  67. ('tx', '8k_en', 'en-US', '英文(8k)'),
  68. ('tx', '16k_en', 'en-US', '英文(16k)'),
  69. ('tx', '16k_yue', 'zh-HK', '粤语');
  70. UPDATE `cc_params`
  71. SET `param_name` = '双向asr语音识别,使用哪个asr引擎(chinatelecom/funasr/aliyun/ali/tx)'
  72. WHERE `param_code` = 'fs_call_asr_engine';