diff options
author | Kristian Lyngstol <kly@kly@.no> | 2016-03-26 03:48:32 +0100 |
---|---|---|
committer | Kristian Lyngstol <kly@kly@.no> | 2016-03-26 03:48:32 +0100 |
commit | cda4d1235486dc74c5d3630fc5e85307f277c5f3 (patch) | |
tree | 0e59890e8afcf09024079d0e3a596e16b63250af /clients/snmp.sql | |
parent | 004f4efcfd0779f4307b90fed139dc87d01ad0b9 (diff) | |
parent | a791ca16c787672ea534dbde39f926d0341aa2e6 (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 ); |