CREATE DATABASE if not exists myiptstate;

USE myiptstate;

DROP TABLE IF EXISTS `iptstate`;
CREATE TABLE `iptstate` (
  `id` int(11) NOT NULL auto_increment,
  `source_ip` varchar(15) NOT NULL,
  `source_port` int(5) NOT NULL,
  `destination_ip` varchar(15) NOT NULL,
  `destination_port` int(5) NOT NULL,
  `protocol` varchar(10) default NULL,
  `state` varchar(25) default NULL,
  `duration` varchar(25) default NULL,
  `logtime` timestamp NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`),
  KEY `source_ip` (`source_ip`),
  KEY `source_port` (`source_port`),
  KEY `destination_ip` (`destination_ip`),
  KEY `destination_port` (`destination_port`),
  KEY `protocol` (`protocol`),
  KEY `state` (`state`),
  KEY `duration` (`duration`),
  KEY `logtime` (`logtime`)
) ENGINE=InnoDB AUTO_INCREMENT=1;