ADD_CLM|trunk_master|max_channel|INT|3|Y|NULL|trunk_out_cid
**
ADD_CLM|trunk_master|disable|INT|1|Y|NULL|max_channel
**
ADD_CLM|company|rec_format|VARCHAR|5|Y|NULL|no_record
**
ADD_CLM|company|rec_api|INT|1|Y|NULL|rec_format
**
ADD_CLM|company|updated_flag|INT|1|Y|NULL|rec_format
**
ADD_CLM|company|rec_ans|INT|1|Y|NULL|rec_api
**
ADD_CLM|company|allow_group|INT|1|Y|NULL|rec_ans
**
ADD_CLM|action_rule|in_rec|INT|1|Y|NULL|caller_id
**
ADD_CLM|action_rule|updated_flag|INT|1|Y|NULL|in_rec
**
ADD_CLM|company|host|INT|1|Y|NULL|show_priority
**
ADD_CLM|company|host_user|VARCHAR|16|Y|NULL|host
**
ADD_CLM|company|ssh_port|INT|5|Y|NULL|host
**
ADD_CLM|company|host_pass|VARCHAR|20|Y|NULL|host_user
**
ADD_CLM|company|email_host|VARCHAR|30|Y|NULL|host_pass
**
ADD_CLM|company|email_port|VARCHAR|4|Y|NULL|email_host
**
ADD_CLM|company|email_user|VARCHAR|100|Y|NULL|email_port
**
ADD_CLM|company|email_pass|VARCHAR|20|Y|NULL|email_user
**
ADD_CLM|company|diaplay_cli_name|INT|1|Y|NULL|allow_group
**
ADD_CLM|company|logo_name|INT|1|Y|NULL|title_prefix 
**
ADD_CLM|company|alert_mail|VARCHAR|50|Y|NULL|title_prefix
**
ADD_CLM|company|hdd_size|INT|3|Y|NULL|alert_mail
**
ADD_CLM|company|max_hdd_size|INT|3|Y|NULL|hdd_size
**
ADD_CLM|company|mail_auth|VARCHAR|5|Y|NULL|hdd_size
**
ADD_CLM|out_route|time_id|INT|11|Y|NULL|out_cid
**
ADD_CLM|out_route|hang_api_id|INT|11|Y|NULL|time_id
**
ADD_CLM|action_rule|rec_ans|INT|1|Y|NULL|in_rec
**
ADD_CLM|action_rule|api_id|INT|11|Y|NULL|rec_ans
**
ADD_CLM|api_master|did|VARCHAR|20|Y|NULL|api
**
ADD_CLM|api_master|callerid|VARCHAR|20|Y|NULL|did
**
ADD_CLM|api_master|exten|VARCHAR|20|Y|NULL|callerid|
**
ADD_CLM|api_master|durn|VARCHAR|20|Y|NULL|callerid|
**
ADD_CLM|api_master|recfile|VARCHAR|20|Y|NULL|durn|
**
ADD_CLM|action_rule|hang_api_id|INT|11|Y|NULL|api_id|
**
ADD_CLM|ivr_rule|api_id|INT|11|Y|NULL|san_value|
**
ADD_CLM|db_schedule|StorageDays|INT|11|Y|NULL|isFTP
**
ADD_CLM|dbbackup|db_schedule_id|INT|1|Y|0|id
**
ADD_CLM|acd_member|memberid|VARCHAR|5|Y|NULL|acd_id
**
ADD_CLM|register_soft|c_call|VARCHAR|100|Y|NULL|no_of_licenses
**
ADD_CLM|register_soft|s_mode|VARCHAR|100|Y|NULL|c_call
**
ADD_CLM|register_soft|web_phone|VARCHAR|100|Y|NULL|s_mode
**
ADD_CLM|register_soft|blaster|VARCHAR|100|Y|NULL|web_phone
**
ADD_CLM|register_soft|conference|VARCHAR|100|Y|NULL|blaster
**
ADD_CLM|register_soft|web_phone|VARCHAR|100|Y|NULL|c_call
**
ADD_CLM|register_soft|is_cluster|INT|11|Y|0|last_checked
**
ADD_CLM|live_call|state_time|DATETIME||Y|NULL|r_status
**
CRT_TBL|exten_rights|`rid` int(11) NOT NULL AUTO_INCREMENT,`exten` varchar(16) NOT NULL,`all_ford` int(1) NOT NULL,`b_ford` int(1) NOT NULL,`n_ford` int(1) NOT NULL,`u_ford` int(1) NOT NULL,`queue_login` int(1) NOT NULL,`blacklist` int(1) NOT NULL,`barge` int(1) NOT NULL,`whisper` int(1) NOT NULL,`conf` int(1) NOT NULL,`exten_id` int(11) NOT NULL,PRIMARY KEY (`rid`) USING BTREE,UNIQUE KEY `exten` (`exten`)
**
CRT_TBL|live_call|`exten` varchar(20) DEFAULT '',`start_time` datetime DEFAULT NULL,`answer_time` datetime DEFAULT NULL,`acd_time` datetime DEFAULT NULL,`Trunk` varchar(30) DEFAULT NULL,`Caller_id` varchar(20) DEFAULT NULL,`status` varchar(20) DEFAULT NULL,`acd` varchar(20) DEFAULT NULL,`call_type` varchar(10) DEFAULT NULL,`did` varchar(16) DEFAULT NULL,`r_status` varchar(15) DEFAULT NULL,`exten_id` int(11) NOT NULL,PRIMARY KEY (`exten_id`) USING BTREE,UNIQUE KEY `exten` (`exten`)
**
CRT_TBL|account_code|`id` int(11) NOT NULL AUTO_INCREMENT,`user_name` varchar(30) NOT NULL,`code` int(10) NOT NULL,`allow_durn` int(5) NOT NULL,`bal_durn` decimal(5,2) NOT NULL,PRIMARY KEY (`id`) USING BTREE,UNIQUE KEY `code` (`code`)
**
ADD_CLM|acd_group|ring_api|INT|11||NULL|rtone
**
ADD_CLM|acd_group|ans_api|INT|11||NULL|ring_api
**
ADD_CLM|acd_group|hang_api|INT|11||NULL|ans_api
**
CRT_TBL|log_setting|`id` int(11) NOT NULL AUTO_INCREMENT,`notice` int(1) NOT NULL,`warning` int(1) NOT NULL,`error` int(1) NOT NULL,`debug` int(1) NOT NULL,`verbose` int(1) NOT NULL,reset_log varchar(20) DEFAULT NULL,del_log varchar(20) DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE
**
QRY|alter table ivr_rule modify column priority varchar(4)
**
CRT_TBL|firewall|`id` int(11) NOT NULL AUTO_INCREMENT,`name` varchar(20) NOT NULL,`rule_type` varchar(10) NOT NULL,`rule_action` varchar(10) NOT NULL,`ip` varchar(20) NOT NULL,`dns` varchar(20) NOT NULL,`protocol` varchar(5) NOT NULL,port_start varchar(10) DEFAULT NULL,port_end varchar(10) DEFAULT NULL,enable int(1) DEFAULT 0,PRIMARY KEY (`id`) USING BTREE
**
QRY|alter table api_master change column api api text
**
ADD_CLM|api_master|noans_api|TEXT|||NULL|api
**
ADD_CLM|user_log|action|VARCHAR|20||NULL|remarks
**
ADD_CLM|user_log|page|VARCHAR|20||NULL|action
**
ADD_CLM|san_voicemail|mail_status|int|1||NULL|maxdurn
**
ADD_CLM|san_voicemail|no_msg|int|1||NULL|mail_status
**
CRT_TBL|firewall_status|`id` int(11) NOT NULL AUTO_INCREMENT,`status` INT(1) NOT NULL,PRIMARY KEY (`id`) USING BTREE
**
QRY|insert into firewall_status (id,status) values('1','0') ON DUPLICATE KEY UPDATE status=0;
**
ADD_CLM|sip_setting|sip_port|int|6||NULL|g729
**
CRT_TBL|pri|`id` int(11) NOT NULL AUTO_INCREMENT,`card_port` int(2) NOT NULL,`context` varchar(30) NOT NULL,`switchtype` varchar(20) NOT NULL,`signalling` varchar(10) NOT NULL, `framing` varchar(10) NOT NULL,`channels` varchar(30) NOT NULL,`d_channel` varchar(20) DEFAULT NULL,`group`varchar(10) DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE,UNIQUE KEY `card_port` (`card_port`)
**
CRT_TBL|san_voicemail|`id` int(11) NOT NULL AUTO_INCREMENT,`context` varchar(20) NOT NULL DEFAULT '',`exten` varchar(20) DEFAULT '',`priority` tinyint(4) DEFAULT '0',`app` varchar(20) NOT NULL DEFAULT '',`appdata` varchar(128) NOT NULL DEFAULT '',`description` varchar(100) DEFAULT NULL,`san_app` varchar(20) DEFAULT NULL,`san_value` varchar(200) DEFAULT NULL,`password` varchar(20) DEFAULT NULL,`email` varchar(30) DEFAULT NULL,`attach` int(1) DEFAULT NULL,`delete_mail` int(1) DEFAULT '1',`maxmsg` int(4) DEFAULT '100',`maxdurn` int(4) DEFAULT '300',`mail_status` int(1) DEFAULT NULL,`no_msg` int(1) DEFAULT NULL,`exten_id` int(11) DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE
**
CRT_TBL|voicemailmessages|`id` int(11) NOT NULL AUTO_INCREMENT,`origtime` datetime NOT NULL,`mailboxuser` varchar(16) DEFAULT '',`callerid` varchar(40) DEFAULT '',`recording` varchar(100) DEFAULT NULL,`duration` varchar(20) DEFAULT '',`flag` varchar(20) DEFAULT '',PRIMARY KEY (`id`)
**
COM|02-02-2019
**
ADD_CLM|company|block_intercom|INT|1|Y|NULL|max_hdd_size
**
QRY|alter table trunk_master modify column trunk_out_cid varchar(16)
**
QRY|insert into fcode (code,application,context,is_edit,updated_flag) values('*7','Extension Call Pickup','exten-pickup',1,1) ON DUPLICATE KEY UPDATE updated_flag=0;
**
ADD_CLM|ivr|check_account|INT|1|Y|NULL|directDial
**
ADD_CLM|voicemailmessages|accountcode|VARCHAR|10|Y|NULL|callerid
**
ADD_CLM|account_code|description|VARCHAR|50|Y|NULL|code
**
ADD_CLM|account_code|user_number|VARCHAR|20|Y|NULL|description
**
ADD_CLM|account_code|user_rank|VARCHAR|20|Y|NULL|user_number
**
ADD_CLM|exten_rights|block_intercom|INT|1|Y|NULL|conf
**
CRT_TBL|san_dnd|`id` int(11) NOT NULL AUTO_INCREMENT,`context` varchar(20) NOT NULL DEFAULT '',`exten` varchar(20) DEFAULT '',`priority` tinyint(4) DEFAULT '0',`app` varchar(20) NOT NULL DEFAULT '',`appdata` varchar(50) NOT NULL,PRIMARY KEY (`id`) USING BTREE,UNIQUE KEY `exten` (`exten`)
**
QRY|insert into san_dnd(context,exten,priority,app,appdata) values('san-dnd','_X.','1','Return','') ON DUPLICATE KEY UPDATE appdata=''
**
ADD_CLM|out_route_rule|rec_folder|VARCHAR|20|Y|NULL|match_pattern
**
ADD_CLM|action_rule|rec_folder|VARCHAR|20|Y|NULL|hang_api_id
**
ADD_CLM|action_rule|user_group|INT|11|Y|NULL|rec_folder
**
ADD_CLM|ivr_rule|user_group|INT|11|Y|NULL|api_id
**
ADD_CLM|company|dial_intercom_trunk|INT|1|Y|NULL|max_hdd_size
**
COM|14-02-2019
**
COM|20-02-2019
**
ADD_CLM|exten_rights|dynamic_lock|VARCHAR|4|Y|NULL|block_intercom
**
QRY|insert into fcode (code,application,context,is_edit,updated_flag) values('*9','Dynamic Lock','dynamic-lock','1','1') ON DUPLICATE KEY UPDATE updated_flag=0;
**
QRY|insert into fcode (code,application,context,is_edit,updated_flag) values('*1','Personal Speed Dial','personal-memory','1','1') ON DUPLICATE KEY UPDATE updated_flag=0;
**
QRY|insert into fcode (code,application,context,is_edit,updated_flag) values('*2','Add Personal Speed Dial','personal-memory-add','1','1') ON DUPLICATE KEY UPDATE updated_flag=0;
**
CRT_TBL|speed_dial_personal|`id` int(11) NOT NULL AUTO_INCREMENT,`context` varchar(20) NOT NULL DEFAULT '',`exten` varchar(20) DEFAULT '',`priority` tinyint(4) DEFAULT '0',`app` varchar(20) NOT NULL DEFAULT '',`appdata` varchar(128) NOT NULL DEFAULT '',`dial_code` varchar(3),`exten_name` varchar(20) DEFAULT '',`number` varchar(20) DEFAULT '',`exten_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE
**
CRT_TBL|user_acd_group|`id` int(11) NOT NULL AUTO_INCREMENT,`user_id` int(11) NOT NULL,`acd_group_id` int(11) NOT NULL, PRIMARY KEY (`id`) USING BTREE
**
QRY|insert into fcode (code,application,context,is_edit,updated_flag) values('*3','Change Account Code','update-account','1','1') ON DUPLICATE KEY UPDATE updated_flag=0;
**
COM|27-02-2019
**
ADD_CLM|firewall|ip_to|VARCHAR|20|Y|NULL|ip
**
ADD_CLM|custom_context|exten|VARCHAR|20|Y|NULL|name
**
ADD_CLM|custom_context|content|TEXT||Y|NULL|destination
**
ADD_CLM|address_book|email|VARCHAR|50|Y|NULL|number
**
CRT_TBL|sticky_route|`id` int(11) NOT NULL AUTO_INCREMENT,`context` varchar(20) NOT NULL DEFAULT '',`exten` varchar(20) DEFAULT '',`priority` tinyint(4) DEFAULT '0',`app` varchar(20) NOT NULL DEFAULT '',`appdata` varchar(128) NOT NULL DEFAULT '',`name` varchar(20) DEFAULT '',`san_app` varchar(20) DEFAULT '',`san_value` varchar(200) DEFAULT '',check_did int(1) DEFAULT '0',e_template int(11) DEFAULT '0',sms_template int(11) DEFAULT '0',api int(11) DEFAULT '0',PRIMARY KEY (`id`) USING BTREE
**
CRT_TBL|sticky_mapping|`id` int(11) NOT NULL AUTO_INCREMENT,`number` varchar(16) NOT NULL DEFAULT '',`did` varchar(16) DEFAULT '',`dest` varchar(16) DEFAULT '',`call_type` varchar(10) NOT NULL DEFAULT '',`insert_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) USING BTREE
**
CRT_TBL|email_template|`id` int(11) NOT NULL AUTO_INCREMENT,`name` varchar(50) NOT NULL DEFAULT '',`subject` varchar(100) NOT NULL DEFAULT '',`content` varchar(250) DEFAULT '', PRIMARY KEY (`id`) USING BTREE
**
DRP_CLM|acd_group|ans_api
**
DRP_CLM|acd_group|hang_api
**
DRP_CLM|acd_group|ring_api
**
ADD_CLM|acd_group|api|INT|11|Y|0|rtone
**
ADD_CLM|acd_group|email_template|INT|11|Y|0|api
**
ADD_CLM|acd_group|sms_api|INT|11|Y|0|email_template
**
ADD_CLM|out_route|upd_sticky|INT|1|Y|0|hang_api_id
**
ADD_CLM|address_book|email|VARCHAR|50|Y|NULL|number
**
ADD_CLM|action_rule|email_id|varchar|50|Y||user_group
**
ADD_CLM|action_rule|email_template|INT|11|Y|0|email_id
**
CRT_TBL|group_dial|`id` int(11) NOT NULL AUTO_INCREMENT,`context` varchar(20) NOT NULL DEFAULT '',`exten` varchar(20) DEFAULT '',`priority` tinyint(4) DEFAULT '0',`app` varchar(20) NOT NULL DEFAULT '',`appdata` varchar(128) NOT NULL DEFAULT '',name varchar(20) NOT NULL DEFAULT '',`exten_group` int(11) DEFAULT NULL,`allow_record` int(1) DEFAULT 0, `sound` varchar(255) DEFAULT NULL,`drop_after_annou` INT(1) DEFAULT 0, PRIMARY KEY (`id`) USING BTREE, KEY `exten` (`exten`)
**
CRT_TBL|group_dial_exten|`id` int(11) NOT NULL AUTO_INCREMENT,`group_code` varchar(10) NOT NULL DEFAULT '',`exten` varchar(16) NOT NULL DEFAULT '', PRIMARY KEY (`id`) USING BTREE
**
ADD_CLM|sip_extension|subscribecontext|VARCHAR|20|Y|NULL|transport
**
ADD_CLM|users_master|allowedReports|TExT||Y|NULL|download_recording
**
ADD_CLM|users_master|extension|INT|11|Y|NULL|allowedReports
**
ADD_CLM|users_master|allow_barge|INT|1|Y|0|extension
**
ADD_CLM|users_master|allow_whisper|INT|1|0|NULL|allow_barge
**
ADD_CLM|users_master|allow_hang|INT|1|0|NULL|allow_whisper
**
COM|PJSIP
**
ADD_CLM|company|exten_type|VARCHAR|10|Y|NULL|dial_intercom_trunk
**
COM|PJSIP
**
ADD_CLM|conference_master|conf_date|date||Y|NULL|p_name
**
ADD_CLM|conference_master|conf_start_hh|VARCHAR|2|Y|NULL|conf_date
**
ADD_CLM|conference_master|conf_start_mm|VARCHAR|2|Y|NULL|conf_start_hh
**
ADD_CLM|conference_master|conf_end_date|date||Y|NULL|conf_start_hh
**
ADD_CLM|conference_master|conf_end_hh|VARCHAR|2|Y|NULL|conf_end_date
**
ADD_CLM|conference_master|conf_end_mm|VARCHAR|2|Y|NULL|conf_end_hh
**
DRP_CLM|conference_master|end_time_hh
**
DRP_CLM|conference_master|end_time_mm
**
DRP_CLM|conference_master|week_start_day
**
DRP_CLM|conference_master|week_end_day
**
DRP_CLM|conference_master|month_start_dayay
**
DRP_CLM|conference_master|month_end_day
**
DRP_CLM|conference_master|month_start
**
DRP_CLM|conference_master|month_end
**
DRP_CLM|conference_master|time_group_id
**
CRT_TBL|conference_member|`id` int(11) NOT NULL AUTO_INCREMENT,`context` varchar(20) NOT NULL DEFAULT '',`exten` varchar(20) NOT NULL DEFAULT '',`priority` INT(11) NOT NULL DEFAULT '1',`app` VARCHAR(20) NOT NULL DEFAULT '',`appdata` VARCHAR(128) NOT NULL DEFAULT '',`member` VARCHAR(20) NOT NULL DEFAULT '',`member_type` VARCHAR(5) NOT NULL DEFAULT '',`conf_id` INT(11) NOT NULL, PRIMARY KEY (`id`) USING BTREE
**
ADD_CLM|sip_san|exten_email|VARCHAR|50|Y|NULL|san_moh
**
ADD_CLM|sip_san|address|VARCHAR|200|Y|NULL|email
**
ADD_CLM|sticky_mapping|call_type|VARCHAR|20|Y|NULL|dest
**
ADD_CLM|account_code|upd_pass|INT|1|Y|0|bal_durn
**
QRY|alter table speed_dial_personal modify column exten_id varchar(11)
**
ADD_CLM|acd_group|announce_position|VARCHAR|5|Y|NULL|announce_frequency
**
ADD_CLM|company|local_len|INT|11|Y|10|allow_group
**
ADD_CLM|company|std_len|INT|11|Y|11|local_len
**
ADD_CLM|company|isd_len|INT|11|Y|12|std_len
**
ADD_CLM|account_code|issue_date|DATE||Y|NULL|upd_pass
**
ADD_CLM|account_code|duduct_intercom|INT|1|Y|0|issue_date
**
ADD_CLM|sip_san|allow_exten_durn|INT|10|Y|NULL|sip_tech
**
ADD_CLM|sip_san|bal_exten_durn|INT|10|Y|NULL|allow_exten_durn
**
ADD_CLM|sip_san|bal_issue_date|DATE||Y|NULL|bal_exten_durn
**
ADD_CLM|sip_san|is_prepaid|INT|1|Y|NULL|bal_issue_date
**
CRT_TBL|ps_aors|`san_id` int(11) NOT NULL AUTO_INCREMENT,`id` varchar(16) NOT NULL,`max_contacts` INT(11) NOT NULL DEFAULT '1',`remove_existing` VARCHAR(5) DEFAULT NULL,`qualify_frequency` VARCHAR(5) DEFAULT NULL,`qualify_timeout` decimal(3,1) DEFAULT NULL,`authenticate_qualify` VARCHAR(10) DEFAULT 'no',`maximum_expiration` VARCHAR(5) DEFAULT NULL,`conf_id` INT(11) NOT NULL, PRIMARY KEY (`san_id`),UNIQUE KEY `id` (`id`) USING BTREE
**
CRT_TBL|ps_auths|`auths_id` int(11) NOT NULL AUTO_INCREMENT,`id` varchar(16) NOT NULL,`auth_type` varchar(20) DEFAULT NULL,`password` varchar(20) DEFAULT NULL,`username` varchar(20) DEFAULT NULL,`ps_id` int(11) DEFAULT NULL,PRIMARY KEY (`auths_id`),UNIQUE KEY `id` (`id`) USING BTREE
**
CRT_TBL|ps_contacts|`id` varchar(100) DEFAULT NULL,`via_addr` varchar(20) DEFAULT NULL,`qualify_timeout` varchar(16) DEFAULT NULL,`call_id` varchar(100) DEFAULT NULL,`reg_server` varchar(30) DEFAULT NULL,`prune_on_boot` varchar(5) DEFAULT NULL,`path` varchar(50) DEFAULT NULL,`endpoint` varchar(16) DEFAULT NULL,`via_port` varchar(10) DEFAULT NULL,`authenticate_qualify` varchar(50) DEFAULT NULL,`uri` varchar(100) DEFAULT NULL, `qualify_frequency` varchar(5) DEFAULT NULL,`user_agent` varchar(100) DEFAULT NULL,`expiration_time` varchar(100) DEFAULT NULL, `outbound_proxy` varchar(20) DEFAULT NULL 
**
CRT_TBL|ps_endpoints|`endpoints_id` int(11) NOT NULL AUTO_INCREMENT,`id` varchar(16) NOT NULL,`transport` varchar(20) DEFAULT NULL,`aors` varchar(16) DEFAULT NULL,`auth` varchar(16) DEFAULT NULL,`context` varchar(30) DEFAULT NULL,`disallow` varchar(20) DEFAULT NULL,`allow` varchar(20) DEFAULT NULL,`direct_media` varchar(5) DEFAULT NULL,`rtp_keepalive` varchar(5) DEFAULT NULL,`identify_by` varchar(10) DEFAULT NULL,`callerid` varchar(30) DEFAULT NULL,`call_group` varchar(10) DEFAULT NULL,`pickup_group` varchar(10) DEFAULT NULL,`moh_suggest` varchar(50) DEFAULT NULL,`dtmf_mode` varchar(20) DEFAULT NULL,`subscribe_context` varchar(30) DEFAULT NULL,`ps_id` int(11) DEFAULT NULL,PRIMARY KEY (`endpoints_id`),UNIQUE KEY `id` (`id`) USING BTREE
**
QRY|alter table live_call modify column exten_id varchar(11)
**
COM|31-05-2019
**
ADD_CLM|sip_extension|mailbox|VARCHAR|30|Y|NULL|secret
**
ADD_CLM|company|conf_type|VARCHAR|20|Y|NULL|exten_type
**
ADD_CLM|conference_master|conf_type|VARCHAR|20|Y|NULL|active
**
ADD_CLM|company|display_logo|INT|1|Y|0|conf_type
**
ADD_CLM|ps_endpoints|bind_rtp_to_media_address|VARCHAR|5|Y|NULL|subscribe_context
**
ADD_CLM|ps_endpoints|rtp_symmetric|VARCHAR|5|Y|NULL|bind_rtp_to_media_address
**
ADD_CLM|ps_endpoints|force_rport|VARCHAR|5|Y|NULL|rtp_symmetric
**
ADD_CLM|ps_endpoints|rewrite_contact|VARCHAR|5|Y|NULL|force_rport
**
ADD_CLM|ps_endpoints|cos_audio|VARCHAR|5|Y|NULL|rewrite_contact
**
ADD_CLM|ps_endpoints|cos_video|VARCHAR|5|Y|NULL|cos_audio
**
ADD_CLM|ps_endpoints|tos_audio|VARCHAR|5|Y|NULL|cos_video
**
ADD_CLM|ps_endpoints|tos_video|VARCHAR|5|Y|NULL|tos_audio
**
ADD_CLM|ps_endpoints|ice_support|VARCHAR|5|Y|NULL|tos_video
**
ADD_CLM|ps_endpoints|media_use_received_transport|VARCHAR|10|Y|NULL|ice_support
**
ADD_CLM|ps_endpoints|media_address|VARCHAR|20|Y|NULL|media_use_received_transport
**
CRT_TBL|acd_priority|`id` int(11) NOT NULL AUTO_INCREMENT,`context` varchar(20) NOT NULL DEFAULT '',`exten` varchar(20) DEFAULT '',`priority` tinyint(4) DEFAULT '0',`app` varchar(20) NOT NULL DEFAULT '',`appdata` varchar(128) NOT NULL DEFAULT '',priority_id int(11) DEFAULT NULL,UNIQUE KEY `id` (`id`) USING BTREE
**
CRT_TBL|acd_priority_master|`id` int(11) NOT NULL AUTO_INCREMENT,`priority_name` varchar(50) NOT NULL DEFAULT '',`set_priority` int(11) DEFAULT '0',`san_app` varchar(20) NOT NULL DEFAULT '',`san_value` varchar(128) NOT NULL DEFAULT '', UNIQUE KEY `id` (`id`) USING BTREE  
**
COM|wss SIP field
**
ADD_CLM|sip_extension|encryption|VARCHAR|5|Y|no|subscribecontext
**
ADD_CLM|sip_extension|avpf|VARCHAR|5|Y|no|encryption
**
ADD_CLM|sip_extension|force_avp|VARCHAR|5|Y|no|avpf
**
ADD_CLM|sip_extension|icesupport|VARCHAR|5|Y|no|force_avp
**
ADD_CLM|sip_extension|directmedia|VARCHAR|5|Y|no|icesupport
**
ADD_CLM|sip_extension|dtlsenable|VARCHAR|5|Y|NULL|directmedia
**
ADD_CLM|sip_extension|dtlsverify|VARCHAR|20|Y|NULL|dtlsenable
**
ADD_CLM|sip_extension|dtlscertfile|VARCHAR|50|Y|NULL|dtlsverify
**
ADD_CLM|sip_extension|dtlscafile|VARCHAR|50|Y|NULL|dtlscertfile
**
ADD_CLM|sip_extension|dtlssetup|VARCHAR|10|Y|actpass|dtlscafile
**
ADD_CLM|sip_extension|rtcp_mux|VARCHAR|10|Y|no|dtlssetup
**
COM|wss SIP field END
**
CRT_TBL|ercc_code|`ercc_id` int(11) NOT NULL AUTO_INCREMENT,`ercc_code` INT(11) DEFAULT NULL,`ercc_color` varchar(50) DEFAULT NULL, `ercc_desc` varchar(200) DEFAULT NULL, `dial_trunk` varchar(100) DEFAULT NULL,`callerid` varchar(20) DEFAULT '',`retry` int(11) DEFAULT '1',`dial_after` int(11) DEFAULT '1', PRIMARY KEY (`ercc_id`) USING BTREE
**
CRT_TBL|ercc_phone|`ercc_id` int(11) NOT NULL,`ercc_code` INT(11) DEFAULT NULL,`phone_no` varchar(20) DEFAULT NULL, `phone_desc` varchar(200) DEFAULT NULL
**
ALT_CLM|mcode_rule|mcode_id|mcode_id|VARCHAR|10|||appdata
**
COM|For Queue AUTOFILL
**
ALT_CLM|acd_group|ringinuse|ringinuse|VARCHAR|5|Y|NULL|periodic_announce_frequency
**
ADD_CLM|acd_group|autofill|VARCHAR|5|Y|NULL|periodic_announce_frequency
**
ALT_CLM|acd_group|setinterfacevar|setinterfacevar|VARCHAR|5|Y|NULL|ringinuse
**
COM|For Queue AUTOFILL
**
ADD_CLM|company|http_port|INT|6|Y|80|ssh_port
**
COM|08-11-2019
**
ADD_CLM|company|block_logout|INT|1|Y|0|block_intercom
**
ADD_CLM|sip_san|skip_login|INT|1|Y|0|block_intercom
**
ADD_CLM|live_call|logintime|DATETIME||Y|NULL|exten_id
**
ADD_CLM|live_call|agent_name|VARCHAR|50|Y||logintime
**
ADD_CLM|live_call|login_acd|VARCHAR|10|Y|NULL|agent_name
**
ADD_CLM|live_call|called_number|INT|16|Y|NULL|login_acd
**
ADD_CLM|address_book|dial_in_trunk|INT|1|Y|0|recording
**
ADD_CLM|address_book|queue_priority|INT|1|Y|0|dial_in_trunk
**
ADD_CLM|acd_group|check_priority|INT|1|Y|0|sms_api
**
ADD_CLM|users_master|ext_only_report|INT|1|Y|0|extension
**
ADD_CLM|users_master|mask_number|INT|1|Y|0|ext_only_report
**
ADD_CLM|action_rule|remote_dial_prefix|INT|11|Y|NULL|san_value
**
ADD_CLM|company|webhook|VARCHAR|200|Y|NULL|conf_type
**
CRT_TBL|live_channel|`unique_id` VARCHAR(50) NULL DEFAULT NULL,`linked_id` VARCHAR(50) NULL DEFAULT NULL,`trunk_channel` VARCHAR(50) NULL DEFAULT NULL,`exten_channel` VARCHAR(50) NULL DEFAULT NULL,`exten` VARCHAR(20) NULL DEFAULT NULL,`caller_id` VARCHAR(20) NULL DEFAULT NULL,`call_type` VARCHAR(20) NULL DEFAULT NULL,`exten_status` VARCHAR(50) NULL DEFAULT NULL,`did` VARCHAR(16) NULL DEFAULT NULL,`start_time` DATETIME NULL DEFAULT NULL,`acd_time` DATETIME NULL DEFAULT NULL,`exten_ring_time` DATETIME NULL DEFAULT NULL,`exten_time` DATETIME NULL DEFAULT NULL,`end_time` DATETIME NULL DEFAULT NULL,`acd` VARCHAR(20) NULL DEFAULT NULL,`conf_no` VARCHAR(20) NULL DEFAULT NULL,`cause` INT(5) NULL DEFAULT NULL,`cause_txt` VARCHAR(100) NULL DEFAULT NULL,`agent_disconnect` INT(1) NULL DEFAULT '0',`recfile` VARCHAR(100) NULL DEFAULT NULL,`exten_type` VARCHAR(2) NULL DEFAULT NULL,`cr_datetime` DATETIME NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,`uni_channel` VARCHAR(50) NOT NULL,PRIMARY KEY (`uni_channel`) 
**
CRT_TBL|ast_error_log|`err_id` INT(11) NOT NULL AUTO_INCREMENT,`event` VARCHAR(50) NOT NULL DEFAULT '0',`runtime_data` TEXT NULL,`err_msg` VARCHAR(255) NULL DEFAULT NULL,`err_stack` TEXT NULL,`cr_date` DATETIME NULL DEFAULT CURRENT_TIMESTAMP,PRIMARY KEY (`err_id`)
**
CRT_TBL|ast_log|`log_id` INT(11) NOT NULL AUTO_INCREMENT,`event` VARCHAR(100) NULL DEFAULT NULL,`data` TEXT NULL,`cr_date` DATETIME NULL DEFAULT CURRENT_TIMESTAMP,PRIMARY KEY (`log_id`)
**
ADD_CLM|company|webhook|VARCHAR|200|Y|NULL|conf_type
**
ADD_CLM|sticky_mapping|notes|VARCHAR|150|Y|NULL|call_type
**
ADD_CLM|sticky_mapping|caller_name|VARCHAR|50|Y|NULL|number
**
ADD_CLM|sticky_mapping|caller_code|VARCHAR|50|Y|NULL|caller_name
**
ADD_CLM|action_rule|ans_api_id|INT|11|Y|NULL|api_id
**
CRT_TBL|trunk_group|`id` int(11) NOT NULL AUTO_INCREMENT,`group_name` varchar(50) DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE
**
ADD_CLM|action_rule|ans_api_id|INT|11|Y|NULL|api_id
**
ADD_CLM|trunk_master|dial_seconds|INT|11|Y|0|max_channel
**
ADD_CLM|trunk_master|trunk_order|INT|11|Y|0|dial_seconds
**
ADD_CLM|trunk_master|trunk_group_id|INT|11|Y|0|trunk_order
**
ADD_CLM|trunk_master|trunk_group_id|INT|11|Y|0|trunk_order
**
ADD_CLM|company|api_key|VARCHAR|150|Y|NULL|webhook
**
ADD_CLM|company|rec_all_call|INT|1|Y|0|rec_api
**
ADD_CLM|users_master|mail_cdr|INT|1|Y|0|allow_hang
**
ADD_CLM|company|report_hour|INT|11|Y|0|conf_type
**
ADD_CLM|company|sip_config|INT|1|Y|0|webhook
**
ADD_CLM|company|version|BLOB||Y|NULL|other_crm
**
ADD_CLM|company|file_system|VARCHAR|30|Y|NULL|version
**
CRT_TBL|ast_app_data|`data_id` INT(11) NOT NULL AUTO_INCREMENT,`data_type` VARCHAR(50) NULL COLLATE 'latin1_swedish_ci',`data_value` LONGTEXT NULL COLLATE 'latin1_swedish_ci',`md_date` datetime DEFAULT NULL,`cr_date` DATETIME NULL DEFAULT CURRENT_TIMESTAMP,PRIMARY KEY (`data_id`) USING BTREE
**
CRT_TBL|ast_cdr|`id` INT(11) NOT NULL AUTO_INCREMENT,`unique_id` VARCHAR(50) NULL COLLATE 'latin1_swedish_ci',`Linkedid` VARCHAR(100) NULL COLLATE 'latin1_swedish_ci',`exten_channel` VARCHAR(100) NOT NULL COLLATE 'latin1_swedish_ci',`trunk` VARCHAR(100) NULL COLLATE 'latin1_swedish_ci',`extension_no` VARCHAR(20) NULL COLLATE 'latin1_swedish_ci',`caller_id` VARCHAR(20) NULL COLLATE 'latin1_swedish_ci',`call_type` VARCHAR(20) NULL COLLATE 'latin1_swedish_ci',`disposition` VARCHAR(50) NULL COLLATE 'latin1_swedish_ci',`did` VARCHAR(16) NULL COLLATE 'latin1_swedish_ci',`start_time` DATETIME NULL,`acd_time` DATETIME NULL,`exten_ring_time` DATETIME NULL,`exten_ans_time` DATETIME NULL,`end_time` DATETIME NULL,`acd` VARCHAR(20) NULL COLLATE 'latin1_swedish_ci',`cause` INT(5) NULL,`cause_txt` VARCHAR(100) NULL COLLATE 'latin1_swedish_ci',`agent_disconnect` INT(1) UNSIGNED NULL DEFAULT '0',`recfile` VARCHAR(100) NULL COLLATE 'latin1_swedish_ci',`out_call_type` VARCHAR(10) NULL COLLATE 'latin1_swedish_ci',`dtmf` TINYTEXT NULL COLLATE 'latin1_swedish_ci',`record_type` ENUM('Partial','Complete') NULL DEFAULT 'Complete' COLLATE 'latin1_swedish_ci',`p_id` VARCHAR(5) NULL,`c_id` VARCHAR(5) NULL,`sr_no` VARCHAR(16) NULL,`durn` INT(11) NULL,`billsec` INT(11) NULL,`end_call` INT(1) NULL DEFAULT '0',`cr_datetime` DATETIME NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,PRIMARY KEY (`id`) USING BTREE
**
CRT_TBL|ast_channel|`unique_id` VARCHAR(50) NULL COLLATE 'latin1_swedish_ci',`linked_id` VARCHAR(50) NULL COLLATE 'latin1_swedish_ci',`exten_channel` VARCHAR(100) NOT NULL COLLATE 'latin1_swedish_ci',`trunk_channel` VARCHAR(100) NULL COLLATE 'latin1_swedish_ci',`p_id` VARCHAR(5) NULL,`c_id` VARCHAR(5) NULL,`sr_no` VARCHAR(16) NULL,`exten` VARCHAR(20) NULL COLLATE 'latin1_swedish_ci',`caller_id` VARCHAR(20) NULL COLLATE 'latin1_swedish_ci',`call_type` VARCHAR(20) NULL COLLATE 'latin1_swedish_ci',`exten_status` VARCHAR(50) NULL COLLATE 'latin1_swedish_ci',`did` VARCHAR(16) NULL COLLATE 'latin1_swedish_ci',`start_time` DATETIME NULL,`acd_time` DATETIME NULL,`exten_ring_time` DATETIME NULL,`exten_time` DATETIME NULL,`end_time` DATETIME NULL,
`acd` VARCHAR(20) NULL COLLATE 'latin1_swedish_ci',`cause` INT(5) NULL,`cause_txt` VARCHAR(100) NULL COLLATE 'latin1_swedish_ci',
`agent_disconnect` INT(1) NULL DEFAULT '0',`recfile` VARCHAR(100) NULL COLLATE 'latin1_swedish_ci',`out_call_type` VARCHAR(10) NULL COLLATE 'latin1_swedish_ci',`dtmf` TINYTEXT NULL COLLATE 'latin1_swedish_ci',`hold` INT(11) NULL DEFAULT '0',`cr_datetime` DATETIME NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,PRIMARY KEY (`exten_channel`) USING BTREE
**
CRT_TBL|ast_emit_log|`event` VARCHAR(100) NULL COLLATE 'latin1_swedish_ci',`exten` VARCHAR(16) NULL COLLATE 'latin1_swedish_ci',`Linkedid` VARCHAR(100) NULL COLLATE 'latin1_swedish_ci',`data` TEXT NULL COLLATE 'latin1_swedish_ci',`event_type` VARCHAR(50) NULL COLLATE 'latin1_swedish_ci',`cr_date` DATETIME NULL DEFAULT CURRENT_TIMESTAMP
**
CRT_TBL|ast_error_log|`err_id` INT(11) NOT NULL AUTO_INCREMENT,`event` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'latin1_swedish_ci',`runtime_data` TEXT NULL COLLATE 'latin1_swedish_ci',`err_msg` VARCHAR(255) NULL COLLATE 'latin1_swedish_ci',`err_stack` TEXT NULL COLLATE 'latin1_swedish_ci',`cr_date` DATETIME NULL DEFAULT CURRENT_TIMESTAMP,PRIMARY KEY (`err_id`) USING BTREE
**
CRT_TBL|ast_log|`log_id` INT(11) NOT NULL AUTO_INCREMENT,`event` VARCHAR(100) NULL COLLATE 'latin1_swedish_ci',`data` TEXT NULL COLLATE 'latin1_swedish_ci',`cr_date` DATETIME NULL DEFAULT CURRENT_TIMESTAMP,PRIMARY KEY (`log_id`) USING BTREE
**
CRT_TBL|ast_socket_log|`exten` VARCHAR(16) NULL COLLATE 'latin1_swedish_ci',`join_state` INT(1) NULL,`join_id` VARCHAR(50) NULL COLLATE 'latin1_swedish_ci',
`Join_ip` VARCHAR(20) NULL COLLATE 'latin1_swedish_ci',`cr_date` DATETIME NULL DEFAULT CURRENT_TIMESTAMP
**
CRT_TBL|bot_ivr|`id` BIGINT(20) NOT NULL AUTO_INCREMENT,`name` VARCHAR(100) NOT NULL COLLATE 'latin1_swedish_ci',`ivr_greeting` VARCHAR(100) NULL COLLATE 'latin1_swedish_ci',`invalid_retry` INT(2) NULL,`invalid_greeting` VARCHAR(100) NULL COLLATE 'latin1_swedish_ci',`invalid_recording` VARCHAR(100) NULL COLLATE 'latin1_swedish_ci',`dial_code` VARCHAR(4) NULL COLLATE 'latin1_swedish_ci',PRIMARY KEY (`id`) USING BTREE
**
CRT_TBL|bot_ivr_log|`start_time` DATETIME NULL,`ivr_id` INT(11) NULL,`uniqueid` VARCHAR(30) NULL COLLATE 'latin1_swedish_ci',`did` VARCHAR(16) NULL COLLATE 'latin1_swedish_ci',`caller_id` VARCHAR(16) NULL COLLATE 'latin1_swedish_ci',`content` INT(11) NULL,`response` VARCHAR(30) NULL COLLATE 'latin1_swedish_ci',
`action` VARCHAR(30) NULL COLLATE 'latin1_swedish_ci'
**
CRT_TBL|bot_ivr_question|`id` BIGINT(20) NOT NULL AUTO_INCREMENT,`ivr_id` INT(11) NOT NULL,`content_label` VARCHAR(30) NOT NULL DEFAULT '' COLLATE 'latin1_swedish_ci',`content` TEXT NOT NULL COLLATE 'latin1_swedish_ci',`greeting` VARCHAR(255) NOT NULL COLLATE 'latin1_swedish_ci',`is_start` INT(1) NULL DEFAULT '0',`custom_dest` VARCHAR(100) NULL COLLATE 'latin1_swedish_ci',PRIMARY KEY (`id`) USING BTREE
**
CRT_TBL|bot_ivr_rule|`id` BIGINT(20) NOT NULL AUTO_INCREMENT,`ivr_id` INT(11) NULL,`q_id` INT(11) NOT NULL,`response` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'latin1_swedish_ci',`app` VARCHAR(20) NOT NULL DEFAULT '' COLLATE 'latin1_swedish_ci',`appdata` VARCHAR(128) NOT NULL DEFAULT '' COLLATE 'latin1_swedish_ci',`san_app` VARCHAR(20) NULL COLLATE 'latin1_swedish_ci',`san_value` VARCHAR(50) NULL COLLATE 'latin1_swedish_ci',`is_hangup` INT(1) NULL DEFAULT '0',`row_order` INT(11) NULL,PRIMARY KEY (`id`) USING BTREE
**
CRT_TBL|bot_new_response|`id` BIGINT(20) NOT NULL AUTO_INCREMENT,`ivr_id` INT(11) NULL,`q_id` INT(11) NULL,`response` VARCHAR(50) NULL COLLATE 'latin1_swedish_ci',`insert_date` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,PRIMARY KEY (`id`) USING BTREE
**
CRT_TBL|dialer_setting|`id` INT(11) NOT NULL AUTO_INCREMENT,`crm_host` VARCHAR(150) NULL COLLATE 'latin1_swedish_ci',`crm_node_port` INT(11) NULL COLLATE 'latin1_swedish_ci',`crm_db_user` VARCHAR(30) NULL COLLATE 'latin1_swedish_ci',`crm_db_pass` VARCHAR(50) NULL COLLATE 'latin1_swedish_ci',`crm_db_name` VARCHAR(30) NULL COLLATE 'latin1_swedish_ci',`ast_host` VARCHAR(20) NULL COLLATE 'latin1_swedish_ci',`ast_user` VARCHAR(20) NULL COLLATE 'latin1_swedish_ci',`ast_port` INT(11) NULL COLLATE 'latin1_swedish_ci',`ast_pass` VARCHAR(30) NULL COLLATE 'latin1_swedish_ci',`context` VARCHAR(50) NOT NULL DEFAULT 'from-internal' COLLATE 'latin1_swedish_ci',`log_min` INT(1) NULL DEFAULT '0',`log_full` INT(1) NULL DEFAULT '0',`emit_log` INT(1) NULL DEFAULT '0',`join_log` INT(1) NULL DEFAULT '0',`log_del_boot` INT(1) NULL DEFAULT '0',`err_reporting` INT(1) NULL DEFAULT '0',`active` INT(1) NULL DEFAULT '0',`dialer_port` INT(11) NULL DEFAULT '0',`md_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,PRIMARY KEY (`id`) USING BTREE USING BTREE
**
ADD_CLM|bot_ivr_question|content_label|VARCHAR|30|Y|NULL|ivr_id
**
CRT_TBL|system_email_log|`id` BIGINT(20) NOT NULL AUTO_INCREMENT,`email_id` VARCHAR(100) NULL COLLATE 'latin1_swedish_ci',`subject` VARCHAR(200) NULL COLLATE 'latin1_swedish_ci',`content` VARCHAR(250) NULL COLLATE 'latin1_swedish_ci',`status` INT(1) NOT NULL DEFAULT '0',`error` TEXT NULL COLLATE 'latin1_swedish_ci',`added_on` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,PRIMARY KEY (`id`) USING BTREE
**
ADD_CLM|dialer_setting|pd_log|INT|1|Y|0|emit_log
**
ADD_CLM|ast_channel|hold|INT|11|Y|0|dtmf
**
ADD_CLM|ast_channel|conf_no|VARCHAR|30|Y|NULL|hold
**
ADD_CLM|ast_channel|is_trunk|INT|1|Y|0|conf_no
**
CRT_TBL|ast_action_log|`action` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`data` TEXT NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`exten` VARCHAR(16) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`cr_date` DATETIME NULL DEFAULT current_timestamp()
**
ADD_CLM|company|enable_dial|INT|1|Y|0|sip_config
**
ADD_CLM|company|is_dialer|INT|1|Y|0|enable_dial
**
ADD_CLM|company|is_crmapp|INT|1|Y|0|is_dialer
**
ADD_CLM|company|dialer_service|INT|1|Y|0|is_dialer
**
CRT_TBL|freshdesk_mapping|`id` INT(11) NOT NULL AUTO_INCREMENT,`exten` VARCHAR(16) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`user` VARCHAR(100) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`pass` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',PRIMARY KEY (`id`) USING BTREE
**
ADD_CLM|sip_san|ext_token|VARCHAR|100|Y|NULL|bal_issue_date
**
ADD_CLM|company|monitor_port|INT|11|Y|9000|other_crm
**
ADD_CLM|company|dialer_port|INT|11|Y|85|monitor_port
**
ADD_CLM|company|crm_ip|VARCHAR|50|Y|NULL|dialer_port
**
ADD_CLM|company|crm_port|INT|11|Y|300|crm_ip
**
ADD_CLM|company|crmdb_host|VARCHAR|20|Y|NULL|crm_port
**
ADD_CLM|company|crmdb_user|VARCHAR|20|Y|NULL|crmdb_host
**
ADD_CLM|company|crmdb_pass|VARCHAR|100|Y|NULL|crmdb_user
**
ADD_CLM|company|crmdb_name|VARCHAR|100|Y|NULL|crmdb_pass
**
ADD_CLM|company|monitor_ssl|INT|1|Y|0|crmdb_name
**
ADD_CLM|company|ami_port|INT|11|Y|5038|monitor_ssl
**
ADD_CLM|company|ami_user|varchar|20|Y|admin|ami_port
**
ADD_CLM|company|ami_pass|varchar|100|Y|Qy9lSUY2K0xOV0c4TlFXWmx3TFc3dz09|ami_user
**
ADD_CLM|company|ssl_key|varchar|100|Y|NULL|ami_pass
**
ADD_CLM|company|ssl_cert|varchar|100|Y|NULL|ssl_key
**
ADD_CLM|sip_setting|ws_port|INT|11|Y|NULL|sip_port
**
ADD_CLM|register_soft|web_phone|VARCHAR|100|Y|NULL|s_mode
**
ADD_CLM|register_soft|blaster|VARCHAR|100|Y|NULL|web_phone
**
ADD_CLM|register_soft|conference|VARCHAR|100|Y|NULL|blaster
**
ADD_CLM|register_soft|bot_ivr|VARCHAR|100|Y|NULL|conference
**
ADD_CLM|users_master|login_time|DATETIME||Y|NULL|mail_cdr
**
ADD_CLM|users_master|invalid_attempts|INT|11|Y|0|login_time
**
CRT_TBL|exten_contact|`id` INT(11) NOT NULL AUTO_INCREMENT,`exten` VARCHAR(16) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`number` VARCHAR(20) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`name` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',PRIMARY KEY (`id`) USING BTREE
**
CRT_TBL|exten_history|`id` INT(11) NOT NULL AUTO_INCREMENT,`exten` VARCHAR(16) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`number` VARCHAR(20) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`name` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`type` VARCHAR(10) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`cr_date` DATETIME NULL DEFAULT current_timestamp(),PRIMARY KEY (`id`) USING BTREE
**
CRT_TBL|queue_in_out|`id` INT(11) NOT NULL AUTO_INCREMENT,`agent_name` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`exten_no` VARCHAR(20) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`queue_no` VARCHAR(16) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',PRIMARY KEY (`id`) USING BTREE
**
ADD_CLM|company|cloud_recording_path|VARCHAR|255|Y|NULL|recording_path
**
ADD_CLM|company|ftp_server|VARCHAR|150|Y|NULL|file_system
**
ADD_CLM|company|ftp_port|INT|11|Y|NULL|ftp_server
**
ADD_CLM|company|ftp_user|VARCHAR|50|Y|NULL|ftp_port
**
ADD_CLM|company|ftp_pass|VARCHAR|100|Y|NULL|ftp_user
**
ADD_CLM|company|rec_upload_before|INT|11|Y|0|ftp_pass
**
ADD_CLM|live_call|exten_channel|VARCHAR|100|Y|NULL|channel
**
ALT_CLM|live_call|channel|channel|VARCHAR|100|Y|NULL|conf_no
**
ALT_CLM|ast_cdr|Linkedid|Linkedid|VARCHAR|100|Y|NULL|unique_id
**
ALT_CLM|ast_emit_log|Linkedid|Linkedid|VARCHAR|100|Y|NULL|exten
**
ADD_CLM|ast_cdr|hold_duration|INT|11|Y|NULL|billsec
**
ADD_CLM|acd_group|mail_noanswer|INT|11|Y|0|check_priority
**
ADD_CLM|company|blaster_timer|INT|11|Y|4|ftp_pass
**
ADD_CLM|company|blaster_dial|INT|11|Y|10|ftp_pass
**
ADD_CLM|conference_master|conf_context|VARCHAR|50|Y|NULL|conf_did
**
ADD_CLM|conference_master|last_dial_time|DATETIME||Y|NULL|dial_after
**
ADD_CLM|ivr|get_feedback|INT|11|Y|NULL|check_account
**
CRT_TBL|ivr_blast|`id` INT(11) NOT NULL AUTO_INCREMENT,`name` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`san_app` VARCHAR(30) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`san_value` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`fromdate` DATE NULL DEFAULT NULL,`enddate` DATE NULL DEFAULT NULL,`from_time` VARCHAR(6) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`end_time` VARCHAR(6) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`dial_prefix` VARCHAR(4) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`allow_channel` INT(11) NULL DEFAULT '0',`trunk_group` INT(11) NULL DEFAULT '0',`is_active` INT(11) NULL DEFAULT '0',PRIMARY KEY (`id`) USING BTREE
**
ADD_CLM|ivr_blast|dial_prefix|VARCHAR|4|Y|NULL|end_time
**
CRT_TBL|user_trunk|`id` INT(11) NOT NULL AUTO_INCREMENT,`user_id` INT(11) NOT NULL,`trunk_id` VARCHAR(11) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',PRIMARY KEY (`id`) USING BTREE
**
ADD_CLM|company|crm_db_port|VARCHAR|100|Y|3306|crmdb_pass
**
ADD_CLM|company|dialer_http_port|INT|11|Y|86|dialer_port
**
ADD_CLM|company|crm_app_host|varchar|100|Y|127.0.0.1|dialer_http_port
**
ADD_CLM|company|crm_ssl|INT|1|Y|0|monitor_ssl
**
ADD_CLM|custom_context|is_return|INT|1|Y|0|content
**
ADD_CLM|ivr|custom_route|VARCHAR|30|Y|NULL|directdial
**
ADD_CLM|company|config_base|INT|1|Y|0|sip_config
**
QRY|drop table apply_rule
**
CRT_TBL|apply_rule|`id` INT(11) NOT NULL AUTO_INCREMENT,`app` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`updated_flag` INT(11) NULL DEFAULT '0',PRIMARY KEY (`id`) USING BTREE
**
QRY|INSERT INTO `apply_rule` (`id`, `app`, `updated_flag`) VALUES (1, 'sip_extension', 0),(2, 'trunk_master', 0),(3, 'out_route', 0),(4, 'action_rule', 0),(5, 'company', 0),(6, 'fcode', 0),(7, 'sip_setting', 0),(8, 'ivr', 0),(9, 'firewall', 1),(10, 'pri', 0),(12, 'ps_aors', 0),(13, 'pjsip_setting', 0),(15, 'announcement', 0),(16, 'address_book', 0),(17, 'callerid', 0),(18, 'timecondition', 0),(19, 'mcode', 0),(20, 'conference', 0),(21, 'blacklist', 0),(22, 'allowlist', 0),(23, 'dnd', 0),(24, 'groupdial', 0),(25, 'sticky', 0),(26, 'queue', 0),(27, 'moh', 0),(28, 'callflow', 0),(29, 'holiday', 0),(30, 'botivr', 0),(31, 'audiosocket', 0),(32, 'out_timeconditions', 0),(33, 'time_group', 0);
**
ADD_CLM|report_fields|user_id|INT|11|Y|NULL|fields
**
ADD_CLM|company|master_login|INT|1|Y|1|blaster_timer
**
ADD_CLM|company|max_call_durn|INT|11|Y|0|blaster_timer
**
ADD_CLM|acd_member|state_interface|VARCHAR|128|Y|NULL|interface
**
ADD_CLM|company|access_key|VARCHAR|10|Y|NULL|master_login
**
ADD_CLM|company|access_token|VARCHAR|150|Y|NULL|access_key
**
ADD_CLM|queue_in_out|state|INT|1|Y|NULL|queue_no
**
ADD_CLM|queue_in_out|manualon|INT|1|Y|NULL|state
**
ADD_CLM|queue_in_out|break|VARCHAR|50|Y|NULL|manualon
**
ADD_CLM|queue_in_out|logintime|DATETIME||Y|NULL|break
**
ADD_CLM|company|ftp_recording|INT|1|Y|0|enable_dial
**
ADD_CLM|company|debug_ftp|INT|1|Y|0|ftp_pass
**
ADD_CLM|company|ftp_backup_path|VARCHAR|50|Y|NULL|debug_ftp
**
ADD_CLM|company|ftp_recording_path|VARCHAR|50|Y|NULL|ftp_backup_path 
**
ADD_CLM|ast_error_log|ast_data|TEXT|||NULL|err_msg
**
ADD_CLM|ast_error_log|channel_data|TEXT|||NULL|ast_data
**
ADD_CLM|ast_cdr|feedback|VARCHAR|20|Y|NULL|end_call 
**
ADD_CLM|ast_cdr|transfer|VARCHAR|5|Y|NULL|feedback
**
ADD_CLM|ast_channel|file_id|INT|11|Y|NULL|transfer
**
ADD_CLM|ast_channel|blaster_name|VARCHAR|50|Y|NULL|file_id
**
ADD_CLM|company|max_memory|INT|11|Y|NULL|dialer_key
**
ADD_CLM|company|max_memory_restart|INT|11|Y|NULL|max_memory
**
ADD_CLM|trunk_master|is_dnd|INT|1|Y|0|trunk_group_id
**
ADD_CLM|company|mysql_conn|INT|11|Y|10000|max_memory_restart
**
ADD_CLM|company|innodb_buffer|INT|11|Y|1073741824|mysql_conn
**
ADD_CLM|ast_cdr|dial_unique_id|VARCHAR|50|Y|NULL|transfer
**
CRT_TBL|exten_register_log|`id` INT(11) NOT NULL AUTO_INCREMENT,`ts` DATETIME NULL ,`exten` VARCHAR(16) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`exten_status` INT(11) NULL DEFAULT '0',`ast_ip` VARCHAR(30) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`state` VARCHAR(20) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',PRIMARY KEY (`id`) USING BTREE
**
ADD_CLM|dialer_setting|exten_register_log_days|INT|11|Y|60|dialer_port
**
ADD_CLM|dialer_setting|ast_cdr_days|INT|11|Y|60|exten_register_log_days
**
ADD_CLM|dialer_setting|ast_socket_log_days|INT|11|Y|7|ast_cdr_days
**
ADD_CLM|dialer_setting|ast_error_log_days|INT|11|Y|30|ast_socket_log_days
**
ADD_CLM|dialer_setting|ast_log_days|INT|11|Y|1|ast_error_log_days
**
ADD_CLM|dialer_setting|log_reset_time|INT|11|Y|22|ast_log_days
**
ADD_CLM|action_rule|holiday_group|INT|11|Y|NULL|allow_list
**
ADD_CLM|time_group|holiday_group|INT|11|Y|0|name
**
CRT_TBL|holiday|`id` INT(11) NOT NULL AUTO_INCREMENT,`name` VARCHAR(100) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`start_time` DATETIME NULL DEFAULT NULL,`end_time` DATETIME NULL DEFAULT NULL,`sound` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`san_app` VARCHAR(20) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`san_value` VARCHAR(20) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`group_id` INT(11) NULL DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE
**
CRT_TBL|holiday_rule|`id` INT(11) NOT NULL AUTO_INCREMENT,`context` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`exten` VARCHAR(20) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`priority` TINYINT(4) NULL DEFAULT '0',`app` VARCHAR(20) NOT NULL DEFAULT '' COLLATE 'latin1_swedish_ci',`appdata` VARCHAR(128) NOT NULL DEFAULT '' COLLATE 'latin1_swedish_ci',PRIMARY KEY (`id`) USING BTREE
**
CRT_TBL|custom_report|`id` INT(11) NOT NULL AUTO_INCREMENT,`name` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'latin1_swedish_ci',`fields` TEXT(65535) NOT NULL COLLATE 'latin1_swedish_ci',`custom_query` TEXT(65535) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`debug` INT(1) NULL DEFAULT '0',`procedure` INT(1) NULL DEFAULT '0',UNIQUE INDEX `report_id` (`id`) USING BTREE
**
CRT_TBL|custom_report_search|`field_id` INT(11) NOT NULL AUTO_INCREMENT,`field_label` VARCHAR(50) NOT NULL COLLATE 'latin1_swedish_ci',`field` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`db_field` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`field_type` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`custom_condition` TEXT(65535) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`search_type` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`dropdown_list` VARCHAR(255) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`default` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`in_subquery` INT(1) NULL DEFAULT '0',`is_required` INT(1) NULL DEFAULT '0',`report_id` INT(11) NULL DEFAULT NULL,UNIQUE INDEX `field_id` (`field_id`) USING BTREE
**
ADD_CLM|dialer_setting|webhook_log|INT|1|Y|0|pd_log
**
ADD_CLM|trunk_master|out_cid_prifix|VARCHAR|10|Y|NULL|trunk_out_cid
**
ADD_CLM|trunk_master|out_cid_from|VARCHAR|16|Y|NULL|out_cid_prifix
**
ADD_CLM|trunk_master|out_cid_to|VARCHAR|16|Y|NULL|out_cid_from
**
ADD_CLM|ast_emit_log|trunk_channel|VARCHAR|50|Y|NULL|data
**
ADD_CLM|ast_emit_log|exten_channel|VARCHAR|50|Y|NULL|trunk_channel
**
ADD_CLM|register_soft|mobile_app|VARCHAR|100|Y|NULL|conference
**
CRT_TBL|callflow|`id` int(11) NOT NULL AUTO_INCREMENT,`name` varchar(100) NOT NULL,`code` int(16) NOT NULL,`pass` int(16) NOT NULL,`on_app` varchar(20) NOT NULL,`on_value` varchar(100) NOT NULL,`off_app` varchar(20) NOT NULL,`off_value` varchar(100) NOT NULL,`status` INT(11) NOT NULL DEFAULT '0',PRIMARY KEY (`id`) USING BTREE
**
CRT_TBL|callflow_rule|`id` INT(11) NOT NULL AUTO_INCREMENT,`context` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`exten` VARCHAR(20) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`priority` TINYINT(4) NULL DEFAULT '0',`app` VARCHAR(20) NOT NULL DEFAULT '' COLLATE 'latin1_swedish_ci',`appdata` VARCHAR(128) NOT NULL DEFAULT '' COLLATE 'latin1_swedish_ci',`rule_id` INT(11) NOT NULL,PRIMARY KEY (`id`) USING BTREE 
**
CRT_TBL|get_callflow_rule|`id` INT(11) NOT NULL AUTO_INCREMENT,`context` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`exten` VARCHAR(20) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`priority` TINYINT(4) NULL DEFAULT '0',`app` VARCHAR(20) NOT NULL DEFAULT '' COLLATE 'latin1_swedish_ci',`appdata` VARCHAR(128) NOT NULL DEFAULT '' COLLATE 'latin1_swedish_ci',`rule_id` INT(11) NOT NULL,PRIMARY KEY (`id`) USING BTREE 
**
QRY|drop table dest_rule
**
CRT_TBL|dest_rule|`id` INT(11) NOT NULL AUTO_INCREMENT,`app` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`app_dest` VARCHAR(20) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`select_table` VARCHAR(30) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`select_field` VARCHAR(20) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`select_value` VARCHAR(20) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`select_desc` VARCHAR(20) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`page_name` VARCHAR(20) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`is_active` varchar(20) DEFAULT '1',PRIMARY KEY (`id`) USING BTREE
**
QRY|INSERT INTO `dest_rule` (`id`, `app`, `app_dest`, `select_table`, `select_field`, `select_value`, `select_desc`, `page_name`,`is_active`) VALUES (11, 'Extension', 'Gosub', 'sip_san', 'exten', '', 'display_name', 'extension',1),(12, 'ACD', 'Goto', 'acd_group', 'name', '', 'name_desc', 'acdgroup',1),(13, 'Sounds', 'Macro', 'sounds', 'name', '', NULL, 'sounds',1),(14, 'Terminate call', 'Macro', '', '', '', NULL, NULL,1),(15, 'Announcement', 'Goto', 'announcement', 'name', 'id', NULL, 'announcement',1),(16, 'IVR', 'Goto', 'ivr', 'name', 'id', NULL, 'ivr',1),(17, 'Timeconditions', 'Gotoiftime', 'timeconditions', 'name', 'id', NULL, 'timecondition',1),(18, 'Address Book', 'Gosub', 'address_book', 'number', '', 'name', 'addressbook',1),(19, 'Set Callerid', 'Goto', 'callerid_master', 'description', 'id', NULL, 'callerid',1),(20, 'Misc Application', 'Goto', 'mcode', 'name', 'misc_code', NULL, 'miscapplication',1),(21, 'Trunk', 'Goto', 'trunk_master', 'name', 'trunk_name', NULL, 'trunk',1),(22, 'Custom Context', 'Goto', 'custom_context', 'name', 'id', NULL, 'customcontext',1),(35, 'Voicemail', 'Goto', 'sip_san', 'exten', NULL, 'display_name', 'voicemail',1),(36, 'Conference', 'Goto', 'conference_master', 'confno', '', 'name', 'conference',1),(37, 'Sticky Route', 'Macro', 'sticky_route', 'name', 'id', NULL, 'stickyagent',1),(38, 'ACD Priority', 'Goto', 'acd_priority_master', 'priority_name', 'id', NULL, 'acdprio',1),(39, 'ERCC Code', 'Goto', 'ercc_code', 'ercc_code', NULL, 'ercc_desc', 'ercc',1),(40, 'Bot IVR', 'Macro', 'bot_ivr ', 'name', 'id', NULL, 'botivr',1),(42, 'Call Flow', 'Goto', 'callflow', 'name', 'id', NULL, 'callflow',1),(43, 'Bot IVR Flow', 'Macro', 'bot_master', 'name', 'id', NULL, 'ivrflowbot',1),(44, 'Audiosocket', 'Goto', 'audiosocket', 'name', 'id', NULL, 'audiosocket',1);
**
ADD_CLM|menu_master|is_client|INT|1|Y|NULL|active
**
QRY|INSERT IGNORE INTO `menu_master` (`menu_id`, `menu_name`, `menu_url`, `menu_parent`, `menu_priority`, `menu_icon`, `menu_type`, `active`,`is_client`,`cr_usr`, `cr_date`) VALUES
(108, 'ERCC', 'javascript:void(0)', 0, 6, 'ercc', 0, 1, NULL, 1, '2022-12-17 16:31:23'),(109, 'Code Master', 'ercc', 108, 1, 'codemaster', 1, 1, 1, 1, '2022-08-16 16:53:11'),(110, 'Code Log', 'ercclog', 108, 2, 'codelog', 1, 1, 1, 1, '2022-08-16 16:52:51'),(111, 'Balance Api', 'balanceapi', 61, 6, 'balanceapi', 0, 0, NULL, 1, '2022-12-05 17:43:21'),(112, 'Balance API Mapping', 'balanceapimap', 61, 7, 'balanceapimap', 0, 0, NULL, 1, '2022-12-05 17:43:23'),(113, 'Allow List', 'allowlist', 2, 19, 'allowlist', 1, 1, 1, 1, '2023-03-13 12:45:07'),(114, 'Report', 'customreport', 0, 9, 'report', 1, 1, NULL, 1, '2023-09-15 12:17:35'),(115, 'Zoho Config', 'zohoconf', 4, 8, 'zohoconfig', 1, 1, NULL, 1, '2022-07-01 11:22:17'),(116, 'Zoho User', 'zohouser', 4, 9, 'zohouser', 1, 1, NULL, 1, '2022-07-01 11:22:24'),(118, 'Pipe Drive Config', 'pipeconf', 4, 10, 'pipedriveconfig', 0, 0, NULL, 1, '2020-09-05 14:32:18'),(119, 'Pipe Drive Users', 'pipeuser', 4, 11, 'pipedriveuser', 0, 0, NULL, 1, '2020-09-05 14:32:42'),(120, 'CDR NEW', 'cdrnew', 0, 2, 'cdr', 0, 0, NULL, 1, '2023-05-01 15:58:40'),(121, 'Trunk Group', 'trunkgroup', 61, 2, 'trunk', 1, 1, NULL, 0, '2022-12-05 17:43:35'),(122, 'Freshdesk Mapping', 'freshdesk', 4, 12, '', 0, 0, NULL, 1, '2020-11-11 11:20:36'),(123, 'Bot IVR', 'botivr', 2, 27, 'ivr', 0, 0, NULL, 1, '2023-11-10 10:38:46'),(124, 'Bot Rules', 'botrules', 2, 28, 'in', 0, 0, NULL, 1, '2023-11-10 10:39:21'),(125, 'IVR Blaster', 'javascript:void(0)', 0, 5, 'ivr', 0, 0, 1, 1, '2021-07-13 19:06:28'),(126, 'Blaster Master', 'blaster', 125, 1, 'custom', 1, 1, 1, 1, '2023-12-07 12:02:03'),(127, 'File Master', 'filemaster', 125, 2, 'address', 1, 1, 1, 1, '2023-12-07 12:02:03'),(128, 'Blaster CDR', 'blastercdr', 125, 3, 'cdr', 1, 1, 1, 1, '2023-12-07 12:02:03'),(129, 'DID', 'did', 2, 0, '', 1, 1, NULL, 1, '2021-08-02 14:05:31'),(130, 'SIP Log', 'siplog', 4, 14, 'pbxlog', 1, 1, NULL, 1, '2023-03-01 16:07:41'),(132, 'Holiday List', 'holiday', 2, 13, 'pbxlog', 1, 1, 1, 1, '2023-03-28 11:40:19'),(134, 'Custom Report', 'customreportmaster', 2, 29, 'voicemail', 1, 1, NULL, 1, '2023-03-15 11:00:32'),(136, 'Trunk Usage', 'trunkusage', 4, 15, '', 1, 1, NULL, 1, '2023-07-27 13:24:26'),(138, 'Call Flow Control', 'callflow', 2, 25, 'tgroup', 1, 1, NULL, 1, '2023-05-31 13:45:28'),(139, 'Log Tables', 'logtable', 89, 9, 'menu', 0, 0, NULL, 1, '2023-07-14 10:21:27'),(140, 'Add API ', 'apiswagger', 89, 10, 'api', 0, 1, NULL, 1, '2023-09-13 10:29:00'),(141, 'Developer API ', 'devapi', 4, 16, 'api', 1, 1, NULL, 1, '2023-09-13 10:29:02'),(142, 'Bot Flow', 'ivrflowbot', 143, 2, 'bot-workflow', 1, 1, 1, 1, '2023-12-14 10:30:52'),(143, 'Bot Master', 'javascript:void(0)', 0, 7, 'Bot-Master', 0, 1, NULL, 1, '2023-11-09 12:56:45'),(146, 'Bot CDR', 'ivrflowlog', 143, 5, 'Bot-CDR', 1, 1, 1, 1, '2023-12-08 19:37:35'),(147, 'Dashboard', 'ivrflowlog/dash', 143, 1, 'dashboard', 1, 1, 1, 1, '2023-12-08 19:37:38'),(148, 'Bot API', 'botapi', 89, 11, 'api', 1, 1, NULL, 1, '2023-11-10 10:44:27'),(149, 'Monitor', 'livebot', 143, 7, 'Monitoring', 1, 1, 1, 1, '2023-12-08 19:37:43'),(150, 'Bot Sounds', 'ivrflowsounds', 143, 3, 'bot-Sound', 1, 1, 1, 1, '2023-12-14 10:30:50'),(151, 'Clients', 'client', 89, 12, '', 1, 1, NULL, 1, '2023-11-27 18:25:41'),(152, 'Bot No Match', 'ivrflownomatch', 143, 6, 'Bot-CDR', 1, 1, 1, 1, '2023-12-08 14:46:11'),(153, 'User log', 'userslog', 3, 5, 'codelog', 1, 1, 1, 1, '2023-12-07 17:55:13'),(154, 'Audio Socket', 'audiosocket', 2, 44, '', 1, 0, NULL, 0, '2024-03-16 12:05:06'),(155, 'Billing', 'javascript:void(0)', 0, 13, '', 0, 0, NULL, 1, '2024-08-08 10:26:41'),(156, 'Plan Master', 'plan', 155, 5, '', 0, 0, NULL, 1, '2024-08-08 10:26:41'),(157, 'STD Table', 'stdtable', 155, 3, '', 0, 0, NULL, 1, '2024-08-08 10:26:41'),(158, 'Client', 'party', 155, 6, '', 0, 0, NULL, 1, '2024-08-08 10:26:41'),(159, 'Invoice', 'invoice', 155, 7, '', 0, 0, NULL, 1, '2024-08-08 10:26:41'),(160, 'Payment Receiving', 'payreceiving', 155, 8, '', 0, 0, NULL, 1, '2024-08-08 10:26:41'),(161, 'Coupon', 'ratecoupon', 155, 4, '', 0, 0, NULL, 1, '2024-08-08 10:26:41'),(162, 'Company', 'billcompany', 155, 2, '', 0, 0, NULL, 1, '2024-08-08 10:26:41'),(163, 'State Master', 'statemaster', 155, 1, '', 0, 0, NULL, 1, '2024-08-08 10:26:41'),(164, 'Call Reports', 'billcdr', 155, 9, '', 0, 0, NULL, 1, '2024-08-08 10:26:41'),(165, 'Job Scheduler', 'jobscheduler', 89, 13, 'dbshed', 1, 1, NULL, 1, '2024-08-08 10:26:41'),(166, 'Reprocess Calls', 'reprocesscall', 155, 7, '', 1, 1, NULL, 1, '2024-08-08 10:26:41'),(167, 'Party Ledger', 'ledger', 155, 11, '', 1, 1, NULL, 1, '2024-08-08 10:26:41'),(168, 'Out Time Condition', 'outtimeblock', 4, 3, 'tcondi', 1, 1, NULL, 1, '2024-08-08 10:26:41'),(169, 'Retry Attempt', 'retryattempt', 4, 3, 'timegroup', 1, 1, NULL, 1, '2024-08-08 10:26:41');
**
QRY|update `menu_master` set is_client=1 where menu_url in('users','users/userpermissions','extension','sounds','acdgroup','moh','inbound','ivr','announcement','timegroup','timecondition','outroute','addressbook','conference','callerid','extengroup','blacklist','accountcode','dnd','stickyagent','emailtemplate','stickymap','ercc','ercclog','allowlist','blaster','filemaster','blastercdr','holiday','ivrflowbot','ivrflowlog','ivrflowlog/dash','livebot','ivrflowsounds') or menu_name in('Home','Master','Users & Roles','PBX Setting','Logout','Connectivity','CDR','Voicemail','ERCC','CDR Ast')
**
ADD_CLM|dbbackup|is_config|INT|11|Y|0|file_name
**
ADD_CLM|db_schedule|is_config|INT|11|Y|0|path
**
CRT_TBL|log_table_list|`id` INT(11) NOT NULL AUTO_INCREMENT,`table_name` VARCHAR(100) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',PRIMARY KEY (`id`) USING BTREE
**
QRY|INSERT IGNORE INTO `log_table_list` (`id`, `table_name`) VALUES (1, 'api_log'),(2, 'ast_action_log'),(3, 'ast_emit_log'),(4, 'ast_error_log'),(5, 'ast_log'),(6, 'ast_socket_log'),(7, 'bot_ivr_log'),(8, 'ercc_log'),(9, 'exten_register_log'),(10, 'system_email_log'),(11, 'user_log'),(12, 'webhook_log'),(13, 'zoho_api_log'),(14, 'zoho_live_log'),(15, 'ast_cdr'),(16, 'blast_cdr'),(17, 'dbbackup'),(18, 'exten_history')
**
ADD_CLM|trunk_master|out_prefix|INT|11|Y|NULL|out_cid_to
**
ADD_CLM|company|validate_ip|INT|1|Y|0|crm_ssl
**
ADD_CLM|company|dialer_cli_len|INT|11|Y|10|max_call_durn
**
ADD_CLM|live_call|current_state|VARCHAR|30|Y|NULL|ast_ip
**
ADD_CLM|ast_channel|bot_id|INT|11|Y|NULL|blaster_name
**
ADD_CLM|ast_cdr|san_unique_id|VARCHAR|100|Y|NULL|dial_unique_id
**
ADD_CLM|ast_cdr|ivr|VARCHAR|200|Y|NULL|san_unique_id
**
ADD_CLM|ast_cdr|userfield|VARCHAR|200|Y|NULL|ivr
**
ADD_CLM|company|is_bot|VARCHAR|200|Y|NULL|master_login
**
ADD_CLM|company|bot_app_port|VARCHAR|7|Y|3000|is_bot
**
ADD_CLM|company|method|varchar|10|Y|NULL|webhook
**
ADD_CLM|company|did|varchar|100|Y|NULL|method
**
ADD_CLM|company|trunk_create|INT|11|Y|0|did
**
ADD_CLM|company|trunk_dialing|INT|11|Y|0|trunk_create
**
ADD_CLM|company|trunk_remove|INT|11|Y|0|trunk_dialing
**
ADD_CLM|company|exten_dialing|INT|11|Y|0|trunk_remove
**
ADD_CLM|company|exten_ringing|INT|11|Y|0|exten_dialing
**
ADD_CLM|company|exten_answer|INT|11|Y|0|exten_ringing
**
ADD_CLM|company|exten_hangup|INT|11|Y|0|exten_answer
**
ADD_CLM|company|queue_join|INT|11|Y|0|exten_hangup
**
ADD_CLM|company|queue_leave|INT|11|Y|0|queue_join
**
ADD_CLM|company|conference_event|INT|11|Y|0|queue_leave
**
ADD_CLM|company|auth_type|VARCHAR|20|Y|NULL|conference_event
**
ADD_CLM|company|auth_user|VARCHAR|50|Y|NULL|auth_type
**
ADD_CLM|company|auth_pass|VARCHAR|50|Y|NULL|auth_user
**
ADD_CLM|company|auth_token|VARCHAR|150|Y|NULL|auth_pass
**
ADD_CLM|company|whatsapp_api|TEXT||Y|NULL|auth_token
**
ADD_CLM|company|sms_api|TEXT||Y|NULL|whatsapp_api
**
ADD_CLM|company|translate|VARCHAR|50|Y|NULL|sms_api
**
ADD_CLM|company|tts|VARCHAR|50|Y|NULL|translate
**
ADD_CLM|company|stt|VARCHAR|50|Y|NULL|tts
**
CRT_TBL|client|`client_id` INT(11) NOT NULL AUTO_INCREMENT,`client_name` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`translate` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`tts` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`stt` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`webhook` VARCHAR(250) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`did` VARCHAR(100) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`method` VARCHAR(10) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`trunk_create` INT(11) NULL DEFAULT '0',`trunk_dialing` INT(11) NULL DEFAULT '0',`trunk_remove` INT(11) NULL DEFAULT '0',`exten_dialing` INT(11) NULL DEFAULT '0',`exten_ringing` INT(11) NULL DEFAULT '0',`exten_answer` INT(11) NULL DEFAULT '0',`exten_hangup` INT(11) NULL DEFAULT '0',`queue_join` INT(11) NULL DEFAULT '0',`queue_leave` INT(11) NULL DEFAULT '0',`auth_type` VARCHAR(20) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`auth_user` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`auth_pass` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`auth_token` VARCHAR(150) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`sms_api` TEXT(65535) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`email_host` VARCHAR(100) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`email_port` INT(11) NULL DEFAULT NULL,`email_user` VARCHAR(100) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`email_pass` VARCHAR(100) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`mail_auth` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`whatsapp_api` TEXT(65535) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`cr_usr` INT(11) NULL DEFAULT '0',PRIMARY KEY (`client_id`) USING BTREE
**
ADD_CLM|client|webhook|varchar|250|Y|NULL|stt
**
ADD_CLM|client|method|varchar|10|Y|NULL|webhook
**
ADD_CLM|client|did|varchar|100|Y|NULL|method
**
ADD_CLM|client|trunk_create|INT|11|Y|0|did
**
ADD_CLM|client|trunk_dialing|INT|11|Y|0|trunk_create
**
ADD_CLM|client|trunk_remove|INT|11|Y|0|trunk_dialing
**
ADD_CLM|client|exten_dialing|INT|11|Y|0|trunk_remove
**
ADD_CLM|client|exten_ringing|INT|11|Y|0|exten_dialing
**
ADD_CLM|client|exten_answer|INT|11|Y|0|exten_ringing
**
ADD_CLM|client|exten_hangup|INT|11|Y|0|exten_answer
**
ADD_CLM|client|queue_join|INT|11|Y|0|exten_hangup
**
ADD_CLM|client|queue_leave|INT|11|Y|0|queue_join
**
ADD_CLM|client|conference_event|INT|11|Y|0|queue_leave
**
ADD_CLM|client|auth_type|VARCHAR|20|Y|NULL|conference_event
**
ADD_CLM|client|auth_user|VARCHAR|50|Y|NULL|auth_type
**
ADD_CLM|client|auth_pass|VARCHAR|50|Y|NULL|auth_user
**
ADD_CLM|client|auth_token|VARCHAR|150|Y|NULL|auth_pass
**
ADD_CLM|client|sms_api|TEXT||Y|NULL|auth_token
**
ADD_CLM|client|email_host|VARCHAR|100|Y|NULL|sms_api
**
ADD_CLM|client|email_port|INT|11|Y|NULL|email_host
**
ADD_CLM|client|email_user|VARCHAR|100|Y|NULL|email_port
**
ADD_CLM|client|email_pass|VARCHAR|100|Y|NULL|email_user
**
ADD_CLM|client|mail_auth|VARCHAR|50|Y|NULL|email_pass
**
ADD_CLM|client|whatsapp_api|TEXT||Y|NULL|mail_auth
**
ADD_CLM|acd_group|mail_noanswer|INT|11||NULL|check_priority
**
ADD_CLM|acd_group|on_call|INT|11||NULL|mail_noanswer
**
ADD_CLM|acd_group|cid|INT|11||NULL|on_call
**
ADD_CLM|address_book|cid|INT|11||NULL|queue_priority
**
ADD_CLM|out_route|cid|INT|11|Y|NULL|upd_sticky
**
ADD_CLM|action_rule|cid|INT|11|Y|NULL|holiday_group
**
ADD_CLM|mcode|cid|INT|11|Y|NULL|san_value
**
ADD_CLM|company|encrypt_start|datetime||Y|NULL|is_bot
**
ADD_CLM|company|del_org_rec|INT|11|Y|0|encrypt_start
**
ADD_CLM|custom_report|recording_path|VARCHAR|100|Y|NULL|procedure
**
ADD_CLM|user_log|user_id|INT|11|Y|NULL|user_name
**
ADD_CLM|users_master|user_type|varchar|11|Y|NULL|invalid_attempts
**
ADD_CLM|users_master|cid|INT|11|Y|0|user_type
**
ADD_CLM|sounds|cid|INT|11|Y|0|upload_file_name
**
ADD_CLM|announcement|cid|INT|11|Y|0|sound
**
ADD_CLM|account_code|cid|INT|11|Y|0|deduct_intercom
**
ADD_CLM|callerid_master|cid|INT|11|Y|0|san_value
**
ADD_CLM|time_group|cid|INT|11|Y|0|timerule
**
ADD_CLM|timeconditions|cid|INT|11|Y|0|conditions
**
ADD_CLM|holiday|cid|INT|11|Y|0|group_id
**
ADD_CLM|ivr|cid|INT|11|Y|0|dial_code
**
ADD_CLM|custom_context|cid|INT|11|Y|0|is_return
**
ADD_CLM|conference_master|cid|INT|11|Y|0|conf_type
**
ADD_CLM|blacklist|number|BIGINT|11|Y|NULL|did
**
ADD_CLM|blacklist|cid|INT|11|Y|0|number
**
ADD_CLM|allowlist|number|BIGINT|11|Y|NULL|code
**
ADD_CLM|allowlist|cid|INT|11|Y|0|number
**
ADD_CLM|san_dnd|number|BIGINT|11|Y|NULL|appdata
**
ADD_CLM|san_dnd|cid|INT|11|Y|0|number
**
ADD_CLM|api_master|cid|INT|11|Y|0|exten
**
ADD_CLM|group_dial|cid|INT|11|Y|0|drop_after_annou
**
ADD_CLM|sticky_route|cid|INT|11|Y|0|api
**
ADD_CLM|sticky_mapping|cid|INT|11|Y|0|insert_time
**
ADD_CLM|callflow|cid|INT|11|Y|0|status
**
ADD_CLM|email_template|cid|INT|11|Y|0|content
**
ADD_CLM|custom_report|cid|INT|11|Y|0|recording_path
**
ADD_CLM|user_group|cid|INT|11|Y|0|download_recording
**
ADD_CLM|ercc_code|cid|INT|11|Y|0|dial_after
**
ADD_CLM|exten_group|display_name|VARCHAR|50|Y|NULL|group_name
**
ADD_CLM|exten_group|cid|INT|11|Y|0|display_name
**
ADD_CLM|sip_san|cid|INT|11|Y|0|exten_id
**
ADD_CLM|musiconhold|cid|INT|11|Y|0|format
**
ADD_CLM|ivr_blast|cid|INT|11|Y|0|is_active
**
CRT_TBL|bot_master| `id` int(11) NOT NULL AUTO_INCREMENT,`name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,`dial_code` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,`did_no` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,`language` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,`flow_chart` text COLLATE utf8_unicode_ci, `ivr_flow` text COLLATE utf8_unicode_ci,`disable` int(11) DEFAULT '0',`client_id` int(11) DEFAULT '0',PRIMARY KEY (`id`) USING BTREE
**
CRT_TBL|bot_node_api|`flow_id` int(11) DEFAULT NULL,`node` int(11) DEFAULT NULL,`url` varchar(255) DEFAULT NULL,`api_type` varchar(15) DEFAULT NULL,`headers` varchar(255) DEFAULT NULL,`data_json` text 
**
CRT_TBL|bot_node_content|`flow_id` int(11) DEFAULT NULL,`node` int(11) DEFAULT NULL,`language` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,`greeting` mediumtext COLLATE utf8_unicode_ci,`voice` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,`options` mediumtext COLLATE utf8_unicode_ci
**
CRT_TBL|bot_node_mapping|`flow_id` int(11) DEFAULT NULL,`node_out` int(11) DEFAULT NULL,`node_in` int(11) DEFAULT NULL,`out_class` varchar(16) DEFAULT NULL
**
CRT_TBL|bot_node_master| `flow_id` int(11) DEFAULT NULL,`node` int(11) DEFAULT NULL,`label` varchar(50) DEFAULT NULL,`option_type` varchar(50) DEFAULT NULL,`options` text,`options_dest` text,`no_match_retry` varchar(100) DEFAULT NULL,`setlanguage` int(1) DEFAULT NULL,`app` varchar(100) DEFAULT NULL,`appdata` varchar(100) DEFAULT NULL,`api` varchar(100) DEFAULT NULL,`utterance` decimal(10,1) DEFAULT '0.6',`max_listen` int(11) DEFAULT '30',`max_silence` int(11) DEFAULT '2',`repeat_nomatch` int(1) DEFAULT '0',`skip_language` int(1) DEFAULT '0',`api_var` text,`condition` varchar(250) DEFAULT NULL,`is_condition` int(11) DEFAULT '0',`is_main` int(11) DEFAULT NULL,`is_mail` int(11) DEFAULT '0',`is_sms` int(11) DEFAULT '0',`is_whatsapp` int(11) DEFAULT '0',`email_to` varchar(100) DEFAULT NULL,`email_subject` varchar(100) DEFAULT NULL,`email_content` varchar(250) DEFAULT NULL,`sms_content` varchar(250) DEFAULT NULL,`whatsapp_content` varchar(250) DEFAULT NULL,`no_response` int(11) DEFAULT '2',`no_response_time` int(11) DEFAULT '60',`validate_type` varchar(20) DEFAULT NULL,`validate_var` varchar(50) DEFAULT NULL
**
CRT_TBL|ivrflowbot_sounds|`id` int(11) NOT NULL AUTO_INCREMENT,`name` varchar(255) NOT NULL,`upload_file_name` varchar(255) DEFAULT NULL,`flow_id` int(11) DEFAULT NULL,PRIMARY KEY (`id`),UNIQUE KEY `sounds_name` (`name`),UNIQUE KEY `upload_file_name` (`upload_file_name`)
**
CRT_TBL|ivrflow_cdr|`start_time` datetime DEFAULT NULL, `flow_id` int(11) DEFAULT NULL,`channel` varchar(150) DEFAULT NULL,`uniqueid` varchar(100) DEFAULT NULL,`threadid` varchar(100) DEFAULT NULL,`did` varchar(16) DEFAULT NULL,`caller_id` varchar(16) DEFAULT NULL,`end_time` datetime DEFAULT NULL,`durn` varchar(30) DEFAULT NULL,`recfilename` varchar(255) DEFAULT NULL, `client_id` int(11) DEFAULT NULL
**
CRT_TBL|ivrflow_directory|`name` varchar(50) DEFAULT NULL,`exten` varchar(16) DEFAULT NULL,`node` varchar(50) DEFAULT NULL,`flow_id` int(11) DEFAULT NULL
**
CRT_TBL|ivrflow_log|`flow_id` int(11) DEFAULT NULL,`uniqueid` varchar(100) DEFAULT NULL, `ins_from` varchar(50) DEFAULT NULL,`content` mediumtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,`translate_content` mediumtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,`language` varchar(50) DEFAULT NULL,`node` int(11) DEFAULT NULL,`cr_datetime` datetime DEFAULT CURRENT_TIMESTAMP,`match_status` int(11) DEFAULT NULL,`utterance` decimal(4,2) DEFAULT NULL
**
CRT_TBL|ivrflow_mail_log|`send_time` datetime DEFAULT CURRENT_TIMESTAMP,`channel` varchar(100) DEFAULT NULL,`flow_id` int(11) DEFAULT NULL,`client_id` int(11) DEFAULT NULL,`uniqueid` varchar(100) DEFAULT NULL,`node` int(11) DEFAULT NULL,`caller_id` varchar(16) DEFAULT NULL,`email_to` varchar(100) DEFAULT NULL,`subject` varchar(100) DEFAULT NULL,`content` tinytext,`status_code` int(11) DEFAULT NULL,`status` varchar(150) DEFAULT NULL
**
CRT_TBL|ivrflow_nomatch|`start_time` datetime DEFAULT NULL,`flow_id` int(11) DEFAULT NULL,`channel` varchar(150) DEFAULT NULL,`uniqueid` varchar(100) DEFAULT NULL,`did` varchar(16) DEFAULT NULL,`caller_id` varchar(16) DEFAULT NULL,`node` varchar(30) DEFAULT NULL,`answer` varchar(255) DEFAULT NULL,`answer_translate` varchar(255) DEFAULT NULL,`best_match` varchar(255) DEFAULT NULL,`utterance` decimal(5,2) DEFAULT NULL,`client_id` int(11) DEFAULT NULL
**
CRT_TBL|ivrflow_question|`q_id` int(11) NOT NULL AUTO_INCREMENT,`question` text,`match_case` text,`answer` text,`next_node` int(11) DEFAULT NULL,`node` varchar(50) DEFAULT NULL,`flow_id` varchar(50) DEFAULT NULL,PRIMARY KEY (`q_id`) USING BTREE
**
CRT_TBL|ivrflow_question_voice|`q_id` int(11) DEFAULT NULL,`language` varchar(50) DEFAULT NULL,`voice` varchar(150) DEFAULT NULL,`greet` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,`node` int(11) DEFAULT NULL,`flow_id` int(11) DEFAULT NULL
**
CRT_TBL|ivrflow_sms_log|`send_time` datetime DEFAULT CURRENT_TIMESTAMP,`channel` varchar(100) DEFAULT NULL,`flow_id` int(11) DEFAULT NULL,`client_id` int(11) DEFAULT NULL,`uniqueid` varchar(100) DEFAULT NULL,`node` int(11) DEFAULT NULL,`caller_id` varchar(16) DEFAULT NULL,`content` varchar(150) DEFAULT NULL,`status_code` int(11) DEFAULT NULL,`status` varchar(150) DEFAULT NULL
**
CRT_TBL|ivrflow_whatsapp_log|`send_time` datetime DEFAULT CURRENT_TIMESTAMP,`channel` varchar(100) DEFAULT NULL,`flow_id` int(11) DEFAULT NULL,`client_id` int(11) DEFAULT NULL,`uniqueid` varchar(100) DEFAULT NULL,`node` int(11) DEFAULT NULL,`caller_id` varchar(16) DEFAULT NULL,`content` varchar(150) DEFAULT NULL,`status_code` int(11) DEFAULT NULL,`status` varchar(150) DEFAULT NULL
**
CRT_TBL|live_conference|`member` VARCHAR(20) NOT NULL,`conf_no` VARCHAR(16) NULL DEFAULT NULL,`channel` VARCHAR(100) NULL DEFAULT NULL,`marked` INT(1) NULL DEFAULT '0',`p_id` INT(1) NULL DEFAULT '0',`c_id` INT(1) NULL DEFAULT '0',`parked` INT(1) NULL DEFAULT '0',`mute` INT(1) NULL DEFAULT '0',`status` VARCHAR(20) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`cr_date` DATETIME NULL DEFAULT CURRENT_TIMESTAMP,UNIQUE INDEX `channel` (`channel`) USING BTREE
**
ADD_CLM|register_soft|multi_client|VARCHAR|100|Y|NULL|mobile_app
**
ADD_CLM|register_soft|encrypt|VARCHAR|100|Y|NULL|multi_client
**
ADD_CLM|live_conference|client_id|INT|11|Y|0|status
**
ADD_CLM|live_call|cid|INT|11|Y|0|Caller_id 
**
ADD_CLM|blast_cdr|san_unique_id|VARCHAR|50|Y|NULL|unique_id
**
ADD_CLM|blast_cdr|cid|INT|11|Y|0|end_call
**
ADD_CLM|zoho_conf|cid|INT|11|Y|0|record_url
**
ADD_CLM|zoho_user|z_id|INT|11|Y|0|is_active
**
ADD_CLM|company|dialpad_permission|INT|11|Y|0|master_login
**
ADD_CLM|company|change_pass_first|INT|11|Y|0|dialpad_permission
**
ADD_CLM|company|reset_pass|INT|11|Y|0|change_pass_first
**
ADD_CLM|company|reset_after_days|VARCHAR|4|Y|NULL|reset_pass
**
ADD_CLM|company|no_previous_pass|INT|11|Y|0|reset_after_days
**
ADD_CLM|company|pass_len|VARCHAR|4|Y|8|no_previous_pass
**
ADD_CLM|company|alert_mail_send|INT|11|Y|0|pass_len
**
ADD_CLM|users_master|last_pass|VARCHAR|32|Y|NULL|cid
**
ADD_CLM|users_master|pass_change_time|DATETIME||Y|NULL|last_pass
**
ADD_CLM|musiconhold|display_name|VARCHAR|50|Y|NULL|name
**
ADD_CLM|sip_san|register_time|DATETIME||Y|NULL|is_prepaid
**
CRT_TBL|audiosocket|`id` INT(11) NOT NULL AUTO_INCREMENT,`name` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`ip` VARCHAR(20) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`port` int(11) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`websocket` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`webhook` VARCHAR(150) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`san_app` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`san_value` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`access_token` text NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`cid` INT(11) DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE
**
CRT_TBL|audiosocket_rule|`id` INT(11) NOT NULL AUTO_INCREMENT,`context` VARCHAR(20) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`exten` VARCHAR(20) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`priority` int(11) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`app` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`appdata` VARCHAR(500) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`audio_id` INT(11) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',PRIMARY KEY (`id`) USING BTREE
**
CRT_TBL|audiosocket_transfer|`id` INT(11) NOT NULL AUTO_INCREMENT,`context` VARCHAR(20) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`exten` VARCHAR(20) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`priority` int(11) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`app` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`appdata` VARCHAR(255) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`audio_id` INT(11) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',PRIMARY KEY (`id`) USING BTREE
**
CRT_TBL|audiosocket_call_log|`id` INT(11) NOT NULL AUTO_INCREMENT,`caller_id` VARCHAR(16) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`unique_id` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`channel` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`uniq_uuid` VARCHAR(100) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`start_time` datetime DEFAULT NULL,`end_time` datetime DEFAULT NULL,`call_durn` INT(11) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`rec_path` VARCHAR(255) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`insert_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,PRIMARY KEY (`id`) USING BTREE
**
CRT_TBL|audiosocket_current_call|`id` INT(11) NOT NULL AUTO_INCREMENT,`caller_id` VARCHAR(16) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`unique_id` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`channel` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`uniq_uuid` VARCHAR(100) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`start_time` datetime DEFAULT NULL,`end_time` datetime DEFAULT NULL,`call_durn` INT(11) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`rec_path` VARCHAR(255) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`insert_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,PRIMARY KEY (`id`) USING BTREE
**
ADD_CLM|users_master|invalid_attempt|INT|11|Y|0|pass_change_time
**
ADD_CLM|san_voicemail|invalid_attempts|INT|11|Y|0|exten_id
**
ADD_CLM|users_master|is_login|INT|11|Y|0|pass_change_time
**
ADD_CLM|audiosocket|websocket_retries|INT|11|Y|0|access_token
**
ADD_CLM|audiosocket|websocket_failover|VARCHAR|50|Y|NULL|websocket_retries
**
ADD_CLM|audiosocket|websocket_failover_value|VARCHAR|50|Y|NULL|websocket_failover
**
ADD_CLM|audiosocket|json_str|VARCHAR|200|Y|NULL|websocket_failover_value
**
CRT_TBL|audiosocket_failover|`id` INT(11) NOT NULL AUTO_INCREMENT,`context` VARCHAR(20) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`exten` VARCHAR(20) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`priority` int(11) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`app` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`appdata` VARCHAR(255) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`audio_id` INT(11) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',PRIMARY KEY (`id`) USING BTREE
**
ADD_CLM|ivr_rule|holiday_group|INT|11|Y|NULL|user_group
**
CRT_TBL|ivr_rule_flow|`id` INT(11) NOT NULL AUTO_INCREMENT,`context` VARCHAR(20) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`exten` VARCHAR(20) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`priority` int(11) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`app` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`appdata` VARCHAR(255) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`flow_id` INT(11) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',PRIMARY KEY (`id`) USING BTREE
**
ADD_CLM|client|other_crm|VARCHAR|200|Y|NULL|whatsapp_api
**
ADD_CLM|sip_san|auto_barge|INT|11|Y|NULL|skip_login
**
ADD_CLM|register_soft|auto_barge|VARCHAR|100|Y|NULL|encrypt
**
ADD_CLM|users_master|ci_session|VARCHAR|150|Y|NULL|pass_change_time
**
ALT_CLM_QRY|users_master|last_activity|alter table users_master add column last_activity TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
**
ADD_CLM|audiosocket|recording_api_url|VARCHAR|200|Y|NULL|json_str
**
ADD_CLM|audiosocket|recording_api_key|VARCHAR|200|Y|NULL|recording_api_url
**
ADD_CLM|users_master|otp|INT|11|Y|NULL|ci_session
**
ADD_CLM|users_master|resetid|VARCHAR|15|Y|NULL|otp
**
ADD_CLM|users_master|otp_time|DATETIME||Y|NULL|resetid
**
ADD_CLM|company|forget_pass|INT|11|Y|0|alert_mail_send
**
CRT_TBL|password_history|`id` int(11) NOT NULL AUTO_INCREMENT,`user_id` INT(11) NOT NULL,`pass` VARCHAR(150) NOT NULL,`cr_datetime` DATETIME NULL DEFAULT CURRENT_TIMESTAMP,PRIMARY KEY (`id`) USING BTREE
**
COM|30-7-24 Billing Table Start
**
ADD_CLM|register_soft|is_billing|VARCHAR|100|Y|NULL|auto_barge
**
CRT_TBL|state_master|`id` int(11) NOT NULL AUTO_INCREMENT,`state_name` varchar(50) DEFAULT NULL,`state_code` varchar(3) DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE
**
CRT_TBL|bill_company| `id` int(11) NOT NULL AUTO_INCREMENT,`name` varchar(50) DEFAULT NULL,`state` int(11) DEFAULT NULL,`gst_no` varchar(15) DEFAULT NULL,`address` text,
`bank_name` varchar(100) DEFAULT NULL,`bank_branch` varchar(150) DEFAULT NULL, `bank_account` bigint(20) DEFAULT NULL,`bank_account_name` varchar(100) DEFAULT NULL,`pan` varchar(10) DEFAULT NULL, `micr_code` varchar(20) DEFAULT NULL,`ifsc_code` varchar(20) DEFAULT NULL,`bill_prefix` varchar(10) DEFAULT NULL,`website` varchar(100) DEFAULT NULL,`email` varchar(100) DEFAULT NULL,PRIMARY KEY (`id`),KEY `state` (`state`),CONSTRAINT `state` FOREIGN KEY (`state`) REFERENCES `state_master` (`id`) ON UPDATE NO ACTION
**
CRT_TBL|std_table| `std_code` varchar(16) DEFAULT NULL,`name` varchar(50) DEFAULT NULL,`call_charges` decimal(6,2) DEFAULT NULL,`pulse` int(11) DEFAULT NULL,`call_charges_cut` decimal(6,2) DEFAULT NULL,`cutter_id` int(11) DEFAULT NULL 
**
CRT_TBL|rate_cutter|`id` int(11) NOT NULL AUTO_INCREMENT,`cutter_name` varchar(50) DEFAULT NULL,`price` varchar(50) DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE
**
CRT_TBL|plan_master|  `id` int(11) NOT NULL AUTO_INCREMENT,`plan_name` varchar(50) DEFAULT NULL,`rental` int(11) DEFAULT NULL,`free_calls` int(11) DEFAULT NULL,
`call_charges` decimal(4,2) DEFAULT NULL, `channels` int(11) DEFAULT NULL,`did` int(11) DEFAULT NULL,`did_charge` decimal(4,2) DEFAULT NULL,`call_limit` int(11) DEFAULT NULL,`cgst` int(11) DEFAULT NULL,`sgst` int(11) DEFAULT NULL,`igst` int(11) DEFAULT NULL,`status` int(11) DEFAULT NULL,`rate_cutter` int(11) DEFAULT NULL,`credit_limit` int(11) DEFAULT NULL,`cr_date` datetime DEFAULT CURRENT_TIMESTAMP,PRIMARY KEY (`id`),KEY `rate_cutter_plan` (`rate_cutter`),CONSTRAINT `rate_cutter_plan` FOREIGN KEY (`rate_cutter`) REFERENCES `rate_cutter` (`id`) ON UPDATE NO ACTION
**
CRT_TBL|party_master|  `id` int(11) NOT NULL AUTO_INCREMENT,`cust_code` varchar(50) DEFAULT NULL,`account_no` varchar(50) DEFAULT NULL,`party_name` varchar(50) DEFAULT NULL,`contact_name` varchar(16) DEFAULT NULL,`contact_phone` varchar(16) DEFAULT NULL,`address` varchar(150) DEFAULT NULL,`email_id` varchar(100) DEFAULT NULL,`gst_no` varchar(15) DEFAULT NULL,`state` int(11) DEFAULT NULL,`pin_code` int(11) DEFAULT NULL,`plan` int(11) DEFAULT NULL,`status` int(11) DEFAULT NULL,`local_status` int(11) DEFAULT '1',`isd_status` int(11) DEFAULT '0',`extra_channel` int(11) DEFAULT NULL,`discount` int(11) DEFAULT NULL,`rate_cutter` int(11) DEFAULT NULL,`did_count` int(11) DEFAULT NULL,`disconnect` int(1) DEFAULT NULL,`disconnect_date` date DEFAULT NULL,`cr_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,PRIMARY KEY (`id`),KEY `state_party` (`state`),KEY `plan_party` (`plan`),KEY `rate_cutter_party` (`rate_cutter`),CONSTRAINT `plan_party` FOREIGN KEY (`plan`) REFERENCES `plan_master` (`id`) ON UPDATE NO ACTION,CONSTRAINT `rate_cutter_party` FOREIGN KEY (`rate_cutter`) REFERENCES `rate_cutter` (`id`) ON UPDATE NO ACTION,CONSTRAINT `state_party` FOREIGN KEY (`state`) REFERENCES `state_master` (`id`) ON UPDATE NO ACTION
**
CRT_TBL|did_issue| `id` int(11) NOT NULL AUTO_INCREMENT,`cust_id` int(11) DEFAULT NULL,`did_type` varchar(30) DEFAULT NULL,`from_did` int(11) DEFAULT NULL,`to_did` int(11) DEFAULT NULL,`individual` int(11) DEFAULT NULL,`multi_did` varchar(250) DEFAULT NULL,`did_status` int(11) DEFAULT '1',`disconnect_date` date DEFAULT NULL,`cust_disconnect_date` date DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE
**
CRT_TBL|did_issue_list| `did` int(11) DEFAULT NULL,`cust_id` int(11) DEFAULT NULL
**
CRT_TBL|billing_cdr| `id` int(11) NOT NULL AUTO_INCREMENT,`exten` int(11) DEFAULT NULL,`did_no` int(11) DEFAULT '0',`caller_id` varchar(16) NOT NULL DEFAULT '0',`call_type` varchar(20) NOT NULL DEFAULT '0',`unique_id` varchar(50) DEFAULT NULL,`san_calluniqueid` varchar(50) DEFAULT NULL,`san_calldate` datetime DEFAULT NULL,`start_time` datetime DEFAULT NULL,`answer_time` datetime DEFAULT NULL,`end_time` datetime DEFAULT NULL,`cust_id` int(11) NOT NULL DEFAULT '0',`plan_id` int(11) NOT NULL DEFAULT '0',`call_charges` double NOT NULL DEFAULT '0',`duration` int(11) NOT NULL DEFAULT '0',
`billsec` int(11) NOT NULL DEFAULT '0',`total_pulse` int(11) NOT NULL DEFAULT '0',`disposition` varchar(50) DEFAULT NULL,`insert_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,PRIMARY KEY (`id`) USING BTREE
**
ADD_CLM|billing_cdr|call_category|enum('Local','STD','ISD')||Y|NULL|disposition
**
CRT_TBL|bill_cust_summary| `id` int(11) NOT NULL AUTO_INCREMENT,`call_date` date DEFAULT NULL,`cust_id` int(11) DEFAULT NULL,`local_calls` int(11) DEFAULT NULL,`isd_calls` int(11) DEFAULT NULL,`total_local_duration` int(11) DEFAULT NULL,`total_isd_duration` int(11) DEFAULT NULL,`total_local_billsec` int(11) DEFAULT NULL,`total_isd_billsec` int(11) DEFAULT NULL,`total_local_pulse` int(11) DEFAULT NULL,`total_isd_pulse` int(11) DEFAULT NULL,`total_local_call_charges` double DEFAULT NULL,`total_isd_call_charges` double DEFAULT NULL,`insert_date` datetime DEFAULT CURRENT_TIMESTAMP,PRIMARY KEY (`id`) USING BTREE
**
CRT_TBL|bill_payment| `id` int(11) NOT NULL AUTO_INCREMENT,`party_id` int(11) DEFAULT NULL,`receiving_date` datetime DEFAULT NULL,`receive_amount` decimal(6,2) DEFAULT NULL,`payment_mode` varchar(10) DEFAULT NULL,`ref_no` varchar(50) DEFAULT NULL,`remark` varchar(100) DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE
**
CRT_TBL|bill_sub_table|`bill_id` int(11) NOT NULL AUTO_INCREMENT,`bill_date` date DEFAULT NULL,`bill_period_from` date DEFAULT NULL,`bill_period_to` date DEFAULT NULL, `insert_date` datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`bill_id`) USING BTREE
**
CRT_TBL|bill_table|`id` int(11) NOT NULL AUTO_INCREMENT,`bill_id` int(11) NOT NULL DEFAULT '0',`cust_id` int(11) NOT NULL DEFAULT '0',`bill_date` date DEFAULT NULL,`bill_period_from` date DEFAULT NULL,`bill_period_to` date DEFAULT NULL,`monthly_rental` int(11) NOT NULL DEFAULT '0',`local_calling_charges` double DEFAULT NULL,`isd_calling_charges` double DEFAULT NULL,`addon_did_charges` double DEFAULT NULL,`isd_rate_cutter_charges` double DEFAULT NULL,`discount` double DEFAULT NULL,`total_charges` double DEFAULT NULL,`cgst` double DEFAULT NULL,`sgst` double DEFAULT NULL,`igst` double DEFAULT NULL,`net_payable` double DEFAULT NULL,`isd_pulses` int(11) DEFAULT NULL,`local_pulses` int(11) DEFAULT NULL,`free_local_pulses` int(11) DEFAULT NULL,`chargeable_local_pulses` int(11) DEFAULT NULL,`addon_did_count` int(11) DEFAULT NULL,`rate_cutter_name` varchar(50) DEFAULT NULL,`insert_date` datetime DEFAULT CURRENT_TIMESTAMP,PRIMARY KEY (`id`) USING BTREE
**
CRT_TBL|bill_transactions| `id` int(11) NOT NULL AUTO_INCREMENT,`party_id` int(11) DEFAULT NULL,`transaction_date` date DEFAULT NULL,`transaction_type` varchar(2) DEFAULT NULL,`ref_no` varchar(50) DEFAULT NULL,`transaction_amt` double DEFAULT NULL,`bill_id` int(11) DEFAULT '0',`bill_table_id` int(11) DEFAULT '0',`insert_date` datetime DEFAULT CURRENT_TIMESTAMP,PRIMARY KEY (`id`) USING BTREE
**
CRT_TBL|user_custom_report|`id` INT(11) NOT NULL AUTO_INCREMENT,`user_id` INT(11) NOT NULL,`report_id` VARCHAR(11) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',PRIMARY KEY (`id`) USING BTREE
**
CRT_TBL|auto_barge|`barge_phone` bigint(20) DEFAULT NULL, `barge_channel` int(11) DEFAULT NULL,`exten_id` int(11) DEFAULT NULL
**
ADD_CLM|company|disable_captcha|INT|11|Y|0|forget_pass
**
ADD_CLM|lan|file_name|VARCHAR|100|Y|NULL|id
**
ADD_CLM|lan|lan_data|TEXT||Y|NULL|net_type
**
ADD_CLM|dbbackup|with_cdr|INT|11|Y|0|is_config
**
ADD_CLM|dbbackup|ftp_status|VARCHAR|10|Y|NULL|with_cdr
**
ADD_CLM|dbbackup|restore_status|VARCHAR|10|Y|NULL|ftp_status
**
ADD_CLM|db_schedule|with_cdr|INT|11|Y|0|is_config
**
ADD_CLM|company|cdr_remove_days|INT|11|Y|0|disable_captcha
**
ADD_CLM|company|cdr_remove_by|VARCHAR|10|Y|NULL|cdr_remove_days
**
ADD_CLM|company|cdr_remove_exec|INT|11|Y|0|cdr_remove_by
**
CRT_TBL|job_scheduler| `id` int(11) NOT NULL AUTO_INCREMENT,`name` VARCHAR(50) DEFAULT NULL,`minute` VARCHAR(2) DEFAULT NULL,`hour` VARCHAR(2) DEFAULT NULL,`month` VARCHAR(2)  DEFAULT NULL,`month_day` VARCHAR(2)  DEFAULT NULL,`week_day` VARCHAR(3),`custom` VARCHAR(30)  DEFAULT NULL,`job` varchar(255) DEFAULT NULL,`insert_date` datetime DEFAULT CURRENT_TIMESTAMP,`disable` INT(11) DEFAULT 0,PRIMARY KEY (`id`) USING BTREE
**
ADD_CLM|audiosocket_current_call|audiosocket_id|INT|11|Y|NULL|id
**
ADD_CLM|audiosocket_call_log|audiosocket_id|INT|11|Y|NULL|id
**
ADD_CLM|audiosocket_current_call|did|VARCHAR|16|Y|NULL|audiosocket_id
**
ADD_CLM|audiosocket_call_log|did|VARCHAR|16|Y|NULL|audiosocket_id
**
ADD_CLM|sip_san|hide_callerid|INT|11|Y|0|auto_barge
**
ADD_CLM|party_master|opening_balance_type|VARCHAR|6|Y|0|disconnect
**
ADD_CLM|party_master|opening_balance|DOUBLE||Y|0|opening_balance_type
**
CRT_TBL|out_timeconditions|`id` INT(11) NOT NULL AUTO_INCREMENT,`start_time_hh` VARCHAR(2) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`start_time_mm` VARCHAR(2) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`end_time_hh` VARCHAR(2) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`end_time_mm` VARCHAR(2) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`week_start_day` VARCHAR(10) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`week_end_day` VARCHAR(10) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`month_start_day` VARCHAR(10) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`month_end_day` VARCHAR(10) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`month_start` VARCHAR(10) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`month_end` VARCHAR(10) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`timerule` VARCHAR(200) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`cid` INT(11) NULL DEFAULT '0',PRIMARY KEY (`id`) USING BTREE
**
ADD_CLM|sip_san|skip_dnd|INT|1|Y|0|auto_barge
**
ADD_CLM|sip_san|time_group|INT|11|Y|NULL|skip_dnd
**
CRT_TBL|retry_attempt|`id` INT(11) NOT NULL AUTO_INCREMENT,`retry_count` INT(11) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`retry_interval_type` VARCHAR(10) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`retry_interval` INT(11) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`cid` INT(11) NULL DEFAULT '0',PRIMARY KEY (`id`) USING BTREE
**
COM|28-9-24 Start
**
ADD_CLM|company|check_retry|INT|11|Y|0|cdr_remove_exec
**
ADD_CLM|company|pd_local_channel|INT|1|Y|0|check_retry
**
ADD_CLM|company|block_parallel_dialing|INT|1|Y|0|pd_local_channel
**
QRY|DROP FUNCTION IF EXISTS `import_column_validation`;
**
QRY|CREATE FUNCTION `import_column_validation`(`col_name` TEXT) RETURNS text CHARSET utf8mb4 COLLATE utf8mb4_bin DETERMINISTIC BEGIN SET @new_col_value = IFNULL(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(col_name,CHAR(10),''),CHAR(13),''),CHAR(34),''),CHAR(39),''),CHAR(44),''),''); return case when @new_col_value = '' OR @new_col_value = '0' then NULL ELSE @new_col_value END; END
**
ADD_CLM|company|multi_user_login|INT|1|Y|0|block_parallel_dialing
**
ADD_CLM|client|access_key|VARCHAR|10|Y|NULL|other_crm
**
ADD_CLM|client|access_token|VARCHAR|150|Y|NULL|access_key
**
ADD_CLM|account_code|valid_upto|VARCHAR|10|Y|NULL|allow_durn
**
CRT_TBL|account_allowed_number|`id` INT(11) NOT NULL AUTO_INCREMENT,`number` VARCHAR(16) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`account_id` INT(11) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',PRIMARY KEY (`id`) USING BTREE
**
ADD_CLM|company|allow_account_contact|INT|11|Y|0|bot_app_port
**
ADD_CLM|company|allow_account_code_durn|INT|5|Y|NULL|allow_account_contact
**
ADD_CLM|company|account_durn_valid_upto|VARCHAR|10|Y|NULL|allow_account_code_durn
**
ADD_CLM|live_conference|talking|VARCHAR|5|Y|0|status
**
CRT_TBL|user_conference_master|`id` INT(11) NOT NULL AUTO_INCREMENT,`user_id` INT(11) NOT NULL,`conf_id` VARCHAR(11) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',PRIMARY KEY (`id`) USING BTREE
**
ADD_CLM|company|custom_dnd|INT|11|Y|0|check_retry
**
CRT_TBL|api_dnd|`id` INT(11) NOT NULL AUTO_INCREMENT,`number` varchar(20) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`status` INT(11) NULL DEFAULT '0',`cid` INT(11) NULL DEFAULT '0',PRIMARY KEY (`id`) USING BTREE
**
CRT_TBL|call_attempts|`id` INT(11) NOT NULL AUTO_INCREMENT,`phone_no` varchar(20) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',`attempt_count` INT(11) NULL DEFAULT NULL,`last_attempt_time` datetime DEFAULT NULL,`next_attempt_time` datetime DEFAULT NULL,`insert_date` datetime DEFAULT CURRENT_TIMESTAMP,PRIMARY KEY (`id`) USING BTREE
**
ADD_CLM|acd_group|san_announce|VARCHAR|10|Y|NULL|on_call