If you check the contrib/realtime/mysql directory in the source tree, you'll find scripts for almost all the tables.<div><br></div><div>Leandro<br><div class="gmail_quote"><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="HOEnZb"><div class="h5"><br><div class="gmail_quote">2012/8/3 Daniel-Constantin Mierla <span dir="ltr"><<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hello,<br>
<br>
I was wondering if there is a tool that can create the realtime database structure for latest Asterisk version or a web resource/file containing the sql scripts. Hope I haven't missed obvious things, I had no luck searching on the web, in the wiki I found few pages with bits of sql or table structures, like:<br>
<br>
<a href="https://wiki.asterisk.org/wiki/display/AST/SIP+Realtime,+MySQL+table+structure" target="_blank">https://wiki.asterisk.org/<u></u>wiki/display/AST/SIP+Realtime,<u></u>+MySQL+table+structure</a><br>
<a href="https://wiki.asterisk.org/wiki/display/AST/ODBC+Voicemail+Storage" target="_blank">https://wiki.asterisk.org/<u></u>wiki/display/AST/ODBC+<u></u>Voicemail+Storage</a><br>
<br>
I have several table structures from the Asterisk 1.6, I dug for them in the code or found on the web when I wrote the tutorial about integration with Kamailio 3.1 (<a href="http://kb.asipto.com/asterisk:realtime:kamailio-3.1.x-asterisk-1.6.2-astdb" target="_blank">http://kb.asipto.com/<u></u>asterisk:realtime:kamailio-3.<u></u>1.x-asterisk-1.6.2-astdb</a>), but hopefully now it is an easy way to get the db structure.<br>
<br>
Thanks,<br>
Daniel<br>
<br>
-- <br>
Daniel-Constantin Mierla - <a href="http://www.asipto.com" target="_blank">http://www.asipto.com</a><br>
<a href="http://twitter.com/#!/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/<u></u>miconda</a><br>
Kamailio Advanced Training, Seattle, USA, Sep 23-26, 2012 - <a href="http://asipto.com/u/katu" target="_blank">http://asipto.com/u/katu</a><br>
Kamailio Practical Workshop, Netherlands, Sep 10-12, 2012 - <a href="http://asipto.com/u/kpw" target="_blank">http://asipto.com/u/kpw</a><br>
<br>
<br>
--<br>
______________________________<u></u>______________________________<u></u>_________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>
New to Asterisk? Join us for a live introductory webinar every Thurs:<br>
<a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/<u></u>mailman/listinfo/asterisk-<u></u>users</a><br>
</blockquote></div><br>
</div></div></blockquote></div><br></div>