← Back to branch summary

~ubuntu-branches/ubuntu/wily/ntop/wily-proposed

« back to all changes in this revision

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