aboutsummaryrefslogtreecommitdiffstats
path: root/clients/snmp.sql
diff options
context:
space:
mode:
authorJoachim Tingvold <joachim@tingvold.com>2016-03-25 15:23:08 +0100
committerJoachim Tingvold <joachim@tingvold.com>2016-03-25 15:23:08 +0100
commit519bae0f07f38bd82257c61a924085f64ad360cc (patch)
treed249ad5957cc3698db40df972c5a60d37679abea /clients/snmp.sql
parent14dbbc1451b4d5ea99e1937020e4fc79fe7ba1a7 (diff)
Moved old, unused files.
Diffstat (limited to 'clients/snmp.sql')
-rw-r--r--clients/snmp.sql25
1 files changed, 0 insertions, 25 deletions
diff --git a/clients/snmp.sql b/clients/snmp.sql
deleted file mode 100644
index 7e09313..0000000
--- a/clients/snmp.sql
+++ /dev/null
@@ -1,25 +0,0 @@
-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 );