Initial commit. Source; TG13-goodiebag.

1 files changed, 24 insertions, 0 deletions

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 );