db.sql

来自「关于NETFLOW信息分析的软件。 is a netflow analyzer.」· SQL 代码 · 共 18 行

DROP TABLE IF EXISTS `acct`;

CREATE TABLE `acct` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `record_time` datetime default NULL,
  `address` int(10) unsigned NOT NULL default '0',
  `total_input` bigint(20) NOT NULL default '0',
  `total_output` bigint(20) NOT NULL default '0',
  `internal_input` bigint(20) NOT NULL default '0',
  `internal_output` bigint(20) NOT NULL default '0',
  `tashix_input` bigint(20) NOT NULL default '0',
  `tashix_output` bigint(20) NOT NULL default '0',
  `external_input` bigint(20) NOT NULL default '0',
  `external_output` bigint(20) NOT NULL default '0',
  `protocol` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `Index_2` (`record_time`,`address`,`protocol`)
) ENGINE=MyISAM DEFAULT PACK_KEYS=1;