diff options
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 ); |