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

[Josh Metzger]

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.  :-)

https://wiki.asterisk.org/wiki/display/AST/MySQL+CDR+Backend

https://wiki.asterisk.org/wiki/display/AST/SIP+Realtime,+MySQL+table+structure



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
>
> --
> _____________________________________________________________________
> -- 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20140521/1df14f32/attachment.html>