We do not have in-depth documentation on the sql statements but the way they are used for registration id more or less selecting the contact based on either the callid or the to and from fields, the same with the subscriptions.<br>
<br>The other presence stuff is a little more involved but we do not have a detailed description.<br><br><br><div class="gmail_quote">On Sun, Apr 6, 2008 at 5:10 PM, kokoska rokoska <<a href="mailto:kokoska.rokoska@post.cz">kokoska.rokoska@post.cz</a>> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><br>
Anthony Minessale napsal(a):<br>
<div class="Ih2E3d">> yes you should create them by yourself.<br>
> We cannot guarantee the syntax to create indexes for each type of db.<br>
> We do make an effort to auto-create the table for you but if you are<br>
> serious about it you may choose<br>
> to set the db up yourself.<br>
><br>
<br>
</div>Thank you very much, Anthony, for your response!<br>
<br>
I will do it, but I'd like to know if somewhere exists<br>
documentation/description of DB queries Freeswitch do.<br>
Or should I "extract" this kind of info from source codes only?<br>
<div><div></div><div class="Wj3C7c"><br>
Regards,<br>
<br>
kokoska.rokoska<br>
<br>
<br>
_______________________________________________<br>
Freeswitch-dev mailing list<br>
<a href="mailto:Freeswitch-dev@lists.freeswitch.org">Freeswitch-dev@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-dev" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-dev</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-dev" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-dev</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>Anthony Minessale II<br><br>FreeSWITCH <a href="http://www.freeswitch.org/">http://www.freeswitch.org/</a><br>ClueCon <a href="http://www.cluecon.com/">http://www.cluecon.com/</a><br>
<br>AIM: anthm<br><a href="mailto:MSN%3Aanthony_minessale@hotmail.com">MSN:anthony_minessale@hotmail.com</a><br>GTALK/JABBER/<a href="mailto:PAYPAL%3Aanthony.minessale@gmail.com">PAYPAL:anthony.minessale@gmail.com</a><br>
IRC: <a href="http://irc.freenode.net">irc.freenode.net</a> #freeswitch<br><br>FreeSWITCH Developer Conference<br><a href="mailto:sip%3A888@conference.freeswitch.org">sip:888@conference.freeswitch.org</a><br><a href="http://iax:guest@conference.freeswitch.org/888">iax:guest@conference.freeswitch.org/888</a><br>
<a href="mailto:googletalk%3Aconf%2B888@conference.freeswitch.org">googletalk:conf+888@conference.freeswitch.org</a><br>pstn:213-799-1400