diff options
author | Kristian Lyngstol <kristian@bohemians.org> | 2016-03-27 08:27:17 +0200 |
---|---|---|
committer | Kristian Lyngstol <kristian@bohemians.org> | 2016-03-27 08:27:17 +0200 |
commit | 1d2470a411e5eaac7e5a1c5d5b6b81e92c92f4a8 (patch) | |
tree | 54b901757b088d54d33e70f28a6203383b4dc844 /clients/snmp.sql | |
parent | 0a230ac5481b9518abc64181dbbb4509d83c0b89 (diff) | |
parent | 96a9bb4c42f4b53020302fea2a46e734c61c0319 (diff) |
Merge branch 'master' of github.com:tech-server/tgmanage
Diffstat (limited to 'clients/snmp.sql')
-rw-r--r-- | clients/snmp.sql | 25 |
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 ); |