ADD_CLM|license|mobile_app|BLOB||Y|NULL|NoOfLiveAgents
**
ADD_CLM|license|Quality|BLOB||Y|NULL|ivr_blasting
**
ADD_CLM|license|Attendance|BLOB||Y|NULL|Quality
**
ADD_CLM|license|omni_channel|BLOB||Y|NULL|Attendance
**
ADD_CLM|license|NoOfMobileAgents|BLOB||Y|NULL|mobile_app
**
ADD_CLM|license|NoOfOmniAgents|BLOB||Y|NULL|NoOfMobileAgents
**
ADD_CLM|client_license|NoOfAppLiveAgents|VARCHAR|30|Y|NULL|NoOfLiveAgents
**
ADD_CLM|client_license|NoOfOmniAgents|VARCHAR|30|Y|NULL|NoOfAppLiveAgents
**
ADD_CLM|updatecrmstatelog|id|INT|11|N|0|PRIMARY KEY AUTO_INCREMENT FIRST
**
ADD_CLM|updatecrmstatelog|crmlogoutby|INT|5|Y|NULL|crmext_channel_id
**
ADD_CLM|company|recording_url|VARCHAR|250|Y|NULL|socket_token		
**
ADD_CLM|company|showTrunkStatus|INT|2|Y|0|recording_url
**
ADD_CLM|company|show_did_in_l_monitoring|INT|2|Y|0|showTrunkStatus
**
ADD_CLM|company|software_logs|INT|2|Y|0|show_did_in_l_monitoring
**
ADD_CLM|company|socket_emit_logs|INT|2|Y|0|software_logs
**
ADD_CLM|company|socket_on_logs|INT|2|Y|0|socket_emit_logs
**
ADD_CLM|company|enable_console|INT|2|Y|0|socket_on_logs
**
ADD_CLM|company|video_server_url|VARCHAR|200|Y|NULL|enable_console
**
ADD_CLM|company|dialer_api_key|VARCHAR|50|Y|NULL|api_before_open_in_cmp
**
ADD_CLM|company|dialer_api_token|VARCHAR|200|Y|NULL|dialer_api_key
**
ADD_CLM|company|dialer_jwt_token|TEXT|||NULL|dialer_api_token
**
ADD_CLM|company|dialer_jwt_expiry_time|DATETIME|||NULL|dialer_jwt_token
**
ADD_CLM|company|api_integration_key|VARCHAR|50|Y|NULL|dialer_jwt_expiry_time
**
ADD_CLM|company|crm_db_host|VARCHAR|20|Y|NULL|api_integration_key
**
ADD_CLM|company|crm_db_user|VARCHAR|20|Y|NULL|crm_db_host
**
ADD_CLM|company|crm_db_passwd|VARCHAR|100|Y|NULL|crm_db_user
**
ADD_CLM|company|crm_db_name|VARCHAR|20|Y|NULL|crm_db_passwd
**
ADD_CLM|company|crm_db_port|INT|5|Y|NULL|crm_db_name
**
ADD_CLM|company|max_upload_size|INT|5|Y|NULL|crm_db_port
**
ADD_CLM|company|queue_interval_time|INT|5|Y|NULL|max_upload_size
**
ADD_CLM|company|console_log|INT|5|Y|NULL|queue_interval_time
**
ADD_CLM|company|console_log_days|INT|2|Y|NULL|console_log
**
ADD_CLM|company|event_log|INT|5|Y|NULL|console_log_days
**
ADD_CLM|company|omni_client_url|VARCHAR|200|Y|NULL|event_log
**
ADD_CLM|company|omni_server_url|VARCHAR|200|Y|NULL|omni_client_url
**
ADD_CLM|company|omni_server_host|VARCHAR|200|Y|NULL|omni_server_url
**
ADD_CLM|company|omni_server_host_port|VARCHAR|200|Y|NULL|omni_server_host
**
ADD_CLM|company|omni_server_host_password|VARCHAR|200|Y|NULL|omni_server_host_port
**
ADD_CLM|company|omni_conf_file_path|VARCHAR|200|Y|NULL|omni_server_host_password
**
ADD_CLM|company|ssl_key_path|VARCHAR|200|Y|NULL|omni_conf_file_path
**
ADD_CLM|company|ssl_cert_path|VARCHAR|200|Y|NULL|ssl_key_path
**
ADD_CLM|company|agent_page_url|VARCHAR|200|Y|NULL|event_log
**
ADD_CLM|company|admin_page_url|VARCHAR|200|Y|NULL|agent_page_url
**
ADD_CLM|company|otp_mobile_no|VARCHAR|200|Y|NULL|admin_page_url
**
ADD_CLM|company|otp_email_id|VARCHAR|200|Y|NULL|otp_mobile_no
**
ADD_CLM|company|split_otp|VARCHAR|200|Y|NULL|otp_email_id
**
ADD_CLM|company|from_email_otp_acc|VARCHAR|100|Y|NULL|split_otp
**
ADD_CLM|company|data_update_otp|VARCHAR|100|Y|NULL|from_email_otp_acc
**
ADD_CLM|company|data_update_otp_expiry_tm|DATETIME||Y|NULL|data_update_otp
**
ADD_CLM|company|audio_monitor_url|VARCHAR|200|Y|NULL|data_update_otp_expiry_tm
**
ADD_CLM|company|audio_mntr_ref_time|INT|11|Y|NULL|audio_monitor_url
**
ADD_CLM|company|meeting_link_base_url|TEXT|||NULL|audio_mntr_ref_time
**
ADD_CLM|company|meeting_secret_key|TEXT|||NULL|meeting_link_base_url
**
ADD_CLM|company|meeting_api_base_url|VARCHAR|200|Y|NULL|meeting_secret_key
**
ADD_CLM|company|meeting_webhook_url|TEXT|||NULL|meeting_api_base_url
**
ADD_CLM|company|meeting_webhook_id|VARCHAR|200|Y|NULL|meeting_webhook_url
**
ADD_CLM|company|tms_access_token|TEXT|||NULL|tms_url
**
ADD_CLM|company|mobileAppVersion|VARCHAR|10|Y|NULL|meeting_webhook_id
**
ADD_CLM|company|other_crm_api|INT|1|Y|0|mobileAppVersion
**
ADD_CLM|company|mobile_api_log|INT|1|Y|0|other_crm_api
**
ADD_CLM|company|master_user_otp_login|INT|1|Y|0|mobile_api_log
**
ADD_CLM|company|enable_socket_log|INT|1|Y|0|master_user_otp_login
**
ADD_CLM|company|with_telephony|INT|2|Y|0|enable_socket_log
**
ADD_CLM|company|forgotPassword|INT|1|Y|0|strongPassword
**
ADD_CLM|company|calling_hours_from|TIME||Y|NULL|forgotPassword
**
ADD_CLM|company|calling_hours_to|TIME||Y|NULL|calling_hours_from
**
ADD_CLM|company|enable_crm_node_app|INT|2|Y|0|calling_hours_to
**
ADD_CLM|company|crm_node_app_url|VARCHAR|200|Y|NULL|enable_crm_node_app
**
ADD_CLM|company|crm_node_app_token|VARCHAR|200|Y|NULL|crm_node_app_url
**
ADD_CLM|company|cdrjob_interval|INT|5|Y|NULL|crm_node_app_token
**
ADD_CLM|company|progressivejob_interval|INT|5|Y|NULL|cdrjob_interval
**
ADD_CLM|company|crm_node_app_logs|INT|1|Y|0|progressivejob_interval
**
ADD_CLM|company|loginWithOtp|INT|1|Y|0|crm_node_app_logs
**
ADD_CLM|company|enable_procedure_log|INT|1|Y|0|loginWithOtp
**
ADD_CLM|company|csv_limit|INT|11|Y|NULL|enable_procedure_log
**
ADD_CLM|company|activate_omni|INT|1|Y|0|csv_limit
**
ADD_CLM|company|activate_report_scheduler|INT|1|Y|0|activate_omni
**
ADD_CLM|company|omni_server_listen_port|INT|5|Y|NULL|activate_report_scheduler
**
ADD_CLM|company|app_path|VARCHAR|255|Y|NULL|omni_server_listen_port
**
ADD_CLM|company|app_url|VARCHAR|255|Y|NULL|app_path
**
ADD_CLM|company|file_attachment_path|VARCHAR|255|Y|NULL|app_url
**
ADD_CLM|company|faq_path|VARCHAR|255|Y|NULL|file_attachment_path
**
ADD_CLM|company|valid_file_upload|TEXT||Y|NULL|faq_path
**
ADD_CLM|company|ssl_ca_path|TEXT||Y|NULL|valid_file_upload
**
ADD_CLM|company|company_ssh_username|VARCHAR|50|Y|NULL|ssl_ca_path
**
ADD_CLM|company|company_ssh_host|VARCHAR|50|Y|NULL|company_ssh_username
**
ADD_CLM|company|company_ssh_password|TEXT||Y|NULL|company_ssh_host
**
ADD_CLM|company|company_ssh_port|VARCHAR|50|Y|NULL|company_ssh_password
**
ADD_CLM|agent_login_log|hold_durn|BIGINT|20|Y|NULL|remark
**
ADD_CLM|agent_current_states|last_campaign_call_type|VARCHAR|25|Y|NULL|last_phone_no
**
ADD_CLM|agent_current_states|ams_hold|BIGINT|20|Y|NULL|last_campaign_call_type
**
ADD_CLM|agent_current_states|ext_pause_unpause|TINYINT|4|Y|NULL|manual_on
**
ADD_CLM|agent_current_states|current_chat_tm|DATETIME|||NULL|ams_hold
**
ADD_CLM|agent_current_states|is_dnd|INT|2|Y|NULL|current_chat_tm
**
QRY|CALL Check_Index ('agent_current_states','login_extension_no');
**
ADD_CLM|agent_login_campaign|did_no|VARCHAR|50|Y|NULL|acd_code
**
ADD_CLM|client_master|data_storage_days|INT|3|Y|NULL|dndApiKey
**
ADD_CLM|client_master|NoOfAppLiveAgents|INT|3|Y|NULL|NoOfLiveAgents
**
ADD_CLM|client_master|allow_mobile_apps|INT|1|Y|NULL|data_storage_days
**
ADD_CLM|client_master|allowDNDfilter|INT|1|Y|0|dndApiKey
**
ADD_CLM|client_master|PD_channel|INT|5|Y|0|allowDNDfilter
**
ADD_CLM|client_master|disablePDChannels|INT|5|Y|0|PD_channel
**
ADD_CLM|client_master|allow_ip_addr|TEXT|||NULL|disablePDChannels
**
ADD_CLM|client_master|client_background_logo|VARCHAR|255|Y|NULL|allow_ip_addr
**
ADD_CLM|client_master|allow_internal_chat_only|INT|1|Y|NULL|client_background_logo
**
ADD_CLM|client_master|calling_hours_from|TIME||Y|NULL|allow_internal_chat_only
**
ADD_CLM|client_master|calling_hours_to|TIME||Y|NULL|calling_hours_from
**
ADD_CLM|client_master|allow_ip_addr_string|LONGTEXT||Y|NULL|calling_hours_to
**
ADD_CLM|client_master|NoOfMobileAgents|INT|3|Y|NULL|NoOfAppLiveAgents
**
ADD_CLM|client_master|NoOfOmniAgents|INT|3|Y|NULL|NoOfMobileAgents
**
ADD_CLM|client_master|max_agent|INT|11|Y|0|allow_ip_addr_string
**
ADD_CLM|client_master|fb_client_name|VARCHAR|200|Y|NULL|name
**
ADD_CLM|client_master|client_chat_logo|VARCHAR|200|Y|NULL|logo
**
ADD_CLM|client_master|cdr_api_url|VARCHAR|100|Y|NULL|client_chat_logo
**
ADD_CLM|client_master|cdrmethod|VARCHAR|10|Y|NULL|cdr_api_url
**
ADD_CLM|client_master|cdrauth|VARCHAR|20|Y|NULL|cdrmethod
**
ADD_CLM|client_master|opnpageactivecdrapi|INT|2|Y|0|cdrauth
**
ADD_CLM|client_master|basicauthusername|VARCHAR|100|Y|NULL|opnpageactivecdrapi
**
ADD_CLM|client_master|basicauthpassword|VARCHAR|100|Y|NULL|basicauthusername
**
ADD_CLM|client_master|bearerauthtoken|TEXT||Y|NULL|basicauthpassword
**
ADD_CLM|client_master|recording_location|VARCHAR|40|Y|NULL|bearerauthtoken
**
ADD_CLM|client_master|agent_login_another_device|INT|11|Y|NULL|recording_location
**
ADD_CLM|process|tranfer_call_to_another_pro|VARCHAR|50|Y|NULL|client_id
**
ADD_CLM|process|callback_date_range|INT|11|Y|NULL|tranfer_call_to_another_pro
**
ADD_CLM|process|auto_logout_time|INT|11|Y|NULL|callback_date_range
**
ADD_CLM|process|allowed_country_code|VARCHAR|10|Y|NULL|auto_logout_time
**
ADD_CLM|process|calling_priority|VARCHAR|200|Y|NULL|allowed_country_code
**
ADD_CLM|process|process_faq|INT|11|Y|NULL|calling_priority
**
ADD_CLM|process_setting|allowConferenceCall|INT|1|Y|NULL|holdOnConferenceCall
**
ADD_CLM|process_setting|allow_attendant_trfr|INT|1|Y|NULL|allow_agt_tnfr
**
ADD_CLM|process_setting|disbaleLogContactMaster|INT|1|Y|0|allowSmsWhatsapp
**
ADD_CLM|process_setting|doNotDialUnregisterExtension|INT|1|Y|0|disbaleLogContactMaster
**
ADD_CLM|process_setting|show_did_number_on_ringing|INT|1|Y|0|doNotDialUnregisterExtension
**
ADD_CLM|process_setting|custom_followup_list|INT|1|Y|0|show_did_number_on_ringing
**
ADD_CLM|process_setting|disable_redial|INT|1|Y|0|custom_followup_list
**
ADD_CLM|process_setting|hide_callerid|INT|1|Y|0|disable_redial
**
ADD_CLM|process_setting|call_back_reminder|INT|1|Y|0|hide_callerid
**
ADD_CLM|process_setting|allowSmsWhatsapp|INT|1|Y|0|time_zone
**
ADD_CLM|process_setting|allow_to_send_faq|INT|1|Y|0|call_back_reminder
**
ADD_CLM|process_setting|allow_attachment_in_chat|INT|1|Y|0|allow_to_send_faq
**
ADD_CLM|process_setting|multi_campaign_calling|INT|1|Y|0|allow_attachment_in_chat
**
ADD_CLM|process_setting|allow_agt_que_calls|INT|1|Y|0|multi_campaign_calling
**
ADD_CLM|process_setting|show_recording_url_to_agent|INT|1|Y|0|allow_agt_que_calls
**
ADD_CLM|process_setting|power_dialing|INT|1|Y|0|show_recording_url_to_agent
**
ADD_CLM|process_setting|add_proc_nm_wav_fl|INT|1|Y|0|add_agt_nm_wav_fl
**
ADD_CLM|process_setting|add_camp_nm_wav_fl|INT|1|Y|0|add_proc_nm_wav_fl
**
ADD_CLM|process_setting|hangup_host_conf|INT|1|Y|0|power_dialing
**
ADD_CLM|process_setting|api_type|VARCHAR|10|Y|NULL|whatsappApi
**
ADD_CLM|process_setting|api_provider|VARCHAR|20|Y|NULL|api_type
**
ADD_CLM|process_setting|whatsApp_passwd_key|VARCHAR|200|Y|NULL|api_provider
**
ADD_CLM|process_setting|disable_validation_on_fields|INT|1|Y|0|whatsApp_passwd_key
**
ADD_CLM|process_setting|process_wise_transfer|INT|1|Y|0|disable_validation_on_fields
**
ADD_CLM|process_setting|recent_call|INT|1|Y|0|process_wise_transfer
**
ADD_CLM|process_setting|auto_pg_dial_time|INT|1|Y|0|recent_call
**
ADD_CLM|process_setting|call_by_primary_field|INT|1|Y|0|auto_pg_dial_time
**
ADD_CLM|process_setting|auto_ready_from_break|INT|1|Y|0|call_by_primary_field
**
ADD_CLM|process_setting|agent_upload_attchment|INT|1|Y|0|auto_ready_from_break
**
ADD_CLM|process_setting|agent_view_scheduled_vc|INT|1|Y|0|agent_upload_attchment
**
ADD_CLM|process_setting|agent_lead_assign_notification|INT|1|Y|0|agent_view_scheduled_vc
**
ADD_CLM|process_setting|allow_same_time_callback|INT|1|Y|0|agent_lead_assign_notification
**
ADD_CLM|process_setting|api_after_assign|VARCHAR|200|Y|0|allow_same_time_callback
**
ADD_CLM|process_setting|api_after_assign_postdata|TEXT|||NULL|api_after_assign
**
ADD_CLM|process_setting|api_assign_method|VARCHAR|10|Y|NULL|api_after_assign_postdata
**
ADD_CLM|process_setting|custmUrlWebhook|INT|1|Y|0|api_assign_method
**
ADD_CLM|process_setting|auth|VARCHAR|200|Y|NULL|custmUrlWebhook
**
ADD_CLM|process_setting|api_assign_key|VARCHAR|200|Y|NULL|auth
**
ADD_CLM|process_setting|api_assign_value|VARCHAR|200|Y|NULL|api_assign_key
**
ADD_CLM|process_setting|basicauthusername|VARCHAR|200|Y|NULL|api_assign_value
**
ADD_CLM|process_setting|basicauthpassword|VARCHAR|200|Y|NULL|basicauthusername
**
ADD_CLM|process_setting|bearerauthtoken|VARCHAR|200|Y|NULL|basicauthpassword
**
ADD_CLM|process_setting|sms_passwd_key|VARCHAR|100|Y|NULL|bearerauthtoken
**
ADD_CLM|process_setting|api_provider_sms|VARCHAR|100|Y|NULL|sms_passwd_key
**
ADD_CLM|process_setting|api_type_sms|VARCHAR|10|Y|NULL|api_provider_sms
**
ADD_CLM|process_disposition|trnsf_to|VARCHAR|50|Y|NULL|favourite
**
ADD_CLM|process_disposition|ncDispo|INT|5|Y|NULL|trnsf_to
**
ADD_CLM|process_disposition|retry_in_day|INT|5|Y|NULL|ncDispo
**
ADD_CLM|process_disposition|total_retry|INT|5|Y|NULL|retry_in_day
**
ADD_CLM|process_disposition|closed_dispo|INT|1|Y|0|total_retry
**
ADD_CLM|process_iframe|isActive|VARCHAR|10|Y|NULL|newWindow
**
ADD_CLM|process_iframe|operate_by|VARCHAR|10|Y|NULL|isActive
**
ADD_CLM|process_smssetting|sms|INT|2|Y|NULL|other_no
**
ADD_CLM|process_smssetting|whatsapp|INT|2|Y|NULL|sms
**
ADD_CLM|process_smssetting|send_to_assign_agent|INT|1|Y|0|whatsapp
**
ADD_CLM|process_emailsetting|send_to_assign_agent|INT|1|Y|0|send_to_branch
**
ADD_CLM|campaign|client_id|INT|5|Y|NULL|id
**
ADD_CLM|campaign|api_after_postdata|VARCHAR|700|Y|NULL|api_after_disposed
**
ADD_CLM|campaign|api_method|VARCHAR|50|Y|NULL|api_after_postdata
**
ADD_CLM|campaign|disable_hangup_button|INT|1|Y|NULL|prevent_call_wait
**
ADD_CLM|campaign|missed_call_email_template|INT|1|Y|NULL|api_method
**
ADD_CLM|campaign|email_on_missed_call|INT|1|Y|NULL|missed_call_email_template
**
ADD_CLM|campaign|dnd_context|INT|3|Y|NULL|context
**
ADD_CLM|campaign|beforeOpenPageapiactive|INT|1|Y|NULL|email_on_missed_call
**
ADD_CLM|campaign|api_before_open|VARCHAR|2500|Y|NULL|api_method
**
ADD_CLM|campaign|api_before_postdata|TEXT|||NULL|api_before_open
**
ADD_CLM|campaign|api_before_method|INT|1|Y|NULL|api_before_postdata
**
ADD_CLM|campaign|minPDlist|INT|6|Y|NULL|beforeOpenPageapiactive
**
ADD_CLM|campaign|maxPDlist|INT|6|Y|NULL|minPDlist
**
ADD_CLM|campaign|max_PD_channel|INT|5|Y|0|maxPDlist
**
ADD_CLM|campaign|auth|VARCHAR|50|Y|NULL|max_PD_channel
**
ADD_CLM|campaign|basicauthusername|VARCHAR|50|Y|NULL|auth
**
ADD_CLM|campaign|basicauthpassword|VARCHAR|50|Y|NULL|basicauthusername
**
ADD_CLM|campaign|bearerauthtoken|VARCHAR|50|Y|NULL|basicauthpassword
**
ADD_CLM|campaign|multi_prefix_camp|VARCHAR|100|Y|NULL|bearerauthtoken
**
ADD_CLM|campaign|total_calls_per_day|INT|5|Y|NULL|multi_prefix_camp
**
ADD_CLM|campaign|fresh_calls_per_day|INT|5|Y|NULL|total_calls_per_day
**
ADD_CLM|campaign|mnaul_dial_threshold_tm|INT|5|Y|NULL|outgoing_threshold_tm
**
ADD_CLM|campaign|enable_missed_call_dial|INT|5|Y|NULL|email_on_missed_call
**
ADD_CLM|campaign|show_ivr_flow|INT|5|Y|NULL|fresh_calls_per_day
**
ADD_CLM|campaign|enable_dy_pacing|INT|5|Y|NULL|hangup_before_save
**
ADD_CLM|campaign|music_on_hold|VARCHAR|50|Y|NULL|show_ivr_flow
**
ADD_CLM|campaign|show_call_log_any_agent|INT|1|Y|0|music_on_hold
**
ADD_CLM|campaign|hide_phone_input_ready|INT|1|Y|0|music_on_hold
**
ADD_CLM|campaign|callerid_range|TEXT||Y|NULL|hide_phone_input_ready
**
ADD_CLM|campaign|recording_from_ring|INT|1|Y|0|show_call_log_any_agent
**
ADD_CLM|campaign|api_key|VARCHAR|50|Y|NULL|recording_from_ring
**
ADD_CLM|campaign|api_value|VARCHAR|50|Y|NULL|api_key
**
ADD_CLM|campaign|caller_id_prefix|VARCHAR|20|Y|NULL|caller_id
**
ADD_CLM|user|manager_id|INT|11|Y|NULL|play_recording
**
ADD_CLM|user|change_campaign|INT|1|Y|0|manager_id
**
ADD_CLM|user|pause_unpause|INT|1|Y|0|change_campaign
**
ADD_CLM|user|IsLoggedIn|INT|2|Y|0|pause_unpause
**
ADD_CLM|user|deviceid|VARCHAR|50|Y|NULL|IsLoggedIn
**
ADD_CLM|user|agent_logout_camp_wise|INT|1|Y|0|deviceid
**
ADD_CLM|user|login_otp_expiry_tm|DATETIME||Y|NULL|login_otp
**
ADD_CLM|user|after_change_prev_passwd|VARCHAR|200|Y|NULL|agent_message
**
ADD_CLM|user|view_attachment|INT|1|Y|0|after_change_prev_passwd
**
ADD_CLM|user|allow_webphone_ext|INT|1|Y|0|view_attachment
**
ADD_CLM|formbuilder|show_grid_add_btn|INT|1|Y|0|sub_log_table_name
**
ADD_CLM|formbuilder|client_id|INT|11|Y|NULL|id
**
ADD_CLM|formbuilder|show_grid_dlt_btn|INT|1|Y|0|show_grid_add_btn
**
ADD_CLM|formbuilder_field|sendSMS|INT|2|Y|NULL|ShowinLogTrail
**
ADD_CLM|formbuilder_field|allow_generate_value|INT|2|Y|NULL|sendSMS
**
ADD_CLM|formbuilder_field|other_lang|INT|2|Y|0|allow_generate_value
**
ADD_CLM|formbuilder_field|show_on_omni|INT|2|Y|0|other_lang
**
ADD_CLM|formbuilder_field|show_ticket|INT|2|Y|0|show_on_omni
**
ADD_CLM|formbuilder_field|uniq_ticket|INT|2|Y|0|show_ticket
**
ADD_CLM|formbuilder_field|generate_value_prefix|VARCHAR|50|Y|NULL|uniq_ticket
**
ADD_CLM|formbuilder_field|group_name|VARCHAR|50|Y|NULL|filter
**
ADD_CLM|formbuilder_field|show_on_dling_dashboard|INT|1|Y|0|generate_value_prefix
**
ADD_CLM|formbuilder_field|default_show|INT|1|Y|1|show_on_dling_dashboard
**
ADD_CLM|formbuilder_field|maintain_log_master_field|VARCHAR|100|Y|NULL|default_show
**
ADD_CLM|formbuilder_field|disable_required_on_noanswer|INT|1|Y|0|maintain_log_master_field
**
ADD_CLM|formbuilder_field|feedback_option|INT|1|Y|0|disable_required_on_noanswer
**
ADD_CLM|formbuilder_field|refresh_dropdown_mobile|VARCHAR|50|Y|NULL|feedback_option
**
ADD_CLM|formbuilder_field|fill_values_mobile|VARCHAR|50|Y|NULL|refresh_dropdown_mobile
**
ADD_CLM|formbuilder_field|maintain_master_other_field|VARCHAR|100|Y|NULL|fill_values_mobile
**
ADD_CLM|extension|client_id|INT|11|Y|NULL|id
**
ADD_CLM|agent|client_id|INT|11|Y|NULL|extension_no
**
ADD_CLM|agent|concurrent_chat|VARCHAR|50|Y|0|device_id
**
ADD_CLM|agent|multi_prefix_agent|VARCHAR|100|Y|NULL|concurrent_chat
**
ADD_CLM|agent|disable_process_change|INT|3|Y|0|multi_prefix_agent
**
ADD_CLM|agent|fresh_calls_per_day|INT|5|Y|0|disable_process_change
**
ADD_CLM|agent|total_calls_per_day|INT|5|Y|0|fresh_calls_per_day
**
ADD_CLM|agent|client_name|VARCHAR|30|Y|NULL|total_calls_per_day
**
ADD_CLM|agent|first_login|INT|5|Y|0|client_name
**
ADD_CLM|agent|fcm_token|TEXT|||NULL|first_login
**
ADD_CLM|agent|last_login|DATETIME||Y|NULL|fcm_token
**
ADD_CLM|agent|login_otp_expiry_tm|DATETIME||Y|NULL|login_otp
**
ADD_CLM|agent|is_app_login|INT|1|Y|0|login_otp_expiry_tm
**
ADD_CLM|agent|is_notification|INT|1|Y|0|is_app_login
**
ADD_CLM|agent|remote_extension_no|VARCHAR|20|Y|NULL|is_notification
**
ADD_CLM|agent|verify_otp|VARCHAR|50|Y|NULL|is_notification
**
ADD_CLM|agent|verify_otp_expiry_tm|VARCHAR|50|Y|NULL|verify_otp
**
ADD_CLM|agent|client_id|INT|5|Y|NULL|id
**
ADD_CLM|agent|total_lead_per_day|INT|10|Y|NULL|verify_otp_expiry_tm
**
ADD_CLM|agent_setting|view_quality_dashboard|INT|1|Y|NULL|attachment_mandatory_for_agent
**
ADD_CLM|agent_setting|view_tms|INT|1|Y|NULL|view_quality_dashboard
**
ADD_CLM|agent_setting|internal_chat|INT|2|Y|NULL|view_tms
**
ADD_CLM|agent_setting|internal_chat_file_sharing|INT|2|Y|NULL|internal_chat
**
ADD_CLM|agent_setting|show_dailing_dashbaord|INT|2|Y|NULL|internal_chat_file_sharing
**
ADD_CLM|agent_setting|remove_attachment|INT|11|Y|NULL|show_dailing_dashbaord
**
ADD_CLM|custom_query_master|dashboard_refresh_time|INT|2|Y|NULL|is_dashboard
**
ADD_CLM|cdrtemp|ivr_name|VARCHAR|200|Y|NULL|cid
**
ADD_CLM|cdrtemp|Wrapup_duration|BIGINT||Y|NULL|ivr_name
**
QRY|CALL Check_Index ('cdrtemp','start_time')
**
ADD_CLM|crm_tms_config|tmstype|VARCHAR|100|Y|NULL|tms_url
**
ADD_CLM|crm_tms_config|tms_api_url|VARCHAR|255|Y|NULL|raise_ticket_request
**
ADD_CLM|crm_tms_config|tms_api_client_token|TEXT||Y|NULL|tms_api_url
**
ADD_CLM|cdr|ivr_name|VARCHAR|200|Y|NULL|disposition
**
ADD_CLM|cdr_1|ivr_name|VARCHAR|200|Y|NULL|disposition
**
QRY|ALTER TABLE cdr modify column start_time DATETIME
**
QRY|ALTER TABLE cdr modify column acd_time DATETIME
**
QRY|ALTER TABLE cdr modify column exten_ring_time DATETIME
**
QRY|ALTER TABLE cdr modify column exten_time DATETIME
**
QRY|ALTER TABLE cdr modify column end_time DATETIME
**
ADD_CLM|fieldgroup|combobox_value|TEXT|||NULL|dispOrder
**
QRY|INSERT IGNORE INTO `agent_status` (`id`, `name`, `color_code`) VALUES (21, 'Ext-Pause', '#BE7A61 ')
**
QRY|INSERT IGNORE INTO `agent_status` (`id`, `name`, `color_code`) VALUES (22, 'Ext-Unpause', '#7BD8A0')
**
QRY|INSERT IGNORE INTO `agent_status` (`id`, `name`, `color_code`) VALUES (23, 'P.D. Incoming', '#80BABF')
**
QRY|INSERT IGNORE INTO `agent_status` (`id`, `name`, `color_code`) VALUES (24, 'DND', '#ff5050')
**
QRY|INSERT IGNORE INTO `agent_status` (`id`, `name`, `color_code`) VALUES (25, 'On Chat', '#ced142')
**
QRY|INSERT IGNORE INTO `report_master` (`name`, `description`, `report_group`,  `created_date`) VALUES ('agent_summary', 'Agent Summary', 'AMS',  '2023-12-11 10:00:00');
**
ADD_CLM|did|client_id|INT|5|Y|NULL|did
**
ADD_CLM|did|active|INT|5|Y|NULL|client_id
**
ADD_CLM|attendance_login_logout_log|campaign_id|INT|5|Y|NULL|process_id
**
ADD_CLM|emailtemplate|client_id|INT|5|Y|NULL|id
**
ADD_CLM|email_account|client_id|INT|5|Y|NULL|id
**
ADD_CLM|smstemplate|client_id|INT|5|Y|NULL|id
**
ADD_CLM|smstemplate|template_type|VARCHAR|50|Y|NULL|body
**
ADD_CLM|smstemplate|extra_parameter|TEXT|||NULL|template_type
**
ADD_CLM|smstemplate|Whatsapp_template_type|VARCHAR|50|Y|NULL|extra_parameter
**
ADD_CLM|smstemplate|wa_solution_provider|VARCHAR|50|Y|NULL|Whatsapp_template_type
**
ADD_CLM|smstemplate|provider_template_id|VARCHAR|50|Y|NULL|name
**
ADD_CLM|smstemplate|omni_setup_template|VARCHAR|50|Y|NULL|provider_template_id
**
ADD_CLM|smstemplate|method|VARCHAR|10|Y|NULL|omni_setup_template
**
ADD_CLM|smstemplate|smsprovider|VARCHAR|50|Y|NULL|method
**
ADD_CLM|client_missedcall_setting|ivr|INT|5|Y|NULL|campaign_id
**
ADD_CLM|client_missedcall_setting|queue|INT|5|Y|NULL|ivr
**
ADD_CLM|client_missedcall_setting|campaigns_transfer|INT|5|Y|NULL|queue
**
ADD_CLM|qa_agentdetails|decline_state|INT|5|Y|NULL|feedback
**
ADD_CLM|qa_agentdetails|log_phone_no|VARCHAR|50|Y|NULL|decline_state
**
ADD_CLM|script|client_id|INT|5|Y|NULL|id
**
ADD_CLM|script|campaign_id|VARCHAR|50|Y|NULL|process_id
**
ADD_CLM|agentgroup|client_id|INT|5|Y|NULL|id
**
ADD_CLM|briefing|client_id|INT|5|Y|NULL|id
**
ADD_CLM|user_type|client_id|INT|5|Y|NULL|id
**
ADD_CLM|usergroup|client_id|INT|5|Y|NULL|id
**
ADD_CLM|attendance_login_logout_log|agent_id|INT|11|Y|NULL|id
**
ADD_CLM|faq|client_id|INT|11|Y|NULL|id
**
ADD_CLM|emailtemplate|temp_type|VARCHAR|30|Y|NULL|cc
**
ADD_CLM|emailtemplate|header|VARCHAR|100|Y|NULL|temp_type
**
ADD_CLM|emailtemplate|footer|VARCHAR|100|Y|NULL|header
**
ADD_CLM|emailtemplate|signature|VARCHAR|100|Y|NULL|footer
**
ADD_CLM|emailtemplate|isdefault|INT|2|Y|NULL|signature
**
ADD_CLM|emailtemplate|temp_type|VARCHAR|50|Y|NULL|isdefault
**
ADD_CLM|omni_chat_session|parent_session_id|INT|5|Y|0|is_customer_exit
**
ADD_CLM|importmaster|force_update_existing_master_data|INT|1|Y|NULL|update_existing_master_data
**
ADD_CLM|campaign_mapping|mapping_remarks|VARCHAR|50|Y|NULL|MapToAgent
**
ADD_CLM|campaign_mapping|added_dial_list|INT|3|Y|NULL|mapping_remarks
**
ADD_CLM|campaign_mapping|dial_list_add_time|DATETIME||Y|NULL|added_dial_list
**
ADD_CLM|campaign_mapping|Agent_assign_date|DATETIME||Y|NULL|dial_list_add_time
**
ADD_CLM|sms_log|message_id|VARCHAR|100|Y|NULL|whatsapp_sent
**
ADD_CLM|sms_log|whatsapp_deliver|INT|1|Y|0|message_id
**
ADD_CLM|sms_log|whatsapp_read|INT|1|Y|0|whatsapp_deliver
**
ADD_CLM|context|gsm_gateway|INT|2|Y|NULL|campaign
**
ADD_CLM|context|Allow_DND|INT|2|Y|NULL|gsm_gateway
**
ADD_CLM|context|active|INT|2|Y|NULL|Allow_DND
**
ADD_CLM|qaparameter|client_id|INT|5|Y|NULL|id
**
ADD_CLM|qa_dispositionmaster|client_id|INT|5|Y|NULL|id
**
ADD_CLM|qa_questionanswers|client_id|INT|5|Y|NULL|id
**
ADD_CLM|qa_questionmaster|client_id|INT|5|Y|NULL|id
**
ADD_CLM|omni_setup|san_meeting_token|VARCHAR|200|Y|NULL|san_welcome_text
**
ADD_CLM|omni_setup|san_meeting_callback_url|VARCHAR|200|Y|NULL|san_meeting_token
**
ADD_CLM|omni_setup|san_meeting_virtual_bg_path|VARCHAR|200|Y|NULL|san_meeting_callback_url
**
ADD_CLM|omni_setup|san_meeting_virtual_background_url|VARCHAR|200|Y|NULL|san_meeting_virtual_bg_path
**
ADD_CLM|omni_setup|san_meeting_logout_url|VARCHAR|200|Y|NULL|san_meeting_virtual_background_url
**
ADD_CLM|omni_setup|san_meeting_enable_audio|TINYINT|1|Y|NULL|san_meeting_logout_url
**
ADD_CLM|omni_setup|san_meeting_enable_video|TINYINT|1|Y|NULL|san_meeting_enable_audio
**
ADD_CLM|omni_setup|san_meeting_enable_screenshare|TINYINT|1|Y|NULL|san_meeting_enable_video
**
ADD_CLM|omni_setup|san_meeting_disable_recording|INT|1|Y|0|san_meeting_enable_audio
**
ADD_CLM|omni_setup|youtube_video_url|TEXT||Y|NULL|san_banner_color
**
ADD_CLM|omni_setup|youtube_comment_url|TEXT||Y|NULL|youtube_video_url
**
ADD_CLM|omni_setup|youtube_reply_url|TEXT|250|Y|NULL|youtube_comment_url
**
ADD_CLM|omni_setup|youtube_reply_token|VARCHAR|250|Y|NULL|youtube_reply_url
**
ADD_CLM|omni_setup|youtube_comment_reply_url|VARCHAR|100|Y|NULL|youtube_reply_token
**
DRP_CLM|omni_setup|youtube_data_limit
**
ADD_CLM|omni_setup|whatsApp_country_code|INT|4|Y|NULL|whatsApp_no
**
ADD_CLM|omni_setup|whatsApp_phone_no|VARCHAR|16|Y|NULL|whatsApp_country_code
**
ADD_CLM|omni_video_call_log|recording_url|VARCHAR|200|Y|NULL|recording_saved
**
ADD_CLM|process|enable_agent_mapping_omni|INT|1|Y|0|process_faq
**
ADD_CLM|process|mx_agent_break_count|INT|4|Y|NULL|enable_agent_mapping_omni
**
ADD_CLM|campaign|client_limit_per_day|INT|5|Y|NULL|fresh_calls_per_day
**
ADD_CLM|campaign|client_limit_per_week|INT|5|Y|NULL|client_limit_per_day
**
ADD_CLM|dnd|block_incoming|INT|1|Y|0|dnd_end_date
**
ADD_CLM|dnd|srch_process_id|VARCHAR|50|Y|NULL|process_id
**
ADD_CLM|whatsapp_provider|agent_editable|INT|1|Y|0|provider_name
**
ADD_CLM|process_data_insert_rule|round_robin|INT|1|Y|0|agent_max_lead
**
ADD_CLM|process_data_insert_rule|agent_condition|TEXT||Y|NULL|round_robin
**
ADD_CLM|process_data_insert_rule|rule_condition|TEXT||Y|NULL|agent_condition
**
ADD_CLM|process_data_insert_rule|lead_by_campaign|INT|11|Y|0|rule_condition
**
QRY|INSERT IGNORE INTO `agent_status` (`id`, `name`, `color_code`) VALUES (27, 'Video Ringing', '#fa8e65')
**
QRY|INSERT IGNORE INTO `agent_status` (`id`, `name`, `color_code`) VALUES (28, 'Video Answer', '#a39940')
**
QRY|INSERT IGNORE INTO `agent_status` (`id`, `name`, `color_code`) VALUES (29, 'Video Wrapup', '#ffa500')
**
QRY|INSERT IGNORE INTO `agent_status` (`id`, `name`, `color_code`) VALUES (30, 'Video Missed', '#f6f6f6')
**
ADD_CLM|computer_master|client_id|INT|5|Y|NULL|id
**
ADD_CLM|agentbreak|break_count|INT|3|Y|NULL|break_time
**
ADD_CLM|campaign|hold_customer_on_conference|INT|1|Y|NULL|recording_from_ring
**
ADD_CLM|agentbreak|process_id|INT|3|Y|NULL|client_id
**
QRY|INSERT IGNORE INTO `report_master` (`name`, `description`, `report_group`,`default_report` ,`created_date`) VALUES('custom_confrence_report', 'Confrenece report', 'CALLLOG', 0, '2024-10-30 11:36:31');
**
QRY|INSERT IGNORE INTO `report_master` (`name`, `description`, `report_group`,`default_report` ,`created_date`) VALUES('custom_callback_report', 'Callback Report', 'CALLLOG', 1, '2024-09-25 15:50:13');
**
ADD_CLM|omni_setup|san_meeting_base_url|VARCHAR|250|Y|NULL|san_meeting_virtual_bg_path
**
ADD_CLM|emailtemplate|campaign_id|INT|3|Y|NULL|process_id
**
ADD_CLM|smstemplate|is_active|INT|3|Y|NULL|process_id
**
ADD_CLM|process_setting|send_feedback_url|INT|3|Y|NULL|api_type_sms
**
ADD_CLM|campaign|maxWaitTime|DATETIME|||NULL|hold_customer_on_conference
**
ADD_CLM|campaign|queuecount|INT|11|Y|NULL|maxWaitTime
**
ADD_CLM|campaign_mapping|attempt_count_campaign|INT|3|Y|NULL|Agent_assign_date
**
ADD_CLM|campaign_mapping|NC_attempt_count|INT|3|Y|NULL|attempt_count_campaign
**
ADD_CLM|campaign_mapping|NC_last_update|DATETIME|||NULL|NC_attempt_count
**
ADD_CLM|campaign_mapping|NC_days|DATETIME|||NULL|NC_last_update
**
ADD_CLM|campaign_mapping|video_call_from|DATETIME||Y|NULL|dial_list_add_time
**
ADD_CLM|campaign_mapping|video_call_to|DATETIME||Y|NULL|video_call_from
**
ADD_CLM|process_setting|auto_logout_from_break|INT|3|Y|NULL|send_feedback_url
**
ADD_CLM|user|agent_message|INT|3|Y|NULL|view_attachment
**
QRY|ALTER TABLE `qaparameter` ADD COLUMN  `created_date`  DATETIME NULL DEFAULT (curreNT_TIMESTAMP()) AFTER `bg_color`;
**
QRY|ALTER TABLE `qaparameter` ADD COLUMN `updated_date` DATETIME NULL DEFAULT NULL ON UPDATE currENT_TIMESTAMP() AFTER `updated_by`;
**
QRY|ALTER TABLE `qaparameter` CHANGE COLUMN `displayOrder` `displayOrder` INT NOT NULL DEFAULT '0' AFTER `name`;
**
QRY|UPDATE `qaparameter` SET created_by = NULL , updated_by = NULL;
**
QRY|ALTER TABLE `qaparameter` CHANGE COLUMN `created_by` `created_by` INT NULL DEFAULT NULL COLLATE 'latin1_swedish_ci' AFTER `created_date`, CHANGE COLUMN `updated_by` `updated_by` INT NULL DEFAULT NULL COLLATE 'latin1_swedish_ci' AFTER `created_by`;
**
QRY|ALTER TABLE `qa_dispositionmaster` ADD COLUMN `created_by` INT NULL AFTER `client_id`, ADD COLUMN `created_date` DATETIME NULL DEFAULT (curreNT_TIMESTAMP()) AFTER `created_by`,ADD COLUMN `updated_by` INT NULL DEFAULT NULL AFTER `created_date`,	ADD COLUMN `updated_date` DATETIME NULL DEFAULT NULL ON UPDATE curRENT_TIMESTAMP() AFTER `updated_by`;
** 
QRY|UPDATE paginate SET created_by = NULL , updated_by = NULL;
**
QRY|ALTER TABLE `paginate` ADD COLUMN `created_date` DATETIME NULL DEFAULT (currENT_TIMESTAMP()) AFTER `updated_by`,ADD COLUMN `updated_date` DATETIME NULL DEFAULT NULL ON UPDATE currENT_TIMESTAMP() AFTER `created_date`;
**
QRY|ALTER TABLE `paginate` CHANGE COLUMN `created_by` `created_by` INT NULL DEFAULT NULL COLLATE 'latin1_swedish_ci' AFTER `default_no_of_record`,CHANGE COLUMN `updated_by` `updated_by` INT NULL DEFAULT NULL COLLATE 'latin1_swedish_ci' AFTER `created_by`;
**
QRY|ALTER TABLE `paginate` CHANGE COLUMN `default_no_of_record` `default_no_of_record` TINYINT(1) NULL DEFAULT '0' AFTER `no_of_record`
**
QRY|ALTER TABLE `qa_questionmaster`
    CHANGE COLUMN `client_id` `client_id` INT NULL DEFAULT NULL AFTER `id`,
	ADD COLUMN `created_by` INT NULL DEFAULT NULL AFTER `question`,
	ADD COLUMN `created_date` DATETIME NULL DEFAULT (currENT_TIMESTAMP()) AFTER `created_by`,
	ADD COLUMN `updated_by` INT NULL DEFAULT NULL AFTER `created_date`,
	ADD COLUMN `updated_date` DATETIME NULL DEFAULT NULL ON UPDATE curreNT_TIMESTAMP() AFTER `updated_by`;
