aboutsummaryrefslogtreecommitdiffstats
path: root/clients/snmp.sql
diff options
context:
space:
mode:
authorKristian Lyngstol <kly@kly@.no>2016-03-26 03:48:32 +0100
committerKristian Lyngstol <kly@kly@.no>2016-03-26 03:48:32 +0100
commitcda4d1235486dc74c5d3630fc5e85307f277c5f3 (patch)
tree0e59890e8afcf09024079d0e3a596e16b63250af /clients/snmp.sql
parent004f4efcfd0779f4307b90fed139dc87d01ad0b9 (diff)
parenta791ca16c787672ea534dbde39f926d0341aa2e6 (diff)
Merge branch 'master' of github.com:tech-server/tgmanage
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 );