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;