<div dir="ltr">Here are links to the Asterisk Wiki for CDR and SIP tables.  I didn't find extensions listed, but it's pretty simple and I can provide the structure for that if needed, but it would be without a definitive source beyond me having used it for years.  :-)<br>
<div><div><br><a href="https://wiki.asterisk.org/wiki/display/AST/MySQL+CDR+Backend">https://wiki.asterisk.org/wiki/display/AST/MySQL+CDR+Backend</a><br><br><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></div></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Fri, May 9, 2014 at 4:32 PM, Stephen More <span dir="ltr"><<a href="mailto:stephen.more@gmail.com" target="_blank">stephen.more@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"><div>I am trying to find where the authoritative sql definitions for Asterisk Realtime Architecture ARA are located. I have found many locations but each and everyone seems to be different.<br>
<br><a href="http://www.asteriskdocs.org/en/3rd_Edition/asterisk-book-html/asterisk-book.html" target="_blank">http://www.asteriskdocs.org/en/3rd_Edition/asterisk-book-html/asterisk-book.html</a><br>
<br><a href="http://www.open-voip.org/index.php?title=Asterisk_Full_RealTime_example" target="_blank">http://www.open-voip.org/index.php?title=Asterisk_Full_RealTime_example</a><br><br></div>Files included with the distribution:<br>
<div>
<br>asterisk-11.9.0/contrib/realtime/mysql/iaxfriends.sql:CREATE TABLE `iaxfriends` (<br>asterisk-11.9.0/contrib/realtime/mysql/meetme.sql:CREATE TABLE meetme (<br>asterisk-11.9.0/contrib/realtime/mysql/musiconhold.sql:CREATE TABLE musiconhold (<br>

asterisk-11.9.0/contrib/realtime/mysql/queue_log.sql:CREATE TABLE queue_log (<br>asterisk-11.9.0/contrib/realtime/mysql/sippeers.sql:CREATE TABLE IF NOT EXISTS `sippeers` (<br>asterisk-11.9.0/contrib/realtime/mysql/voicemail.sql:CREATE TABLE voicemail (<br>

asterisk-11.9.0/contrib/realtime/mysql/voicemail_data.sql:CREATE TABLE voicemail_data (<br>asterisk-11.9.0/contrib/realtime/mysql/voicemail_messages.sql:CREATE TABLE voicemail_messages (<br><br>asterisk-11.9.0/contrib/realtime/postgresql/realtime.sql:CREATE TABLE extensions_conf (<br>

asterisk-11.9.0/contrib/realtime/postgresql/realtime.sql:CREATE TABLE cdr (<br>asterisk-11.9.0/contrib/realtime/postgresql/realtime.sql:CREATE TABLE sip_conf (<br>asterisk-11.9.0/contrib/realtime/postgresql/realtime.sql:CREATE TABLE voicemail_users (<br>

asterisk-11.9.0/contrib/realtime/postgresql/realtime.sql:CREATE TABLE queue_table (<br>asterisk-11.9.0/contrib/realtime/postgresql/realtime.sql:CREATE TABLE queue_member_table<br>asterisk-11.9.0/contrib/realtime/postgresql/realtime.sql:CREATE TABLE "queue_log" (<br>

<br></div><div>Any help is appreciated.<span class="HOEnZb"><font color="#888888"><br></font></span></div><span class="HOEnZb"><font color="#888888"><div>-Stephen More<br></div></font></span></div>
<br>--<br>
_____________________________________________________________________<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/mailman/listinfo/asterisk-users</a><br></blockquote></div><br></div>