**
QRY|ALTER TABLE `client_logs_admin` CHANGE COLUMN `method` `method` TEXT NULL DEFAULT NULL COLLATE 'latin1_swedish_ci' AFTER `class`;	
**
ADD_CLM|formbuilder_field|show_on_qa_filter|TINYINT|1|Y|0|maintain_master_other_field
**
ADD_CLM|user_type|is_qa_user|TINYINT|1|Y|0|type
**
QRY|ALTER TABLE `qa_questionmaster`	CHANGE COLUMN `question` `question` TEXT NULL DEFAULT NULL COLLATE 'latin1_swedish_ci' AFTER `client_id`;
**
QRY|ALTER TABLE `qa_questionanswers`
	CHANGE COLUMN `client_id` `client_id` INT NULL DEFAULT NULL AFTER `id`,
	CHANGE COLUMN `process_id` `process_id` INT NULL DEFAULT NULL AFTER `client_id`,
	CHANGE COLUMN `campaign_id` `campaign_id` INT NULL DEFAULT NULL AFTER `process_id`,
	CHANGE COLUMN `date` `date` DATE NULL DEFAULT NULL AFTER `campaign_id`,
	ADD COLUMN `re_audit` TINYINT(1) NOT NULL DEFAULT (0) AFTER `date`,
	ADD COLUMN `auto_assign` TINYINT(1) NOT NULL DEFAULT (0) AFTER `re_audit`,
	ADD COLUMN `user_id` VARCHAR(50) NULL DEFAULT NULL AFTER `auto_assign`,
	CHANGE COLUMN `parameter_wise_fatal` `parameter_wise_fatal` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci' AFTER `qa_uploadID`,
	CHANGE COLUMN `created_date` `created_date` DATETIME NULL DEFAULT (currENT_TIMESTAMP()) AFTER `created_by`,
	CHANGE COLUMN `updated_date` `updated_date` DATETIME NULL DEFAULT NULL ON UPDATE curreNT_TIMESTAMP() AFTER `created_date`;
