easycallcenter365-gui-dev/sql/v1.0.5.sql

-- 2026-02-28
INSERT INTO `cc_params` VALUES ('101', 'freeswitch根目录', 'freeswitch_root', '/home/freeswitch', 'sys', '0', '1');

-- 2026-03-16
INSERT INTO `cc_llm_agent_provider` VALUES ('8', 'ChatGPT', '对接openai的ChatGPT模型');
INSERT INTO `cc_llm_agent_provider` VALUES ('9', 'ClaudeChat', '对接anthropic的Claude模型');

-- 2026-03-19
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`,`update_by`,`update_time`,`remark`)
VALUES (4010,'亚马逊ASR配置','awsAsrConf',3018,6,'/cc/fsconf/awsasrconf','menuItem','C','0','1','cc:awsasrconf:view','#','admin',NOW(),'admin',NOW(),'');

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`,`update_by`,`update_time`,`remark`)
VALUES (4011,'亚马逊TTS配置','awsTtsConf',3019,6,'/cc/fsconf/awsttsconf','menuItem','C','0','1','cc:awsttsconf:view','#','admin',NOW(),'admin',NOW(),'');

INSERT INTO `sys_config` VALUES ('25', '亚马逊', 'config_asr_provider_aws', 'aws', 'Y', 'admin', NOW(), '', NULL, 'ASR厂商-亚马逊');
INSERT INTO `sys_config` VALUES ('34', '亚马逊', 'config_tts_provider_aws', 'aws_tts', 'Y', 'admin', NOW(), '', NULL, 'TTS厂商-亚马逊');

ALTER TABLE cc_tts_aliyun ADD COLUMN language_code VARCHAR(32) DEFAULT '' NOT NULL COMMENT 'Language of the voice';
UPDATE cc_tts_aliyun SET language_code = 'zh-CN' WHERE language_code = '';
INSERT INTO `cc_tts_aliyun` ( `voice_name`, `voice_code`, `voice_enabled`, `voice_source`, `priority`, `provider`, language_code)
VALUES ('Danielle','Danielle','1','aws_tts','1','aws', 'en-US') ;
INSERT INTO `cc_tts_aliyun` ( `voice_name`, `voice_code`, `voice_enabled`, `voice_source`, `priority`, `provider`, language_code)
VALUES ('Gregory','Gregory','1','aws_tts','1','aws', 'en-US') ;
INSERT INTO `cc_tts_aliyun` ( `voice_name`, `voice_code`, `voice_enabled`, `voice_source`, `priority`, `provider`, language_code)
VALUES ('Ivy','Ivy','1','aws_tts','1','aws', 'en-US') ;
INSERT INTO `cc_tts_aliyun` ( `voice_name`, `voice_code`, `voice_enabled`, `voice_source`, `priority`, `provider`, language_code)
VALUES ('Kendra','Kendra','1','aws_tts','1','aws', 'en-US') ;
INSERT INTO `cc_tts_aliyun` ( `voice_name`, `voice_code`, `voice_enabled`, `voice_source`, `priority`, `provider`, language_code)
VALUES ('Kimberly','Kimberly','1','aws_tts','1','aws', 'en-US') ;
INSERT INTO `cc_tts_aliyun` ( `voice_name`, `voice_code`, `voice_enabled`, `voice_source`, `priority`, `provider`, language_code)
VALUES ('Céline/Celine','Céline/Celine','1','aws_tts','1','aws', 'fr-FR') ;
INSERT INTO `cc_tts_aliyun` ( `voice_name`, `voice_code`, `voice_enabled`, `voice_source`, `priority`, `provider`, language_code)
VALUES ('Léa','Léa','1','aws_tts','1','aws', 'fr-FR') ;
INSERT INTO `cc_tts_aliyun` ( `voice_name`, `voice_code`, `voice_enabled`, `voice_source`, `priority`, `provider`, language_code)
VALUES ('Mathieu','Mathieu','1','aws_tts','1','aws', 'fr-FR') ;
INSERT INTO `cc_tts_aliyun` ( `voice_name`, `voice_code`, `voice_enabled`, `voice_source`, `priority`, `provider`, language_code)
VALUES ('Rémi','Rémi','1','aws_tts','1','aws', 'fr-FR') ;
INSERT INTO `cc_tts_aliyun` ( `voice_name`, `voice_code`, `voice_enabled`, `voice_source`, `priority`, `provider`, language_code)
VALUES ('Conchita','Conchita','1','aws_tts','1','aws', 'es-ES') ;
INSERT INTO `cc_tts_aliyun` ( `voice_name`, `voice_code`, `voice_enabled`, `voice_source`, `priority`, `provider`, language_code)
VALUES ('Lucia','Lucia','1','aws_tts','1','aws', 'es-ES') ;
INSERT INTO `cc_tts_aliyun` ( `voice_name`, `voice_code`, `voice_enabled`, `voice_source`, `priority`, `provider`, language_code)
VALUES ('Alba','Alba','1','aws_tts','1','aws', 'es-ES') ;
INSERT INTO `cc_tts_aliyun` ( `voice_name`, `voice_code`, `voice_enabled`, `voice_source`, `priority`, `provider`, language_code)
VALUES ('Enrique','Enrique','1','aws_tts','1','aws', 'es-ES') ;
INSERT INTO `cc_tts_aliyun` ( `voice_name`, `voice_code`, `voice_enabled`, `voice_source`, `priority`, `provider`, language_code)
VALUES ('Sergio','Sergio','1','aws_tts','1','aws', 'es-ES') ;
INSERT INTO `cc_tts_aliyun` ( `voice_name`, `voice_code`, `voice_enabled`, `voice_source`, `priority`, `provider`, language_code)
VALUES ('Zhiyu','Zhiyu','1','aws_tts','1','aws', 'cmn-CN') ;
INSERT INTO `cc_tts_aliyun` ( `voice_name`, `voice_code`, `voice_enabled`, `voice_source`, `priority`, `provider`, language_code)
VALUES ('Hiujin','Hiujin','1','aws_tts','1','aws', 'yue-CN') ;

