[asterisk-users] authoritative sql definitions for Asterisk Realtime Architecture ARA

[Stephen More]

It appears that starting with version 12, there will be a methodical
approach to maintaining schemas:
https://wiki.asterisk.org/wiki/display/AST/Managing+Realtime+Databases+with+Alembic


On Fri, May 9, 2014 at 4:32 PM, Stephen More <stephen.more at gmail.com> wrote:

> 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.
>
>
> http://www.asteriskdocs.org/en/3rd_Edition/asterisk-book-html/asterisk-book.html
>
> http://www.open-voip.org/index.php?title=Asterisk_Full_RealTime_example
>
> Files included with the distribution:
>
> asterisk-11.9.0/contrib/realtime/mysql/iaxfriends.sql:CREATE TABLE
> `iaxfriends` (
> asterisk-11.9.0/contrib/realtime/mysql/meetme.sql:CREATE TABLE meetme (
> asterisk-11.9.0/contrib/realtime/mysql/musiconhold.sql:CREATE TABLE
> musiconhold (
> asterisk-11.9.0/contrib/realtime/mysql/queue_log.sql:CREATE TABLE
> queue_log (
> asterisk-11.9.0/contrib/realtime/mysql/sippeers.sql:CREATE TABLE IF NOT
> EXISTS `sippeers` (
> asterisk-11.9.0/contrib/realtime/mysql/voicemail.sql:CREATE TABLE
> voicemail (
> asterisk-11.9.0/contrib/realtime/mysql/voicemail_data.sql:CREATE TABLE
> voicemail_data (
> asterisk-11.9.0/contrib/realtime/mysql/voicemail_messages.sql:CREATE TABLE
> voicemail_messages (
>
> asterisk-11.9.0/contrib/realtime/postgresql/realtime.sql:CREATE TABLE
> extensions_conf (
> asterisk-11.9.0/contrib/realtime/postgresql/realtime.sql:CREATE TABLE cdr (
> asterisk-11.9.0/contrib/realtime/postgresql/realtime.sql:CREATE TABLE
> sip_conf (
> asterisk-11.9.0/contrib/realtime/postgresql/realtime.sql:CREATE TABLE
> voicemail_users (
> asterisk-11.9.0/contrib/realtime/postgresql/realtime.sql:CREATE TABLE
> queue_table (
> asterisk-11.9.0/contrib/realtime/postgresql/realtime.sql:CREATE TABLE
> queue_member_table
> asterisk-11.9.0/contrib/realtime/postgresql/realtime.sql:CREATE TABLE
> "queue_log" (
>
> Any help is appreciated.
> -Stephen More
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20140511/b08c9088/attachment.html>