<div dir="ltr">It appears that starting with version 12, there will be a methodical approach to maintaining schemas: <a href="https://wiki.asterisk.org/wiki/display/AST/Managing+Realtime+Databases+with+Alembic">https://wiki.asterisk.org/wiki/display/AST/Managing+Realtime+Databases+with+Alembic</a><br>
</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>
</blockquote></div><br></div>