Module: sip-router
Branch: master
Commit: b61b3d2f43108e2f758e3428449cdfadefd4097f
URL:
http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=b61b3d2f43108e2f758e3428449cdfadefd4097f
Author: Alexandr Dubovikov <alexandr.dubovi...@gmail.com>
Committer: Alexandr Dubovikov <alexandr.dubovi...@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=b61b3d2f43108e2f758e3428449cdfadefd4097f
_______________________________________________
sr-dev mailing list
sr-dev@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
