From 2a0c0a3dbbdf7fa5040953c0b0d88ad6f62c011e Mon Sep 17 00:00:00 2001
From: Joachim Tingvold <joachim@tingvold.com>
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

