diff options
| author | Jon Langseth <jon.langseth@lilug.no> | 2014-04-16 03:01:37 +0200 |
|---|---|---|
| committer | Jon Langseth <jon.langseth@lilug.no> | 2014-04-16 03:01:37 +0200 |
| commit | 47869c4fcc8ebefc90bd29f501c198980e669196 (patch) | |
| tree | 9ab4787f5b1f4bb36e7d5a156e636c178dd18413 | |
| parent | fe0d64deab4b01b808e6f1280a33072f07d511fe (diff) | |
Changed SQL column name, added change to SQL schema
| -rwxr-xr-x | clients/build-linknets.pl | 4 | ||||
| -rw-r--r-- | clients/snmp.sql | 1 |
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, |