From a43ffc48e2f1247a6440206cfcf2b94cdd0ece83 Mon Sep 17 00:00:00 2001 From: Stefan Walter Date: Wed, 30 Jun 2010 20:05:46 +0000 Subject: - Add rc.d script. - Optimise db table creation with indexes. - Add PID file option. - Fix a few warnings in the Makefile. - Assign maintainership to submitter. PR: 145924 Submitted by: Daniel Austin Feature safe: yes --- net/rtg/files/patch-etc-rtgtargmkr.pl.in | 11 +++++++++++ 1 file changed, 11 insertions(+) create mode 100644 net/rtg/files/patch-etc-rtgtargmkr.pl.in (limited to 'net/rtg/files/patch-etc-rtgtargmkr.pl.in') 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); + } + } -- cgit v1.2.3