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

[Mikael Fredin]

AFAIK, there's few columns that are required, and for example sippeers can
have as many columns as the corresponding configuration values of peers,
and if not present they will claim default values...


On 9 May 2014 22:32, 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/97761f42/attachment.html>