callcenter-private-master/sql-scripts/clear.txt

1. clear database tables;

truncate table  cc_call_phone;
truncate table  cc_call_task;
-- truncate table  cc_gateways;
truncate table  cc_inbound_cdr;
-- truncate table  cc_inbound_llm_account;
-- truncate table  cc_llm_agent_account;
truncate table  cc_outbound_cdr;
truncate table  sys_oper_log;

SELECT * FROM cc_tts_aliyun  WHERE voice_code LIKE 'S\\_%' ESCAPE '\\';
delete FROM cc_tts_aliyun  WHERE voice_code LIKE 'S\\_%' ESCAPE '\\';

reset master;


2. clear FreeSWITCH configuration files:

   a. update asr configuration:  /cc/fsconf/aliasrconf
   b. update tts configuration:  /cc/fsconf/alittsconf
   c. update tts configuration: /cc/fsconf/doubaottsconf
   
   update above configs via admin web pages.
   
   
3. delete gateway config files:   
   rm -rf /home/freeswitch/etc/freeswitch/sip_profiles/internal/*.xml   
   rm -rf /home/freeswitch/etc/freeswitch/sip_profiles/external/*.xml
    
4. update version info:
   update sys_config set config_value='v20260217' where config_key='sys.version';
   
5. delete all test-user accounts:  
   DELETE from sys_user where user_name <> 'admin';
   
6. delete install_lock file:
   rm -rf /home/freeswitch/etc/freeswitch/autoload_configs/install_lock.data    
   
7. 修改参数管理页面： event-socket-ip 为127.0.0.1