Stephen More
2014-May-09 20:32 UTC
[asterisk-users] authoritative sql definitions for Asterisk Realtime Architecture ARA
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/20140509/fcbc9b5d/attachment.html>
Stephen More
2014-May-11 20:09 UTC
[asterisk-users] authoritative sql definitions for Asterisk Realtime Architecture ARA
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>
Mikael Fredin
2014-May-21 06:30 UTC
[asterisk-users] authoritative sql definitions for Asterisk Realtime Architecture ARA
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>
Josh Metzger
2014-May-21 12:51 UTC
[asterisk-users] authoritative sql definitions for Asterisk Realtime Architecture ARA
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>