1
2
3
4
5
6
7
8
9
10
11
12
13

CREATE TABLE `DomainsTraffic` (
  `dom_id` int(10) unsigned NOT NULL,
  `date` date NOT NULL,
  `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 (`dom_id`,`date`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

CREATE TABLE `DomainsTraffic` ( `dom_id` int(10) unsigned NOT NULL, `date` date NOT NULL, `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 (`dom_id`,`date`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1