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 <[email protected]> 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 >
-- _____________________________________________________________________ -- 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