INSERT INTO `sys_config` VALUES ('41', '阿里云tts语言设置', 'config_tts_language_aliyun_tts', '{"zh-CN":"中文"}', 'Y', 'admin', NOW(), '', NULL, '阿里云tts语言设置');
INSERT INTO `sys_config` VALUES ('42', '豆包tts语言设置', 'config_tts_language_doubao_vcl_tts', '{"zh-CN":"中文"}', 'Y', 'admin', NOW(), '', NULL, '豆包tts语言设置');
INSERT INTO `sys_config` VALUES ('43', '亚马逊tts语言设置', 'config_tts_language_aws_tts', '{"en-US":"English(en-US)", "fr-FR":"French(fr-FR)", "es-ES":"Spanish(es-ES)", "cmn-CN":"Chinese(cmn-CN)"}', 'Y', 'admin', NOW(), '', NULL, '亚马逊tts语言设置');

INSERT INTO `sys_config` VALUES ('51', '阿里云asr语言设置', 'config_asr_language_aliyun', '{"zh-CN":"中文"}', 'Y', 'admin', NOW(), '', NULL, '阿里云asr语言设置');
INSERT INTO `sys_config` VALUES ('52', '亚马逊asr语言设置', 'config_asr_language_aws', '{"en-US":"English(en-US)", "fr-FR":"French(fr-FR)", "es-ES":"Spanish(es-ES)", "zh-CN":"Chinese(zh-CN)"}', 'Y', 'admin', NOW(), '', NULL, '亚马逊asr语言设置');

ALTER TABLE cc_inbound_llm_account DROP COLUMN language_code;
ALTER TABLE cc_inbound_llm_account ADD COLUMN asr_language_code VARCHAR(32) DEFAULT '' NOT NULL COMMENT 'Language of the asr';
UPDATE cc_inbound_llm_account SET asr_language_code = 'zh-CN' WHERE asr_language_code = '';
ALTER TABLE cc_inbound_llm_account ADD COLUMN tts_language_code VARCHAR(32) DEFAULT '' NOT NULL COMMENT 'Language of the tts';
UPDATE cc_inbound_llm_account SET tts_language_code = 'zh-CN' WHERE tts_language_code = '';

