← Back to branch summary

~ubuntu-branches/ubuntu/maverick/ntop/maverick

« back to all changes in this revision

Viewing changes to ntop/database/mySQLdefs.txt

  • Committer: Bazaar Package Importer
  • Author(s): Dennis Schoen
  • Date: 2002-04-12 11:38:47 UTC
  • Revision ID: james.westby@ubuntu.com-20020412113847-4k4yydw0pzybc6g8
Tags: upstream-2.0.0
Import upstream version 2.0.0

Show diffs side-by-side

added added

removed removed

Lines of Context:
ntop/database/mySQLdefs.txt
 
1
CREATE TABLE Hosts
 
2
     (
 
3
     ID                   INT NOT NULL AUTO_INCREMENT,
 
4
     IPaddress            CHAR(16) NOT NULL,
 
5
     MACaddress           CHAR(50),
 
6
     NICvendor            CHAR(32),
 
7
     OsName               CHAR(50),
 
8
     PktRcvd              INT,
 
9
     PktSent              INT,
 
10
     PktMulticastSent     INT,
 
11
     PktBroadcastSent     INT,
 
12
     DataSent             INT,
 
13
     DataRcvd             INT,
 
14
     FirstSeen            DATETIME,
 
15
     LastSeen             DATETIME,
 
16
     DataMulticastSent    INT,
 
17
     DataBroadcastSent    INT,
 
18
     KEY (ID),
 
19
     PRIMARY KEY (ID)
 
20
     );
 
21
 
 
22
CREATE TABLE IPtraffic
 
23
     (
 
24
     IPaddress            CHAR(16) NOT NULL,
 
25
     TCPsentLocally       INT,
 
26
     TCPsentRemotely      INT,
 
27
     TCPrcvdLocally       INT,
 
28
     TCPrcvdFromRemote    INT,
 
29
     UDPsentLocally       INT,
 
30
     UDPsentRemotely      INT,
 
31
     UDPrcvdLocally       INT,
 
32
     UDPrcvdFromRemote    INT,
 
33
     ICMPsent             INT,
 
34
     ICMPrcvd             INT,
 
35
     OSPFsent             INT,
 
36
     OSPFrcvd             INT,
 
37
     IGMPsent             INT,
 
38
     IGMPrcvd             INT,
 
39
     PRIMARY KEY (IPaddress)
 
40
     );
 
41
 
 
42
CREATE TABLE NameMapper
 
43
     (
 
44
     IPaddress            CHAR(16) NOT NULL,
 
45
     Name                 CHAR(50),
 
46
     PRIMARY KEY (IPaddress)
 
47
     );
 
48
 
 
49
CREATE TABLE NonIPTraffic
 
50
     (
 
51
     IPaddress            CHAR(16) NOT NULL,
 
52
     IPXsent              INT,
 
53
     IPXrcvd              INT,
 
54
     OSIsent              INT,
 
55
     OSIrcvd              INT,
 
56
     DLCsent              INT,
 
57
     DLCrcvd              INT,
 
58
     ARPsent              INT,
 
59
     ARPrcvd              INT,
 
60
     DECNETsent           INT,
 
61
     DECNETrcvd           INT,
 
62
     ATALKsent            INT,
 
63
     ATALKrcvd            INT,
 
64
     NBIOSsent            INT,
 
65
     NBIOSrcvd            INT,
 
66
     OtherSent            INT,
 
67
     OtherRcvd            INT,
 
68
     PRIMARY KEY (IPaddress)
 
69
     );
 
70
 
 
71
CREATE TABLE TCPsessions
 
72
     (
 
73
     Client               CHAR(18),
 
74
     Server               CHAR(18),
 
75
     ClientPort           INT,
 
76
     ServerPort           INT,
 
77
     DataSent             CHAR(16),
 
78
     DataRcvd             CHAR(16),
 
79
     FirstSeen            DATETIME,
 
80
     LastSeen             DATETIME,
 
81
     ID                   INT NOT NULL AUTO_INCREMENT,
 
82
     KEY (ID),
 
83
     PRIMARY KEY (ID)
 
84
     );