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

[Alexandr Dubovikov]

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.dubovikov at gmail.com>
Committer: Alexandr Dubovikov <alexandr.dubovikov at 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