[Spce-user] Tables in Accounting

[Martin Wong]

Hi, we're trying to get the CDR directly from the database from another app
on the network for billing purposes.

I noticed that there the calls are all in the cdr table but there are other
ones like cdr_201208 etc.

mysql> show tables;
+----------------------+
| Tables_in_accounting |
+----------------------+
| acc                  |
| acc_backup           |
| acc_trash            |
| cdr                  |
| cdr_201208           |
| cdr_201209           |
| cdr_201210           |
| mark                 |
| prepaid_costs        |
+----------------------+
9 rows in set (0.00 sec)

1. Is there an automatic script that renames the tables for archiving
purposes?
2. Is the cdr table the correct source to getting call detail records? Just
don't want to go through the file system.

Thanks

Martin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/mailman/private/spce-user_lists.sipwise.com/attachments/20130502/b4d54ca0/attachment.html>