ALTER TABLE cc_ivr DROP COLUMN language_code;
ALTER TABLE cc_ivr ADD COLUMN tts_language_code VARCHAR(32) DEFAULT '' NOT NULL COMMENT 'Language of the tts';
UPDATE cc_ivr SET tts_language_code = 'zh-CN' WHERE tts_language_code = '';

ALTER TABLE cc_call_task DROP COLUMN language_code;
ALTER TABLE cc_call_task ADD COLUMN asr_language_code VARCHAR(32) DEFAULT '' NOT NULL COMMENT 'Language of the asr';
UPDATE cc_call_task SET asr_language_code = 'zh-CN' WHERE asr_language_code = '';
ALTER TABLE cc_call_task ADD COLUMN tts_language_code VARCHAR(32) DEFAULT '' NOT NULL COMMENT 'Language of the tts';
UPDATE cc_call_task SET tts_language_code = 'zh-CN' WHERE tts_language_code = '';

-- 2026-03-22
INSERT INTO `cc_llm_agent_provider` VALUES ('10', 'LocalWavFile', '对接本地模型接口-播放录音文件');

-- 2026-03-25
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`,`update_by`,`update_time`,`remark`) values (4001,'防火墙管理','firewalld',2000,0,'/system/firewalld','menuItem','C','0','1','system:firewalld:view','#','admin','2025-04-21 16:08:39','admin','2025-05-05 13:00:39','');
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`,`update_by`,`update_time`,`remark`) values (4002,'防火墙管理-添加','firewalldAdd',4001,1,'#','','F','0','1','system:firewalld:add','#','admin','2025-04-21 16:08:41','',NULL,'');
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`,`update_by`,`update_time`,`remark`) values (4003,'防火墙管理-修改','firewalldEdit',4001,2,'#','','F','0','1','system:firewalld:edit','#','admin','2025-04-21 16:08:44','',NULL,'');
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`,`update_by`,`update_time`,`remark`) values (4004,'防火墙管理-删除','firewalldDel',4001,3,'#','','F','0','1','system:firewalld:remove','#','admin','2025-04-21 16:08:45','',NULL,'');


-- 2026-03-31
INSERT INTO `cc_params` VALUES ('102', '客户未说话静默时长', 'max-wait-time-customer-speaking', '7000', 'sys', '0', '1');

-- 2026-04-02
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`,`update_by`,`update_time`,`remark`)
VALUES (4020,'Deepgram ASR配置','deepgramAsrConf',3018,6,'/cc/fsconf/deepgramasrconf','menuItem','C','0','1','cc:deepgramasrconf:view','#','admin',NOW(),'admin',NOW(),'');

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`,`update_by`,`update_time`,`remark`)
VALUES (4021,'Deepgram TTS配置','deepgramTtsConf',3019,6,'/cc/fsconf/deepgramttsconf','menuItem','C','0','1','cc:deepgramttsconf:view','#','admin',NOW(),'admin',NOW(),'');

INSERT INTO `sys_config` VALUES ('26', 'Deepgram', 'config_asr_provider_deepgram', 'deepgram', 'Y', 'admin', NOW(), '', NULL, 'ASR厂商-deepgram');
INSERT INTO `sys_config` VALUES ('35', 'Deepgram', 'config_tts_provider_deepgram', 'deepgram_tts', 'Y', 'admin', NOW(), '', NULL, 'TTS厂商-deepgram');

INSERT INTO `sys_config` VALUES ('44', 'Deepgramtts语言设置', 'config_tts_language_deepgram_tts', '{"en-us":"English(en-us)", "es-es":"Spanish(es-es)", "fr-fr":"French(fr-fr)", "ja-jp":"Japanese(ja-jp)"}', 'Y', 'admin', NOW(), '', NULL, 'Deepgram tts语言设置');
INSERT INTO `sys_config` VALUES ('53', 'Deepgramasr语言设置', 'config_asr_language_deepgram', '{"en-US":"English(en-US)", "zh-CN":"Chinese(zh-CN)", "es":"Spanish(es)", "fr":"French(fr)", "ja":"Japanese(ja)"}', 'Y', 'admin', NOW(), '', NULL, 'Deepgram asr语言设置');

INSERT INTO `cc_tts_aliyun` ( `voice_name`, `voice_code`, `voice_enabled`, `voice_source`, `priority`, `provider`, language_code)
VALUES ('thalia','thalia','1','deepgram_tts','1','deepgram', 'en-us') ;

