[sr-dev] git:master: module: sipcapture: Changed SQL schema for partitioning table.

Module: sip-router Branch: master Commit: b61b3d2f43108e2f758e3428449cdfadefd4097f URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=b61b3d2… Author: Alexandr Dubovikov <alexandr.dubovikov(a)gmail.com> Committer: Alexandr Dubovikov <alexandr.dubovikov(a)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=b61…