Merge branch 'master' of ssh://github.com/tech-server/tgmanage

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