INSERT INTO `cc_tts_aliyun` ( `voice_name`, `voice_code`, `voice_enabled`, `voice_source`, `priority`, `provider`, language_code)
VALUES ('andromeda','andromeda','1','deepgram_tts','1','deepgram', 'en-us') ;

INSERT INTO `cc_tts_aliyun` ( `voice_name`, `voice_code`, `voice_enabled`, `voice_source`, `priority`, `provider`, language_code)
VALUES ('helena','helena','1','deepgram_tts','1','deepgram', 'en-us') ;

INSERT INTO `cc_tts_aliyun` ( `voice_name`, `voice_code`, `voice_enabled`, `voice_source`, `priority`, `provider`, language_code)
VALUES ('apollo','apollo','1','deepgram_tts','1','deepgram', 'en-us') ;

INSERT INTO `cc_tts_aliyun` ( `voice_name`, `voice_code`, `voice_enabled`, `voice_source`, `priority`, `provider`, language_code)
VALUES ('arcas','arcas','1','deepgram_tts','1','deepgram', 'en-us') ;

INSERT INTO `cc_tts_aliyun` ( `voice_name`, `voice_code`, `voice_enabled`, `voice_source`, `priority`, `provider`, language_code)
VALUES ('aries','aries','1','deepgram_tts','1','deepgram', 'en-us') ;

INSERT INTO `cc_tts_aliyun` ( `voice_name`, `voice_code`, `voice_enabled`, `voice_source`, `priority`, `provider`, language_code)
VALUES ('nestor','nestor','1','deepgram_tts','1','deepgram', 'es-es') ;

INSERT INTO `cc_tts_aliyun` ( `voice_name`, `voice_code`, `voice_enabled`, `voice_source`, `priority`, `provider`, language_code)
VALUES ('carina','carina','1','deepgram_tts','1','deepgram', 'es-es') ;

INSERT INTO `cc_tts_aliyun` ( `voice_name`, `voice_code`, `voice_enabled`, `voice_source`, `priority`, `provider`, language_code)
VALUES ('alvaro','alvaro','1','deepgram_tts','1','deepgram', 'es-es') ;

INSERT INTO `cc_tts_aliyun` ( `voice_name`, `voice_code`, `voice_enabled`, `voice_source`, `priority`, `provider`, language_code)
VALUES ('diana','diana','1','deepgram_tts','1','deepgram', 'es-es') ;

INSERT INTO `cc_tts_aliyun` ( `voice_name`, `voice_code`, `voice_enabled`, `voice_source`, `priority`, `provider`, language_code)
VALUES ('agathe','agathe','1','deepgram_tts','1','deepgram', 'fr-fr') ;

INSERT INTO `cc_tts_aliyun` ( `voice_name`, `voice_code`, `voice_enabled`, `voice_source`, `priority`, `provider`, language_code)
VALUES ('hector','hector','1','deepgram_tts','1','deepgram', 'fr-fr') ;

INSERT INTO `cc_tts_aliyun` ( `voice_name`, `voice_code`, `voice_enabled`, `voice_source`, `priority`, `provider`, language_code)
VALUES ('uzume','uzume','1','deepgram_tts','1','deepgram', 'ja-jp') ;

INSERT INTO `cc_tts_aliyun` ( `voice_name`, `voice_code`, `voice_enabled`, `voice_source`, `priority`, `provider`, language_code)
VALUES ('ebisu','ebisu','1','deepgram_tts','1','deepgram', 'ja-jp') ;

INSERT INTO `cc_tts_aliyun` ( `voice_name`, `voice_code`, `voice_enabled`, `voice_source`, `priority`, `provider`, language_code)
VALUES ('fujin','fujin','1','deepgram_tts','1','deepgram', 'ja-jp') ;

INSERT INTO `cc_tts_aliyun` ( `voice_name`, `voice_code`, `voice_enabled`, `voice_source`, `priority`, `provider`, language_code)
VALUES ('izanami','izanami','1','deepgram_tts','1','deepgram', 'ja-jp') ;



