[OpenSIPS-Users] How to convert acc table in a kind of circular buffer?

[Rodrigo Pimenta Carvalho]

Thank you for the hint!


RODRIGO PIMENTA CARVALHO
Inatel Competence Center
Software
Ph: +55 35 3471 9200 RAMAL 979


________________________________
De: users-bounces at lists.opensips.org <users-bounces at lists.opensips.org> em nome de Podrigal, Aron <aronp at guaranteedplus.com>
Enviado: quinta-feira, 1 de outubro de 2015 14:35
Para: OpenSIPS users mailling list
Assunto: Re: [OpenSIPS-Users] How to convert acc table in a kind of circular buffer?


Use database triggers for that.

On Oct 1, 2015 7:44 AM, "Rodrigo Pimenta Carvalho" <pimenta at inatel.br<mailto:pimenta at inatel.br>> wrote:



Dear OpenSIPS-users,


A requirement of my current project says that the list of registered calls, from table acc, must have no more than X records. So, I need an way of controlling how many records can be kept in acc table.


Is there some script code that allows me to limit the maximum number of records in acc table and missed_calls too? By the way, when a call is created, but the table acc has the maximum allowed number of records, it should delete the old data record and keep the new one.


Any hint will be very helpful!


Best regards.



RODRIGO PIMENTA CARVALHO
Inatel Competence Center
Software
Ph: +55 35 3471 9200<tel:%2B55%2035%203471%209200> RAMAL 979

_______________________________________________
Users mailing list
Users at lists.opensips.org<mailto:Users at lists.opensips.org>
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20151001/78f41251/attachment-0001.htm>