linux 2.6 conntrack stats
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
 
 

20 lines
723 B

CREATE DATABASE `ctstats` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `ctstats`;
-- --------------------------------------------------------
--
-- Table structure for table `stats`
--
CREATE TABLE IF NOT EXISTS `stats` (
`timestamp` int(10) unsigned NOT NULL,
`srcip` int(10) unsigned NOT NULL default '0',
`proto` int(10) unsigned NOT NULL default '0',
`dport` int(10) unsigned NOT NULL default '0',
`flags` int(10) unsigned NOT NULL default '0',
`srcbytes` int(10) unsigned NOT NULL default '0',
`dstbytes` int(10) unsigned NOT NULL default '0',
`count` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`timestamp`,`srcip`,`proto`,`dport`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;