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.

21 lines
723B

  1. CREATE DATABASE `ctstats` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
  2. USE `ctstats`;
  3. -- --------------------------------------------------------
  4. --
  5. -- Table structure for table `stats`
  6. --
  7. CREATE TABLE IF NOT EXISTS `stats` (
  8. `timestamp` int(10) unsigned NOT NULL,
  9. `srcip` int(10) unsigned NOT NULL default '0',
  10. `proto` int(10) unsigned NOT NULL default '0',
  11. `dport` int(10) unsigned NOT NULL default '0',
  12. `flags` int(10) unsigned NOT NULL default '0',
  13. `srcbytes` int(10) unsigned NOT NULL default '0',
  14. `dstbytes` int(10) unsigned NOT NULL default '0',
  15. `count` int(10) unsigned NOT NULL default '0',
  16. PRIMARY KEY (`timestamp`,`srcip`,`proto`,`dport`)
  17. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;