service.sql

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

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

--
-- Table structure for table `service`
--

CREATE TABLE service (
  prot smallint(5) unsigned NOT NULL default '0',
  port smallint(5) unsigned NOT NULL default '0',
  name varchar(50) NOT NULL default '',
  descr varchar(255) default NULL,
  PRIMARY KEY  (prot,port,name)
) TYPE=MyISAM;

--
-- Dumping data for table `service`
--

INSERT INTO service VALUES (37,1,'rtmp','Routing Table Maintenance Protocol');
INSERT INTO service VALUES (6,1,'tcpmux','TCP Port Service Multiplexer');
INSERT INTO service VALUES (17,1,'tcpmux','TCP Port Service Multiplexer');
INSERT INTO service VALUES (37,2,'nbp','Name Binding Protocol');
INSERT INTO service VALUES (6,2,'compressnet','Management Utility');
INSERT INTO service VALUES (17,2,'compressnet','Management Utility');
INSERT INTO service VALUES (6,3,'compressnet','Compression Process');
INSERT INTO service VALUES (17,3,'compressnet','Compression Process');
INSERT INTO service VALUES (37,4,'echo','AppleTalk Echo Protocol');
INSERT INTO service VALUES (6,5,'rje','Remote Job Entry');
INSERT INTO service VALUES (17,5,'rje','Remote Job Entry');
INSERT INTO service VALUES (37,6,'zip','Zone Information Protocol');
INSERT INTO service VALUES (6,7,'echo','');
INSERT INTO service VALUES (17,7,'echo','');
INSERT INTO service VALUES (6,9,'discard','sink null');
INSERT INTO service VALUES (17,9,'discard','sink null');
INSERT INTO service VALUES (6,11,'systat','users #Active Users');
INSERT INTO service VALUES (17,11,'systat','users #Active Users');
INSERT INTO service VALUES (6,13,'daytime','');
INSERT INTO service VALUES (17,13,'daytime','');
INSERT INTO service VALUES (6,17,'qotd','quote #Quote of the Day');
INSERT INTO service VALUES (17,17,'qotd','quote #Quote of the Day');
INSERT INTO service VALUES (6,18,'msp','Message Send Protocol');
INSERT INTO service VALUES (17,18,'msp','Message Send Protocol');
INSERT INTO service VALUES (6,19,'chargen','ttytst source #Character Generator');
INSERT INTO service VALUES (17,19,'chargen','ttytst source #Character Generator');
INSERT INTO service VALUES (6,20,'ftp-data','File Transfer [Default Data]');
INSERT INTO service VALUES (17,20,'ftp-data','File Transfer [Default Data]');
INSERT INTO service VALUES (6,21,'ftp','File Transfer [Control]');
INSERT INTO service VALUES (17,21,'ftp','File Transfer [Control]');
INSERT INTO service VALUES (6,22,'ssh','Secure Shell Login');
INSERT INTO service VALUES (17,22,'ssh','Secure Shell Login');
INSERT INTO service VALUES (6,23,'telnet','');
INSERT INTO service VALUES (17,23,'telnet','');
INSERT INTO service VALUES (6,25,'smtp','mail #Simple Mail Transfer');
INSERT INTO service VALUES (17,25,'smtp','mail #Simple Mail Transfer');
INSERT INTO service VALUES (6,27,'nsw-fe','NSW User System FE');
INSERT INTO service VALUES (17,27,'nsw-fe','NSW User System FE');
INSERT INTO service VALUES (6,29,'msg-icp','MSG ICP');
INSERT INTO service VALUES (17,29,'msg-icp','MSG ICP');
INSERT INTO service VALUES (6,31,'msg-auth','MSG Authentication');
INSERT INTO service VALUES (17,31,'msg-auth','MSG Authentication');
INSERT INTO service VALUES (6,33,'dsp','Display Support Protocol');
INSERT INTO service VALUES (17,33,'dsp','Display Support Protocol');
INSERT INTO service VALUES (6,37,'time','timserver');
INSERT INTO service VALUES (17,37,'time','timserver');
INSERT INTO service VALUES (6,38,'rap','Route Access Protocol');
INSERT INTO service VALUES (17,38,'rap','Route Access Protocol');
INSERT INTO service VALUES (6,39,'rlp','resource #Resource Location Protocol');
INSERT INTO service VALUES (17,39,'rlp','resource #Resource Location Protocol');
INSERT INTO service VALUES (6,41,'graphics','');
INSERT INTO service VALUES (17,41,'graphics','');
INSERT INTO service VALUES (6,42,'nameserver','name #Host Name Server');
INSERT INTO service VALUES (17,42,'nameserver','name #Host Name Server');
INSERT INTO service VALUES (6,43,'nicname','whois');
INSERT INTO service VALUES (17,43,'nicname','whois');
INSERT INTO service VALUES (6,44,'mpm-flags','MPM FLAGS Protocol');
INSERT INTO service VALUES (17,44,'mpm-flags','MPM FLAGS Protocol');
INSERT INTO service VALUES (6,45,'mpm','Message Processing Module [recv]');
INSERT INTO service VALUES (17,45,'mpm','Message Processing Module [recv]');
INSERT INTO service VALUES (6,46,'mpm-snd','MPM [default send]');
INSERT INTO service VALUES (17,46,'mpm-snd','MPM [default send]');
INSERT INTO service VALUES (6,47,'ni-ftp','NI FTP');
INSERT INTO service VALUES (17,47,'ni-ftp','NI FTP');
INSERT INTO service VALUES (6,48,'auditd','Digital Audit Daemon');
INSERT INTO service VALUES (17,48,'auditd','Digital Audit Daemon');
INSERT INTO service VALUES (6,49,'tacacs','Login Host Protocol (TACACS)');
INSERT INTO service VALUES (17,49,'tacacs','Login Host Protocol (TACACS)');
INSERT INTO service VALUES (6,50,'re-mail-ck','Remote Mail Checking Protocol');
INSERT INTO service VALUES (17,50,'re-mail-ck','Remote Mail Checking Protocol');
INSERT INTO service VALUES (6,51,'la-maint','IMP Logical Address Maintenance');
INSERT INTO service VALUES (17,51,'la-maint','IMP Logical Address Maintenance');
INSERT INTO service VALUES (6,52,'xns-time','XNS Time Protocol');
INSERT INTO service VALUES (17,52,'xns-time','XNS Time Protocol');
INSERT INTO service VALUES (6,53,'domain','Domain Name Server');
INSERT INTO service VALUES (17,53,'domain','Domain Name Server');
INSERT INTO service VALUES (6,54,'xns-ch','XNS Clearinghouse');
INSERT INTO service VALUES (17,54,'xns-ch','XNS Clearinghouse');
INSERT INTO service VALUES (6,55,'isi-gl','ISI Graphics Language');
INSERT INTO service VALUES (17,55,'isi-gl','ISI Graphics Language');
INSERT INTO service VALUES (6,56,'xns-auth','XNS Authentication');
INSERT INTO service VALUES (17,56,'xns-auth','XNS Authentication');
INSERT INTO service VALUES (6,57,'mtp',' deprecated');
INSERT INTO service VALUES (6,58,'xns-mail','XNS Mail');
INSERT INTO service VALUES (17,58,'xns-mail','XNS Mail');
INSERT INTO service VALUES (6,61,'ni-mail','NI MAIL');
INSERT INTO service VALUES (17,61,'ni-mail','NI MAIL');
INSERT INTO service VALUES (6,62,'acas','ACA Services');
INSERT INTO service VALUES (17,62,'acas','ACA Services');
INSERT INTO service VALUES (6,63,'whois++','');
INSERT INTO service VALUES (17,63,'whois++','');
INSERT INTO service VALUES (6,64,'covia','Communications Integrator (CI)');
INSERT INTO service VALUES (17,64,'covia','Communications Integrator (CI)');
INSERT INTO service VALUES (6,65,'tacacs-ds','TACACS-Database Service');
INSERT INTO service VALUES (17,65,'tacacs-ds','TACACS-Database Service');
INSERT INTO service VALUES (6,66,'sql*net','Oracle SQL*NET');
INSERT INTO service VALUES (17,66,'sql*net','Oracle SQL*NET');
INSERT INTO service VALUES (6,67,'bootps','dhcps #Bootstrap Protocol Server');
INSERT INTO service VALUES (17,67,'bootps','dhcps #Bootstrap Protocol Server');
INSERT INTO service VALUES (6,68,'bootpc','dhcpc #Bootstrap Protocol Client');
INSERT INTO service VALUES (17,68,'bootpc','dhcpc #Bootstrap Protocol Client');
INSERT INTO service VALUES (6,69,'tftp','Trivial File Transfer');
INSERT INTO service VALUES (17,69,'tftp','Trivial File Transfer');
INSERT INTO service VALUES (6,70,'gopher','');
INSERT INTO service VALUES (17,70,'gopher','');
INSERT INTO service VALUES (6,71,'netrjs-1','Remote Job Service');
INSERT INTO service VALUES (17,71,'netrjs-1','Remote Job Service');
INSERT INTO service VALUES (6,72,'netrjs-2','Remote Job Service');
INSERT INTO service VALUES (17,72,'netrjs-2','Remote Job Service');
INSERT INTO service VALUES (6,73,'netrjs-3','Remote Job Service');
INSERT INTO service VALUES (17,73,'netrjs-3','Remote Job Service');
INSERT INTO service VALUES (6,74,'netrjs-4','Remote Job Service');
INSERT INTO service VALUES (17,74,'netrjs-4','Remote Job Service');
INSERT INTO service VALUES (6,76,'deos','Distributed External Object Store');
INSERT INTO service VALUES (17,76,'deos','Distributed External Object Store');
INSERT INTO service VALUES (6,77,'netrjs','');
INSERT INTO service VALUES (6,78,'vettcp','');
INSERT INTO service VALUES (17,78,'vettcp','');
INSERT INTO service VALUES (6,79,'finger','');
INSERT INTO service VALUES (17,79,'finger','');
INSERT INTO service VALUES (6,80,'http','www www-http #World Wide Web HTTP');
INSERT INTO service VALUES (17,80,'http','www www-http #World Wide Web HTTP');
INSERT INTO service VALUES (6,81,'hosts2-ns','HOSTS2 Name Server');
INSERT INTO service VALUES (17,81,'hosts2-ns','HOSTS2 Name Server');
INSERT INTO service VALUES (6,82,'xfer','XFER Utility');
INSERT INTO service VALUES (17,82,'xfer','XFER Utility');
INSERT INTO service VALUES (6,83,'mit-ml-dev','MIT ML Device');
INSERT INTO service VALUES (17,83,'mit-ml-dev','MIT ML Device');
INSERT INTO service VALUES (6,84,'ctf','Common Trace Facility');
INSERT INTO service VALUES (17,84,'ctf','Common Trace Facility');
INSERT INTO service VALUES (6,85,'mit-ml-dev','MIT ML Device');
INSERT INTO service VALUES (17,85,'mit-ml-dev','MIT ML Device');
INSERT INTO service VALUES (6,86,'mfcobol','Micro Focus Cobol');
INSERT INTO service VALUES (17,86,'mfcobol','Micro Focus Cobol');
INSERT INTO service VALUES (6,87,'ttylink','');
INSERT INTO service VALUES (6,88,'kerberos-sec','kerberos # krb5 # Kerberos (v5)');
INSERT INTO service VALUES (17,88,'kerberos-sec','kerberos # krb5 # Kerberos (v5)');
INSERT INTO service VALUES (6,89,'su-mit-tg','SU/MIT Telnet Gateway');
INSERT INTO service VALUES (17,89,'su-mit-tg','SU/MIT Telnet Gateway');
INSERT INTO service VALUES (6,90,'dnsix','DNSIX Securit Attribute Token Map');
INSERT INTO service VALUES (17,90,'dnsix','DNSIX Securit Attribute Token Map');
INSERT INTO service VALUES (6,91,'mit-dov','MIT Dover Spooler');
INSERT INTO service VALUES (17,91,'mit-dov','MIT Dover Spooler');
INSERT INTO service VALUES (6,92,'npp','Network Printing Protocol');
INSERT INTO service VALUES (17,92,'npp','Network Printing Protocol');
INSERT INTO service VALUES (6,93,'dcp','Device Control Protocol');
INSERT INTO service VALUES (17,93,'dcp','Device Control Protocol');
INSERT INTO service VALUES (6,94,'objcall','Tivoli Object Dispatcher');
INSERT INTO service VALUES (17,94,'objcall','Tivoli Object Dispatcher');
INSERT INTO service VALUES (6,95,'supdup','');
INSERT INTO service VALUES (17,95,'supdup','');
INSERT INTO service VALUES (6,96,'dixie','DIXIE Protocol Specification');
INSERT INTO service VALUES (17,96,'dixie','DIXIE Protocol Specification');
INSERT INTO service VALUES (6,97,'swift-rvf','Swift Remote Virtural File Protocol');
INSERT INTO service VALUES (17,97,'swift-rvf','Swift Remote Virtural File Protocol');
INSERT INTO service VALUES (6,98,'tacnews','TAC News, Unofficial: Red Hat linuxconf');
INSERT INTO service VALUES (17,98,'tacnews','TAC News, Unofficial: Red Hat linuxconf');
INSERT INTO service VALUES (6,99,'metagram','Metagram Relay');
INSERT INTO service VALUES (17,99,'metagram','Metagram Relay');
INSERT INTO service VALUES (6,100,'newacct','[unauthorized use]');
INSERT INTO service VALUES (6,101,'hostname','hostnames #NIC Host Name Server');
INSERT INTO service VALUES (17,101,'hostname','hostnames #NIC Host Name Server');
INSERT INTO service VALUES (6,102,'iso-tsap','tsap #ISO-TSAP Class 0');
INSERT INTO service VALUES (17,102,'iso-tsap','tsap #ISO-TSAP Class 0');
INSERT INTO service VALUES (6,103,'gppitnp','Genesis Point-to-Point Trans Net');
INSERT INTO service VALUES (17,103,'gppitnp','Genesis Point-to-Point Trans Net');
INSERT INTO service VALUES (6,104,'acr-nema','ACR-NEMA Digital Imag. & Comm. 300');
INSERT INTO service VALUES (17,104,'acr-nema','ACR-NEMA Digital Imag. & Comm. 300');
INSERT INTO service VALUES (6,105,'csnet-ns','cso-ns cso #Mailbox Name Nameserver');
INSERT INTO service VALUES (17,105,'csnet-ns','cso-ns cso #Mailbox Name Nameserver');
INSERT INTO service VALUES (6,106,'pop3pw','3com-tsmux #Eudora compatible PW changer');
INSERT INTO service VALUES (17,106,'3com-tsmux','');
INSERT INTO service VALUES (6,107,'rtelnet','Remote Telnet Service');
INSERT INTO service VALUES (17,107,'rtelnet','Remote Telnet Service');
INSERT INTO service VALUES (6,108,'snagas','SNA Gateway Access Server');
INSERT INTO service VALUES (17,108,'snagas','SNA Gateway Access Server');
INSERT INTO service VALUES (6,109,'pop2','postoffice #Post Office Protocol - Version 2');
INSERT INTO service VALUES (17,109,'pop2','postoffice #Post Office Protocol - Version 2');
INSERT INTO service VALUES (6,110,'pop3','Post Office Protocol - Version 3');
INSERT INTO service VALUES (17,110,'pop3','Post Office Protocol - Version 3');
INSERT INTO service VALUES (6,111,'sunrpc','rpcbind #SUN Remote Procedure Call');
INSERT INTO service VALUES (17,111,'sunrpc','rpcbind #SUN Remote Procedure Call');
INSERT INTO service VALUES (6,112,'mcidas','McIDAS Data Transmission Protocol');
INSERT INTO service VALUES (17,112,'mcidas','McIDAS Data Transmission Protocol');
INSERT INTO service VALUES (6,113,'auth','ident tap #Authentication Service');
INSERT INTO service VALUES (17,113,'auth','ident tap #Authentication Service');
INSERT INTO service VALUES (6,114,'audionews','Audio News Multicast');
INSERT INTO service VALUES (17,114,'audionews','Audio News Multicast');
INSERT INTO service VALUES (6,115,'sftp','Simple File Transfer Protocol');