# MySQL dump 6.4
#
# Host: localhost    Database: netmon
#--------------------------------------------------------
# Server version	3.22.27

#
# Table structure for table 'ipchainslogs'
#
CREATE TABLE ipchainslogs (
  id int(11) DEFAULT '0' NOT NULL auto_increment,
  timestamp timestamp(14) NOT NULL,
  syslog_time char(20) DEFAULT '' NOT NULL,
  chain char(64) DEFAULT '' NOT NULL,
  action char(8) DEFAULT '' NOT NULL,
  interface char(8) DEFAULT '' NOT NULL,
  protocol int(11) DEFAULT '0' NOT NULL,
  source_ip char(16) DEFAULT '' NOT NULL,
  source_port smallint(5) unsigned DEFAULT '0' NOT NULL,
  dest_ip char(16) DEFAULT '' NOT NULL,
  dest_port smallint(5) unsigned DEFAULT '0' NOT NULL,
  length int(11) DEFAULT '0' NOT NULL,
  tos char(4) DEFAULT '' NOT NULL,
  fragment_offset int(11) DEFAULT '0' NOT NULL,
  flags char(6) DEFAULT '' NOT NULL,
  ttl int(11) DEFAULT '0' NOT NULL,
  rule int(11) DEFAULT '0' NOT NULL,
  rule_flags char(8) DEFAULT '',
  PRIMARY KEY (id),
  KEY chain (chain),
  KEY action (action),
  KEY interface (interface),
  KEY protocol (protocol),
  KEY source_ip (source_ip),
  KEY source_port (source_port),
  KEY dest_ip (dest_ip),
  KEY dest_port (dest_port),
  KEY rule (rule),
  KEY syslog_time (syslog_time)
);