From 519bae0f07f38bd82257c61a924085f64ad360cc Mon Sep 17 00:00:00 2001
From: Joachim Tingvold <joachim@tingvold.com>
Date: Fri, 25 Mar 2016 15:23:08 +0100
Subject: Moved old, unused files.

---
 examples/historical/clients/snmp.sql | 25 +++++++++++++++++++++++++
 1 file changed, 25 insertions(+)
 create mode 100644 examples/historical/clients/snmp.sql

(limited to 'examples/historical/clients/snmp.sql')

diff --git a/examples/historical/clients/snmp.sql b/examples/historical/clients/snmp.sql
new file mode 100644
index 0000000..7e09313
--- /dev/null
+++ b/examples/historical/clients/snmp.sql
@@ -0,0 +1,25 @@
+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,
+	secondary_ip inet,
+	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