VoIP Mailing List Archives :: View topic - [asterisk-users] authoritative sql definitions for Asterisk Realtime Architecture ARA

Sponsor: VoiceMeUp - Corporate & Wholesale VoIP Services

VoIP Mailing List Archives
Mailing list archives for the VoIP community

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

VoIP Mailing List Archives Forum Index -> Asterisk Users

View previous topic :: View next topic

Author

Message

stephen.more at gmail.com
Guest

Posted: Fri May 09, 2014 3:32 pm Post subject: [asterisk-users] authoritative sql definitions for Asterisk

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

stephen.more at gmail.com
Guest

Posted: Sun May 11, 2014 3:10 pm Post subject: [asterisk-users] authoritative sql definitions for Asterisk

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@gmail.com (stephen.more@gmail.com)> wrote:

Quote:

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

mikael at wiraya.com
Guest

Posted: Wed May 21, 2014 1:30 am Post subject: [asterisk-users] authoritative sql definitions for Asterisk

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@gmail.com (stephen.more@gmail.com)> wrote:

Quote:

joshdmetzger at gmail.com
Guest

Posted: Wed May 21, 2014 7:52 am Post subject: [asterisk-users] authoritative sql definitions for Asterisk

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. Smile

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@gmail.com (stephen.more@gmail.com)> wrote:

Quote:

kevin.larsen at pionee...
Guest

Posted: Wed May 21, 2014 8:13 am Post subject: [asterisk-users] authoritative sql definitions for Asterisk

Quote:

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. Smile

I think the problem with those links are that they are as close as you get to authoritative, but they are not complete nor totally correct.

Two examples I can think of off the top of my head are that the sendrpid enum definition only has yes or no. pai should also be a valid option. Second, there is no description column. It should be a varchar(40).

Probably the only way to make a definitive list for this would be to find the appropriate source files and look at every place they can read in from the database to see what columns they can read.

Display posts from previous:

	VoIP Mailing List Archives Forum Index -> Asterisk Users	All times are GMT - 5 Hours
Page 1 of 1

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum