"Fossies" - the Fresh Open Source Software Archive

Member "bandwidthd-2.0.1/schema.postgresql" (7 Jan 2005, 1428 Bytes) of package /linux/privat/old/bandwidthd-2.0.1.tgz:


As a special service "Fossies" has tried to format the requested text file into HTML format (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file.

    1 CREATE TABLE bd_rx_log
    2 (sensor_id int,
    3 ip inet,
    4 timestamp timestamp with time zone DEFAULT now(),
    5 sample_duration int,
    6 total int,
    7 icmp int,
    8 udp int,
    9 tcp int,
   10 ftp int,
   11 http int,
   12 p2p int);
   13 create index bd_rx_log_sensor_id_ip_timestamp_idx on bd_rx_log (sensor_id, ip, timestamp);
   14 create index bd_rx_log_sensor_id_timestamp_idx on bd_rx_log(sensor_id, timestamp);
   15 
   16 CREATE TABLE bd_tx_log
   17 (sensor_id int,
   18 ip inet,
   19 timestamp timestamp with time zone DEFAULT now(),
   20 sample_duration int,
   21 total int,
   22 icmp int,
   23 udp int,
   24 tcp int,
   25 ftp int,
   26 http int,
   27 p2p int);
   28 create index bd_tx_log_sensor_id_ip_timestamp_idx on bd_tx_log (sensor_id, ip, timestamp);
   29 create index bd_tx_log_sensor_id_timestamp_idx on bd_tx_log(sensor_id, timestamp);
   30 
   31 CREATE TABLE bd_rx_total_log
   32 (sensor_id int,
   33 ip inet,
   34 timestamp timestamp with time zone DEFAULT now(),
   35 sample_duration int,
   36 total int,
   37 icmp int,
   38 udp int,
   39 tcp int,
   40 ftp int,
   41 http int,
   42 p2p int);
   43 create index bd_rx_total_log_sensor_id_timestamp_ip_idx on bd_rx_total_log (sensor_id, timestamp);
   44 
   45 
   46 CREATE TABLE bd_tx_total_log
   47 (sensor_id int,
   48 ip inet,
   49 timestamp timestamp with time zone DEFAULT now(),
   50 sample_duration int,
   51 total int,
   52 icmp int,
   53 udp int,
   54 tcp int,
   55 ftp int,
   56 http int,
   57 p2p int);
   58 create index bd_tx_total_log_sensor_id_timestamp_ip_idx on bd_tx_total_log (sensor_id, timestamp);
   59 
   60 CREATE TABLE sensors
   61 (
   62 sensor_id serial PRIMARY KEY,
   63 sensor_name varchar,
   64 last_connection timestamp with time zone
   65 );