<div dir="ltr">Well, a very basic sign of good piece of software, that is driven by database,is that it ALWAYS uses column names, instead of index numbers. OpenSIPS not only confirm to this very basic standard but it further improves it by allowing user to define table and column names as module parameter that will be internally called by module through SQL queries. So, yes adding more columns should not and will not effect its processing. However, be sure to only add columns that are really need or at least fit to the philosophy of the module.<div>
<br></div><div>In my personal view routing and rating are two distinct entities and for sake of data independence they should not be mixed together in a single table. Perhaps you should to be interested in call-control module or something similar. If you are good in PERL or LUA you can even write up your own module for rating and billing, and it would work like a charm even for high loads, as long as you keep your database optimized. And yes, you can make such rating / billing module on commercial license.<br>
<div><br><div>Thank you.</div><div><br></div><div><br></div></div></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Mon, Aug 5, 2013 at 6:00 PM, Nick Khamis <span dir="ltr"><<a href="mailto:symack@gmail.com" target="_blank">symack@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hello Muhammad,<div><br></div><div>I have no problem updating the DB script and relevant code using optimized indexing/views, and sharing that with the community. It's about time I contribute in some form or another... :)</div>
<div><br></div><div>Furthermore, I would also like to share the final DB schema and script in charge of creating an OpenSIPS LCR instance with the community. And would be happy to see it posted on the OpenSIPS Tut section. I will have some questions to steer me to the right direction however, will keep them short and connect the dots without taking too much of the community's time.</div>
<div><br></div><div>My first question will be, is it safe to add additional fields to the `dr_rules` table. What I will need are things like (bill_minimum, bill_increment, list/retail_rate etc..). Things we usually see in a rate deck ;). What I am asking is do the OpenSIPS code use index based queries or actual field names when querying the database. The latter would be safer and thus pose no problem when adding extra fields...</div>
<div><br></div><div>PS I will use this email as a thread to this subject.</div><div><br></div><div>Kind Regards,</div><div><br></div><div>Nick.</div></div>
<br>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div><span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">Mit freundlichen Grüßen</span></div>
<span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">Muhammad Shahzad</span><br style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
<span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">------------------------------</span><span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">-----</span><br style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
<span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">CISCO Rich Media Communication Specialist (CRMCS)</span><br style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
<span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">CISCO Certified Network Associate (CCNA)</span><br style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
<span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">Cell: +49 176 99 83 10 85</span><br style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
<span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">MSN: </span><a href="mailto:shari_786pk@hotmail.com" style="color:rgb(17,85,204);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)" target="_blank">shari_786pk@hotmail.com</a><br style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
<span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">Email: </span><a href="mailto:shaheryarkh@googlemail.com" style="color:rgb(17,85,204);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)" target="_blank">shaheryarkh@googlemail.com</a>
</div>