Module: sip-router Branch: master Commit: b61b3d2f43108e2f758e3428449cdfadefd4097f URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=b61b3d2f...

Author: Alexandr Dubovikov alexandr.dubovikov@gmail.com Committer: Alexandr Dubovikov alexandr.dubovikov@gmail.com Date: Fri Aug 26 17:18:21 2011 +0200

module: sipcapture: Changed SQL schema for partitioning table.

Bug fix: mySQL doesn't support DAYOFWEEK rushing. Changed to RANGE condition: TO_DAYS and UNIX_TIMESTAMP. The last one, only for mySQL => 5.1.58 The two crontab scripts are in example directory.

---

modules/sipcapture/examples/crontabtruncate.pl | 8 ++- modules/sipcapture/examples/partrotate_todays.pl | 86 ++++++++++++++++++ .../examples/partrotate_unixtimestamp.pl | 93 ++++++++++++++++++++ .../sipcapture/sql/create_part_unixtimestamp.sql | 86 ++++++++++++++++++ modules/sipcapture/sql/sipcapture-create.sql | 41 ++++----- 5 files changed, 291 insertions(+), 23 deletions(-)

Diff: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commitdiff;h=b61b...