-- 2026-04-07
ALTER TABLE cc_tts_aliyun ADD COLUMN language_name VARCHAR(255) DEFAULT '' NOT NULL COMMENT 'Language name of the voice';
ALTER TABLE cc_tts_aliyun ADD COLUMN tts_models VARCHAR(32) DEFAULT '' NOT NULL COMMENT 'Models of the voice';
UPDATE cc_tts_aliyun SET language_name = '中文' WHERE language_code = 'zh-CN';

ALTER TABLE cc_inbound_llm_account ADD COLUMN asr_models VARCHAR(32) DEFAULT '' NOT NULL COMMENT 'Models of the asr';
ALTER TABLE cc_inbound_llm_account ADD COLUMN tts_models VARCHAR(32) DEFAULT '' NOT NULL COMMENT 'Models of the tts';

ALTER TABLE cc_ivr ADD COLUMN tts_models VARCHAR(32) DEFAULT '' NOT NULL COMMENT 'Models of the tts';

ALTER TABLE cc_call_task ADD COLUMN asr_models VARCHAR(32) DEFAULT '' NOT NULL COMMENT 'Models of the asr';
ALTER TABLE cc_call_task ADD COLUMN tts_models VARCHAR(32) DEFAULT '' NOT NULL COMMENT 'Models of the tts';

ALTER TABLE his_cc_call_task ADD COLUMN asr_language_code VARCHAR(32) DEFAULT '' NOT NULL COMMENT 'Language of the asr';
ALTER TABLE his_cc_call_task ADD COLUMN tts_language_code VARCHAR(32) DEFAULT '' NOT NULL COMMENT 'Language of the tts';
ALTER TABLE his_cc_call_task ADD COLUMN asr_models VARCHAR(32) DEFAULT '' NOT NULL COMMENT 'Models of the asr';
ALTER TABLE his_cc_call_task ADD COLUMN tts_models VARCHAR(32) DEFAULT '' NOT NULL COMMENT 'Models of the tts';


DROP TABLE IF EXISTS cc_asr_languages;
CREATE TABLE `cc_asr_languages` (
                                    `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT 'id',
                                    `asr_provider` VARCHAR(32) NOT NULL DEFAULT '' COMMENT 'provider of asr',
                                    `models` VARCHAR(32) NOT NULL DEFAULT '' COMMENT 'models of asr',
                                    `language_code` VARCHAR(32) NOT NULL DEFAULT '' COMMENT 'language code',
                                    `language_name` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'language name',
                                    PRIMARY KEY (`id`)
) ENGINE=INNODB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;


INSERT  INTO `cc_params`(`id`,`param_name`,`param_code`,`param_value`,`param_type`,`hide_value`,`allow_edit`) VALUES (1231316,'firewalld 防火墙配置文件路径','firewalld-config-path','/etc/firewalld/zones/public.xml','sys',0,1);
INSERT  INTO `cc_params`(`id`,`param_name`,`param_code`,`param_value`,`param_type`,`hide_value`,`allow_edit`) VALUES (1231317,'重启firewalld防火墙的命令','firewalld-restart-cmd','/usr/bin/systemctl  restart firewalld','sys',0,1);
INSERT  INTO `cc_params`(`id`,`param_name`,`param_code`,`param_value`,`param_type`,`hide_value`,`allow_edit`) VALUES (1231318,'是否启用firewalld防护墙','firewalld-enabled','true','sys',0,1);
INSERT  INTO `cc_params`(`id`,`param_name`,`param_code`,`param_value`,`param_type`,`hide_value`,`allow_edit`) VALUES (1231319,'呼入ip白名单(用于外部线路呼入)','fs-inbound-allow-ip-list','192.168.67.110\r\n192.168.67.120','sys',0,1);
INSERT  INTO `cc_params`(`id`,`param_name`,`param_code`,`param_value`,`param_type`,`hide_value`,`allow_edit`) VALUES (1231320,'分机注册的白名单 ','fs-register-allow-ip-list','192.168.67.110\r\n192.168.67.120','sys',0,1);
INSERT  INTO `cc_params`(`id`,`param_name`,`param_code`,`param_value`,`param_type`,`hide_value`,`allow_edit`) VALUES (1231321,'是否启用freeswitch的分机注册防护','fs-register-acl-enabled','true','sys',0,1);