From 2a0c0a3dbbdf7fa5040953c0b0d88ad6f62c011e Mon Sep 17 00:00:00 2001 From: Joachim Tingvold Date: Sun, 6 Apr 2014 03:11:04 +0200 Subject: Initial commit. Source; TG13-goodiebag. --- clients/snmp.sql | 24 ++++++++++++++++++++++++ 1 file changed, 24 insertions(+) create mode 100644 clients/snmp.sql (limited to 'clients/snmp.sql') diff --git a/clients/snmp.sql b/clients/snmp.sql new file mode 100644 index 0000000..47b4458 --- /dev/null +++ b/clients/snmp.sql @@ -0,0 +1,24 @@ +create table switchtypes ( + switchtype varchar not null primary key, + ports varchar not null +); + +create table switches ( + switch serial not null primary key, + ip inet not null, + sysname varchar not null, + switchtype varchar not null references switchtypes, + last_updated timestamp, + locked boolean not null default 'f' +); + +create table poll ( + time timestamp not null, + switch integer not null references switches, + port integer not null, + bytes_in bigint not null, + bytes_out bigint not null, + + primary key ( time, switch, port ) +); +create index poll_switch_port on poll ( switch, port ); -- cgit v1.2.3