diff options
Diffstat (limited to 'net/rtg/files/patch-etc-rtgtargmkr.pl.in')
| -rw-r--r-- | net/rtg/files/patch-etc-rtgtargmkr.pl.in | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/net/rtg/files/patch-etc-rtgtargmkr.pl.in b/net/rtg/files/patch-etc-rtgtargmkr.pl.in new file mode 100644 index 000000000000..318b3c3e06e7 --- /dev/null +++ b/net/rtg/files/patch-etc-rtgtargmkr.pl.in @@ -0,0 +1,11 @@ +--- etc/rtgtargmkr.pl.in.orig 2010-04-21 20:55:58.903081619 +0100 ++++ etc/rtgtargmkr.pl.in 2010-04-21 20:56:15.567832088 +0100 +@@ -126,7 +126,7 @@ + &sql_insert($sql); + $rid = &find_router_id($router); + foreach $mib ( keys %mibs_of_interest ) { +- $sql = "CREATE TABLE $mib"."_$rid (id INT NOT NULL, dtime DATETIME NOT NULL, counter BIGINT NOT NULL, KEY $mib"."_$rid". "_idx (dtime))"; ++ $sql = "CREATE TABLE $mib"."_$rid (id INT NOT NULL, dtime DATETIME NOT NULL, counter BIGINT NOT NULL, KEY $mib"."_$rid". "_idx (dtime), KEY id_dtime_idx (id,dtime))"; + &sql_insert($sql); + } + } |