protocol.sql

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

-- MySQL dump 9.09
--
-- Host: localhost    Database: flow
---------------------------------------------------------
-- Server version	4.0.15-log

--
-- Table structure for table `protocol`
--

CREATE TABLE protocol (
  number smallint(5) unsigned NOT NULL default '0',
  name varchar(20) NOT NULL default '',
  descr varchar(255) default NULL,
  PRIMARY KEY  (number)
) TYPE=MyISAM;

--
-- Dumping data for table `protocol`
--

INSERT INTO protocol VALUES (0,'ip','internet protocol, pseudo protocol number');
INSERT INTO protocol VALUES (1,'icmp','internet control message protocol');
INSERT INTO protocol VALUES (2,'igmp','internet group management protocol');
INSERT INTO protocol VALUES (3,'ggp','gateway-gateway protocol');
INSERT INTO protocol VALUES (4,'ipencap','IP encapsulated in IP (officially ``IP\'\')');
INSERT INTO protocol VALUES (5,'st2','ST2 datagram mode (RFC 1819)');
INSERT INTO protocol VALUES (6,'tcp','transmission control protocol');
INSERT INTO protocol VALUES (7,'cbt','CBT, Tony Ballardie <[e-mail]>');
INSERT INTO protocol VALUES (8,'egp','exterior gateway protocol');
INSERT INTO protocol VALUES (9,'igp','any private interior gateway (Cisco: for IGRP)');
INSERT INTO protocol VALUES (10,'bbn-rcc','BBN RCC Monitoring');
INSERT INTO protocol VALUES (11,'nvp','Network Voice Protocol');
INSERT INTO protocol VALUES (12,'pup','PARC universal packet protocol');
INSERT INTO protocol VALUES (13,'argus','ARGUS');
INSERT INTO protocol VALUES (14,'emcon','EMCON');
INSERT INTO protocol VALUES (15,'xnet','Cross Net Debugger');
INSERT INTO protocol VALUES (16,'chaos','Chaos');
INSERT INTO protocol VALUES (17,'udp','user datagram protocol');
INSERT INTO protocol VALUES (18,'mux','Multiplexing protocol');
INSERT INTO protocol VALUES (19,'dcn','DCN Measurement Subsystems');
INSERT INTO protocol VALUES (20,'hmp','host monitoring protocol');
INSERT INTO protocol VALUES (21,'prm','packet radio measurement protocol');
INSERT INTO protocol VALUES (22,'xns-idp','Xerox NS IDP');
INSERT INTO protocol VALUES (23,'trunk-1','Trunk-1');
INSERT INTO protocol VALUES (24,'trunk-2','Trunk-2');
INSERT INTO protocol VALUES (25,'leaf-1','Leaf-1');
INSERT INTO protocol VALUES (26,'leaf-2','Leaf-2');
INSERT INTO protocol VALUES (27,'rdp','\"reliable datagram\" protocol');
INSERT INTO protocol VALUES (28,'irtp','Internet Reliable Transaction Protocol');
INSERT INTO protocol VALUES (29,'iso-tp4','ISO Transport Protocol Class 4');
INSERT INTO protocol VALUES (30,'netblt','Bulk Data Transfer Protocol');
INSERT INTO protocol VALUES (31,'mfe-nsp','MFE Network Services Protocol');
INSERT INTO protocol VALUES (32,'merit-inp','MERIT Internodal Protocol');
INSERT INTO protocol VALUES (33,'sep','Sequential Exchange Protocol');
INSERT INTO protocol VALUES (34,'3pc','Third Party Connect Protocol');
INSERT INTO protocol VALUES (35,'idpr','Inter-Domain Policy Routing Protocol');
INSERT INTO protocol VALUES (36,'xtp','Xpress Tranfer Protocol');
INSERT INTO protocol VALUES (37,'ddp','Datagram Delivery Protocol');
INSERT INTO protocol VALUES (38,'idpr-cmtp','IDPR Control Message Transport Proto');
INSERT INTO protocol VALUES (39,'tp++','TP++ Transport Protocol');
INSERT INTO protocol VALUES (40,'il','IL Transport Protocol');
INSERT INTO protocol VALUES (41,'ipv6','ipv6');
INSERT INTO protocol VALUES (42,'sdrp','Source Demand Routing Protocol');
INSERT INTO protocol VALUES (43,'ipv6-route','routing header for ipv6');
INSERT INTO protocol VALUES (44,'ipv6-frag','fragment header for ipv6');
INSERT INTO protocol VALUES (45,'idrp','Inter-Domain Routing Protocol');
INSERT INTO protocol VALUES (46,'rsvp','Resource ReSerVation Protocol');
INSERT INTO protocol VALUES (47,'gre','Generic Routing Encapsulation');
INSERT INTO protocol VALUES (48,'mhrp','Mobile Host Routing Protocol');
INSERT INTO protocol VALUES (49,'bna','BNA');
INSERT INTO protocol VALUES (50,'esp','encapsulating security payload');
INSERT INTO protocol VALUES (51,'ah','authentication header');
INSERT INTO protocol VALUES (52,'i-nlsp','Integrated Net Layer Security TUBA');
INSERT INTO protocol VALUES (53,'swipe','IP with Encryption');
INSERT INTO protocol VALUES (54,'narp','NBMA Address Resolution Protocol');
INSERT INTO protocol VALUES (55,'mobile','IP Mobility');
INSERT INTO protocol VALUES (56,'tlsp','Transport Layer Security Protocol');
INSERT INTO protocol VALUES (57,'skip','SKIP');
INSERT INTO protocol VALUES (58,'ipv6-icmp','ICMP for IPv6');
INSERT INTO protocol VALUES (59,'ipv6-nonxt','no next header for ipv6');
INSERT INTO protocol VALUES (60,'ipv6-opts','destination options for ipv6');
INSERT INTO protocol VALUES (62,'cftp','CFTP');
INSERT INTO protocol VALUES (64,'sat-expak','SATNET and Backroom EXPAK');
INSERT INTO protocol VALUES (65,'kryptolan','Kryptolan');
INSERT INTO protocol VALUES (66,'rvd','MIT Remote Virtual Disk Protocol');
INSERT INTO protocol VALUES (67,'ippc','Internet Pluribus Packet Core');
INSERT INTO protocol VALUES (69,'sat-mon','SATNET Monitoring');
INSERT INTO protocol VALUES (70,'visa','VISA Protocol');
INSERT INTO protocol VALUES (71,'ipcv','Internet Packet Core Utility');
INSERT INTO protocol VALUES (72,'cpnx','Computer Protocol Network Executive');
INSERT INTO protocol VALUES (73,'cphb','Computer Protocol Heart Beat');
INSERT INTO protocol VALUES (74,'wsn','Wang Span Network');
INSERT INTO protocol VALUES (75,'pvp','Packet Video Protocol');
INSERT INTO protocol VALUES (76,'br-sat-mon','Backroom SATNET Monitoring');
INSERT INTO protocol VALUES (77,'sun-nd','SUN ND PROTOCOL-Temporary');
INSERT INTO protocol VALUES (78,'wb-mon','WIDEBAND Monitoring');
INSERT INTO protocol VALUES (79,'wb-expak','WIDEBAND EXPAK');
INSERT INTO protocol VALUES (80,'iso-ip','ISO Internet Protocol');
INSERT INTO protocol VALUES (81,'vmtp','Versatile Message Transport');
INSERT INTO protocol VALUES (82,'secure-vmtp','SECURE-VMTP');
INSERT INTO protocol VALUES (83,'vines','VINES');
INSERT INTO protocol VALUES (84,'ttp','TTP');
INSERT INTO protocol VALUES (85,'nsfnet-igp','NSFNET-IGP');
INSERT INTO protocol VALUES (86,'dgp','Dissimilar Gateway Protocol');
INSERT INTO protocol VALUES (87,'tcf','TCF');
INSERT INTO protocol VALUES (88,'eigrp','Enhanced Interior Routing Protocol (Cisco)');
INSERT INTO protocol VALUES (89,'ospf','Open Shortest Path First IGP');
INSERT INTO protocol VALUES (90,'sprite-rpc','Sprite RPC Protocol');
INSERT INTO protocol VALUES (91,'larp','Locus Address Resolution Protocol');
INSERT INTO protocol VALUES (92,'mtp','Multicast Transport Protocol');
INSERT INTO protocol VALUES (93,'ax.25','AX.25 Frames');
INSERT INTO protocol VALUES (94,'ipip','Yet Another IP encapsulation');
INSERT INTO protocol VALUES (95,'micp','Mobile Internetworking Control Pro.');
INSERT INTO protocol VALUES (96,'scc-sp','Semaphore Communications Sec. Pro.');
INSERT INTO protocol VALUES (97,'etherip','Ethernet-within-IP Encapsulation');
INSERT INTO protocol VALUES (98,'encap','Yet Another IP encapsulation');
INSERT INTO protocol VALUES (100,'gmtp','GMTP');
INSERT INTO protocol VALUES (101,'ifmp','Ipsilon Flow Management Protocol');
INSERT INTO protocol VALUES (102,'pnni','PNNI over IP');
INSERT INTO protocol VALUES (103,'pim','Protocol Independent Multicast');
INSERT INTO protocol VALUES (104,'aris','ARIS');
INSERT INTO protocol VALUES (105,'scps','SCPS');
INSERT INTO protocol VALUES (106,'qnx','QNX');
INSERT INTO protocol VALUES (107,'a/n','Active Networks');
INSERT INTO protocol VALUES (108,'ipcomp','IP Payload Compression Protocol');
INSERT INTO protocol VALUES (109,'snp','Sitara Networks Protocol');
INSERT INTO protocol VALUES (110,'compaq-peer','Compaq Peer Protocol');
INSERT INTO protocol VALUES (111,'ipx-in-ip','IPX in IP');
INSERT INTO protocol VALUES (112,'vrrp','Virtual Router Redundancy Protocol');
INSERT INTO protocol VALUES (113,'pgm','PGM Reliable Transport Protocol');
INSERT INTO protocol VALUES (115,'l2tp','Layer Two Tunneling Protocol');
INSERT INTO protocol VALUES (116,'ddx','D-II Data Exchange');
INSERT INTO protocol VALUES (117,'iatp','Interactive Agent Transfer Protocol');
INSERT INTO protocol VALUES (118,'st','Schedule Transfer');
INSERT INTO protocol VALUES (119,'srp','SpectraLink Radio Protocol');
INSERT INTO protocol VALUES (120,'uti','UTI');
INSERT INTO protocol VALUES (121,'smp','Simple Message Protocol');
INSERT INTO protocol VALUES (122,'sm','SM');
INSERT INTO protocol VALUES (123,'ptp','Performance Transparency Protocol');
INSERT INTO protocol VALUES (124,'isis','ISIS over IPv4');
INSERT INTO protocol VALUES (125,'fire','');
INSERT INTO protocol VALUES (126,'crtp','Combat Radio Transport Protocol');
INSERT INTO protocol VALUES (127,'crudp','Combat Radio User Datagram');
INSERT INTO protocol VALUES (128,'sscopmce','');
INSERT INTO protocol VALUES (129,'iplt','');
INSERT INTO protocol VALUES (130,'sps','Secure Packet Shield');
INSERT INTO protocol VALUES (131,'pipe','Private IP Encapsulation within IP');
INSERT INTO protocol VALUES (132,'sctp','Stream Control Transmission Protocol');
INSERT INTO protocol VALUES (133,'fc','Fibre Channel');
INSERT INTO protocol VALUES (258,'divert','Divert pseudo-protocol [non IANA]');