v20260715_vt_voiceclone.sql 1.5 KB

12345678910111213141516171819202122232425262728293031323334
  1. -- 2026-07-15
  2. -- Add ViiTorTTS voice clone menu and permissions.
  3. DELETE FROM `sys_role_menu`
  4. WHERE `menu_id` IN (4034, 4035);
  5. DELETE FROM `sys_menu`
  6. WHERE `menu_id` IN (4034, 4035)
  7. OR `perms` IN ('aicall:vtvoiceclone:view', 'aicall:vtvoiceclone:registerVoice')
  8. OR `url` = '/aicall/vtvoiceclone/voiceclone';
  9. INSERT INTO `sys_menu`
  10. (`menu_id`, `menu_name`, `menu_code`, `parent_id`, `order_num`, `url`, `target`, `menu_type`, `visible`, `is_refresh`, `perms`, `icon`, `create_by`, `create_time`, `remark`)
  11. VALUES
  12. (4034, 'ViiTorTTS音色注册', 'vtvoiceclone', 3019, 12, '/aicall/vtvoiceclone/voiceclone', 'menuItem', 'C', '0', '1', 'aicall:vtvoiceclone:view', 'fa fa-microphone', 'admin', NOW(), 'ViiTorTTS音色注册工具');
  13. INSERT INTO `sys_menu`
  14. (`menu_id`, `menu_name`, `menu_code`, `parent_id`, `order_num`, `url`, `target`, `menu_type`, `visible`, `is_refresh`, `perms`, `icon`, `create_by`, `create_time`, `remark`)
  15. VALUES
  16. (4035, 'ViiTorTTS音色注册提交', 'vtvoicecloneRegister', 4032, 1, '#', '', 'F', '0', '1', 'aicall:vtvoiceclone:registerVoice', '#', 'admin', NOW(), 'ViiTorTTS音色注册提交权限');
  17. INSERT INTO `sys_role_menu` (`role_id`, `menu_id`)
  18. VALUES
  19. (2, 4034),
  20. (2, 4035);
  21. DELETE FROM `cc_tts_aliyun`
  22. WHERE `voice_code` = 'juvenile'
  23. AND `voice_source` = 'vt_tts';
  24. INSERT INTO `cc_tts_aliyun`
  25. (`voice_name`, `voice_code`, `voice_enabled`, `voice_source`, `priority`, `provider`, `language_code`, `language_name`, `tts_models`)
  26. VALUES
  27. ('ViiTor默认女声 - juvenile', 'juvenile', 1, 'vt_tts', 0, 'vt_tts', 'zh-CN', '中文', 'standard');