Merge branch 'master' of github.com:tech-server/tgmanage

1 files changed, 25 insertions, 0 deletions

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