psa.ClientsTraffic
Overview
The ClientsTraffic table contains traffic data at the client level.
Column Descriptions
cl_id – links to id from clients table
date – date traffic was calculated in YYYY-MM-DD format
http_in – inbound HTTP traffic
http_out – outbound HTTP traffic
ftp_in – inbound FTP traffic
ftp_out – outbound FTP traffic
smtp_in – inbound SMTP traffic
smtp_out – outbound SMTP traffic
pop3_imap_in – inbound POP3/IMAP traffic
pop3_imap_out – outbound POP3/IMAP traffic
Table Structure
CREATE TABLE `ClientsTraffic` ( `cl_id` int(10) unsigned NOT NULL default '0', `date` date NOT NULL default '0000-00-00', `http_in` bigint(20) unsigned NOT NULL default '0', `http_out` bigint(20) unsigned NOT NULL default '0', `ftp_in` bigint(20) unsigned NOT NULL default '0', `ftp_out` bigint(20) unsigned NOT NULL default '0', `smtp_in` bigint(20) unsigned NOT NULL default '0', `smtp_out` bigint(20) unsigned NOT NULL default '0', `pop3_imap_in` bigint(20) unsigned NOT NULL default '0', `pop3_imap_out` bigint(20) unsigned NOT NULL default '0', PRIMARY KEY (`cl_id`,`date`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1