tables.sql

c语言实现的将Netflow数据直接导入Mysql数据库的工具

-- Table skeltons for NetFlow2MySQL
-- 
-- If you also want to store IPv4 addresses of your NetFlow exporters,
-- Execute exporter_address.sql after executing this file.
--

--
-- Table structure for table `header`
--

CREATE TABLE header (
  hid bigint(20) unsigned NOT NULL auto_increment,
  version smallint(5) unsigned NOT NULL default '0',
  system_uptime int(10) unsigned NOT NULL default '0',
  unix_seconds int(10) unsigned NOT NULL default '0',
  package_sequence int(10) unsigned NOT NULL default '0',
  source_id int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (hid),
  KEY idx_unix_seconds (unix_seconds),
  KEY idx_source_id (source_id)
) TYPE=MyISAM MAX_ROWS=1000000000;

--
-- Table structure for table `record`
--

CREATE TABLE record (
  rid bigint(20) unsigned NOT NULL auto_increment,
  hid bigint(20) unsigned NOT NULL default '0',
  ip_protocol_version tinyint(3) unsigned default NULL,
  last_switched int(10) unsigned NOT NULL default '0',
  first_switched int(10) unsigned NOT NULL default '0',
  bytes int(10) unsigned NOT NULL default '0',
  pkts int(10) unsigned NOT NULL default '0',
  input_snmp smallint(5) unsigned NOT NULL default '0',
  output_snmp smallint(5) unsigned NOT NULL default '0',
  ipv4_src_addr int(10) unsigned default NULL,
  ipv6_src_addr varchar(16) binary default NULL,
  ipv4_dst_addr int(10) unsigned default NULL,
  ipv6_dst_addr varchar(16) binary default NULL,
  prot tinyint(3) unsigned NOT NULL default '0',
  src_tos tinyint(3) unsigned NOT NULL default '0',
  l4_src_port smallint(5) unsigned NOT NULL default '0',
  l4_dst_port smallint(5) unsigned NOT NULL default '0',
  ipv4_next_hop int(10) unsigned default NULL,
  ipv6_next_hop varchar(16) binary default NULL,
  dst_as smallint(5) unsigned NOT NULL default '0',
  src_as smallint(5) unsigned NOT NULL default '0',
  dst_mask tinyint(3) unsigned NOT NULL default '0',
  src_mask tinyint(3) unsigned NOT NULL default '0',
  tcp_flags tinyint(3) unsigned NOT NULL default '0',
  fqdn_src_addr text,
  fqdn_dst_addr text,
  fqdn_next_hop text,
  PRIMARY KEY  (rid),
  KEY idx_hid (hid),
  KEY idx_ip_protocol_version (ip_protocol_version),
  KEY idx_input_snmp (input_snmp),
  KEY idx_output_snmp (output_snmp),
  KEY idx_ipv4_src_addr (ipv4_src_addr),
  KEY idx_ipv4_dst_addr (ipv4_dst_addr),
  KEY idx_ipv4_next_hop (ipv4_next_hop),
  KEY idx_ipv6_src_addr (ipv6_src_addr),
  KEY idx_ipv6_dst_addr (ipv6_dst_addr),
  KEY idx_ipv6_next_hop (ipv6_next_hop),
  KEY idx_prot (prot),
  KEY idx_l4_src_port (l4_src_port),
  KEY idx_l4_dst_port (l4_dst_port)
) TYPE=MyISAM MAX_ROWS=1000000000;