**
ADD_CLM|process|apr_filter_interval|INT|3|Y|NULL|enable_agent_mapping_omni
**
ADD_CLM|process_setting|audio_play_on_hangup|INT|3|Y|NULL|send_feedback_url
**
ADD_CLM|client_master|generate_api_key|TEXT||Y|NULL|agent_login_another_device
**
ADD_CLM|email_account|reply_to|VARCHAR|150|Y|NULL|email
**
ADD_CLM|client_master|log_retention_days|INT|3|Y|NULL|generate_api_key
**
QRY|ALTER TABLE `client_logs_admin` CHANGE COLUMN `time` `added_on` DATETIME NULL DEFAULT (now()) AFTER `request`;
**
ADD_CLM|qa_dispositionmaster|is_default|TINYINT||Y|0|client_id
**
ADD_CLM|campaign|sync_with_google_calendar|INT|1|Y|NULL|queuecount
**
ADD_CLM|processreport|client_id|INT|1|Y|NULL|process_id
**
ADD_CLM|crm_tms_config|tms_login_url|VARCHAR|300|Y|NULL|tmstype
**
ADD_CLM|crm_tms_config|tms_logout_url|VARCHAR|300|Y|NULL|tms_login_url
**
ADD_CLM|campaign|sync_with_invite_calendar|INT|1|Y|NULL|sync_with_google_calendar
**
ADD_CLM|license|Letter|BLOB||Y|NULL|webphone
**
ADD_CLM|license|NoOfIVRChannel|BLOB||Y|NULL|NoOfOmniAgents
**
ADD_CLM|client_license|NoOfIVRChannel|VARCHAR|30|Y|NULL|NoOfOmniAgents
**
ADD_CLM|client_master|generate_api_key|TEXT||Y|NULL|recording_location
**
ADD_CLM|client_master|log_retention_days|INT||Y|NULL|generate_api_key
**
ADD_CLM|client_master|user_login_another_device|INT|1|Y|NULL|log_retention_days
**
ADD_CLM|campaign|sync_with_invite_calendar|INT|1|Y|NULL|api_after_data_insert
**
ADD_CLM|campaign_mapping|invite_from|DATETIME||Y|NULL|video_call_to
**
ADD_CLM|campaign_mapping|invite_to|DATETIME||Y|NULL|invite_from
**
ADD_CLM|campaign_mapping|invite_to|priority|3|Y|NULL|invite_to
**
ADD_CLM|sms_log|crm_id|VARCHAR|60|Y|NULL|master_id
**
ADD_CLM|email_log|crm_id|VARCHAR|60|Y|NULL|master_id
**
ADD_CLM|process_setting|blind_mode|INT|1|Y|NULL|audio_play_on_hangup
**
ADD_CLM|process_setting|send_template_on_fresh_lead|INT|1|Y|NULL|blind_mode
**
ADD_CLM|campaign|api_after_data_insert_url|VARCHAR|200|Y|NULL|sync_with_invite_calendar
**
ADD_CLM|campaign|api_afterdatainsert_method|VARCHAR|6|Y|NULL|api_after_data_insert_url
**
ADD_CLM|campaign|api_postdata_afterinsertdata|TEXT||Y|NULL|api_afterdatainsert_method
**
ADD_CLM|campaign|afterDataInsertactive|INT|1|Y|NULL|api_postdata_afterinsertdata
**
ADD_CLM|campaign_transfer_setting|process_trasfer|INT||Y|NULL|othr_field_value_campaign_trasfer
**
ADD_CLM|did|context|INT||Y|NULL|did
**
ADD_CLM|did|customize_url|VARCHAR|200|Y|NULL|description
**
ADD_CLM|did|open_cust_url_only|INT||Y|NULL|customize_url
**
ADD_CLM|crm_tms_config|tms_login_url|VARCHAR|300|Y|NULL|tmstype
**
ADD_CLM|crm_tms_config|tms_logout_url|VARCHAR|300|Y|NULL|tms_login_url
**
ADD_CLM|crm_tms_config|login_api_json|LONGTEXT||Y|NULL|view_ticket_request
**
ADD_CLM|crm_tms_config|logout_api_json|LONGTEXT||Y|NULL|login_api_json
**
ADD_CLM|email_schedule|crm_id|VARCHAR|60|Y|NULL|master_id
**
ADD_CLM|email_schedule|sendinvite|INT||Y|NULL|status
**
ADD_CLM|email_schedule|Master_data|TEXT||Y|NULL|sendinvite
**
ADD_CLM|company|recording_type|VARCHAR|50|Y|NULL|company_ssh_port
**
ADD_CLM|company|single_screen_login|INT|1|Y|NULL|recording_type
**
ADD_CLM|company|recording_backup_url|VARCHAR|250|Y|NULL|single_screen_login
**
ADD_CLM|process_emailsetting|emailsetting_subdisposition|VARCHAR|150|Y|NULL|admin_send
**
ADD_CLM|crm_tms_config|sub_disposition_tms|VARCHAR|300|Y|NULL|disposition
**
ADD_CLM|crm_tms_config|sub_disposition_tms|VARCHAR|300|Y|NULL|disposition
**
ADD_CLM|formbuilder|view_type|VARCHAR|10|Y|NULL|show_grid_dlt_btn
**
ADD_CLM|process_disposition|sub_sub_dispo_json|TEXT||Y|NULL|sub_dispo
**
ADD_CLM|omni_video_call_log|customer_join_status|TINYINT|1|Y|NULL|recording_url
**
ADD_CLM|omni_video_call_log|agent_join_status|TINYINT|1|Y|NULL|customer_join_status
**
ADD_CLM|agent|allow_videocall|TINYINT|1|Y|NULL|total_lead_per_day
**
ADD_CLM|agent|last_lead_assign_datetime|DATETIME||Y|NULL|allow_videocall
**
ADD_CLM|agent|api_login_token|TEXT||Y|NULL|last_lead_assign_datetime
**
ADD_CLM|agent|caller_id|VARCHAR|20|Y|NULL|api_login_token
**
ADD_CLM|extension|caller_id|VARCHAR|20|Y|NULL|ippbx_id
**
ADD_CLM|client_missedcall_setting|callback|TINYINT|1|Y|NULL|campaigns_transfer
**
ADD_CLM|client_logs_admin|time|DATETIME||Y|NULL|ip
**
ADD_CLM|process_iframe|homeOPen|INT|1|Y|NULL|newWindow
**
ADD_CLM|process_iframe|homeOPen|INT|1|Y|NULL|newWindow
**
ADD_CLM|omni_setup|outbound_session|INT|1|Y|NULL|san_meeting_enable_external_video
**
ADD_CLM|omni_setup|san_meeting_recordignapi_url|INT|1|Y|NULL|outbound_session
**
QRY|INSERT IGNORE INTO  `cron_scheduler` ( `is_active`, `Cron`, `url`, `Desc`, `create_by`, `modified_by`,`created_on`,`modified_on`) VALUES (1, '* * * * *', 'https://YourDomain/crm/cronjob/serviceCSV', 'CSV Service', 'admin', 'admin', '2025-01-01 04:30:00', '2025-11-11 16:58:59')
**
QRY|INSERT IGNORE INTO  `cron_scheduler` ( `is_active`, `Cron`, `url`, `Desc`, `create_by`, `modified_by`,`created_on`,`modified_on`) VALUES (1, '* * * * *', 'http://127.0.0.1/crm/cronjob/sendSMS', 'sendSMS', 'admin', NULL, '2025-11-05 12:33:48', NULL)
**
QRY|INSERT IGNORE INTO  `cron_scheduler` ( `is_active`, `Cron`, `url`, `Desc`, `create_by`, `modified_by`,`created_on`,`modified_on`) VALUES (1, '* * * * *', 'http://127.0.0.1/crm/cronjob/sendEmails', 'Email Send', 'admin', NULL, '2025-11-05 12:35:00', NULL)
**
QRY|INSERT IGNORE INTO  `cron_scheduler` ( `is_active`, `Cron`, `url`, `Desc`, `create_by`, `modified_by`,`created_on`,`modified_on`) VALUES (1, '* * * * *', 'http://127.0.0.1/crm/cronjob/SendDataAfterSavePOST', 'SendDataAfterSavePOST', 'admin', NULL, '2025-11-05 12:35:53', NULL)
**
QRY|INSERT IGNORE INTO  `cron_scheduler` ( `is_active`, `Cron`, `url`, `Desc`, `create_by`, `modified_by`,`created_on`,`modified_on`) VALUES (1, '*/15 * * * *', 'http://127.0.0.1/crm/cronjob/SendLetter', 'SendLetter', 'admin', NULL, '2025-11-05 12:52:47', NULL)
**
QRY|INSERT IGNORE INTO  `cron_scheduler` ( `is_active`, `Cron`, `url`, `Desc`, `create_by`, `modified_by`,`created_on`,`modified_on`) VALUES (1, '0 0 * * *', 'http://127.0.0.1/crm/cronjob/Removecdrtemp', 'Removecdrtemp', 'admin', NULL, '2025-11-05 12:54:07', NULL)
**
QRY|CALL Check_Index ('cdr','campaign_id');
**
QRY|CALL Check_Index ('cdr','agent');
**
QRY|CALL Check_Index ('cdr','process_id');
**
QRY|CALL Check_Index ('cdr','end_call');
**
QRY|CALL Check_Index ('cdr','start_time');
**
QRY|CALL Check_Index ('cdr','trunk_channel');
**
QRY|CALL Check_Index ('cdr_1','campaign_id');
**
QRY|CALL Check_Index ('cdr_1','agent');
**
QRY|CALL Check_Index ('cdr_1','process_id');
**
QRY|CALL Check_Index ('cdr_1','end_call');
**
QRY|CALL Check_Index ('cdr_1','start_time');
**
QRY|CALL Check_Index ('cdr_1','trunk_channel');