aboutsummaryrefslogtreecommitdiffstats
path: root/clients/snmp.sql
diff options
context:
space:
mode:
authorKristian Lyngstol <kristian@bohemians.org>2016-03-27 08:27:17 +0200
committerKristian Lyngstol <kristian@bohemians.org>2016-03-27 08:27:17 +0200
commit1d2470a411e5eaac7e5a1c5d5b6b81e92c92f4a8 (patch)
tree54b901757b088d54d33e70f28a6203383b4dc844 /clients/snmp.sql
parent0a230ac5481b9518abc64181dbbb4509d83c0b89 (diff)
parent96a9bb4c42f4b53020302fea2a46e734c61c0319 (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 );