If you check the contrib/realtime/mysql directory in the source tree, you'll find scripts for almost all the tables.
Leandro > > 2012/8/3 Daniel-Constantin Mierla <mico...@gmail.com> > >> Hello, >> >> 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: >> >> https://wiki.asterisk.org/**wiki/display/AST/SIP+Realtime,** >> +MySQL+table+structure<https://wiki.asterisk.org/wiki/display/AST/SIP+Realtime,+MySQL+table+structure> >> https://wiki.asterisk.org/**wiki/display/AST/ODBC+**Voicemail+Storage<https://wiki.asterisk.org/wiki/display/AST/ODBC+Voicemail+Storage> >> >> 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 (http://kb.asipto.com/**asterisk:realtime:kamailio-3.** >> 1.x-asterisk-1.6.2-astdb<http://kb.asipto.com/asterisk:realtime:kamailio-3.1.x-asterisk-1.6.2-astdb>), >> but hopefully now it is an easy way to get the db structure. >> >> Thanks, >> Daniel >> >> -- >> Daniel-Constantin Mierla - http://www.asipto.com >> http://twitter.com/#!/miconda - >> http://www.linkedin.com/in/**miconda<http://www.linkedin.com/in/miconda> >> Kamailio Advanced Training, Seattle, USA, Sep 23-26, 2012 - >> http://asipto.com/u/katu >> Kamailio Practical Workshop, Netherlands, Sep 10-12, 2012 - >> http://asipto.com/u/kpw >> >> >> -- >> ______________________________**______________________________**_________ >> -- Bandwidth and Colocation Provided by http://www.api-digital.com -- >> New to Asterisk? Join us for a live introductory webinar every Thurs: >> http://www.asterisk.org/hello >> >> asterisk-users mailing list >> To UNSUBSCRIBE or update options visit: >> >> http://lists.digium.com/**mailman/listinfo/asterisk-**users<http://lists.digium.com/mailman/listinfo/asterisk-users> >> > >
-- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users