I was looking for MySQL table structures for ARA (Asterisk 1.8.X).<br>I found one for SIP friends on, <a href="https://wiki.asterisk.org/wiki/display/AST/SIP+Realtime,+MySQL+table+structure">https://wiki.asterisk.org/wiki/display/AST/SIP+Realtime,+MySQL+table+structure</a><br>
<br>But it seems that it is not as per the Asterisk 1.8 SIP options. i.e. it contains 'call-limit' which is deprecated in 1.8 and not the 'callcounter' as one of the fields. <br>Pardon my ignorance, but are 'cid_number','trunkname','fullname' from given link sip parameters to be set? sip.conf has no such entries.<br>
<br>I also looked at .../contrib/realtime/mysql, and didn't find 'callcounter' in sipfriends.sql. I also couldn't find tables for queue and queue members in it.<br><br>Yes, I can update or add latest options(fields) in sipfriends.sql. I can even create structures for queue and queue members.I just wanted to come across the latest table definitions so that I don't spend time on reinventing the wheels.<br>
<br>Will it not be a good option to have latest and all '.sql's for ARA in contrib/realtime/mysql? <br><br>I appreciate the kind of work Digium has done in the form of Asterisk. I also acknowledge the kind of (indirect :)) help I have got from Asterisk users' group.<br>
<br>Thanks a lot.<br>[SATISH]<br><br><br>