Connected OK
=== vicidial_log columns ===
uniqueid (varchar(20))
lead_id (int(9) unsigned)
list_id (bigint(14) unsigned)
campaign_id (varchar(8))
call_date (datetime)
start_epoch (int(10) unsigned)
end_epoch (int(10) unsigned)
length_in_sec (int(10))
status (varchar(6))
phone_code (varchar(10))
phone_number (varchar(18))
user (varchar(20))
comments (varchar(255))
processed (enum('Y','N'))
user_group (varchar(20))
term_reason (enum('CALLER','AGENT','QUEUETIMEOUT','ABANDON','AFTERHOURS','NONE','SYSTEM'))
alt_dial (varchar(6))
called_count (smallint(5) unsigned)
=== vicidial_agent_log columns ===
agent_log_id (int(9) unsigned)
user (varchar(20))
server_ip (varchar(15))
event_time (datetime)
lead_id (int(9) unsigned)
campaign_id (varchar(8))
pause_epoch (int(10) unsigned)
pause_sec (smallint(5) unsigned)
wait_epoch (int(10) unsigned)
wait_sec (smallint(5) unsigned)
talk_epoch (int(10) unsigned)
talk_sec (smallint(5) unsigned)
dispo_epoch (int(10) unsigned)
dispo_sec (smallint(5) unsigned)
status (varchar(6))
user_group (varchar(20))
comments (varchar(20))
sub_status (varchar(6))
dead_epoch (int(10) unsigned)
dead_sec (smallint(5) unsigned)
processed (enum('Y','N'))
uniqueid (varchar(20))
pause_type (enum('UNDEFINED','SYSTEM','AGENT','API','ADMIN'))