aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rwxr-xr-xclients/build-linknets.pl4
-rw-r--r--clients/snmp.sql1
2 files changed, 2 insertions, 3 deletions
diff --git a/clients/build-linknets.pl b/clients/build-linknets.pl
index b0bd7e0..0b07d33 100755
--- a/clients/build-linknets.pl
+++ b/clients/build-linknets.pl
@@ -96,10 +96,8 @@ while (my ($sysname, $ip) = each %loopbacks) {
$dbh->do('UPDATE switches SET ip=? WHERE sysname=?',
undef, $ip, $sysname);
}
-
-# Update the switches we have loopback addresses fora
while (my ($sysname, $ipv6) = each %loopbacks) {
- $dbh->do('UPDATE switches SET ipv6=? WHERE sysname=?',
+ $dbh->do('UPDATE switches SET second_ip=? WHERE sysname=?',
undef, $ipv6, $sysname);
}
diff --git a/clients/snmp.sql b/clients/snmp.sql
index 47b4458..7e09313 100644
--- a/clients/snmp.sql
+++ b/clients/snmp.sql
@@ -6,6 +6,7 @@ create table switchtypes (
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,